Herunterladen als
root/tests/em/tst_em.cpp @ f8b8663b
| e7cfc35a | Christian Ehringfeld | #include <QString>
|
|
#include <QtTest>
|
|||
#include "entitymanager.h"
|
|||
#include "databasemigration.h"
|
|||
#include "../models.h"
|
|||
class Em : public QObject {
|
|||
Q_OBJECT
|
|||
public:
|
|||
Em();
|
|||
private Q_SLOTS:
|
|||
void initTestCase();
|
|||
void cleanupTestCase();
|
|||
void testCheckDuplicates();
|
|||
void testBasics();
|
|||
void init();
|
|||
void cleanup();
|
|||
void testFindById();
|
|||
void testFindId();
|
|||
void testHasChanged();
|
|||
void testValidate();
|
|||
void testRelations();
|
|||
| f8b8663b | Christian Ehringfeld | void testRelationTableCreation();
|
|
| e7cfc35a | Christian Ehringfeld | ||
private:
|
|||
CuteEntityManager::EntityManager *e;
|
|||
};
|
|||
Em::Em() {
|
|||
}
|
|||
void Em::initTestCase() {
|
|||
CuteEntityManager::EntityInstanceFactory::registerClass<Group>();
|
|||
CuteEntityManager::EntityInstanceFactory::registerClass<Person>();
|
|||
CuteEntityManager::EntityInstanceFactory::registerClass<Article>();
|
|||
| f8b8663b | Christian Ehringfeld | CuteEntityManager::EntityInstanceFactory::registerClass<Employee>();
|
|
CuteEntityManager::EntityInstanceFactory::registerClass<WorkerGroup>();
|
|||
| e7cfc35a | Christian Ehringfeld | this->e = new CuteEntityManager::EntityManager("QSQLITE",
|
|
":memory:", "", "", "", "", true, "foreign_keys = ON");
|
|||
}
|
|||
void Em::cleanupTestCase() {
|
|||
if (this->e) {
|
|||
delete this->e;
|
|||
this->e = nullptr;
|
|||
}
|
|||
}
|
|||
void Em::testCheckDuplicates() {
|
|||
QSharedPointer<Article> article = QSharedPointer<Article>(new Article(10,
|
|||
QString("TestItem")));
|
|||
QSharedPointer<Entity> entity = article.objectCast<Entity>();
|
|||
QVERIFY(this->e->create(entity));
|
|||
QSharedPointer<Entity> copy = QSharedPointer<Entity>(article->copy());
|
|||
QVERIFY(!this->e->create(copy, true, true));
|
|||
}
|
|||
void Em::testBasics() {
|
|||
QSharedPointer<Article> article = QSharedPointer<Article>(new Article(10,
|
|||
QString("TestItem")));
|
|||
QSharedPointer<Entity> entity = article.objectCast<Entity>();
|
|||
QVERIFY(this->e->create(entity));
|
|||
article->setPrice(20);
|
|||
article->setName("NewTestItem");
|
|||
QVERIFY(this->e->save(entity));
|
|||
QHash<QString, QVariant> attrs = QHash<QString, QVariant>();
|
|||
attrs.insert("price", 20);
|
|||
attrs.insert("name", "NewTestItem");
|
|||
QSharedPointer<Article> article2 = this->e->findEntityByAttributes<Article>
|
|||
(attrs);
|
|||
QVERIFY(article2);
|
|||
entity = article2.objectCast<Entity>();
|
|||
QVERIFY(this->e->remove(entity));
|
|||
QCOMPARE(this->e->count("article"), (quint8)0);
|
|||
}
|
|||
void Em::init() {
|
|||
QStringList inits = QStringList() << "Person" << "Group" << "Article";
|
|||
| f8b8663b | Christian Ehringfeld | QVERIFY2(this->e->startup("emTestA", inits), "Failure");
|
|
| e7cfc35a | Christian Ehringfeld | auto tableNames = this->e->getSchema()->getTableNames();
|
|
QVERIFY(tableNames.contains("article"));
|
|||
QVERIFY(tableNames.contains("person"));
|
|||
QVERIFY(tableNames.contains("group"));
|
|||
| f8b8663b | Christian Ehringfeld | QVERIFY(tableNames.contains("person_groups"));
|
|
QVERIFY(!tableNames.contains("group_persons"));
|
|||
| e7cfc35a | Christian Ehringfeld | QVERIFY(tableNames.contains("cuteentitymanager::databasemigration"));
|
|
auto migrations = this->e->findAll<CuteEntityManager::DatabaseMigration>();
|
|||
QCOMPARE(migrations.size(), 1);
|
|||
| f8b8663b | Christian Ehringfeld | QCOMPARE(migrations.at(0)->getVersion(), QString("emTestA"));
|
|
| e7cfc35a | Christian Ehringfeld | }
|
|
void Em::cleanup() {
|
|||
auto qb = this->e->getQueryBuilder();
|
|||
| f8b8663b | Christian Ehringfeld | QVERIFY(this->e->executeQuery(qb->dropTable("person_groups")));
|
|
| e7cfc35a | Christian Ehringfeld | QVERIFY(this->e->executeQuery(qb->dropTable("group")));
|
|
QVERIFY(this->e->executeQuery(qb->dropTable("person")));
|
|||
QVERIFY(this->e->executeQuery(qb->dropTable("article")));
|
|||
auto tableNames = this->e->getSchema()->getTableNames();
|
|||
QVERIFY(!tableNames.contains("person"));
|
|||
QVERIFY(!tableNames.contains("group"));
|
|||
QVERIFY(!tableNames.contains("article"));
|
|||
| f8b8663b | Christian Ehringfeld | QVERIFY(!tableNames.contains("person_groups"));
|
|
| e7cfc35a | Christian Ehringfeld | QVERIFY(this->e->removeAll("cuteentitymanager::databasemigration"));
|
|
}
|
|||
| f8b8663b | Christian Ehringfeld | void Em::testRelationTableCreation() {
|
|
QStringList relationTables = QStringList() << "Employee" << "WorkerGroup";
|
|||
QVERIFY2(this->e->startup("emTestB", relationTables), "Failure");
|
|||
auto tableNames = this->e->getSchema()->getTableNames();
|
|||
QVERIFY(tableNames.contains("workergroup"));
|
|||
QVERIFY(tableNames.contains("employee"));
|
|||
QVERIFY(tableNames.contains("workergroup_workers"));
|
|||
QVERIFY(!tableNames.contains("group_employee"));
|
|||
QVERIFY(!tableNames.contains("employee_workergroups"));
|
|||
QVERIFY(!tableNames.contains("employee_groups"));
|
|||
QVERIFY(tableNames.contains("cuteentitymanager::databasemigration"));
|
|||
auto migrations = this->e->findAll<CuteEntityManager::DatabaseMigration>();
|
|||
QCOMPARE(migrations.size(), 2);
|
|||
QCOMPARE(migrations.at(1)->getVersion(), QString("emTestB"));
|
|||
auto qb = this->e->getQueryBuilder();
|
|||
QVERIFY(this->e->executeQuery(qb->dropTable("workergroup_workers")));
|
|||
QVERIFY(this->e->executeQuery(qb->dropTable("employee")));
|
|||
QVERIFY(this->e->executeQuery(qb->dropTable("workergroup")));
|
|||
}
|
|||
| e7cfc35a | Christian Ehringfeld | void Em::testFindById() {
|
|
| f8b8663b | Christian Ehringfeld | QSharedPointer<Person> p = QSharedPointer<Person>(new Person("Patrick", "De",
|
|
Person::Gender::MALE, "patrick.jpeg", "", "Pat", QDate(2000, 1, 1)));
|
|||
| e7cfc35a | Christian Ehringfeld | auto ent = p.objectCast<Entity>();
|
|
QVERIFY(this->e->create(ent));
|
|||
auto id = p->getId();
|
|||
QVERIFY(id > -1);
|
|||
QVERIFY(this->e->findById(id, p->getClassname()));
|
|||
}
|
|||
void Em::testFindId() {
|
|||
| f8b8663b | Christian Ehringfeld | QSharedPointer<Person> p = QSharedPointer<Person>(new Person("Essi", "Sa",
|
|
Person::Gender::MALE, "essi.jpeg", "", "Essi", QDate(2000, 1, 1)));
|
|||
| e7cfc35a | Christian Ehringfeld | auto ent = p.objectCast<Entity>();
|
|
QVERIFY(this->e->create(ent));
|
|||
auto entity = QSharedPointer<Entity>(p->copy());
|
|||
auto foundId = this->e->findId(entity);
|
|||
QVERIFY(foundId > -1 && foundId == ent->getId());
|
|||
}
|
|||
void Em::testHasChanged() {
|
|||
| f8b8663b | Christian Ehringfeld | QSharedPointer<Person> p = QSharedPointer<Person>(new Person("Jelena", "Fl",
|
|
| e7cfc35a | Christian Ehringfeld | Person::Gender::MALE, "max.jpeg", "", "Maxi", QDate(2000, 1, 1)));
|
|
auto ent = p.objectCast<Entity>();
|
|||
QVERIFY(this->e->create(ent));
|
|||
| f8b8663b | Christian Ehringfeld | p->setFirstName("Laura");
|
|
| e7cfc35a | Christian Ehringfeld | p->setFamilyName("Musterfrau");
|
|
p->setBirthday(QDate(200, 1, 2));
|
|||
QVERIFY(this->e->hasChanged(ent));
|
|||
}
|
|||
void Em::testValidate() {
|
|||
| f8b8663b | Christian Ehringfeld | QSharedPointer<Person> p = QSharedPointer<Person>(new Person("Patrick", "Pe",
|
|
Person::Gender::MALE, "patrick2.jpeg", "", "Maxi", QDate(2000, 1, 1)));
|
|||
| e7cfc35a | Christian Ehringfeld | auto ent = p.objectCast<Entity>();
|
|
QVERIFY(this->e->validate(ent));
|
|||
p->setFirstName("M");
|
|||
QVERIFY(!this->e->validate(ent) && ent->getErrors().size() == 1);
|
|||
p->setBirthday(QDate(2030, 10, 10));
|
|||
QVERIFY(!this->e->validate(ent) && ent->getErrors().size() == 2);
|
|||
}
|
|||
void Em::testRelations() {
|
|||
| f8b8663b | Christian Ehringfeld | QSharedPointer<Person> p1 = QSharedPointer<Person>(new Person("Lucien", "We",
|
|
Person::Gender::MALE, "lucien.jpeg", "", "Luc", QDate(2000, 1, 1)));
|
|||
QSharedPointer<Person> p2 = QSharedPointer<Person>(new Person("Janine", "Musterfrau",
|
|||
Person::Gender::FEMALE, "janine.jpeg", "", "", QDate(2000, 1, 1)));
|
|||
QSharedPointer<Person> p3 = QSharedPointer<Person>(new Person("Fenja", "Sey.",
|
|||
Person::Gender::FEMALE, "fenja.jpeg", "", "Lotta", QDate(1990, 1, 1)));
|
|||
| e7cfc35a | Christian Ehringfeld | QSharedPointer<Group> g = QSharedPointer<Group>(new Group());
|
|
g->setName("TestGroup");
|
|||
g->setLeader(p1);
|
|||
g->setPersons({p1});
|
|||
auto gEnt = g.objectCast<Entity>();
|
|||
auto pEnt = p3.objectCast<Entity>();
|
|||
QVERIFY(this->e->save(gEnt));
|
|||
QVERIFY(p1->getId() > -1);
|
|||
QVERIFY(p1->getMaintainedGroups().size() > 0);
|
|||
QVERIFY(p1->getGroups().size() > 0);
|
|||
g->addPerson(p2);
|
|||
g->setName("TestGroupExtended");
|
|||
QVERIFY(this->e->save(gEnt));
|
|||
p3->setGroups({g});
|
|||
QVERIFY(this->e->save(pEnt, true, true));
|
|||
QVERIFY(g->getPersons().size() == 3);
|
|||
QList<QSharedPointer<Group>> groups;
|
|||
p3->setGroups(groups);
|
|||
QVERIFY(this->e->save(pEnt, true, true));
|
|||
this->e->refresh(gEnt);
|
|||
QVERIFY(g->getPersons().size() == 2);
|
|||
auto firstPerson = g->getPersons().first();
|
|||
g->removePerson(firstPerson);
|
|||
QVERIFY(this->e->save(gEnt, true, true));
|
|||
auto entityFp = firstPerson.objectCast<Entity>();
|
|||
this->e->refresh(entityFp);
|
|||
QVERIFY(firstPerson->getGroups().size() == 0 && g->getPersons().size() == 1);
|
|||
}
|
|||
QTEST_APPLESS_MAIN(Em)
|
|||
#include "tst_em.moc"
|