| # |
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 |
| # |
Mar 9th 2018, 13:29 |
braguzz |
3.x doesnt handle the prefix of tables? |
| # |
Mar 9th 2018, 13:29 |
braguzz |
my whole tables are prefixed |
| # |
Mar 9th 2018, 13:28 |
braguzz |
but I got an obstacle |
| # |
Mar 9th 2018, 13:28 |
braguzz |
trying to see if its good to switch from 2.x to 3.x |
| # |
Mar 9th 2018, 13:28 |
braguzz |
hi all |
| # |
Mar 9th 2018, 13:26 |
jkpatel291289 |
can we use virtual field in where conditon? |
| # |
Mar 9th 2018, 12:03 |
birdy247 |
@admad Where would cake be without me lol |
| # |
Mar 9th 2018, 11:50 |
admad |
@birdy247 you are this close to getting on my "people I shouldn't help" list. :P |
| # |
Mar 9th 2018, 11:04 |
exhogin |
lol |