Revision 1ac14ffb
Von Christian Ehringfeld vor etwa 8 Jahren hinzugefügt
src/entityhelper.cpp | ||
---|---|---|
void EntityHelper::setListProperty(const QSharedPointer<Entity> &entity,
|
||
QList<QSharedPointer<Entity>> &value, const QMetaProperty &property) {
|
||
auto i = EntityInstanceFactory::createInstance(EntityInstanceFactory::extractEntityType(property.typeName()));
|
||
auto t = property.typeName();
|
||
if(i) {
|
||
i->setListProperty(entity, value, property);
|
||
delete i;
|
src/entitymanager.cpp | ||
---|---|---|
QStringList EntityManager::connectionNames = QStringList();
|
||
|
||
QHash<QString, EntityManager *> EntityManager::instances =
|
||
QHash<QString, EntityManager *>();
|
||
QHash<QString, EntityManager *>();
|
||
|
||
QStringList EntityManager::getConnectionNames() {
|
||
return EntityManager::connectionNames;
|
||
... | ... | |
void EntityManager::init(bool inspect, const MsgType msgType) {
|
||
EntityInstanceFactory::registerClass<DatabaseMigration>();
|
||
this->schema = QSharedPointer<Schema>(Database::getSchema(Database::getDatabaseType(
|
||
this->db->getDatabase().driverName()), this->db));
|
||
this->db->getDatabase().driverName()), this->db));
|
||
this->schema->setTables(this->schema->getTableSchemas());
|
||
this->ar = QSharedPointer<AttributeResolver>(new AttributeResolver(
|
||
this->schema->getQueryBuilder()));
|
||
this->schema->getQueryBuilder()));
|
||
this->queryInterpreter = QSharedPointer<QueryInterpreter>(new QueryInterpreter(
|
||
this->ar));
|
||
this->ar));
|
||
this->appendToInstanceList();
|
||
if (inspect) {
|
||
EntityInspector inspector = EntityInspector(msgType);
|
||
... | ... | |
loggerFile.replace("[", "");
|
||
loggerFile.replace("]", "");
|
||
this->logger = QSharedPointer<Logger>(new Logger(QDir::currentPath() + "/" +
|
||
loggerFile, msgType));
|
||
loggerFile, msgType));
|
||
}
|
||
|
||
EntityManager::EntityManager(const QString &databaseType, QString databasename,
|
||
... | ... | |
bool logQueries, QString databaseOptions, const bool inspectEntities,
|
||
CuteEntityManager::MsgType logActions) : QObject() {
|
||
this->db = QSharedPointer<Database>(new Database(databaseType, this->createConnection(),
|
||
hostname,
|
||
databasename, username,
|
||
password,
|
||
port.toInt(), true, logQueries, databaseOptions, logActions));
|
||
hostname,
|
||
databasename, username,
|
||
password,
|
||
port.toInt(), true, logQueries, databaseOptions, logActions));
|
||
this->init(inspectEntities, logActions);
|
||
}
|
||
|
||
... | ... | |
}
|
||
this->db->startTransaction();
|
||
QList<QSqlQuery> q = this->schema->getQueryBuilder()->merge(
|
||
entity);
|
||
entity);
|
||
ok = this->db->exec(q);
|
||
if (!ok || !this->db->commitTransaction()) {
|
||
this->db->rollbackTransaction();
|
||
... | ... | |
}
|
||
this->db->startTransaction();
|
||
QList<QSqlQuery> q = this->schema->getQueryBuilder()->create(
|
||
entity);
|
||
entity);
|
||
bool first = true;
|
||
QVariant id = -1;
|
||
for (int var = 0; var < q.size(); ++var) {
|
||
... | ... | |
bool EntityManager::startup(QString version, QStringList toInitialize,
|
||
bool createIndices) {
|
||
QSharedPointer<Entity> dbm = QSharedPointer<DatabaseMigration>
|
||
(new DatabaseMigration());
|
||
(new DatabaseMigration());
|
||
QHash<QString, QVariant> map = QHash<QString, QVariant>();
|
||
bool ok = true;
|
||
map.insert("version", version);
|
||
... | ... | |
if (ok) {
|
||
QString c = toInitialize.at(var);
|
||
auto entity = QSharedPointer<Entity>
|
||
(EntityInstanceFactory::createInstance(c));
|
||
(EntityInstanceFactory::createInstance(c));
|
||
ok = this->createTable(entity, false);
|
||
entities.append(entity);
|
||
} else {
|
||
this->logger->logMsg("startup of version " + version + " failed",
|
||
MsgType::CRITICAL);
|
||
this->logger->logMsg( "erroneous entity:" + (var == 0 ?
|
||
"null, this should not happen!" : toInitialize.at(var - 1)), MsgType::CRITICAL);
|
||
"null, this should not happen!" : toInitialize.at(var - 1)), MsgType::CRITICAL);
|
||
break;
|
||
}
|
||
}
|
||
... | ... | |
}
|
||
|
||
QList<QHash<QString, QVariant>> EntityManager::selectBySql(
|
||
const QString &sql) {
|
||
const QString &sql) {
|
||
QSqlQuery q = this->db->select(sql);
|
||
return this->convertQueryResult(q);
|
||
}
|
||
... | ... | |
for (int i = 0; i < rules.size(); ++i) {
|
||
ValidationRule rule = rules.at(i);
|
||
QSharedPointer<Validator> validator = ValidatorFactory::getValidatorObject(
|
||
rule.getValidatorName());
|
||
rule.getValidatorName());
|
||
if (validator) {
|
||
for (int var = 0; var < rule.getAttributes().size(); ++var) {
|
||
QString attr = rule.getAttributes().at(var);
|
||
QList<ErrorMsg> msgs = validator->validate(entity->getProperty(attr),
|
||
rule.getParams());
|
||
rule.getParams());
|
||
for (int i = 0; i < msgs.size(); ++i) {
|
||
QString emsg = msgs.at(i).getErrorMsg().replace("<property>", attr);
|
||
ErrorMsg m = msgs.at(i);
|
||
... | ... | |
for (auto i = listmap.constBegin(); i != listmap.constEnd(); ++i) {
|
||
if (rels.contains(i.key())) {
|
||
QString appendix =
|
||
this->schema->getQueryBuilder()->columnNameIDAppendix();
|
||
this->schema->getQueryBuilder()->columnNameIDAppendix();
|
||
QString relKey = i.key();
|
||
QVariant v = entity->getProperty(relKey.remove(relKey.size() - appendix.size(),
|
||
appendix.size()));
|
||
appendix.size()));
|
||
if (!v.isNull() && v.data()) {
|
||
auto e = EntityInstanceFactory::castQVariant(v);
|
||
if (e && e->getProperty(e->getPrimaryKey()) != i.value()) {
|
||
... | ... | |
}
|
||
|
||
QSharedPointer<Entity> EntityManager::findById(const qint64 &id,
|
||
QSharedPointer<Entity> &e,
|
||
const bool refresh) {
|
||
QSharedPointer<Entity> &e,
|
||
const bool refresh) {
|
||
QSharedPointer<Entity> r;
|
||
if (e && (refresh || !(r = this->cache.get(id, EntityHelper::getClassname(e.data()))))) {
|
||
auto map = this->findByPk(id, e);
|
||
... | ... | |
}
|
||
|
||
QSharedPointer<Entity> EntityManager::findById(const qint64 &id,
|
||
const QString &classname, const bool refresh) {
|
||
const QString &classname, const bool refresh) {
|
||
QSharedPointer<Entity> e = QSharedPointer<Entity>
|
||
(EntityInstanceFactory::createInstance(classname));
|
||
(EntityInstanceFactory::createInstance(classname));
|
||
return this->findById(id, e, refresh);
|
||
}
|
||
|
||
... | ... | |
QString className = attr->getRelatedClass()->className();
|
||
QSharedPointer<Entity> ptr = QSharedPointer<Entity>();
|
||
if (!(this->cache.contains(convertedId, className)
|
||
&& (ptr = this->cache.get(convertedId, className)))) {
|
||
&& (ptr = this->cache.get(convertedId, className)))) {
|
||
ptr = this->findById(convertedId, className);
|
||
}
|
||
EntityHelper::setProperty(entity,ptr,attr->getMetaProperty());
|
||
... | ... | |
auto e = QSharedPointer<Entity>(EntityInstanceFactory::createInstance(attr));
|
||
if (e) {
|
||
Query query = this->schema->getQueryBuilder()->oneToMany(
|
||
attr->getRelatedTable(),
|
||
attr->getRelatedColumnName(), entity->getId());
|
||
attr->getRelatedTable(),
|
||
attr->getRelatedColumnName(), entity->getId());
|
||
QSqlQuery q = this->queryInterpreter->build(query);
|
||
auto listMap = this->convertQueryResult(q);
|
||
auto relationalClass = EntityHelper::getClassName(e.data());
|
||
... | ... | |
auto e = QSharedPointer<Entity>(EntityInstanceFactory::createInstance(attr));
|
||
if (e) {
|
||
Query query = this->schema->getQueryBuilder()->oneToMany(
|
||
e->getTablename(),
|
||
this->schema->getQueryBuilder()->generateColumnNameID(
|
||
attr->getRelation().getMappedBy()),
|
||
entity->getProperty(entity->getPrimaryKey()).toLongLong(), 1);
|
||
e->getTablename(),
|
||
this->schema->getQueryBuilder()->generateColumnNameID(
|
||
attr->getRelation().getMappedBy()),
|
||
entity->getProperty(entity->getPrimaryKey()).toLongLong(), 1);
|
||
QSqlQuery q = this->queryInterpreter->build(query);
|
||
auto listMap = this->convertQueryResult(q);
|
||
auto entities = this->convert(listMap, EntityHelper::getClassname(e.data()));
|
||
... | ... | |
}
|
||
|
||
void EntityManager::savePrePersistedRelations(const QSharedPointer<Entity>
|
||
&entity, QList<Entity *> &mergedObjects, bool ignoreHasChanged) {
|
||
&entity, QList<Entity *> &mergedObjects, bool ignoreHasChanged) {
|
||
auto relations = EntityHelper::getRelationProperties(entity.data());
|
||
auto iterator = relations.constBegin();
|
||
while (iterator != relations.constEnd()) {
|
||
... | ... | |
}
|
||
|
||
void EntityManager::savePostPersistedRelations(const QSharedPointer<Entity>
|
||
&entity, QList<Entity *> &mergedObjects, bool ignoreHasChanged, bool newItem) {
|
||
&entity, QList<Entity *> &mergedObjects, bool ignoreHasChanged, bool newItem) {
|
||
auto relations = EntityHelper::getRelationProperties(entity.data());
|
||
for (auto i = relations.constBegin(); i != relations.constEnd(); ++i) {
|
||
const Relation r = i.key();
|
||
... | ... | |
newItem);
|
||
} else if (r.getType() == RelationType::ONE_TO_MANY) {
|
||
QList<QSharedPointer<Entity>> list = EntityInstanceFactory::castQVariantList(
|
||
var);
|
||
var);
|
||
if (!list.isEmpty()) {
|
||
auto fkProp = EntityHelper::mappedProperty(r, list.at(0));
|
||
for (int var = 0; var < list.size(); ++var) {
|
||
... | ... | |
}
|
||
|
||
void EntityManager::persistMappedByRelation(const QList<QSharedPointer<Entity>>
|
||
&list, QSqlQuery &q, const QSharedPointer<Entity> &entity,
|
||
const QSharedPointer<Entity> &ptr, const Relation &r,
|
||
const QString &tblName, QList<Entity *> &mergedObjects) {
|
||
&list, QSqlQuery &q, const QSharedPointer<Entity> &entity,
|
||
const QSharedPointer<Entity> &ptr, const Relation &r,
|
||
const QString &tblName, QList<Entity *> &mergedObjects) {
|
||
q.clear();
|
||
QList<QSharedPointer<Entity>> saved =
|
||
r.getCascadeType().contains(CascadeType::ALL) ||
|
||
r.getCascadeType().contains(CascadeType::MERGE) ||
|
||
r.getCascadeType().contains(CascadeType::PERSIST) ?
|
||
this->saveRelationEntities(list, r, mergedObjects) : list;
|
||
r.getCascadeType().contains(CascadeType::ALL) ||
|
||
r.getCascadeType().contains(CascadeType::MERGE) ||
|
||
r.getCascadeType().contains(CascadeType::PERSIST) ?
|
||
this->saveRelationEntities(list, r, mergedObjects) : list;
|
||
this->db->startTransaction();
|
||
auto builder = this->schema->getQueryBuilder();
|
||
q = builder->manyToManyInsert(tblName,
|
||
... | ... | |
}
|
||
|
||
void EntityManager::setNullEntityPropertyRelation(QVariant &var,
|
||
const Relation &r) {
|
||
const Relation &r) {
|
||
if (r.getCascadeType().contains(CascadeType::REMOVE)
|
||
|| r.getCascadeType().contains(CascadeType::ALL)) {
|
||
this->removeEntity(var);
|
||
... | ... | |
}
|
||
|
||
void EntityManager::removeManyToManyEntityList(const QSharedPointer<Entity> &e,
|
||
const Relation &r,
|
||
QVariant &var) {
|
||
const Relation &r,
|
||
QVariant &var) {
|
||
if (!var.isNull() && var.canConvert<QVariantList>()) {
|
||
auto list = EntityInstanceFactory::castQVariantList(var);
|
||
if (!list.isEmpty()) {
|
||
... | ... | |
QString tblName = builder->generateManyToManyTableName(e, ptr, r);
|
||
if (this->schema->getTables().contains(tblName)) {
|
||
QSqlQuery q = builder->manyToManyDelete(
|
||
tblName, builder->generateManyToManyColumnName(e, r.getPropertyName()),
|
||
e->getProperty(e->getPrimaryKey()).toLongLong());
|
||
tblName, builder->generateManyToManyColumnName(e, r.getPropertyName()),
|
||
e->getProperty(e->getPrimaryKey()).toLongLong());
|
||
if (this->db->exec(q)) {
|
||
bool refresh = r.getCascadeType().contains(CascadeType::REFRESH)
|
||
|| r.getCascadeType().contains(CascadeType::ALL);
|
||
|| r.getCascadeType().contains(CascadeType::ALL);
|
||
bool remove = r.getCascadeType().contains(CascadeType::REMOVE)
|
||
|| r.getCascadeType().contains(CascadeType::ALL);
|
||
|| r.getCascadeType().contains(CascadeType::ALL);
|
||
auto fkProp = EntityHelper::mappedProperty(r, ptr);
|
||
for (int var = 0; var < list.size(); ++var) {
|
||
auto entity = list.at(var);
|
||
... | ... | |
}
|
||
|
||
QList<QSharedPointer<Entity>> EntityManager::saveRelationEntities(
|
||
const QList<QSharedPointer<Entity>> &list, const Relation &r,
|
||
QList<Entity *> &mergedObjects) {
|
||
const QList<QSharedPointer<Entity>> &list, const Relation &r,
|
||
QList<Entity *> &mergedObjects) {
|
||
QList<QSharedPointer<Entity>> saved = QList<QSharedPointer<Entity>>();
|
||
QSharedPointer<Entity> ptr;
|
||
for (int var = 0; var < list.size(); ++var) {
|
||
... | ... | |
* @todo diff and remove entity from relational object when association is deleted
|
||
*/
|
||
q = builder->manyToManyDelete(
|
||
tblName, builder->generateManyToManyColumnName(entity, r.getPropertyName()),
|
||
entity->getProperty(entity->getPrimaryKey()).toLongLong());
|
||
tblName, builder->generateManyToManyColumnName(entity, r.getPropertyName()),
|
||
entity->getProperty(entity->getPrimaryKey()).toLongLong());
|
||
ok = this->db->exec(q);
|
||
} else {
|
||
q = builder->getQuery();
|
||
... | ... | |
}
|
||
|
||
void EntityManager::missingManyToManyTable(const QString &tblName,
|
||
const QSharedPointer<Entity> &e, const Relation &r) {
|
||
const QSharedPointer<Entity> &e, const Relation &r) {
|
||
QString text = "MANY_TO_MANY Table " + tblName + " is missing.\n" +
|
||
"Entity " + EntityHelper::getClassName(e.data()) +
|
||
" is affected.\n" + "Relation of property: " + r.getPropertyName();
|
||
"Entity " + EntityHelper::getClassName(e.data()) +
|
||
" is affected.\n" + "Relation of property: " + r.getPropertyName();
|
||
#ifdef QT_DEBUG
|
||
throw QString(text);
|
||
#else
|
||
... | ... | |
void EntityManager::manyToMany(const QSharedPointer<Entity> &entity,
|
||
Attribute *&attr) {
|
||
QSharedPointer<Entity> secEntityPtr = QSharedPointer<Entity>
|
||
(EntityInstanceFactory::createInstance(attr->getRelatedClass()->className()));
|
||
(EntityInstanceFactory::createInstance(attr->getRelatedClass()->className()));
|
||
auto builder = this->schema->getQueryBuilder();
|
||
EntityHelper::clearEntityListProperty(entity, attr->getMetaProperty());
|
||
if (secEntityPtr) {
|
||
... | ... | |
for (int var = 0; var < listMap.size(); ++var) {
|
||
auto id = listMap.at(var).value(attr->getRelatedColumnName());
|
||
if (!(this->cache.contains(id.toLongLong(), secClassName) &&
|
||
(e = this->cache.get(id.toLongLong(), secClassName)))) {
|
||
(e = this->cache.get(id.toLongLong(), secClassName)))) {
|
||
e = this->findById(id.toLongLong(), secClassName);
|
||
}
|
||
if (e) {
|
||
... | ... | |
}
|
||
|
||
QList<QSharedPointer<Entity>> EntityManager::findEntityByAttributes(
|
||
const QSharedPointer<Entity> &entity,
|
||
bool ignoreID, const bool resolveRelations) {
|
||
const QSharedPointer<Entity> &entity,
|
||
bool ignoreID, const bool resolveRelations) {
|
||
auto maps = this->findAllByAttributes(entity, ignoreID);
|
||
return this->convert(maps, EntityHelper::getClassname(entity.data()), resolveRelations);
|
||
}
|
||
|
||
QHash<QString, QVariant> EntityManager::findByPk(qint64 id,
|
||
const QSharedPointer<Entity>
|
||
&e) {
|
||
const QSharedPointer<Entity>
|
||
&e) {
|
||
QSqlQuery q = this->schema->getQueryBuilder()->find(id, e, 0,
|
||
e->getPrimaryKey());
|
||
e->getPrimaryKey());
|
||
auto listMap = this->convertQueryResult(q);
|
||
if (!listMap.isEmpty()) {
|
||
return listMap.at(0);
|
||
... | ... | |
|
||
|
||
QList<QHash<QString, QVariant>> EntityManager::findAllByAttributes(
|
||
const QSharedPointer<Entity>
|
||
&entity,
|
||
bool ignoreID) {
|
||
const QSharedPointer<Entity>
|
||
&entity,
|
||
bool ignoreID) {
|
||
Query query = this->schema->getQueryBuilder()->findByAttributes(
|
||
entity, ignoreID);
|
||
entity, ignoreID);
|
||
QSqlQuery q = this->queryInterpreter->build(query);
|
||
return this->convertQueryResult(q);
|
||
}
|
||
|
||
QList<QHash <QString, QVariant>> EntityManager::findAllByAttributes(
|
||
const QHash<QString, QVariant> &m, const QString &tblname, bool ignoreID) {
|
||
const QHash<QString, QVariant> &m, const QString &tblname, bool ignoreID) {
|
||
Query query = this->schema->getQueryBuilder()->findByAttributes(m,
|
||
tblname, ignoreID);
|
||
tblname, ignoreID);
|
||
QSqlQuery q = this->queryInterpreter->build(query);
|
||
return this->convertQueryResult(q);
|
||
}
|
||
|
||
QList<QHash<QString, QVariant>> EntityManager::convertQueryResult(
|
||
QSqlQuery &q) {
|
||
QSqlQuery &q) {
|
||
QList<QHash <QString, QVariant>> listmap = QList<QHash <QString, QVariant>>();
|
||
this->db->select(q);
|
||
QSqlRecord rec = q.record();
|
||
... | ... | |
}
|
||
|
||
QList<QHash <QString, QVariant>> EntityManager::findAll(
|
||
const QSharedPointer<Entity> &e) {
|
||
const QSharedPointer<Entity> &e) {
|
||
QSqlQuery q = this->schema->getQueryBuilder()->findAll(e);
|
||
return this->convertQueryResult(q);
|
||
}
|
||
... | ... | |
bool EntityManager::createTable(const QSharedPointer<Entity> &entity,
|
||
bool createRelationTables) {
|
||
return this->schema->getQueryBuilder()->createTable(entity,
|
||
createRelationTables);
|
||
createRelationTables);
|
||
}
|
||
|
||
bool EntityManager::createTable(QString className, bool createRelationTables) {
|
||
QSharedPointer<Entity> e = QSharedPointer<Entity>
|
||
(EntityInstanceFactory::createInstance(className));
|
||
(EntityInstanceFactory::createInstance(className));
|
||
return this->schema->getQueryBuilder()->createTable(e, createRelationTables);
|
||
}
|
||
|
||
... | ... | |
if (joinBaseClasses) {
|
||
q.appendJoins(qb->joinBaseClasses(entity));
|
||
values = EntityHelper::getEntityAttributes(EntityHelper::getMetaProperties(
|
||
entity.data()), entity);
|
||
entity.data()), entity);
|
||
} else {
|
||
values = EntityHelper::getEntityAttributes(
|
||
EntityHelper::getNonInheritedMetaProperties(entity.data()), entity);
|
||
EntityHelper::getNonInheritedMetaProperties(entity.data()), entity);
|
||
}
|
||
//maybe filter MANY_TO_MANY and ONE_TO_MANY relations
|
||
q.appendFrom(entity->getTablename());
|
||
... | ... | |
}
|
||
|
||
QSharedPointer<Entity> EntityManager::convert(const QHash<QString, QVariant>
|
||
&map,
|
||
const char *classname, const bool resolveRelations) {
|
||
auto ptr = QSharedPointer<Entity>(EntityInstanceFactory::createInstance(
|
||
classname, map));
|
||
&map,
|
||
const char *classname, const bool resolveRelations) {
|
||
auto ptr = QSharedPointer<Entity>(map.isEmpty() ? nullptr : EntityInstanceFactory::createInstance(
|
||
classname, map));
|
||
this->cache.insert(ptr);
|
||
if (resolveRelations) {
|
||
this->resolveRelations(ptr, map);
|
||
... | ... | |
}
|
||
|
||
QList<QSharedPointer<Entity>> EntityManager::convert(
|
||
QList<QHash<QString, QVariant>> maps,
|
||
const char *classname, const bool resolveRelations) {
|
||
QList<QHash<QString, QVariant>> maps,
|
||
const char *classname, const bool resolveRelations) {
|
||
auto list = QList<QSharedPointer<Entity>>();
|
||
for (int var = 0; var < maps.size(); ++var) {
|
||
auto ptr = this->convert(maps.at(var), classname, resolveRelations);
|
tests/em/tst_em.cpp | ||
---|---|---|
QVERIFY(this->e->findById(id, p->getClassname()));
|
||
}
|
||
|
||
void EmTest::testFindByIdOnNull()
|
||
{
|
||
QSharedPointer<Person> p = QSharedPointer<Person>(new Person("Patrick", "De",
|
||
Person::Gender::MALE, "Pat", QDate(2000, 1, 1)));
|
||
auto ent = p.objectCast<Entity>();
|
||
QVERIFY(this->e->create(ent));
|
||
auto id = p->getId();
|
||
QVERIFY(id > -1);
|
||
if(this->e->findById(-1, p->getClassname())) {
|
||
QFAIL("FindById should not return any Person Pointer");
|
||
}
|
||
if(this->e->findById(63275, p->getClassname())) {
|
||
QFAIL("FindById should not return any Person Pointer");
|
||
}
|
||
}
|
||
|
||
void EmTest::testFindId() {
|
||
QSharedPointer<Person> p = QSharedPointer<Person>(new Person("Essi", "Sa",
|
||
Person::Gender::MALE, "Essi", QDate(2000, 1, 1)));
|
tests/em/tst_em.h | ||
---|---|---|
void init();
|
||
void cleanup();
|
||
void testFindById();
|
||
void testFindByIdOnNull();
|
||
void testFindId();
|
||
void testHasChanged();
|
||
void testValidate();
|
Auch abrufbar als: Unified diff
closes #625