Log message #4267544

# At Username Text
# Jul 13th 2021, 15:47 tyler.adam.lazenby `bin/cake bake migration_snapshot Initial`
# Jul 13th 2021, 15:47 richard how exactly did you create it via the migrations plugin
# Jul 13th 2021, 15:46 tyler.adam.lazenby but the first was actually created by the migrations plugin
# Jul 13th 2021, 15:46 tyler.adam.lazenby ```->addColumn('updated', 'datetime', [ 'default' => 'CURRENT_TIMESTAMP', 'limit' => null, 'null' => false, ])```
# Jul 13th 2021, 15:46 tyler.adam.lazenby It will work if I mass change it to this
# Jul 13th 2021, 15:45 tyler.adam.lazenby ```->addColumn('updated', 'datetime', [ 'default' => 'current_timestamp()', 'limit' => null, 'null' => false, ])```
# Jul 13th 2021, 15:45 kevin.pfeifer I can’t find any valid php function which is called `current_timestamp()` Or do you mean the MySQL function?
# Jul 13th 2021, 15:41 tyler.adam.lazenby Is there a reason why the default value for datetime `current_timestamp()` is (a) generated by the snapshot command in migrations and (b) the system considers that invalid?
# Jul 13th 2021, 14:59 tyler.adam.lazenby gosh dang it, I have to use an app_local file
# Jul 13th 2021, 14:57 richard tired of doing sudo mysql then creating dbs/etc
# Jul 13th 2021, 14:57 richard I was thinking as some sort of dev ops chain but honestly i haven’t done that either, it’s something i want to start doing more often though
# Jul 13th 2021, 14:56 tyler.adam.lazenby init script huh? I have never done one of those
# Jul 13th 2021, 14:55 richard also might be weird, yeah, so you’re better off just doing that part yourself as some sort of init script or something
# Jul 13th 2021, 14:55 tyler.adam.lazenby yeah, but the thing about that is... migrations rufuses to run if it can't find a database connection
# Jul 13th 2021, 14:55 richard i don’t think there is a db-agnostic way to do it though
# Jul 13th 2021, 14:54 richard @tyler.adam.lazenby you can run any query in a migration technically, so yeah
# Jul 13th 2021, 14:45 tyler.adam.lazenby so question... can migrations be programed to create a db or do I need to do that manually
# Jul 13th 2021, 13:46 erwane If data are encoded with default flags, you can change it after i think. toPhp decode all data (escaped or not) toDatabase recode them with flags. I'm hot sure this should add bug. BUT this should be an option in JsonType, not default.
# Jul 13th 2021, 13:43 dereuromark yeah, as expected the impact is rather small. but none the less, sounds like a more consistent data storage if done with the right flags from the beginning. one should however not change those in the middle (if data already exists).
# Jul 13th 2021, 13:42 erwane ```decode 1119 escaped: 0.001491s decode 1663 unescaped: 0.001954s```
# Jul 13th 2021, 13:42 erwane After more tests, not sure there is a large impact on speed.
# Jul 13th 2021, 13:38 erwane weird result :S
# Jul 13th 2021, 13:38 erwane with true datas : ```decode 1663 unescaped: 0.005169s decode 1119 escaped: 0.002547s```
# Jul 13th 2021, 13:14 erwane on 10'000 iteration but input is not random. Maybe internal php cache do the job. ```encode default: 0.335539s encode unescaped: 0.341111s decode escaped json: 0.426201s decode unescaped json: 0.410178s```
# Jul 13th 2021, 13:08 val but that doesn't work
# Jul 13th 2021, 13:07 val I tried ``` $Query->getTypeMap() ->addDefaults([ 'Restaurant' => Restaurant::class, ]);```
# Jul 13th 2021, 13:02 val Hi, is there a way in Cake 3.x to tell the framework that the results of manual join in the query should be parsed as a model entity object (when there is no association to that's entity table)?
# Jul 13th 2021, 12:17 dereuromark could be interesting to know also the impact of this - for a future default case one day as well
# Jul 13th 2021, 12:17 dereuromark did you do a performance check here for lets say 1000 rows etc?
# Jul 13th 2021, 12:17 dereuromark ok, sounds useful :)
# Jul 13th 2021, 12:13 erwane @dereuromark cleaner json in an utf8 context (database tables encoding set to utf8 or utf8mb4). No need to escape everything i think.
# Jul 13th 2021, 12:00 caseyw Thanks for that, I'll look into it!
# Jul 13th 2021, 11:53 dereuromark I use it for font icons for example, to not have to search the correct names, but just to get the list of available ones.
# Jul 13th 2021, 11:52 dereuromark e.g. any $this->Theme->get(..) etc would be able to give you a list of available magic strings, constants or alike to select from, at least in PHPStorm that works nicely.
# Jul 13th 2021, 11:51 dereuromark I would also look into that for generating IDE specific meta data that can help to create auto complete lists. Most useful for magic strings. But also for a list of classes or constants on those.
# Jul 13th 2021, 11:50 dereuromark Plugin::path() is for plugins usually, see how IdeHelper detects paths here for the plugins available.
# Jul 13th 2021, 11:46 slackebot2 probably something outside the general support scope.
# Jul 13th 2021, 11:46 caseyw Yeah, sorry I was just meaning an example. In our system as new themes are created an old one is typically duplicated and some things change while most remain the same. I was hoping to have a dynamic way of calling the plugin specific constant without having to know the name of the Plugin itself. Someone messaged me and said App::path() might help to know the plugin dynamically, but I don't see how that would. Anyway, this is
# Jul 13th 2021, 11:42 dereuromark No, not with constants. They usually use ClassName::CONST_NAME syntax, which requires use statements. You could build a helper that does that though. Thats how I wrapped some things like Configure to be more easily accessible in the view (See Shim plugin).
# Jul 13th 2021, 11:19 caseyw Ok, thanks. As far as accessing the class is there a way to initialize it into the view to make use easier? $this->ConstantClass->MARK ?
# Jul 13th 2021, 10:41 dereuromark this is quite a specific case. I guess you could create some ConstantInterface that defines those, if there are different groups I suggest naming the interfaces accordingly.