Log message #4202920

# At Username Text
# Sep 12th 2019, 16:35 this.impetus oh!
# Sep 12th 2019, 16:35 this.impetus oooooh
# Sep 12th 2019, 16:35 jh until you do that you can continue to build the query object, adding more finders, adding more conditionals etc
# Sep 12th 2019, 16:34 jh foreach, or toArray()
# Sep 12th 2019, 16:34 jh @this.impetus so the query builder in cakephp builds some object that then is converted to vendor specific (mariadb, postgres, etc) sql code and executed once you want to access data out of it
# Sep 12th 2019, 16:20 this.impetus @jh It may help you to know that I am a front-end guy, haha; I loosely understand what you've said, but not really the implications beyond the simple idea that there are fast and slow, or efficient and inefficient ways to retrieve data. :S
# Sep 12th 2019, 16:17 jh not sure about the contains though... probably only for the primary query
# Sep 12th 2019, 16:16 jh ->sql() will get you the sql (with placeholders)
# Sep 12th 2019, 16:16 jh afair the query builder is lazy aka if you do not fetch something from it it is just a query object
# Sep 12th 2019, 16:16 jh toArray() will also run formatResults and not sure if only then or earlier all the accessors in the entities
# Sep 12th 2019, 16:13 this.impetus On any other day I'd be super curious about that, haha, today is just get-to-the-finish-line. But thanks modi
# Sep 12th 2019, 16:12 ricksaccous pretty much transforms it into an array of entities, which is great because there is a lot you can do with entity magic
# Sep 12th 2019, 16:11 this.impetus oh thank god. :the_horns:
# Sep 12th 2019, 16:11 ricksaccous it won't be exactly like cakephp2 but yep
# Sep 12th 2019, 16:10 ricksaccous ->toArray
# Sep 12th 2019, 16:10 this.impetus Last question today guys, I swear; is there any means at all of getting a query object to just dump an array of data as cake once did? One of those days where I jsut want to get the work done and do the learning on my own time...
# Sep 12th 2019, 15:48 jh like so https://gist.github.com/inoas/1226835ee066cf54c3bf1f30b1ec028d
# Sep 12th 2019, 15:46 jh @admad yay it works... custom AppErrorMiddleware
# Sep 12th 2019, 15:45 jh I would be explicit about it.
# Sep 12th 2019, 15:45 jh a references b references a
# Sep 12th 2019, 15:45 jh @ricksaccous if you setup a recursive function, yes, but do not forget that there can be loops so you need to stop the looping
# Sep 12th 2019, 15:43 this.impetus :slightly_smiling_face:
# Sep 12th 2019, 15:43 ricksaccous oh well, good luck
# Sep 12th 2019, 15:43 ricksaccous lolll
# Sep 12th 2019, 15:43 ricksaccous 70 page CV, would anyone even read that
# Sep 12th 2019, 15:43 this.impetus He has a 70 page CV. Guy is a luminary. Haha, but in any case, failing to have found a magic bullet, I'll just do it by hand. thanks, as usual
# Sep 12th 2019, 15:42 ricksaccous but it also sounds like if it's just a single CV how bad could the query actually be anyway
# Sep 12th 2019, 15:42 ricksaccous welp, good luck sounds like you could adjust the associations based on request data though
# Sep 12th 2019, 15:41 this.impetus lol I need all the fields, haha. I'm building a digital CV for an academic who wants it utterly modular so a visitor could assemble a PDF based on which lines they want, it's a crazy amount of work to just print out what is essentially a document
# Sep 12th 2019, 15:40 ricksaccous i know it's tedious but sometimes it's worth it
# Sep 12th 2019, 15:40 ricksaccous you might want to specify fields in the contain array if you could
# Sep 12th 2019, 15:40 ricksaccous really really really slow
# Sep 12th 2019, 15:39 ricksaccous that query might be really really really slow
# Sep 12th 2019, 15:39 this.impetus recursive retrieval is indeed what I'm after here. I can just write this out as an array, it's just tedious
# Sep 12th 2019, 15:39 ricksaccous not just all associations on the main table
# Sep 12th 2019, 15:39 ricksaccous it seems he wants child associations of child associations
# Sep 12th 2019, 15:38 this.impetus @jh I'll give that a shot, thanks
# Sep 12th 2019, 15:38 ricksaccous @jh would that work recursively though?
# Sep 12th 2019, 15:38 jh try get_class_methods($this->Articles) should have some getAssociations() or so class
# Sep 12th 2019, 15:37 this.impetus @ricksaccous yeah I figured. I just *actually* have a context where it is required—the relationships go several assocations deep and I actually need them all
# Sep 12th 2019, 15:37 jh but it is bad practise