Articles tagged with "sql"
Loading SQL with table prefixes
Your project uses a table prefix because you share a database, or you don’t want to clash table names. Maybe you just like the groupings that prefixes provide. Now what if someone hands you some SQL code that you need to load, but it doesn’t have your prefixes applied? What do you do?
[Read more] Want to order your SQL
If you don't like to have your sqls scattered around your code maybe this component is for you
[Read more] Aggregator & Aggregatable Behaviors: if You think that You need a GROUP BY statement
I wrote these two behaviors because I thought, that I need to use some GROUP BY sql statements. It is possible to use them in cakePHP only by $this->query, so it is not a good solution. Then I realized that I don't need GROUP BY actually. All I need is solution similar to counterCache - functionality that is already implemented in CakePHP
[Read more]
Latest Comments