Class

PgsqlDataSQLBuilder

class PgsqlDataSQLBuilder extends DataSQLBuilder

PostgreSQL class for building data dump SQL.

Methods

static  reset()

Perform any reset between runs of this builder.

 from DataSQLBuilder
static string getDatabaseStartSql()

Gets any SQL to place at the start of all the row inserts.

 from DataSQLBuilder
static string getDatabaseEndSql()

Gets any SQL to place at the end of all the row inserts.

 from DataSQLBuilder
string getTableStartSql()

Gets any SQL to place before row inserts for a new table.

 from DataSQLBuilder
string getTableEndSql()

Gets any SQL to place at the end of row inserts for a table.
string buildRowSql(DataRow $row)

The main method in this class, returns the SQL for INSERTing data into a row.
string getTimestampSql(string $value)

Gets a representation of a timestamp value suitable for use in a SQL statement.

 from DataSQLBuilder
__construct(Table $table)

Construct a new PgsqlDataSQLBuilder object.

Details

in DataSQLBuilder at line 28
static public reset()

Perform any reset between runs of this builder.

This can be used, for example, to clear any stored start/end SQL.

in DataSQLBuilder at line 38
static public string getDatabaseStartSql()

Gets any SQL to place at the start of all the row inserts.

Return Value

string

in DataSQLBuilder at line 48
static public string getDatabaseEndSql()

Gets any SQL to place at the end of all the row inserts.

Return Value

string

in DataSQLBuilder at line 58
public string getTableStartSql()

Gets any SQL to place before row inserts for a new table.

Return Value

string

at line 65
public string getTableEndSql()

Gets any SQL to place at the end of row inserts for a table.

Return Value

string

at line 46
public string buildRowSql(DataRow $row)

The main method in this class, returns the SQL for INSERTing data into a row.

Parameters

DataRow $row The row to process.

Return Value

string

in DataSQLBuilder at line 273
public string getTimestampSql(string $value)

Gets a representation of a timestamp value suitable for use in a SQL statement.

Parameters

string $value

Return Value

string

at line 34
public __construct(Table $table)

Construct a new PgsqlDataSQLBuilder object.

Parameters

Table $table