Class ANSICompiler

Alchemy\dialect\ANSICompiler

Direct known subclasses

Alchemy\dialect\MySQLCompiler, Alchemy\dialect\SQLiteCompiler

Namespace: Alchemy\dialect
Located at alchemy/dialect/ANSICompiler.php

Methods summary
`public static`	# `get_schema_format( mixed $type )`
`public string`	# `alias( Element $obj )` Always returns the same auto-generated string for a given object Always returns the same auto-generated string for a given object Parameters `$obj` `Element` $obj key Returns `string` alias
`public`	# `Alias_ColumnRef( mixed $obj, mixed $id )`
`public`	# `Alias_Scalar( mixed $obj, mixed $id )`
`public`	# `Alias_TableRef( mixed $obj, mixed $id )`
`public`	# `Column( mixed $obj )`
`public`	# `ColumnRef( mixed $obj )`
`public`	# `Create( mixed $obj )`
`public`	# `Create_Column( mixed $obj )`
`public`	# `Create_Index( mixed $obj )`
`public`	# `Create_ForeignKey( mixed $obj )`
`public`	# `Create_Element( mixed $obj )`
`public`	# `Delete( mixed $obj )`
`public`	# `Drop( mixed $obj )`
`public`	# `Insert( mixed $obj )`
`public`	# `Join( mixed $obj )`
`public`	# `Expression( mixed $obj )`
`public`	# `Query( mixed $obj )`
`public`	# `Scalar( mixed $obj )`
`public`	# `Select( mixed $obj )`
`public`	# `TableRef( mixed $obj )`
`public`	# `Update( mixed $obj )`
`public`	# `Query_Join( mixed $obj )`
`public`	# `Query_Limit( mixed $obj )`
`public`	# `Query_Where( mixed $obj )`

Methods inherited from Alchemy\dialect\Compiler
`__construct(), compile(), format(), getConfig(), getFunction(), map(), popConfig(), pushConfig()`

Properties summary
`protected static array`	`$expr_formats`	array( // operators 'add' => '%s + %s', 'sub' => '%s - %s', 'mult' => '%s * %s', 'div' => '%s / %s', 'mod' => 'MOD(%s, %s)', 'abs' => 'ABS(%s)', 'ceil' => 'CEIL(%s)', 'exp' => 'EXP(%s)', 'floor' => 'FLOOR(%s)', 'ln' => 'LN(%s)', 'sqrt' => 'SQRT(%s)', 'extract' => 'EXTRACT(%s FROM %s)', 'interval' => 'INTERVAL %s %s', 'now' => 'NOW()', 'lower' => 'LOWER(%s)', 'upper' => 'UPPER(%s)', 'convert' => 'CONVERT(%s USING %s)', 'translate' => 'TRANSLATE(%s USING %s)', 'concat' => '%s \|\| %s', 'coalesce' => 'COALESCE(%1//, /)', // predicates 'equal' => '%s = %s', 'lt' => '%s < %s', 'gt' => '%s > %s', 'ne' => '%s != %s', 'le' => '%s <= %s', 'ge' => '%s >= %s', 'between' => '%s BETWEEN %s AND %s', 'isnull' => '%s IS NULL', 'like' => '%s LIKE %s', 'in' => '%s IN (%2//, /)', 'and' => '(%// AND /)', 'or' => '(%// OR /)', 'not' => 'NOT (%s)')	#
`protected static array`	`$schema_formats`	array( // numerics 'Bool' => "BOOL", 'Integer' => "INT(%s)", 'TinyInt' => "TINYINT(%s)", 'SmallInt' => "SMALLINT(%s)", 'MediumInt' => "MEDIUMINT(%s)", 'BigInt' => "BIGINT(%s)", 'Float' => "FLOAT(%s)", 'Decimal' => "DECIMAL(%s, %s)", //strings 'Blob' => "BLOB", 'Binary' => "BINARY(%s)", 'String' => "VARCHAR(%s)", 'Char' => "CHAR(%s)", 'Text' => "TEXT(%s)", // datetimes 'Date' => "DATE", 'Time' => "TIME", 'Datetime' => "DATETIME", 'Timestamp' => "TIMESTAMP", // indexes 'Index' => "KEY %s (%3$//, /)", 'UniqueKey' => "UNIQUE KEY %s (%3$//, /)", 'PrimaryKey' => "PRIMARY KEY (%3$//, /)")	#
`protected array`	`$defaults`	`array( 'alias_columns' => true, 'alias_tables' => false)`	#

Properties inherited from Alchemy\dialect\Compiler
`$default_tag`

Namespaces

Classes

Class ANSICompiler

Direct known subclasses

Parameters

Returns