Revision 9cf4747e
Von Christian Ehringfeld vor etwa 9 Jahren hinzugefügt
| src/schema.cpp | ||
|---|---|---|
|
#include "schema.h"
|
||
|
#include <QRegularExpression>
|
||
|
#include <QSqlRecord>
|
||
|
#include <QSqlQuery>
|
||
|
using namespace CuteEntityManager;
|
||
|
|
||
|
Schema::Schema() {
|
||
|
Schema::Schema(std::shared_ptr<Database> database) {
|
||
|
this->database = database;
|
||
|
this->typeMap = QSharedPointer<QHash<QString, QString>>(new QHash<QString, QString>());
|
||
|
}
|
||
|
|
||
| ... | ... | |
|
}
|
||
|
|
||
|
QString Schema::quoteTableName(QString name) {
|
||
|
|
||
|
if (name.indexOf("(") || name.indexOf("{{")) {
|
||
|
return name;
|
||
|
}
|
||
|
if (name.indexOf(".") == -1) {
|
||
|
return this->quoteSimpleTableName(name);
|
||
|
}
|
||
|
QStringList parts = name.split(".");
|
||
|
for (int i = 0; i < parts.size(); ++i) {
|
||
|
parts.replace(i, this->quoteSimpleTableName(parts.at(i)));
|
||
|
}
|
||
|
return parts.join(".");
|
||
|
}
|
||
|
|
||
|
QString Schema::quoteColumnName(QString name) {
|
||
|
|
||
|
if (name.indexOf("(") || name.indexOf("[[") || name.indexOf("{{")) {
|
||
|
return name;
|
||
|
}
|
||
|
int pos = name.indexOf(".");
|
||
|
QString prefix = "";
|
||
|
if (pos) {
|
||
|
prefix = this->quoteTableName(name.mid(0, pos)) + ".";
|
||
|
name = name.mid(pos + 1);
|
||
|
}
|
||
|
return prefix + this->quoteSimpleColumnName(name);
|
||
|
}
|
||
|
|
||
|
QString Schema::quoteSimpleColumnName(QString name) {
|
||
|
return name.indexOf("`") || name == "*" ? name : "`" + name + "`";
|
||
|
}
|
||
|
|
||
|
QList<TableSchema> Schema::getTableSchemas(QString schema) {
|
||
|
|
||
|
QHash<QString, QSharedPointer<TableSchema> > Schema::getTableSchemas(QString schema, bool refresh) {
|
||
|
QStringList names = this->getTableNames();
|
||
|
for (int i = 0; i < names.size(); ++i) {
|
||
|
QString name;
|
||
|
if (schema != "") {
|
||
|
name = schema + "." + names.at(i);
|
||
|
}
|
||
|
TableSchema *t = this->getTableSchema(name, refresh);
|
||
|
if (t) {
|
||
|
this->tables.insert(name, QSharedPointer<TableSchema>(t));
|
||
|
}
|
||
|
}
|
||
|
return this->tables;
|
||
|
}
|
||
|
|
||
|
QStringList Schema::getTableNames(QString schema) {
|
||
|
//7QStringList QSqlDriver::tables(QSql::TableType tableType) const
|
||
|
return this->database.get()->getDatabase().tables();
|
||
|
}
|
||
|
|
||
|
QStringList Schema::findUniqueIndexes(TableSchema schema) {
|
||
|
|
||
|
}
|
||
|
|
||
|
QString Schema::getLastInsertID(QString sequenceName) {
|
||
|
|
||
|
QVariant Schema::getLastInsertID() {
|
||
|
QSqlQuery q(this->database.get()->getDatabase());
|
||
|
return q.lastInsertId();
|
||
|
}
|
||
|
|
||
|
void Schema::refresh() {
|
||
|
|
||
|
this->tables.clear();
|
||
|
}
|
||
|
|
||
|
QString Schema::getRawTable(QString name) {
|
||
|
|
||
|
}
|
||
|
|
||
|
QStringList Schema::findTableNames(QString schema) {
|
||
|
|
||
|
}
|
||
|
|
||
|
QStringList Schema::findUniqueIndexes(QString tableName) {
|
||
|
|
||
|
}
|
||
|
|
||
|
TableSchema Schema::findConstraints(TableSchema ts) {
|
||
|
}
|
||
|
|
||
|
QString Schema::getCreateTableSql(TableSchema ts) {
|
||
|
|
||
|
}
|
||
|
|
||
|
bool Schema::findColumns(TableSchema ts) {
|
||
|
|
||
|
}
|
||
|
|
||
|
TableSchema Schema::getTableSchema(QString name, bool refresh) {
|
||
|
|
||
|
if (name.indexOf("{{")) {
|
||
|
QRegularExpression re("/\\{\\{(.*?)\\}\\}/");
|
||
|
QRegularExpression re2("\1");
|
||
|
return name.replace(re, re2);
|
||
|
}
|
||
|
return name;
|
||
|
}
|
||
|
|
||
|
TableSchema *Schema::getTableSchema(QString name, bool refresh) {
|
||
|
if (refresh) {
|
||
|
this->refresh();
|
||
|
}
|
||
|
if (this->tables.contains(name)) {
|
||
|
return this->tables.value(name);
|
||
|
}
|
||
|
QString realName = this->getRawTable(name);
|
||
|
QSharedPointer<TableSchema> ts = this->loadTableSchema(realName);
|
||
|
if (ts.data()) {
|
||
|
this->tables.insert(name, ts);
|
||
|
}
|
||
|
return ts.data();
|
||
|
|
||
|
}
|
||
|
QHash<QString, QSharedPointer<TableSchema> > Schema::getTables() const {
|
||
|
return this->tables;
|
||
|
}
|
||
|
|
||
|
void Schema::setTables(const QHash<QString, QSharedPointer<TableSchema> > &value) {
|
||
|
tables = value;
|
||
|
}
|
||
|
|
||
Auch abrufbar als: Unified diff
wip