| # |
Aug 29th 2019, 20:17 |
 cnizzardini |
thanks Jim |
| # |
Aug 29th 2019, 20:17 |
cnizzardini |
MySQL too |
| # |
Aug 29th 2019, 20:16 |
jimbo2150 |
I just checked PostgreSQL and SQLServer documentation and they both seem to support CAST( x as DATE ) - should be pretty safe. |
| # |
Aug 29th 2019, 20:16 |
cnizzardini |
id have to use that func() type stuff perhaps |
| # |
Aug 29th 2019, 20:16 |
yamcomnet |
would be nice to use https://github.com/ypnos-web/cakephp-datatables just have no idea about be best approach for timerange search |
| # |
Aug 29th 2019, 20:15 |
ricksaccous |
i think the functions they provide are all agnostic i could be wrong though |
| # |
Aug 29th 2019, 20:15 |
cnizzardini |
is DATE() a SQL standard...? |
| # |
Aug 29th 2019, 20:15 |
cnizzardini |
so, i don't want to use a MySQL DATE cast, unless that is standard SQL... |
| # |
Aug 29th 2019, 20:14 |
cnizzardini |
Yes, but the plugin is designed to be db agnostic |
| # |
Aug 29th 2019, 20:14 |
ricksaccous |
yeah nvm lol |
| # |
Aug 29th 2019, 20:14 |
ricksaccous |
hmmm maybe not |
| # |
Aug 29th 2019, 20:14 |
ricksaccous |
might be able to do a datediff on a date |
| # |
Aug 29th 2019, 20:13 |
ricksaccous |
https://book.cakephp.org/3.0/en/orm/query-builder.html#using-sql-functions |
| # |
Aug 29th 2019, 20:13 |
jimbo2150 |
If you do a cast on the value within the database (not the value you are searching for) it should work - it should cast the database datetime to 00:00:00. |
| # |
Aug 29th 2019, 20:13 |
cnizzardini |
Though your idea, is a tad more elegant than my plan b at least |
| # |
Aug 29th 2019, 20:12 |
cnizzardini |
https://github.com/cnizzardini/cakephp-yummy |
| # |
Aug 29th 2019, 20:12 |
cnizzardini |
Its to patch an issue in my plugin and that could be tricky :( |
| # |
Aug 29th 2019, 20:11 |
cnizzardini |
Thanks Jim, I am hoping to avoid a ranged search |
| # |
Aug 29th 2019, 20:11 |
ricksaccous |
you want exact match of date on day |
| # |
Aug 29th 2019, 20:11 |
ricksaccous |
lol |
| # |
Aug 29th 2019, 20:11 |
ricksaccous |
oh yeah i forgot about that |
| # |
Aug 29th 2019, 20:11 |
cnizzardini |
yes |
| # |
Aug 29th 2019, 20:11 |
yamcomnet |
I have also been working with vue and Cake. Would be interesting to know your approach. I have just used vue in views and passed json from controller and back |
| # |
Aug 29th 2019, 20:11 |
jimbo2150 |
When you search for a single date (without time), most databases assume 00:00:00 as the time. Since that is not equal to 11:54:32 it will not find anything. You should do a between 2019-01-01 and 2019-01-02 (add a day to the end date). That will search for anything between 2019-01-01 00:00:00 and 2019-02-02 00:00:00. |
| # |
Aug 29th 2019, 20:11 |
ricksaccous |
oh because it won't have a time? |
| # |
Aug 29th 2019, 20:11 |
cnizzardini |
i dont think that will work |
| # |
Aug 29th 2019, 20:10 |
ricksaccous |
or in the orm rather |
| # |
Aug 29th 2019, 20:10 |
ricksaccous |
and plop that in the query |
| # |
Aug 29th 2019, 20:10 |
ricksaccous |
and give it that date |
| # |
Aug 29th 2019, 20:10 |
ricksaccous |
just create a date time object |
| # |
Aug 29th 2019, 20:10 |
cnizzardini |
I actually need a means of doing this that is database engine agnostic |
| # |
Aug 29th 2019, 20:09 |
cnizzardini |
or casting the column to DATE() for MySQL |
| # |
Aug 29th 2019, 20:09 |
cnizzardini |
I was hoping there is a way of instructing cake to treat it as date field, rather than having to add a ranged search |
| # |
Aug 29th 2019, 20:08 |
cnizzardini |
so if I have a record with a created value of '2019-01-01 11:54:32' and I search for created = '2019-01-01' obviously that will not return results |
| # |
Aug 29th 2019, 20:05 |
ricksaccous |
are you talking about just displaying the date in that format? |
| # |
Aug 29th 2019, 20:05 |
ricksaccous |
i don't understand exactly what you want |
| # |
Aug 29th 2019, 20:03 |
cnizzardini |
I understand within the where operation I could probably cast to date with something like DATE(table_name.created) but is there another way to accomplish this? I'd like to avoid updating so much code. |
| # |
Aug 29th 2019, 20:03 |
cnizzardini |
How do you tell the Cake ORM to treat a date/time field as a date field when doing like things like table_name.created = '2019-08-01' |
| # |
Aug 29th 2019, 19:36 |
admad |
bakers pagination very large table might appreciate this https://github.com/cakephp/cakephp/pull/13572 |
| # |
Aug 29th 2019, 18:11 |
sdevore |
Well maybe @bmudda tip will solve your problem for now…. |
| # |
Aug 29th 2019, 18:04 |
noel |
I haven't quite figured out how to string them all together in a local env yet. |