| # |
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. |
| # |
Aug 29th 2019, 18:03 |
noel |
I'm deploying to Docker containers but not using them for my local dev env, which is not ideal. |
| # |
Aug 29th 2019, 18:02 |
sdevore |
Docker containers. So I kind of solve the whole it works on my machine issue by just having my machine everywhere ;) Mostly I can better replicate client environments with only a little extra overhead |
| # |
Aug 29th 2019, 18:02 |
bmudda |
@noel your `phinx.yml` file should look like this if you are using MAMP ``` development: adapter: mysql host: localhost name: your_db_name user: your_db_user pass: 'your_db_password' unix_socket: /Applications/MAMP/tmp/mysql/mysql.sock charset: utf8 ``` |
| # |
Aug 29th 2019, 17:59 |
noel |
What do you use instead of MAMP now? |
| # |
Aug 29th 2019, 17:58 |
sdevore |
this mamp stuff is from memory so could be *wrong* or *outdated* |
| # |
Aug 29th 2019, 17:56 |
sdevore |
it is likely that when running phnix from the command line you are using the system mysql to connect to the db and cake is all running in MAMP so you might need to edit the my.conf for your installed mysql to change where the socket is… `/etc/my.conf` edit the lines ``` [mysqld] socket=/Applications/MAMP/tmp/mysql/mysql.sock [client] socket=/Applications/MAMP/tmp/mysql/mysql.sock ``` |