|
| TcDataAccess (const QString &connectionName=QLatin1String(QSqlDatabase::defaultConnection)) |
|
| TcDataAccess (const QSqlDatabase &other) |
|
QString | connectionName () const |
|
QSqlQuery | sqlQuery () const |
|
QSqlDatabase | sqlDatabase () const |
|
QList< QVariantMap > | fetchAll (const QString &sql, const QVariantList &bind=QVariantList()) |
|
QList< QVariantMap > | fetchAll (const TcDataAccessStatement &stat, const QVariantList &bind=QVariantList()) |
|
QList< QVariantList > | fetchAllList (const QString &sql, const QVariantList &bind=QVariantList()) |
|
QList< QVariantList > | fetchAllList (const TcDataAccessStatement &stat, const QVariantList &bind=QVariantList()) |
|
QVariantMap | fetchRow (const QString &sql, const QVariantList &bind=QVariantList()) |
|
QVariantMap | fetchRow (const TcDataAccessStatement &stat, const QVariantList &bind=QVariantList()) |
|
QVariantList | fetchCol (const QString &sql, const QVariantList &bind=QVariantList()) |
|
QVariantList | fetchCol (const TcDataAccessStatement &stat, const QVariantList &bind=QVariantList()) |
|
QVariant | fetchOne (const QString &sql, const QVariantList &bind=QVariantList()) |
|
QVariant | fetchOne (const TcDataAccessStatement &stat, const QVariantList &bind=QVariantList()) |
|
template<typename T > |
QMap< T, QVariant > | fetchPairs (const QString &sql, const QVariantList &bind=QVariantList()) |
|
template<typename T > |
QMap< T, QVariant > | fetchPairs (const TcDataAccessStatement &stat, const QVariantList &bind=QVariantList()) |
|
template<typename T > |
QMap< T, QVariantMap > | fetchAssoc (const QString &sql, const QVariantList &bind=QVariantList()) |
|
template<typename T > |
QMap< T, QVariantMap > | fetchAssoc (const TcDataAccessStatement &stat, const QVariantList &bind=QVariantList()) |
|
QString | limitPage (const QString &sql, int page, int rowCount) const |
|
QString | limit (const QString &sql, int count, int offset=0) const |
|
QVariant | lastInsertId (const QString &table=QString(), const QString &primaryKey=QString()) const |
|
QSqlError | lastError () const |
|
int | doDelete (const QString &table, const QString &where=QString(), const QVariantList &bind=QVariantList()) |
|
int | doUpdate (const QString &table, const QVariantMap &field, const QString &where=QString(), const QVariantList &bind=QVariantList()) |
|
int | doInsert (const QString &table, const QVariantMap &field) |
|
TcDataAccess & | operator= (const TcDataAccess &da) |
|
TcDataAccess & | operator= (const QSqlDatabase &db) |
|