An SQLite3 connection. More...

#include <Wt/Dbo/backend/Sqlite3>

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

Public Types
enum	DateTimeStorage { ISO8601AsText, PseudoISO8601AsText, JulianDaysAsReal, UnixTimeAsInteger }
	Configuration of date time storage. More...

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 Sqlite3 *	clone () const
	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 ()
	Starts a transaction. More...

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

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

virtual SqlStatement *	prepareStatement (const std::string &sql)
	Prepares a statement. More...

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

virtual std::vector< std::string >	autoincrementCreateSequenceSql (const std::string &table, const std::string &id) const
	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
	Returns the SQL statement(s) required to drop an id sequence. More...

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

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

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

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

virtual bool	supportDeferrableFKConstraint () const
	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 void	executeSqlStateful (const std::string &sql)
	Executes a connection-stateful SQL statement. More...

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

virtual void	saveStatement (const std::string &id, 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

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.

Member Enumeration Documentation

◆ DateTimeStorage

enum Wt::Dbo::backend::Sqlite3::DateTimeStorage

Configuration of date time storage.

SQlite3 does not provide real type support for date time. Instead, it offers 3 choices for storing a date time, each of these compatible with the use of the built-in arithmetic functions.

Enumerator
ISO8601AsText	As 'text' in ISO8601 format. This also interprets correctly dates stored in the database using the PseudoISO8601AsText format.
PseudoISO8601AsText	As 'text' in ISO8601-like format, but using a space (' ') instead of 'T' as a separator character between date and time. This is the behaviour of Wt::Dbo prior to Wt 3.2.3. This also interprets correctly dates stored in the database using the ISO8601AsText format.
JulianDaysAsReal	As 'real', the number of julian days. Note that this does not support second accuracy for a date time, but is the preferred format for a plain date.
UnixTimeAsInteger	As 'integer', number of seconds since UNIX Epoch.

Constructor & Destructor Documentation

◆ Sqlite3()

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().

◆ ~Sqlite3()

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

Destructor.

Closes the connection.

Member Function Documentation

◆ autoincrementCreateSequenceSql()

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

virtual

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.

◆ autoincrementDropSequenceSql()

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

virtual

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.