Revision caea9141
Von Christian Ehringfeld vor fast 10 Jahren hinzugefügt
| src/database.cpp | ||
|---|---|---|
|
return this->seqTable;
|
||
|
}
|
||
|
|
||
|
QString Database::pgsqlSeqTable() {
|
||
|
return "CREATE TABLE IF NOT EXISTS sequence (SEQ_NAME varchar(255) NOT NULL UNIQUE , SEQ_COUNT bigint NOT NULL);";
|
||
|
}
|
||
|
//QString Database::pgsqlSeqTable() {
|
||
|
// return "CREATE TABLE IF NOT EXISTS sequence (SEQ_NAME varchar(255) NOT NULL UNIQUE , SEQ_COUNT bigint NOT NULL);";
|
||
|
//}
|
||
|
|
||
|
QString Database::mysqlSeqTable() {
|
||
|
return "CREATE TABLE IF NOT EXISTS `sequence` (`SEQ_NAME` varchar(255) NOT NULL UNIQUE , `SEQ_COUNT` bigint(20) unsigned NOT NULL) CHARSET = utf8";
|
||
|
}
|
||
|
//QString Database::mysqlSeqTable() {
|
||
|
// return "CREATE TABLE IF NOT EXISTS `sequence` (`SEQ_NAME` varchar(255) NOT NULL UNIQUE , `SEQ_COUNT` bigint(20) unsigned NOT NULL) CHARSET = utf8";
|
||
|
//}
|
||
|
|
||
|
QString Database::sqliteSeqTable() {
|
||
|
return "CREATE TABLE IF NOT EXISTS \"sequence\" (\"SEQ_NAME\" TEXT PRIMARY KEY NOT NULL , \"SEQ_COUNT\" INTEGER NOT NULL );";
|
||
|
}
|
||
|
//QString Database::sqliteSeqTable() {
|
||
|
// return "CREATE TABLE IF NOT EXISTS \"sequence\" (\"SEQ_NAME\" TEXT PRIMARY KEY NOT NULL , \"SEQ_COUNT\" INTEGER NOT NULL );";
|
||
|
//}
|
||
|
|
||
|
QChar Database::escapeChar() {
|
||
|
QChar c = QChar();
|
||
| src/database.h | ||
|---|---|---|
|
QStringList *tableList;
|
||
|
|
||
|
protected:
|
||
|
inline QString pgsqlSeqTable();
|
||
|
inline QString mysqlSeqTable();
|
||
|
inline QString sqliteSeqTable();
|
||
|
inline QString sqliteTableList();
|
||
|
inline QString mysqlTableList();
|
||
|
inline QString pgsqlTableList();
|
||
|
// inline QString pgsqlSeqTable();
|
||
|
// inline QString mysqlSeqTable();
|
||
|
// inline QString sqliteSeqTable();
|
||
|
// inline QString sqliteTableList();
|
||
|
// inline QString mysqlTableList();
|
||
|
// inline QString pgsqlTableList();
|
||
|
|
||
|
public:
|
||
|
Database(QSqlDatabase database);
|
||
| src/entity.cpp | ||
|---|---|---|
|
Entity::~Entity() {
|
||
|
}
|
||
|
|
||
|
//QHash<QString, QString> OpenTeacherTool::Entity::getProperties(Datebasetype t) {
|
||
|
// QMap<QString, QString> map = QMap<QString, QString>();
|
||
|
// map.insert("id",this->idColumnSQL());
|
||
|
// return map;
|
||
|
//}
|
||
|
|
||
|
//OpenTeacherTool::PersistenceType OpenTeacherTool::Entity::getPersistenceType() {
|
||
|
// OpenTeacherTool::PersistenceType type = SQLITE;
|
||
|
// return type;
|
||
|
//}
|
||
|
|
||
|
//QMap<QString, OpenTeacherTool::Entity> OpenTeacherTool::Entity::getRelations() {
|
||
|
// QMap<QString, Entity> map;
|
||
|
// return map;
|
||
|
//}
|
||
|
|
||
|
|
||
|
|
||
|
QString Entity::getTablename() {
|
||
|
return QString(this->metaObject()->className());
|
||
|
}
|
||
|
}
|
||
| src/entity.h | ||
|---|---|---|
|
virtual qint64 getId();
|
||
|
virtual void setId(qint64 id);
|
||
|
virtual ~Entity();
|
||
|
virtual QString getTablename() = 0;
|
||
|
virtual QString getTablename();
|
||
|
// virtual QMap<QString, QString> getManyToManyRelations() = 0; //Key = Table, Value = joined Table Column
|
||
|
protected:
|
||
|
Entity();
|
||
| src/schema.cpp | ||
|---|---|---|
|
}
|
||
|
|
||
|
QString Schema::quoteSimpleTableName(QString name) {
|
||
|
// return strpos($name, "`") !== false ? $name : "`" . $name . "`";
|
||
|
return name.indexOf("`") ? name : "`" + name + "`";
|
||
|
}
|
||
|
|
||
|
QString Schema::quoteTableName(QString name) {
|
||
| ... | ... | |
|
}
|
||
|
|
||
|
QString Schema::quoteSimpleColumnName(QString name) {
|
||
|
//return strpos($name, '`') !== false || $name === '*' ? $name : '`' . $name . '`';
|
||
|
return name.indexOf("`") || name == "*" ? name : "`" + name + "`";
|
||
|
}
|
||
|
|
||
|
QList<TableSchema> Schema::getTableSchemas(QString schema) {
|
||
|
|
||
|
}
|
||
|
|
||
|
QList<QString> Schema::getTableNames(QString schema) {
|
||
|
|
||
|
QStringList Schema::getTableNames(QString schema) {
|
||
|
//7QStringList QSqlDriver::tables(QSql::TableType tableType) const
|
||
|
}
|
||
|
|
||
|
QList<QString> Schema::findUniqueIndexes(TableSchema schema) {
|
||
|
QStringList Schema::findUniqueIndexes(TableSchema schema) {
|
||
|
|
||
|
}
|
||
|
|
||
| ... | ... | |
|
|
||
|
}
|
||
|
|
||
|
void Schema::quoteValue(QString str) {
|
||
|
|
||
|
}
|
||
|
|
||
|
QString Schema::getRawTable(QString name) {
|
||
|
|
||
|
}
|
||
|
|
||
|
QList<QString> Schema::findTableNames(QString schema) {
|
||
|
QStringList Schema::findTableNames(QString schema) {
|
||
|
|
||
|
}
|
||
|
|
||
|
QList<QString> Schema::findUniqueIndexes(QString tableName) {
|
||
|
QStringList Schema::findUniqueIndexes(QString tableName) {
|
||
|
|
||
|
}
|
||
|
|
||
| src/schema.h | ||
|---|---|---|
|
virtual QString quoteColumnName(QString name);
|
||
|
virtual QString quoteSimpleColumnName(QString name);
|
||
|
virtual QList<TableSchema> getTableSchemas(QString schema = "");
|
||
|
virtual QList<QString> getTableNames(QString schema = "");
|
||
|
virtual QStringList getTableNames(QString schema = "");
|
||
|
//virtual QueryBuilder getQueryBuilder();
|
||
|
//virtual QueryBuilder createQueryBuilder();
|
||
|
virtual QList<QString> findUniqueIndexes(TableSchema schema);
|
||
|
virtual QStringList findUniqueIndexes(TableSchema schema);
|
||
|
virtual QString getLastInsertID(QString sequenceName = "");
|
||
|
virtual void refresh();
|
||
|
virtual void quoteValue(QString str);
|
||
|
virtual QString getRawTable(QString name);
|
||
|
|
||
|
|
||
|
|
||
|
protected:
|
||
|
virtual QList<QString> findTableNames(QString schema = "");
|
||
|
virtual QList<QString> findUniqueIndexes(QString tableName);
|
||
|
virtual QStringList findTableNames(QString schema = "");
|
||
|
virtual QStringList findUniqueIndexes(QString tableName);
|
||
|
virtual TableSchema findConstraints(TableSchema ts);
|
||
|
virtual QString getCreateTableSql(TableSchema ts);
|
||
|
virtual bool findColumns(TableSchema ts);
|
||
|
QSharedPointer<QHash<QString, QString>> typeMap;
|
||
|
virtual TableSchema loadTableSchema(QString name) = 0;
|
||
|
virtual TableSchema getTableSchema(QString name, bool refresh = false);
|
||
|
virtual QList<QString> findTableNames(QString schema = "");
|
||
|
virtual QStringList findTableNames(QString schema = "");
|
||
|
|
||
|
};
|
||
|
}
|
||
| src/tableschema.cpp | ||
|---|---|---|
|
const QList<QString> TableSchema::getColumnNames() {
|
||
|
|
||
|
}
|
||
|
|
||
|
QString TableSchema::getSchemaName() const {
|
||
|
return schemaName;
|
||
|
}
|
||
| ... | ... | |
|
void TableSchema::setColumns(const QList<ColumnSchema> &value) {
|
||
|
columns = value;
|
||
|
}
|
||
|
|
||
|
|
||
|
|
||
|
|
||
|
|
||
|
|
||
|
|
||
|
|
||
Auch abrufbar als: Unified diff
...