LibEngsas
Classes | Enumerations
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

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

Enumerator
Nothing 

Neither Settings nor update is needed

Settings 

Only Setting is needed

Update 

Only update is needed

Both 

Settings and update are needed

possible SQL permissions CREATE assumes ALTER and CREATE VIEW

Enumerator
SELECT 
INSERT 
UPDATE 
DEL 
CREATE 
ALTER 
Enumerator
Failed 
LoggedIn 
Canceled 
Enumerator
BadSettings 
LoggedIn 
LoginFailed 
UpdateNeeded 
UpdateFailed 
NoUpdateNeeded 
Enumerator
NoType 
Integer 
Text 
Varchar 
Boolean 
Date 
Time 
Tinyint 
Double 
Timestamp 
Blob 
LongBlob