CONFIG += c++17 console DEFINES += _BUILDING_USER # You can make your code fail to compile if it uses deprecated APIs. # In order to do so, uncomment the following line. #DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x060000 # disables all the APIs deprecated before Qt 6.0.0
[QxOrm] qx::QxSqlDatabase : create new database connection in thread '0x1ac8' with key '{be9fbd8b-7e6c-4365-bd0b-d6db34ce495c}' [QxOrm] sql query (total: 897 ms, db_exec: 0 ms) : CREATE TABLE User (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name TEXT, age INTEGER) [QxOrm] sql query (total: 131 ms, db_exec: 0.803 ms) : INSERT INTO User (name, age) VALUES (:name, :age) [QxOrm] sql query (total: 99.9 ms, db_exec: 0.88 ms) : UPDATE User SET id = :id, name = :name, age = :age WHERE id = :id_bis [QxOrm] sql query (total: 109 ms, db_exec: 108 ms) : DELETE FROM User WHERE id = :id
Process exited with code: 0.[QxOrm] sql query (total: 0.197 ms, db_exec: 0.149 ms) : SELECT COUNT(*) FROM User User Count: 2 [QxOrm] sql query (total: 0.323 ms, db_exec: 0.1 ms) : SELECT User.id AS User_id_0, User.name AS User_name_0, User.age AS User_age_0 FROM User WHERE User.id = :id User Tmp: 3 "Waleon" 18
再次运行,提示数据库已经存在,不能重复创建。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
[QxOrm] qx::QxSqlDatabase : create new database connection in thread '0x4b90' with key '{77bd0719-5661-4acb-afd7-e4b16ee2b82d}' [QxOrm] execute sql query failed : CREATE TABLE User (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name TEXT, age INTEGER) Database error number ' 1' : Unable to execute statement
table User already exists [QxOrm] sql query (total: 470 ms, db_exec: 1.25 ms) : INSERT INTO User (name, age) VALUES (:name, :age) [QxOrm] sql query (total: 83.4 ms, db_exec: 0.876 ms) : UPDATE User SET id = :id, name = :name, age = :age WHERE id = :id_bis [QxOrm] sql query (total: 91.1 ms, db_exec: 91 ms) : DELETE FROM User WHERE id = :id [QxOrm] sql query (total: 0.172 ms, db_exec: 0.127 ms) : SELECT COUNT(*) FROM User User Count: 4 [QxOrm] sql query (total: 0.298 ms, db_exec: 0.0939 ms) : SELECT User.id AS User_id_0, User.name AS User_name_0, User.age AS User_age_0 FROM User WHERE User.id = :id User Tmp: 3 "Waleon" 18 Process exited with code: 0.