$Content?>
Active Record (ORM) with support for Conditions, Expressions, Sub-Queries, References and Joins. Based on "Model" and "DSQL".
Models will manage your SQL Query for you, consistently and reliably.
/?> Automatic ConditionsWhen traversing references, conditions are automatically set eliminating the possibility for developer's mistake.
/?> Complex Table JoinsSometimes your business entity consists of 2, 3 or even more tables joined together. Relational Models support automatic table joins when you are retrieving data or inserts into related table and linking ID fields if you are addin records.
/?> ExpressionsModels do eliminate need for the SQL but they still give the power of specifying expressions.
/?> Based on Basic ModelsBecause Model_Table inherits regular Model, you can still use it with any Data Controllers such as caches.
/?> Multi-row AcitonsWhenever you need to create a custom SQL query, you can clone it off "base" query used by the model. That will automatically apply conditions and joins.
/?> Insert versus ModifyRelational Models distinguish events for performing Insert and Modification. You can set hooks to intercept and modify query before it is executed.
/?> Relies on DSQLThrough the power of DSQL Models support multiple database vendors and will automatically use proper SQL syntax.
/?>In the spirit of Agile Toolkit — all of it's classes are strictly focused on a one simple task, without trying to do everything. Here are things which Model will not do and why: No attempting to manage structure
That is job of your database migration scripts.
/?> Not LimitingRelational Model does not take the power of custom SQL queries.
/?>