目录
一、设置.pro文件中的include、lib路径与include(QxOrm.pri)
一、设置.pro文件中的include、lib路径与include(QxOrm.pri)
QT -= gui
CONFIG += c++11 console
CONFIG -= app_bundle
include(QxOrm.pri)
# The following define makes your compiler emit warnings if you use
# any Qt feature that has been marked deprecated (the exact warnings
# depend on your compiler). Please consult the documentation of the
# deprecated API in order to know how to port your code away from it.
DEFINES += QT_DEPRECATED_WARNINGS
INCLUDEPATH += ./include
# You can also make your code fail to compile if it uses deprecated APIs.
# In order to do so, uncomment the following line.
# You can also select to disable deprecated APIs only up to a certain version of Qt.
#DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x060000 # disables all the APIs deprecated before Qt 6.0.0
SOURCES += \
main.cpp \
person.cpp
# Default rules for deployment.
qnx: target.path = /tmp/$${TARGET}/bin
else: unix:!android: target.path = /opt/$${TARGET}/bin
!isEmpty(target.path): INSTALLS += target
HEADERS += \
person.h
unix|win32: LIBS += -L$$PWD/lib/ -lQxOrmd
二、头文件与宏函数注册
#ifndef PERSON_H
#define PERSON_H
#include <QxOrm.h>
#include <QString>
class QX_DLL_EXPORT_HELPER Person
{
QX_REGISTER_FRIEND_CLASS(Person)
public:
Person() : id(0) {}
long id;
QString name;
};
QX_REGISTER_HPP_EXPORT_DLL(Person, qx::trait::no_base_class_defined, 1);
#endif // PERSON_H
三、cpp文件宏注册与模板实现
#include "person.h"
#include <QxOrm_Impl.h>
QX_REGISTER_CPP_EXPORT_DLL(Person)
namespace qx{
template<> void register_class(QxClass<Person> & t)
{
t.id(&Person::id, "id");
t.data(&Person::name, "name");
}
}
四、main函数实现
#include <QCoreApplication>
#include "person.h"
//#include <QxOrm.h>
//#include <QxOrm_Impl.h>
int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);
qx::QxSqlDatabase::getSingleton()->setDriverName("QSQLITE");
qx::QxSqlDatabase::getSingleton()->setDatabaseName("Test.db");
QSqlError error = qx::dao::create_table<Person>();
typedef QSharedPointer<Person> PersonPointer;
// PersonPointer p1;
// p1.reset(new Person());
// p1->name = "Jack";
// PersonPointer p2;
// p2.reset(new Person());
// p2->name = "Mark";
// PersonPointer p3;
// p3.reset(new Person());
// p3->name = "Jerry";
// QVector<PersonPointer> vect;
// vect.append(p1);
// vect.append(p2);
// vect.append(p3);
PersonPointer ptr;
ptr.reset(new Person());
ptr->id = 4;
error = qx::dao::fetch_by_id(ptr);
qx_query que;
que.where("name").isEqualTo("Jerry");
qx_query que2;
que2.where("id").isGreaterThanOrEqualTo(2);
QList<Person> list {};
error = qx::dao::fetch_by_query(que2, list);
for(auto i : list)
qDebug()<<i.id<<endl;
return a.exec();
}