QxOrm ORM框架的使用一例

Question

[代码] drug.h

1. #ifndef _CLASS_DRUG_H_
2. #define _CLASS_DRUG_H_
4. class drug
5. {
6. public:
7.    long id;
8.    QString name;
9.    QString description;
11.    drug() : id(0) { ; }
12.    virtual ~drug() { ; }
13. };
15. QX_REGISTER_HPP_MY_TEST_EXE(drug, qx::trait::no_base_class_defined, 1)
17. /* This macro is necessary to register 'drug' class in QxOrm context */
18. /* param 1 : the current class to register => 'drug' */
19. /* param 2 : the base class, if no base class, use the qx trait => 'qx::trait::no_base_class_defined' */
20. /* param 3 : the class version used by serialization to provide 'ascendant compatibility' */
22. #endif // _CLASS_DRUG_H_

复制代码[代码] drug.cpp

1. #include "precompiled.h"   // Precompiled-header with '#include <QxOrm.h>' and '#include "export.h"'
3. #include "drug.h"          // Class definition 'drug'
5. #include <QxMemLeak.h>     // Automatic memory leak detection
8. QX_REGISTER_CPP_MY_TEST_EXE(drug)   // This macro is necessary to register 'drug' class in QxOrm context
10. namespace qx {
11. template <> void register_class(QxClass<drug> & t)
12. {
13.   t.id(& drug::id, "id");               // Register 'drug::id' <=> primary key in your database
14.   t.data(& drug::name, "name", 1);      // Register 'drug::name' property with key 'name' and version '1'
15.   t.data(& drug::description, "desc");  // Register 'drug::description' property with key 'desc'
16. }}

复制代码[代码] main.cpp

1. #include "precompiled.h"
3. #include "drug.h"
5. #include <QxMemLeak.h>
8. int main(int argc, char * argv[])
9. {
10.    QApplication app(argc, argv); // Qt application
12.    // Create 3 new drugs
13.    // It is possible to use 'boost' and 'Qt' smart pointer : 'boost::shared_ptr', 'QSharedPointer', etc...
14.    typedef boost::shared_ptr<drug> drug_ptr;
15.    drug_ptr d1; d1.reset(new drug()); d1->name = "name1"; d1->description = "desc1";
16.    drug_ptr d2; d2.reset(new drug()); d2->name = "name2"; d2->description = "desc2";
17.    drug_ptr d3; d3.reset(new drug()); d3->name = "name3"; d3->description = "desc3";
19.    // Insert drugs into container
20.    // It is possible to use a lot of containers from 'std', 'boost', 'Qt' and 'qx::QxCollection<Key, Value>'
21.    typedef std::vector<drug_ptr> type_lst_drug;
22.    type_lst_drug lst_drug;
23.    lst_drug.push_back(d1);
24.    lst_drug.push_back(d2);
25.    lst_drug.push_back(d3);
27.    // Init parameters to communicate with a database
28.    qx::QxSqlDatabase::getSingleton()->setDriverName("QSQLITE");
29.    qx::QxSqlDatabase::getSingleton()->setDatabaseName("./test_qxorm.db");
30.    qx::QxSqlDatabase::getSingleton()->setHostName("localhost");
31.    qx::QxSqlDatabase::getSingleton()->setUserName("root");
32.    qx::QxSqlDatabase::getSingleton()->setPassword("");
34.    // Create table 'drug' into database to store drugs
35.    QSqlError daoError = qx::dao::create_table<drug>();
37.    // Insert drugs from container to database
38.    // 'id' property of 'd1', 'd2' and 'd3' are auto-updated
39.    daoError = qx::dao::insert(lst_drug);
41.    // Modify and update the second drug into database
42.    d2->name = "name2 modified";
43.    d2->description = "desc2 modified";
44.    daoError = qx::dao::update(d2);
46.    // Delete the first drug from database
47.    daoError = qx::dao::delete_by_id(d1);
49.    // Count drugs into database
50.    long lDrugCount = qx::dao::count<drug>();
52.    // Fetch drug with id '3' into a new variable
53.    drug_ptr d_tmp; d_tmp.reset(new drug());
54.    d_tmp->id = 3;
55.    daoError = qx::dao::fetch_by_id(d_tmp);
57.    // Export drugs from container to a file under xml format (serialization)
58.    qx::serialization::xml::to_file(lst_drug, "./export_drugs.xml");
60.    // Import drugs from xml file into a new container
61.    type_lst_drug lst_drug_tmp;
62.    qx::serialization::xml::from_file(lst_drug_tmp, "./export_drugs.xml");
64.    // Clone a drug
65.    drug_ptr d_clone = qx::clone(* d1);
67.    // Create a new drug by class name (factory)
68.    boost::any d_any = qx::create("drug");
70.    // Insert drugs container into 'qx::cache'
71.    qx::cache::set("drugs", lst_drug);
73.    // Remove all elements from 'qx::cache'
74.    qx::cache::clear();
76.    // Create a dummy memory leak
77.    drug * pDummy = new drug();
79.    return 0;
80. }

复制代码[代码] 执行结果

1. [QxOrm] qx::QxSqlDatabase : create new database connection in thread '3616' with key '{d315250c-b5c9-46e0-9402-f800368a6673}'
2. [QxOrm] sql query (78 ms) : CREATE TABLE drug (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name TEXT, desc TEXT)
3. [QxOrm] sql query (63 ms) : INSERT INTO drug (name, desc) VALUES (:name, :desc)
4. [QxOrm] sql query (62 ms) : UPDATE drug SET id = :id, name = :name, desc = :desc WHERE id = :id_bis
5. [QxOrm] sql query (63 ms) : DELETE FROM drug WHERE id = :id
6. [QxOrm] sql query (0 ms) : SELECT COUNT(*) FROM drug
7. [QxOrm] sql query (0 ms) : SELECT drug.id AS drug_id_0, drug.name AS drug_name_0, drug.desc AS drug_desc_0 FROM drug WHERE drug_id_0 = :id
8. [QxOrm] Leaked object at 0xf52ad8 (size 16, srcmain.cpp:74)
9. [QxOrm] **** 1 memory leaks found ****

复制代码