Thoughts, etc. – Page 3 – Tracking the occasional random walk

Arrays of joined ids

2015-05-08 / Leave a Comment

Thanks to a helpful stack overflow response, I now have an improved solution to my problem of needing to add arrays of joined ids to JSON output from CakePHP 3. The output from a test containing Widget models that can each have many Foos looks something like this:

{
    "widgets": [
        {
            "id": 1,
            "foo_ids": [ 1 ]
        },
        {
            "id": 3,
            "foo_ids": [ ]
        },
        {
            "id": 2,
            "foo_ids": [ 1, 2, 3 ]
        }
    ]
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

{

"widgets": [

{

"id": 1,

"foo_ids": [ 1 ]

},

{

"id": 3,

"foo_ids": [ ]

},

{

"id": 2,

"foo_ids": [ 1, 2, 3 ]

}

]

}

To easily and automatically add this … [Read more…]

Listing associated IDs during a Controller query in CakePHP 3

2015-04-28 / Leave a Comment

Yesterday I looked into adding a key-value pair such as "tag_ids": [1, 2, 3] to a JSON object returned by a serialized CakePHP view, for Bookmarks belonging to many Tags. My solution produces the desired result, but involves the execution of a new database query for every bookmark, on top of the one that retrieved the record in the first place. This is not … [Read more…]

Array of associated IDs in CakePHP 3.0 “belongsToMany” relationship

2015-04-27 / 1 Comment

Today I was struggling with how to get CakePHP to return a JSON representation of a model, including a simple array of the foreign-key ids from the join table that specifies a mutual belongsToMany relationship (formerly, hasAndBelongsToMany or HABTM). For a concrete example, I wanted to build on the Bookmarker tutorial by creating an API endpoint to … [Read more…]