| # |
Aug 30th 2019, 05:02 |
 turkles |
I looked at that, but couldn't work out how to ensure when I save from the api data it converts from the text to an int |
| # |
Aug 30th 2019, 05:01 |
conehead |
@turkles If I understood you correctly, maybe have a look at this: https://www.dereuromark.de/2010/06/24/static-enums-or-semihardcoded-attributes/ https://github.com/dereuromark/cakephp-tools/blob/master/docs/Entity/Enum.md |
| # |
Aug 30th 2019, 04:50 |
turkles |
Hi all, I am grabbing data from external api - which gives me text 'status' values I want to convert to TINYINT before saving, but if I need to display show the original text. I was hoping I could do this in the entity, has anyone got examples of this? I seem to have ballsed it up so it tries to save the text, but does show text when retreiving the tinyint from db.. |
| # |
Aug 29th 2019, 20:24 |
yamcomnet |
https://www.cnizz.com/yummy-demo does not seem to work |
| # |
Aug 29th 2019, 20:23 |
jimbo2150 |
Granted, if you are doing searches on DATE only from a DATETIME column, make sure you have appropriate indexes that cast to DATE as well so it is not constantly going through every entry :clock130: |
| # |
Aug 29th 2019, 20:23 |
cnizzardini |
i just noticed that too, i haven't really been maintaining my personal site |
| # |
Aug 29th 2019, 20:22 |
cnizzardini |
yeah |
| # |
Aug 29th 2019, 20:22 |
yamcomnet |
does it have time range search capabilities? |
| # |
Aug 29th 2019, 20:22 |
yamcomnet |
yummySearch looks very promising. |
| # |
Aug 29th 2019, 20:22 |
challgren |
@cnizzardini FYI https://www.cnizz.com/yummy-demo reports a SSL error and the redirect is all munged up |
| # |
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 |