Hi Arthur,
MySQL views are like tables in MySQL, so if you put the following property
in your model:
class SomeModel extends AppModel
{
public $useTable = 'viewName';
}
The find methods will work perfectly, because the SELECT Statements
generated by the Cake Model work the same way as in tables.
Otherwise, you won't be able to save anything as you may know.
Regards,
2012/11/22 Arthur <demer...@gmail.com>
> Hello, I have model with only select functions. How to set mysql view as
> model table instead real sql table?
>
> For example:
>
> class SomeModel extends AppModel {
> public $name = 'someView'; // this is a view
> function getEntries() {
> return $this->find('all');
> }
> }
>
> I need it instead hardcoded query from view.
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To post to this group, send email to cake-php@googlegroups.com.
> To unsubscribe from this group, send email to
> cake-php+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
>
>
>
--
Jorge González
Web Developer
twitter: @jorgonor
github: https://github.com/jorgonor
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
