#include <sqlStatementsFeature.h>
Public Member Functions | |
virtual const std::string & | getNameInst () |
Returns name of the database feature. | |
virtual std::string | getCreateTableStatement (const MetadataHolder &tableMeta, const std::vector< const MetadataHolder * > &columns, const MetadataHolder &createMeta=MetadataHolder::emptyMeta)=0 |
Generates a CREATE TABLE statement. | |
virtual std::string | getDropTableStatement (const MetadataHolder &tableMeta, const MetadataHolder &dropmeta=MetadataHolder::emptyMeta)=0 |
Generates a DROP TABLE statement. | |
virtual std::string | getInsertStatement (const MetadataHolder &tableMeta, const std::vector< const MetadataHolder * > &inColumns, const MetadataHolder &insertMeta=MetadataHolder::emptyMeta)=0 |
Generates an INSERT statement. | |
virtual std::string | getUpdateStatement (const MetadataHolder &tableMeta, const std::vector< const MetadataHolder * > &inColumns, const MetadataHolder &updateMeta=MetadataHolder::emptyMeta)=0 |
Generates an UPDATE statement. | |
virtual std::string | getDeleteStatement (const MetadataHolder &tableMeta, const MetadataHolder &deleteMeta=MetadataHolder::emptyMeta)=0 |
Generates a DELETE statement. | |
virtual std::string | getSelectStatement (const std::vector< const MetadataHolder * > &tables, const std::vector< const MetadataHolder * > &outColumns, const MetadataHolder &selectMeta=MetadataHolder::emptyMeta)=0 |
Generates a basic SELECT statement. | |
virtual std::string | getCreateViewStatement (const MetadataHolder &meta, const MetadataHolder &createMeta=MetadataHolder::emptyMeta)=0 |
Generates a CREATE VIEW statement. | |
virtual std::string | getDropViewStatement (const MetadataHolder &meta, const MetadataHolder &dropMeta=MetadataHolder::emptyMeta)=0 |
Generates a DROP VIEW statement. | |
virtual std::vector< std::string > | getIndexes (const MetadataHolder &tableMeta, const std::vector< const MetadataHolder * > &columns)=0 |
Generates a CREATE INDEX statement. |
These statements are: CREATE TABLE, DROP TABLE, INSERT INTO table, UPDATE table, DELETE FROM table, SELECT FROM table CREATE VIEW, DROP VIEW.
virtual const std::string& iopc::SqlStatementsFeature::getNameInst | ( | ) | [inline, virtual] |
Returns name of the database feature.
Database features must have unique names across the library
Implements iopc::DbFeature.
virtual std::string iopc::SqlStatementsFeature::getCreateTableStatement | ( | const MetadataHolder & | tableMeta, | |
const std::vector< const MetadataHolder * > & | columns, | |||
const MetadataHolder & | createMeta = MetadataHolder::emptyMeta | |||
) | [pure virtual] |
Generates a CREATE TABLE statement.
tableMeta | Metadata describing the table.
| |
columns | Metadata describing the columns.
| |
createMeta | Additional driver-specific parameters |
virtual std::string iopc::SqlStatementsFeature::getDropTableStatement | ( | const MetadataHolder & | tableMeta, | |
const MetadataHolder & | dropmeta = MetadataHolder::emptyMeta | |||
) | [pure virtual] |
Generates a DROP TABLE statement.
tableMeta | Metadata describing the table to drop
| |
dropmeta | Additional driver-specific parameters |
virtual std::string iopc::SqlStatementsFeature::getInsertStatement | ( | const MetadataHolder & | tableMeta, | |
const std::vector< const MetadataHolder * > & | inColumns, | |||
const MetadataHolder & | insertMeta = MetadataHolder::emptyMeta | |||
) | [pure virtual] |
virtual std::string iopc::SqlStatementsFeature::getUpdateStatement | ( | const MetadataHolder & | tableMeta, | |
const std::vector< const MetadataHolder * > & | inColumns, | |||
const MetadataHolder & | updateMeta = MetadataHolder::emptyMeta | |||
) | [pure virtual] |
Generates an UPDATE statement.
virtual std::string iopc::SqlStatementsFeature::getDeleteStatement | ( | const MetadataHolder & | tableMeta, | |
const MetadataHolder & | deleteMeta = MetadataHolder::emptyMeta | |||
) | [pure virtual] |
Generates a DELETE statement.
tableMeta | Metadata describing the table from which to delete rows
| |
deleteMeta | Additional parameters
|
virtual std::string iopc::SqlStatementsFeature::getSelectStatement | ( | const std::vector< const MetadataHolder * > & | tables, | |
const std::vector< const MetadataHolder * > & | outColumns, | |||
const MetadataHolder & | selectMeta = MetadataHolder::emptyMeta | |||
) | [pure virtual] |
Generates a basic SELECT statement.
tables | Metadata describing the tables from which to select data
| |
outColumns | Metadata describing the columns which will be selected
| |
selectMeta | Additional parameters
|
virtual std::string iopc::SqlStatementsFeature::getCreateViewStatement | ( | const MetadataHolder & | meta, | |
const MetadataHolder & | createMeta = MetadataHolder::emptyMeta | |||
) | [pure virtual] |
Generates a CREATE VIEW statement.
meta | Metadata describing the view
| |
createMeta | Additional driver-specific parameters |
virtual std::string iopc::SqlStatementsFeature::getDropViewStatement | ( | const MetadataHolder & | meta, | |
const MetadataHolder & | dropMeta = MetadataHolder::emptyMeta | |||
) | [pure virtual] |
Generates a DROP VIEW statement.
meta | MEtadata describing the view
| |
dropMeta | Additional driver-specific parameters |
virtual std::vector<std::string> iopc::SqlStatementsFeature::getIndexes | ( | const MetadataHolder & | tableMeta, | |
const std::vector< const MetadataHolder * > & | columns | |||
) | [pure virtual] |
Generates a CREATE INDEX statement.
tableMeta | Metadata describing the table on which to create the index
| |
columns | Metadata describing the indexes
|