An SQLite3 connection. More...

#include <Wt/Dbo/backend/Sqlite3.h>

Inheritance diagram for Wt::Dbo::backend::Sqlite3:

Public Member Functions
	Sqlite3 (const std::string &db)
	Opens a new SQLite3 backend connection. More...

	Sqlite3 (const Sqlite3 &other)
	Copies an SQLite3 connection.

	~Sqlite3 ()
	Destructor. More...

virtual std::unique_ptr< SqlConnection >	clone () const override
	Clones the connection. More...

sqlite3 *	connection ()
	Returns the underlying connection.

std::string	connectionString ()
	Returns the underlying connection string.

void	setDateTimeStorage (SqlDateTimeType type, DateTimeStorage format)
	Configures how to store date or date time. More...

DateTimeStorage	dateTimeStorage (SqlDateTimeType type) const
	Returns the date time storage.

virtual void	startTransaction () override
	Starts a transaction. More...

virtual void	commitTransaction () override
	Commits a transaction. More...

virtual void	rollbackTransaction () override
	Rolls back a transaction. More...

virtual std::unique_ptr< SqlStatement >	prepareStatement (const std::string &sql) override
	Prepares a statement. More...

Methods that return dialect information
virtual std::string	autoincrementSql () const override
	Returns the 'autoincrement' SQL type modifier. More...

virtual std::vector< std::string >	autoincrementCreateSequenceSql (const std::string &table, const std::string &id) const override
	Returns the SQL statement(s) required to create an id sequence. More...

virtual std::vector< std::string >	autoincrementDropSequenceSql (const std::string &table, const std::string &id) const override
	Returns the SQL statement(s) required to drop an id sequence. More...

virtual std::string	autoincrementType () const override
	Returns the 'autoincrement' SQL type. More...

virtual std::string	autoincrementInsertSuffix (const std::string &id) const override
	Returns the suffix for an 'autoincrement' insert statement. More...

virtual const char *	dateTimeType (SqlDateTimeType type) const override
	Returns the date/time type. More...

virtual const char *	blobType () const override
	Returns the blob type. More...

virtual bool	supportDeferrableFKConstraint () const override
	Returns true if the backend supports "deferrable initially deferred" foreign key constraints. More...

Public Member Functions inherited from Wt::Dbo::SqlConnection
virtual	~SqlConnection ()
	Destructor.

virtual void	executeSql (const std::string &sql)
	Executes an SQL statement. More...

virtual SqlStatement *	getStatement (const std::string &id) const
	Returns the statement with the given id. More...

virtual void	saveStatement (const std::string &id, std::unique_ptr< SqlStatement > statement)
	Saves a statement with the given id. More...

void	setProperty (const std::string &name, const std::string &value)
	Sets a property. More...

std::string	property (const std::string &name) const
	Returns a property. More...

virtual std::string	autoincrementInsertInfix (const std::string &id) const
	Returns the infix for an 'autoincrement' insert statement. More...

virtual void	prepareForDropTables ()
	Execute code before dropping the tables. More...

virtual std::string	textType (int size) const
	Returns the text type. More...

virtual std::string	longLongType () const
	Returns the 64-bit integer type. More...

virtual const char *	booleanType () const
	Returns the boolean type. More...

virtual bool	supportUpdateCascade () const
	Returns true if the database supports Update Cascade. More...

virtual bool	requireSubqueryAlias () const
	Returns the true if the database require subquery alias. More...

virtual LimitQuery	limitQueryMethod () const
	Returns the 'autoincrement' SQL type modifier. More...

virtual bool	usesRowsFromTo () const
	Returns whether the SQL dialect uses 'ROWS ? TO ?', limit or rownum for partial select results. More...

virtual bool	supportAlterTable () const
	Returns true if the backend support Alter Table. More...

virtual const char *	alterTableConstraintString () const
	Returns the command used in alter table .. drop constraint .. More...

Detailed Description

An SQLite3 connection.

This class provides the backend implementation for SQLite3 databases.

Constructor & Destructor Documentation

Wt::Dbo::backend::Sqlite3::Sqlite3 ( const std::string & db )

Opens a new SQLite3 backend connection.

The db may be any of the values supported by sqlite3_open().

Wt::Dbo::backend::Sqlite3::~Sqlite3 ( )

Destructor.

Closes the connection.

Member Function Documentation

std::vector< std::string > Wt::Dbo::backend::Sqlite3::autoincrementCreateSequenceSql	(	const std::string &	table,
		const std::string &	id
	)		const

overridevirtual

Returns the SQL statement(s) required to create an id sequence.

This is used by Session::createTables() to create the id sequence for a table. The table's name and primary key are passed as arguments to this function and can be used to construct an SQL sequence that is unique for the table.

Implements Wt::Dbo::SqlConnection.

std::vector< std::string > Wt::Dbo::backend::Sqlite3::autoincrementDropSequenceSql	(	const std::string &	table,
		const std::string &	id
	)		const

overridevirtual

Returns the SQL statement(s) required to drop an id sequence.

This is used by Session::dropTables() to drop the id sequence for a table. The table's name and primary key are passed as arguments to this function and can be used to construct an SQL sequence that is unique for the table.

Implements Wt::Dbo::SqlConnection.

std::string Wt::Dbo::backend::Sqlite3::autoincrementInsertSuffix ( const std::string & id ) const

overridevirtual

Returns the suffix for an 'autoincrement' insert statement.

This is appended to the insert statement, since some back-ends need to be indicated that they should return the autoincrement id.

Implements Wt::Dbo::SqlConnection.

std::string Wt::Dbo::backend::Sqlite3::autoincrementSql ( ) const

overridevirtual

Returns the 'autoincrement' SQL type modifier.

This is used by Session::createTables() to create the id column.

Implements Wt::Dbo::SqlConnection.

std::string Wt::Dbo::backend::Sqlite3::autoincrementType ( ) const