SQL

Classes
class	EDBBackup
	ESetupWizardObject to dump SQL databases into a file.If you need a dialog around it, use EDBBackupDialog instead. More...
class	EDBBackupDialog
	Dialog to dump SQL databases into a file.It uses EDBBackup widget to do the dump. More...
class	EDBSettings
	This class is used to let the user enter some settings related to the database.The widget is displayed at two places. First it is used at the. More...
class	EDBUpdateWidget
	Widget to create and update database schemas defined with ESqlInit. More...
class	EQueryThread
	Allows to execute SQL-Queries asynchronous.Should be stopped right that: More...
class	ESqlDatabase
	An improved QSqlDatabase class. More...
class	ESqlField
	Represents an field in an sql table.This class is used with ESqlInit to define database schemas. More...
class	ESqlInit
	Class to manage database structures.This class is able to create and modify complexe database structures. You can define a structure in scheme() and this class handles the creation of this structure or updates an existing one automatically. To allow more customization, you can register update routines, to get a more customized post processsing of updates. More...
class	ESqlLogin
	Class to login into a database.If GUI is not disabled, it requests the login data with help of ESqlLoginWidget, if needed. Otherwise only the specified login data is used. More...
class	ESqlTable
	Represents an sql table.This class is used with ESqlInit to define database schemas. More...
class	EQueryWorker
	Executes the SQL-Statements given by the EQueryThread.This class is executed within EQueryThread::run() in a seperate thread. Therefore all executed queries within this class are executed asychronously. More...
class	ESqlLoginDialog
	Displays a login dialog for a database. More...

Enumerations
enum	EDBUpdateWidget::Needed { EDBUpdateWidget::Nothing, EDBUpdateWidget::Settings, EDBUpdateWidget::Update, EDBUpdateWidget::Both }
enum	ESqlField::Type {   ESqlField::NoType, ESqlField::Integer, ESqlField::Text, ESqlField::Varchar,   ESqlField::Boolean, ESqlField::Date, ESqlField::Time, ESqlField::Tinyint,   ESqlField::Double, ESqlField::Timestamp, ESqlField::Blob, ESqlField::LongBlob }
enum	ESqlInit::privileges {   ESqlInit::SELECT, ESqlInit::INSERT, ESqlInit::UPDATE, ESqlInit::DEL,   ESqlInit::CREATE, ESqlInit::ALTER }
enum	ESqlInit::Status {   ESqlInit::BadSettings, ESqlInit::LoggedIn, ESqlInit::LoginFailed, ESqlInit::UpdateNeeded,   ESqlInit::UpdateFailed, ESqlInit::NoUpdateNeeded }
enum	ESqlLogin::Result { ESqlLogin::Failed, ESqlLogin::LoggedIn, ESqlLogin::Canceled }
enum	ESqlTable::FkAction { ESqlTable::NoAction, ESqlTable::SetNull, ESqlTable::Cascade, ESqlTable::Restrict }
	Actions, which are done, if an foreign key is changed. More...

Detailed Description

This module contains all classes related to SQL databases.

Enumeration Type Documentation

enum ESqlTable::FkAction

Actions, which are done, if an foreign key is changed.

Enumerator
NoAction	Nothing is done
SetNull	The fk-field is set to NULL
Cascade	See MySQL Handbook
Restrict	See MySQL Handbook

enum EDBUpdateWidget::Needed

Enumerator
Nothing	Neither Settings nor update is needed
Settings	Only Setting is needed
Update	Only update is needed
Both	Settings and update are needed

enum ESqlInit::privileges

possible SQL permissions CREATE assumes ALTER and CREATE VIEW

Enumerator
SELECT
INSERT
UPDATE
DEL
CREATE
ALTER

enum ESqlLogin::Result

Enumerator
Failed
LoggedIn
Canceled

enum ESqlInit::Status

Enumerator
BadSettings
LoggedIn
LoginFailed
UpdateNeeded
UpdateFailed
NoUpdateNeeded

enum ESqlField::Type

Enumerator
NoType
Integer
Text
Varchar
Boolean
Date
Time
Tinyint
Double
Timestamp
Blob
LongBlob