iframe-proxy | Sunbelt Computer Software

Repository navigation

History

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

#ifndef SQLITEDB_H

#define SQLITEDB_H

#include "sqlitetypes.h"

#include <QStringList>

#include <QMultiMap>

#include <QByteArray>

struct sqlite3;

class CipherDialog;

enum

{

kLogMsg_User,

kLogMsg_App

};

typedef QMultiMap<QString, sqlb::ObjectPtr> objectMap;

class DBBrowserDB : public QObject

{

Q_OBJECT

public:

explicit DBBrowserDB () : _db(0), isEncrypted(false), isReadOnly(false), dontCheckForStructureUpdates(false) {}

virtual ~DBBrowserDB (){}

bool open(const QString& db, bool readOnly = false);

bool attach(const QString& filename, QString attach_as = "");

bool create ( const QString & db);

bool close();

bool setSavepoint(const QString& pointname = "RESTOREPOINT");

bool releaseSavepoint(const QString& pointname = "RESTOREPOINT");

bool revertToSavepoint(const QString& pointname = "RESTOREPOINT");

bool releaseAllSavepoints();

bool revertAll();

bool dump(const QString & filename, const QStringList &tablesToDump, bool insertColNames, bool insertNew, bool exportSchema, bool exportData);

bool executeSQL(QString statement, bool dirtyDB = true, bool logsql = true);

bool executeMultiSQL(const QString& statement, bool dirty = true, bool log = false);

const QString& lastError() const { return lastErrorMessage; }

/**

* @brief getRow Executes a sqlite statement to get the rowdata(columns)

* for the given rowid.

* @param sTableName Table to query.

* @param rowid The rowid to fetch.

* @param rowdata A list of QByteArray containing the row data.

* @return true if statement execution was ok, else false.

bool getRow(const QString& sTableName, const QString& rowid, QList<QByteArray>& rowdata);

/**

* @brief max Queries the table t for the max value of field.

* @param t Table to query

* @param field Field to get the max value

* @return the max value of the field or 0 on error

QString max(const sqlb::Table& t, sqlb::FieldPtr field) const;

void updateSchema();

QString addRecord(const QString& sTableName);

/**

* @brief Creates an empty insert statement.

* @param pk_value This optional parameter can be used to manually set a specific value for the primary key column

* @return An sqlite conform INSERT INTO statement with empty values. (NULL,'',0)

QString emptyInsertStmt(const sqlb::Table& t, const QString& pk_value = QString()) const;

bool deleteRecords(const QString& table, const QStringList& rowids);

bool updateRecord(const QString& table, const QString& column, const QString& rowid, const QByteArray& value, bool itsBlob);

bool createTable(const QString& name, const sqlb::FieldVector& structure);

bool renameTable(const QString& from_table, const QString& to_table);

bool addColumn(const QString& table, const sqlb::FieldPtr& field);

/**

* @brief renameColumn Can be used to rename, modify or drop an existing column of a given table

* @param table_name Specifies the name of the table to edit

* @param table Specifies the table to edit. The table constraints are used from this but not the columns

* @param name Name of the column to edit

* @param to The new field definition with changed name, type or the like. If Null-Pointer is given the column is dropped.

* @param move Set this to a value != 0 to move the new column to a different position

* @return true if renaming was successful, false if not. In the latter case also lastErrorMessage is set

bool renameColumn(const QString& tablename, const sqlb::Table& table, const QString& name, sqlb::FieldPtr to, int move = 0);

objectMap getBrowsableObjects() const;

const sqlb::ObjectPtr getObjectByName(const QString& name) const;

bool isOpen() const;

bool encrypted() const { return isEncrypted; }

bool readOnly() const { return isReadOnly; }

bool getDirty() const;

QString currentFile() const { return curDBFilename; }

void logSQL(QString statement, int msgtype);

QString getPragma(const QString& pragma);

bool setPragma(const QString& pragma, const QString& value);

bool setPragma(const QString& pragma, const QString& value, QString& originalvalue);

bool setPragma(const QString& pragma, int value, int& originalvalue);

bool loadExtension(const QString& filename);

QVector<QPair<QString, QString>> queryColumnInformation(const QString& object_name);

QString generateSavepointName(const QString& identifier = QString()) const;

sqlite3 * _db;

objectMap objMap;

signals:

void sqlExecuted(QString sql, int msgtype);

void dbChanged(bool dirty);

void structureUpdated();

private:

QString curDBFilename;

QString lastErrorMessage;

QStringList savepointList;

bool isEncrypted;

bool isReadOnly;

bool tryEncryptionSettings(const QString& filename, bool* encrypted, CipherDialog*& cipherSettings);

bool dontCheckForStructureUpdates;

class NoStructureUpdateChecks

{

public:

NoStructureUpdateChecks(DBBrowserDB& db) : m_db(db) { m_db.dontCheckForStructureUpdates = true; }

~NoStructureUpdateChecks() { m_db.dontCheckForStructureUpdates = false; }

private:

DBBrowserDB& m_db;

};

#endif

Sunbelt Computer Software

PL/B Language Development and Support

Navigation Menu

Repository navigation

sqlitedb.h

sqlitedb.h

Sunbelt Computer Software

PL/B Language Development and Support

FilesExpand file tree

sqlitedb.h

Latest commit

History

sqlitedb.h

File metadata and controls