ExportDBMS
in
Table of Contents
Methods
- drop() : string
- Return a query to drop this table
- hdr() : string
- Return the header for the export.
- insert() : string
- Create an INSERT query
- insertUpdate() : string
- Create an INSERT...UPDATE query
- structure() : string
- Return a query to create the table
- update() : string
- Create an UPDATE query
Methods
drop()
Return a query to drop this table
public
drop(ExportTableSQL $table_def) : string
Parameters
- $table_def : ExportTableSQL
-
The table definition.
Return values
string —The query to drop the table.
hdr()
Return the header for the export.
public
hdr() : string
Return values
string —The header.
insert()
Create an INSERT query
public
insert(ExportTableSQL $table_def, array<string|int, mixed> $row) : string
Parameters
- $table_def : ExportTableSQL
-
The table definition.
- $row : array<string|int, mixed>
-
The row data.
Return values
string —The query to insert the row.
insertUpdate()
Create an INSERT...UPDATE query
public
insertUpdate(ExportTableSQL $table_def, array<string|int, string> $pk_names, array<string|int, mixed> $row) : string
Parameters
- $table_def : ExportTableSQL
-
The table definition.
- $pk_names : array<string|int, string>
-
The primary key column names.
- $row : array<string|int, mixed>
-
The row data.
Return values
string —The query to insert the row.
structure()
Return a query to create the table
public
structure(ExportTableSQL $table_def) : string
Parameters
- $table_def : ExportTableSQL
-
The table definition.
Return values
string —The query to create the table.
update()
Create an UPDATE query
public
update(ExportTableSQL $table_def, array<string|int, string> $pk_names, array<string|int, mixed> $row) : string
Parameters
- $table_def : ExportTableSQL
-
The table definition.
- $pk_names : array<string|int, string>
-
The primary key column names.
- $row : array<string|int, mixed>
-
The row data.
Return values
string —The query to update the row.