Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
29 lines (19 sloc) 1.01 KB

ORM Query

The Query class is the heart of the ORM system. It's a query builder and builds and outputs queries that are compatible with MySQL and SQLite.

Basic Usage

Query itself does nothing with the database, except for escaping values through \Parable\ORM\Database::quote(), which in itself uses PDO::quote(). If no database instance is available, it uses soft quoting instead, adding single quotes where needed, unless it's disabled.

$query = \Parable\ORM\Query::createInstance();

$query->setAction("delete");
$query->setTableName("users");
$query->where("id", "=", 1);

$result = $database->query($query);

Soft quoting can be disabled by setting the parable.database.soft-quoting config setting to false or calling setSoftQuoting(false) on the database instance at any point.

Actions

Query supports only the 4 most basic actions: select, insert, update and delete. For anything more involved, you can either extend Query and add them, or you should do it without the use of Query.