Log message #4202915

# At Username Text
# 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
# Sep 12th 2019, 15:37 ricksaccous so i listened
# Sep 12th 2019, 15:37 jh you can do that by getting a list of all assocaitions from the table class
# Sep 12th 2019, 15:37 ricksaccous then @dereuromark told me don't be a lazy boi
# Sep 12th 2019, 15:37 ricksaccous I once wanted to contain all the associations like you
# Sep 12th 2019, 15:37 ricksaccous so $this->find() will be sufficient