Doctrine Language Cheat Sheet printable pdf download

Ch eat Sh eet

Doctrine Query Language

Command Line Interface

http:/ / ctrine .org

$query = new Doctrine_Query();

./doctrine

$results = $query->delete()->update()->set()->select()->distinct()

Doctrine Command Line Interface

Doctrine Facade

->forUpdate()->from()->leftJoin()->innerJoin()->where()->addWhere()

->whereIn()->whereNotIn()->orderBy()->groupBy()->addGroupBy()

./doctrine build-all

$path = Doctrine::getPath();

->having()->addHaving()->addOrderBy()->limit()->offset()

./doctrine build-all-load

$models = Doctrine::loadModels($modelsPath);

->setHydrationMode();

./doctrine build-all-reload

$models = Doctrine::getLoadedModels();

./doctrine compile

Doctrine::generateModelsFromDb($modelsPath);

$count = $query->count();

./doctrine create-db

Doctrine::generateYamlFromDb($schemasPath);

$results = $query->execute(array $params);

./doctrine create-tables

Doctrine::generateModelsFromYaml($schemasPath, $modelsPath);

$ﬁrstRecord = $results->getFirst();

./doctrine dql

Doctrine::createTablesFromModels($modelsPath);

$lastRecord = $results->getLast();

./doctrine drop-db

Doctrine::generateSqlFromModels($modelsPath);

$count = $results->count();

./doctrine dump-data

Doctrine::generateYamlFromModels($schemasPath, $modelsPath);

./doctrine generate-migration

$results = Doctrine::createDatabases();

./doctrine generate-migrations-db

$results = Doctrine::dropDatabases();

./doctrine generate-migrations-models

Doctrine::dumpData($ﬁxturesPath);

./doctrine generate-models-db

Validators

Doctrine::loadData($ﬁxturesPath);

./doctrine generate-models-yaml

Doctrine::migration($migrationsPath, $versionNum);

./doctrine generate-sql

Doctrine::generateMigrationClass($className, $migrationsPath);

./doctrine generate-yaml-db

notnull, email, notblank, nospace, past, future, minlength(length), country,

Doctrine::generateMIgrationsFromDb($migrationsPath);

./doctrine generate-yaml-models

ip, htmlcolor, range(min, max), unique, regexp(expression), creditcard,

Doctrine::generateMigrationsFromModels($migrationsPath, $modelsPath);

./doctrine load-data

digits(int, frac)

$modelNameTable = Doctrine::getTable($modelName);

./doctrine load-dummy-data

Doctrine::compile(‘/path/to/doctrine/lib’, array $drivers);

./doctrine migrate

Doctrine_Manager::getInstance()->setAttribute($attribute, $value);

./doctrine rebuild-db

Migrations

$conn = Doctrine_Manager::connection($dsn, $connName);

$conn = Doctrine_Manager::getInstance()->getConnection($connName);

$manager = Doctrine_Manager::getInstance();

Data Fixtures

up() down() preUp() postUp() preDown() postDown()

createTable($tableName, array $ﬁelds, array $options);

User:

dropTable($tableName);

Schema Files

Records / Collections

username: jwage

renameTable($oldTableName, $newTableName);

password: changeme

createConstraint($tableName, $constraintName, array $deﬁnition);

User_1:

type: string(length)

setTableDeﬁnition()

dropConstraint($tableName, $constraintName, $primary = false);

Phonenumbers: [Phone_1]

length: integer

setUp()

createForeignKey($tableName, array $deﬁnition);

User_2:

connection: conn_name

hasOne(‘Model’, $options);

dropForeignKey($tableName, $fkName);

Phonenumbers:

package: PackageName

hasMany(‘Model’, $options);

addColumn($tableName, $columnName, $type, array $options);

Phone_2:

actAs: [BehaviorName]

$options = array(‘local’ => ‘local_id’, ‘foreign’

renameColumn($tableName, $oldColumnName, $newColumnName);

number: 555-555-5555

validator_name: name

=> ‘id’, ‘refClass’ => ‘XrefModel’);

changeColumn($tableName, $columnName, $type, array $options);

Proﬁle: Proﬁle_1

autoincrement: true

hasColumn($name, $type, $length $options);

removeColumn($tableName, $columnName);

columns:

index($name, $options);

addIndex($tableName, $indexName, array $options);

Proﬁle:

username: string(255)

actAs(‘BehaviorName’);

removeIndex($tableName, $indexName);

Proﬁle_1:

relations:

option($name, $value);

ﬁrst_name: Jonathan

Phonenumbers:

$record->toArray($deep = true);

last_name: Wage

class: Phonenumber

$collection->toArray($deep = true);

email_address:

Model Loading

local: user_id

$collection->getFirst();

Phonenumber:

foreign: phonenumber_id

$collection->getLast();

Phone_1:

refClass: UserPhonenumber

$collection->count();

$manager->setAttribute(‘model_loading’, ‘conservative’); // lazy loading

User: User_1

foreignAlias: Users

$record->fromArray($array);

$manager->setAttribute(‘model_loading’, ‘aggressive’);

// require_once all

number: 555-555-5555

foreignType: many

$collection->fromArray($array);

spl_autoload_register(array(‘Doctrine’, ‘autoload’));

type: many

Doctrine::loadModels($models);

Doctrine Language Cheat Sheet

Related Articles

Related forms

Related Categories