| # |
Dec 31st 2018, 00:16 |
 sdevore |
I do like using the matching approach makes the intent clearer to my old brain when I come back |
| # |
Dec 31st 2018, 00:16 |
rightscoreanalysis |
should have been start_date <= :slightly_smiling_face: |
| # |
Dec 31st 2018, 00:15 |
sdevore |
PEBKAC issues are tough to debug |
| # |
Dec 31st 2018, 00:15 |
rightscoreanalysis |
start date >= $from |
| # |
Dec 31st 2018, 00:15 |
rightscoreanalysis |
my comparison operator was the wrong way around |
| # |
Dec 31st 2018, 00:15 |
rightscoreanalysis |
it's ok - it was error in my logic |
| # |
Dec 31st 2018, 00:13 |
sdevore |
This is how I do it |
| # |
Dec 31st 2018, 00:13 |
sdevore |
https://book.cakephp.org/3.0/en/orm/query-builder.html#filtering-by-associated-data |
| # |
Dec 31st 2018, 00:04 |
rightscoreanalysis |
I tried left and inner joins |
| # |
Dec 31st 2018, 00:04 |
rightscoreanalysis |
as if the join isn't filtering |
| # |
Dec 31st 2018, 00:04 |
rightscoreanalysis |
the count on the result is always the total number of all Poperties |
| # |
Dec 31st 2018, 00:03 |
rightscoreanalysis |
what am I doing wrong |
| # |
Dec 31st 2018, 00:03 |
rightscoreanalysis |
even when I use join conditions that do not match I am getting results when I should be getting 0 |
| # |
Dec 31st 2018, 00:03 |
rightscoreanalysis |
i have Properties model and PropertyPeriods, I am queryinging Properties and joining on PropertyPeriods |
| # |
Dec 30th 2018, 21:05 |
sdevore |
I would rename the old ones and rebake and then merge them (maybe by hand). But to be honest mostly I just manually update them, but I’ve been doing this stuff for a really long time on and off… |
| # |
Dec 30th 2018, 20:17 |
tomas.saghy |
I see I need to check 4.x branch :slightly_smiling_face: |
| # |
Dec 30th 2018, 20:16 |
tomas.saghy |
thanks for the example for `allowEmptyString` |
| # |
Dec 30th 2018, 19:24 |
dereuromark |
check the wiki page |
| # |
Dec 30th 2018, 19:24 |
dereuromark |
not really |
| # |
Dec 30th 2018, 19:21 |
k4t |
will we get any big change in ORM in Cake 4.0? |
| # |
Dec 30th 2018, 19:07 |
k4t |
fair enough |
| # |
Dec 30th 2018, 18:02 |
dereuromark |
sry, i dont do json without ext |
| # |
Dec 30th 2018, 17:56 |
k4t |
gi @dereuromark could you please check this? https://gist.github.com/K4T/1a2972e2e93fa1bb542a63a683675a26 I am using CRUD plugin and I would like to have urls without .json extension to work exactly like urls with .json extension (e.g. /api/v1/users/2 should gave me the same respone as /api/v1/users/2.json). In attached GIST you will find my current code and how current responses looks now. |
| # |
Dec 30th 2018, 17:18 |
k4t |
you can not rebake them again as you lost your entity/table modifications |
| # |
Dec 30th 2018, 17:18 |
k4t |
to reflect new database tables structure? |
| # |
Dec 30th 2018, 17:17 |
k4t |
do you update them manually? |
| # |
Dec 30th 2018, 17:17 |
k4t |
what with old baked models now? |
| # |
Dec 30th 2018, 17:17 |
k4t |
how do you handle follwing scenario: you have some tables in db, u baked models based on current tables structure. Now you added to the database tables some new columns, removed old ones etc |
| # |
Dec 30th 2018, 17:16 |
k4t |
hi guys |
| # |
Dec 30th 2018, 14:34 |
challgren |
Can you gist the structure for accounts and accounting_records please |
| # |
Dec 30th 2018, 14:32 |
challgren |
Now that I’m reading what your trying to accomplish |
| # |
Dec 30th 2018, 14:32 |
challgren |
I think your query might be a bit overkill |
| # |
Dec 30th 2018, 14:31 |
kitcat711 |
got it in debugkit I think |
| # |
Dec 30th 2018, 14:28 |
challgren |
https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#debugging-queries-and-resultsets the debug should be outputting the bound parameters and its not |
| # |
Dec 30th 2018, 14:27 |
kitcat711 |
yes |
| # |
Dec 30th 2018, 14:23 |
challgren |
Do you have debugkit enabled? |
| # |
Dec 30th 2018, 14:23 |
kitcat711 |
but same result xith debug($query) or sql($query) |
| # |
Dec 30th 2018, 14:22 |
kitcat711 |
https://gist.github.com/Kitcat711/6b440733f5566b243c946bdf047a99fa |
| # |
Dec 30th 2018, 14:20 |
challgren |
Ahh ok |
| # |
Dec 30th 2018, 14:20 |
kitcat711 |
Here I must debug to file for it is called through the api of the app => nothing on the screen |
| # |
Dec 30th 2018, 14:19 |
challgren |
I think debug outputs to browser and log depending on settings |