Sayonara Player
Public Member Functions | Protected Member Functions | List of all members
DB::Base Class Referenceabstract
Inheritance diagram for DB::Base:
DB::Module DB::Connector SC::Database

Public Member Functions

 Base (DbId databaseId, const QString &sourceDirectory, const QString &targetDirectory, const QString &filename, QObject *parent=nullptr)
 
virtual bool closeDatabase ()
 
virtual bool isInitialized ()
 
virtual void transaction ()
 
virtual void commit ()
 
virtual void rollback ()
 
QSqlDatabase db () const
 
DbId databaseId () const
 
QString connectionName () const
 
DB::Query runQuery (const QString &query, const QString &error_text) const
 
DB::Query runQuery (const QString &query, const QPair< QString, QVariant > &bindings, const QString &error_text) const
 
DB::Query runQuery (const QString &query, const QMap< QString, QVariant > &bindings, const QString &error_text) const
 
DB::Query update (const QString &tablename, const QMap< QString, QVariant > &field_bindings, const QPair< QString, QVariant > &where_binding, const QString &error_message)
 update More...
 
DB::Query insert (const QString &tablename, const QMap< QString, QVariant > &field_bindings, const QString &error_message)
 

Protected Member Functions

virtual bool createDatabase ()
 
virtual bool applyFixes ()=0
 
virtual bool checkAndInsertColumn (const QString &tablename, const QString &column, const QString &sqltype, const QString &default_value)
 
virtual bool checkAndInsertColumn (const QString &tablename, const QString &column, const QString &sqltype)
 
virtual bool checkAndCreateTable (const QString &tablename, const QString &sql_create_str)
 
virtual bool checkAndDropTable (const QString &tablename)
 

Member Function Documentation

◆ update()

DB::Query DB::Module::update ( const QString &  tablename,
const QMap< QString, QVariant > &  field_bindings,
const QPair< QString, QVariant > &  where_binding,
const QString &  error_message 
)
inherited

update

Parameters
tablenameName of table to update
field_bindingsFields to update
where_bindingWhere clause
error_message
Returns