Log message #4123419

# At Username Text
# Mar 9th 2018, 15:26 bravo-kernel I am about to start a bounty program for two missing crud-json-api features https://github.com/FriendsOfCake/crud-json-api/issues/1 and https://github.com/FriendsOfCake/crud-json-api/issues/2
# Mar 9th 2018, 14:08 braguzz ok thanks I'll give a try
# Mar 9th 2018, 14:01 dereuromark in 3.x writing and testing plugins is actually quite fun (compared to 2.x), nice standalone thing.
# Mar 9th 2018, 14:01 dereuromark braguzz: it helps to upgrade some of the ecosystem things first and adding testing around it etc, this way when you actually upgrade you can use all the things in the new version right away, and fully working. depends on the time schedule, but thats what I did with my plugins, this way it works again way faster than getting lost in many different things that need upgrading.
# Mar 9th 2018, 13:59 admad "some plugins that handle automatic charts and reports" if you have proper standalone classes then updating them for 3.x wouldn't be too difficult either :slightly_smiling_face:
# Mar 9th 2018, 13:58 braguzz bootstrap is the easyer task .. ;)
# Mar 9th 2018, 13:58 admad bootstrap: there's friendsofcake/boostrap-ui plugin
# Mar 9th 2018, 13:58 braguzz admad thanks admad ;)
# Mar 9th 2018, 13:57 admad authentication: if you have made a proper authentication class then upgrading it to 3.x would be too difficult
# Mar 9th 2018, 13:57 admad braguzz: you could try adding an AppTable and overriding setTable() method to add prefix. Then make all your table classes extends AppTable
# Mar 9th 2018, 13:54 braguzz impossible task
# Mar 9th 2018, 13:54 braguzz :(
# Mar 9th 2018, 13:54 braguzz it seem to me that is a impossible work
# Mar 9th 2018, 13:54 braguzz authentication (with italian cns), twitter bootstrap views, automatic way to handle some aspects of join tables, some plugins that handle automatic charts and reports...
# Mar 9th 2018, 13:52 braguzz we made many changes from the base skel
# Mar 9th 2018, 13:51 braguzz but the harder point is porting the skeleton from 2 to 3
# Mar 9th 2018, 13:50 braguzz probably I'll go to fight
# Mar 9th 2018, 13:47 dereuromark the alternative is a big harder: finish the PRs and tickets for prefix support.
# Mar 9th 2018, 13:47 braguzz thanks
# Mar 9th 2018, 13:47 braguzz mmm ok
# Mar 9th 2018, 13:47 dereuromark i am sure they will understand and give you a few more DBs
# Mar 9th 2018, 13:47 braguzz hihihi
# Mar 9th 2018, 13:47 dereuromark sounds like they are in the 90s still :slightly_smiling_face: you might want to update them on what century it is
# Mar 9th 2018, 13:47 braguzz and I have many DBS per department
# Mar 9th 2018, 13:46 braguzz and they give me only one DB per deparment
# Mar 9th 2018, 13:46 braguzz not managed by me
# Mar 9th 2018, 13:45 braguzz I know but I have a server farm
# Mar 9th 2018, 13:43 dereuromark the point is: it is usually just better/easier to have different DBs then (they are cheap)
# Mar 9th 2018, 13:42 dereuromark braguzz: we all know, yeah
# Mar 9th 2018, 13:42 dereuromark jay: i dont call those virtual fields tba
# Mar 9th 2018, 13:40 braguzz so I caould bake without prefixes and evrything worked
# Mar 9th 2018, 13:40 braguzz in 2.x prefix was handle directli in DB configuration
# Mar 9th 2018, 13:40 jkpatel291289 @dereuromark i have set virtualfield as display field and i am fetshin display field from model.. $displayField = $this->{$this->name}->getDisplayField(); $term = $this->request->getQuery('term'); $results = $this->{$this->name}->find('all', [ 'conditions' => [ $displayField.' LIKE' => $term . '%'], 'limit' => 10, 'fields'=>['id', $displayField ] ]);
# Mar 9th 2018, 13:34 dereuromark what do you mean? bake also dosnt do prefixes yet afaik
# Mar 9th 2018, 13:33 braguzz does it works with bake?
# Mar 9th 2018, 13:33 dereuromark @braguzz: Ah, found it: https://github.com/dereuromark/cakephp-setup/blob/master/src/Shell/DbMaintenanceShell.php#L166
# Mar 9th 2018, 13:33 braguzz ;)
# Mar 9th 2018, 13:33 braguzz thanks
# Mar 9th 2018, 13:32 dereuromark its easy :slightly_smiling_face: I even had a shell doing that for me
# Mar 9th 2018, 13:32 dereuromark braguzz: unprefix em
# Mar 9th 2018, 13:32 dereuromark @jkpatel291289 sure, why not. those are usually just concat(y,z) which would still always work in SQL