QxOrm ORM框架的使用一例

boy11-2

[代码] drug.h

1. #ifndef _CLASS_DRUG_H_
   
2. #define _CLASS_DRUG_H_
   
3. 
   
4. class drug
   
5. {
   
6. public:
   
7.    long id;
   
8.    QString name;
   
9.    QString description;
   
10. 
    
11.    drug() : id(0) { ; }
    
12.    virtual ~drug() { ; }
    
13. };
    
14. 
    
15. QX_REGISTER_HPP_MY_TEST_EXE(drug, qx::trait::no_base_class_defined, 1)
    
16. 
    
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' */
    
21. 
    
22. #endif // _CLASS_DRUG_H_

复制代码

[代码] drug.cpp

1. #include "precompiled.h"   // Precompiled-header with '#include <QxOrm.h>' and '#include "export.h"'
   
2. 
   
3. #include "drug.h"          // Class definition 'drug'
   
4. 
   
5. #include <QxMemLeak.h>     // Automatic memory leak detection
   
6. 
   
7. 
   
8. QX_REGISTER_CPP_MY_TEST_EXE(drug)   // This macro is necessary to register 'drug' class in QxOrm context
   
9. 
   
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"
   
2. 
   
3. #include "drug.h"
   
4. 
   
5. #include <QxMemLeak.h>
   
6. 
   
7. 
   
8. int main(int argc, char * argv[])
   
9. {
   
10.    QApplication app(argc, argv); // Qt application
    
11. 
    
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";
    
18. 
    
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);
    
26. 
    
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("");
    
33. 
    
34.    // Create table 'drug' into database to store drugs
    
35.    QSqlError daoError = qx::dao::create_table<drug>();
    
36. 
    
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);
    
40. 
    
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);
    
45. 
    
46.    // Delete the first drug from database
    
47.    daoError = qx::dao::delete_by_id(d1);
    
48. 
    
49.    // Count drugs into database
    
50.    long lDrugCount = qx::dao::count<drug>();
    
51. 
    
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);
    
56. 
    
57.    // Export drugs from container to a file under xml format (serialization)
    
58.    qx::serialization::xml::to_file(lst_drug, "./export_drugs.xml");
    
59. 
    
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");
    
63. 
    
64.    // Clone a drug
    
65.    drug_ptr d_clone = qx::clone(* d1);
    
66. 
    
67.    // Create a new drug by class name (factory)
    
68.    boost::any d_any = qx::create("drug");
    
69. 
    
70.    // Insert drugs container into 'qx::cache'
    
71.    qx::cache::set("drugs", lst_drug);
    
72. 
    
73.    // Remove all elements from 'qx::cache'
    
74.    qx::cache::clear();
    
75. 
    
76.    // Create a dummy memory leak
    
77.    drug * pDummy = new drug();
    
78. 
    
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, src\main.cpp:74)
   
9. [QxOrm] **** 1 memory leaks found ****

复制代码