ExportDBMS_SQLite
in package
implements
ExportDBMS
Exporter for SQLite databases.
Table of Contents
Interfaces
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
- createKvpString() : mixed
- Creates a key-value-pair string for use in a sql query
- mapDatatype() : mixed
- Map a MySQL data type to a SQLite data type
Methods
drop()
Return a query to drop this table
public
drop(mixed $table_def) : string
Parameters
- $table_def : mixed
-
The table definition.
Return values
string —The query to drop the table.
hdr()
Return the header for the export.
public
hdr() : string
Tags
Return values
string —The header.
insert()
Create an INSERT query
public
insert(mixed $table_def, mixed $row) : string
Parameters
- $table_def : mixed
-
The table definition.
- $row : mixed
-
The row data.
Return values
string —The query to insert the row.
insertUpdate()
Create an INSERT...UPDATE query
public
insertUpdate(mixed $table_def, mixed $pk_names, mixed $row) : string
Parameters
- $table_def : mixed
-
The table definition.
- $pk_names : mixed
-
The primary key column names.
- $row : mixed
-
The row data.
Return values
string —The query to insert the row.
structure()
Return a query to create the table
public
structure(mixed $table_def) : string
Parameters
- $table_def : mixed
-
The table definition.
Return values
string —The query to create the table.
update()
Create an UPDATE query
public
update(mixed $table_def, mixed $pk_names, mixed $row) : string
Parameters
- $table_def : mixed
-
The table definition.
- $pk_names : mixed
-
The primary key column names.
- $row : mixed
-
The row data.
Return values
string —The query to update the row.
createKvpString()
Creates a key-value-pair string for use in a sql query
private
createKvpString(mixed $row[, mixed $sep = ', ' ]) : mixed
Parameters
- $row : mixed
- $sep : mixed = ', '
mapDatatype()
Map a MySQL data type to a SQLite data type
private
mapDatatype(mixed $mysql_type) : mixed
Parameters
- $mysql_type : mixed