| # |
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" |
| # |
Sep 16th 2019, 14:24 |
slackebot |
<ricksaccous> |
| # |
Sep 16th 2019, 14:23 |
ricksaccous |
I have an allowEmptyArray on the _ids field in a nestedmany validator |
| # |
Sep 16th 2019, 14:23 |
ricksaccous |
to show as required |
| # |
Sep 16th 2019, 14:23 |
ricksaccous |
I'm having trouble getting an _ids field |
| # |
Sep 16th 2019, 14:08 |
alexdd55976 |
no in combination with yii on a xampp installation |
| # |
Sep 16th 2019, 14:02 |
neon1024 |
I’ve found Codeception to be quite helpful |
| # |
Sep 16th 2019, 13:54 |
alexdd55976 |
never do anything with codeception.. a PITA |
| # |
Sep 16th 2019, 12:28 |
javier.villanueva |
In my app.php I change my defaultLocale to es_ES but this format in validation not change |
| # |
Sep 16th 2019, 12:27 |
javier.villanueva |
then... how do I change this "ymd" ? |
| # |
Sep 16th 2019, 12:27 |
javier.villanueva |
(it is ok) |
| # |
Sep 16th 2019, 12:27 |
javier.villanueva |
If I use another date format in save thorw an error |
| # |
Sep 16th 2019, 12:26 |
javier.villanueva |
validator format is ymd by default. |
| # |
Sep 16th 2019, 12:25 |
admad |
Validator format is unrelated to db type class formats |
| # |
Sep 16th 2019, 12:25 |
javier.villanueva |
only works if I set an specific format in validation :S |