Log message #4203350

# At Username Text
# Sep 16th 2019, 15:27 daniel.upshaw Thanks
# Sep 16th 2019, 15:26 ricksaccous if you run into trouble then feel free to ask questions
# Sep 16th 2019, 15:26 daniel.upshaw Lol fair enough
# Sep 16th 2019, 15:26 ricksaccous just copy and paste from the docs, lol
# Sep 16th 2019, 15:25 daniel.upshaw But it's outdated it seems
# Sep 16th 2019, 15:25 daniel.upshaw There's this Udemy course: https://www.udemy.com/course/cakephp-3-tutorial-with-user-authentication-and-admin/
# Sep 16th 2019, 15:24 daniel.upshaw Of a recommended codebase
# Sep 16th 2019, 15:24 daniel.upshaw Mainly a structural overview
# Sep 16th 2019, 15:23 ricksaccous what are you trying to do that you feel lacks explanation to achieve?
# Sep 16th 2019, 15:22 daniel.upshaw It's not super hands-on though
# Sep 16th 2019, 15:22 daniel.upshaw Yep
# Sep 16th 2019, 15:22 ricksaccous @daniel.upshaw have you read the docs on it?
# Sep 16th 2019, 15:22 daniel.upshaw Having a hard time finding clear tutorials or examples of the newest Authentication system
# Sep 16th 2019, 15:13 itmpls for contains it decides whether to left join or separate query it, right?
# Sep 16th 2019, 15:13 itmpls yeah but the thing don't even left join it I think
# Sep 16th 2019, 15:12 ricksaccous or at least that's the easiest way in my head
# Sep 16th 2019, 15:12 ricksaccous @itmpls I think you'd have to select the count of the hasmany and then do a having where count >1
# Sep 16th 2019, 15:09 itmpls if I contain a hasMany table, it will do a separate select . query unless I change the query strategy, right? i'm just trying to do a having clause where i wanna pull if there are >1 records in the hasMany
# Sep 16th 2019, 15:09 ricksaccous @jotpe http://docs.phinx.org/en/latest/migrations.html#executing-queries
# Sep 16th 2019, 15:09 jotpe Will do that then :slightly_smiling_face:
# Sep 16th 2019, 15:08 ricksaccous you can indeed insert raw sql
# Sep 16th 2019, 15:08 jotpe Or can i insert raw sql?
# Sep 16th 2019, 15:08 ricksaccous might as well just write straight up SQL because I don't think phinx has an ORM like CakePHP that handles something like that
# Sep 16th 2019, 15:08 ricksaccous welp
# Sep 16th 2019, 15:07 jotpe Chicken or Egg?
# Sep 16th 2019, 15:07 jotpe I don't have the table class for now. Need to cleanup the db first
# Sep 16th 2019, 15:06 ricksaccous @jotpe if you want you can import the table class from cake into a migration
# Sep 16th 2019, 15:05 jotpe or migrations
# Sep 16th 2019, 15:05 jotpe Is there a way to build a `WHERE 'id' IN (1, 2,3 ...)` query in phinx?
# Sep 16th 2019, 14:35 ricksaccous I learned something, cool
# Sep 16th 2019, 14:35 ricksaccous that makes sense actually since it's not keyed like service_modalities.0._ids just service_modalities._ids
# Sep 16th 2019, 14:35 ricksaccous interesting...
# Sep 16th 2019, 14:35 ricksaccous rather than addNestedMany
# Sep 16th 2019, 14:35 ricksaccous if I change it to addNested
# Sep 16th 2019, 14:35 ricksaccous okay, it seemed to fix itself
# Sep 16th 2019, 14:33 ricksaccous at this point I don't care about the _nested key, I just want my message returned instead
# Sep 16th 2019, 14:29 slackebot <ricksaccous>
# Sep 16th 2019, 14:29 ricksaccous this happens even if i change the rule like so:
# Sep 16th 2019, 14:25 ricksaccous hmmmm
# Sep 16th 2019, 14:25 ricksaccous and rather than it showing up on the _ids field in the errors array it shows up in _nested
# Sep 16th 2019, 14:25 ricksaccous I keep getting the error message "the provided value is invalid"