Pluf_DB_Schema_PostgreSQL Class Reference

List of all members.

Public Member Functions
	__construct ($con)
	getSqlCreate ($model)
	getSqlIndexes ($model)
	getSqlDelete ($model)
Public Attributes
	$mappings
	$defaults
Private Attributes
	$con = null

---

Detailed Description

Generator of the schemas corresponding to a given model.

This class is for PostgreSQL, you can create a class on the same model for another database engine.

---

Constructor & Destructor Documentation

Pluf_DB_Schema_PostgreSQL::__construct

(

$

con

)

---

Member Function Documentation

Pluf_DB_Schema_PostgreSQL::getSqlCreate

(

$

model

)

Get the SQL to generate the tables of the given model.

Parameters:

Object

Model

Returns:

array Array of SQL strings ready to execute.

Pluf_DB_Schema_PostgreSQL::getSqlIndexes

(

$

model

)

Get the SQL to generate the indexes of the given model.

Parameters:

Object

Model

Returns:

array Array of SQL strings ready to execute.

Pluf_DB_Schema_PostgreSQL::getSqlDelete

(

$

model

)

Get the SQL to drop the tables corresponding to the model.

Parameters:

Object

Model

Returns:

string SQL string ready to execute.

---

Member Data Documentation

Pluf_DB_Schema_PostgreSQL::$mappings

Initial value:

 array(
                             'varchar' => 'character varying',
                             'sequence' => 'serial',
                             'boolean' => 'boolean',
                             'date' => 'date',
                             'datetime' => 'timestamp',
                             'file' => 'character varying',
                             'manytomany' => null,
                             'foreignkey' => 'integer',
                             'text' => 'text',
                             'html' => 'text',
                             'time' => 'time',
                             'integer' => 'integer',
                             'email' => 'character varying',
                             'password' => 'character varying',
                             'float' => 'real',
                             'blob' => 'bytea',
                             )

Mapping of the fields.

Pluf_DB_Schema_PostgreSQL::$defaults

Initial value:

 array(
                             'varchar' => "''",
                             'sequence' => null,
                             'boolean' => 'FALSE',
                             'date' => "'0001-01-01'",
                             'datetime' => "'0001-01-01 00:00:00'",
                             'file' => "''",
                             'manytomany' => null,
                             'foreignkey' => 0,
                             'text' => "''",
                             'html' => "''",
                             'time' => "'00:00:00'",
                             'integer' => 0,
                             'email' => "''",
                             'password' => "''",
                             'float' => 0.0,
                             'blob' => "''",

                             )

Pluf_DB_Schema_PostgreSQL::$con = null [private]

---

The documentation for this class was generated from the following file:

• pluf/src/Pluf/DB/Schema/PostgreSQL.php