Hi. I'm looking for a solution to set custom partition with MySQL models in Phalcon. I tried to figure it out with modelsManager, behaviours, events etc., but still can not find a solution. What I'm looking for:
<?php $model = new SomeThing; $model->setPartition('p1'); $model->find(...); // or $model->find(['partition' => 'p1']); // with conditions
And the output should be:
SELECT `id`, `name` FROM `something` PARTITION (`p1`);
Thanks in advance.