generate_createtb_sql生成如下:
CREATE TABLE IF NOT EXISTS user(index INTEGER PRIMARY KEY AUTOINCREMENT , id TEXT , username TEXT , password TEXT , role TEXT , enable INTEGER , creator TEXT , update_ts INTEGER )
执行sql时失败,经测试需要改为如下才可以:
CREATE TABLE IF NOT EXISTS user(" index " INTEGER PRIMARY KEY AUTOINCREMENT , id TEXT , username TEXT , password TEXT , role TEXT , enable INTEGER , creator TEXT , update_ts INTEGER )
在index外套上双引号
struct GbsUser { using Ptr = std::shared_ptr;
int32_t index = 0;
std::string id;
std::string username;
std::string password;
std::string role;
bool enable = false;
std::string creator;
long long update_ts = 0;
}; REGISTER_AUTO_KEY(GbsUser, index) REFLECTION_WITH_NAME(GbsUser, "user", index, id, username, password, role, enable, creator, update_ts)
generate_createtb_sql生成如下: CREATE TABLE IF NOT EXISTS
user
(index INTEGER PRIMARY KEY AUTOINCREMENT , id TEXT , username TEXT , password TEXT , role TEXT , enable INTEGER , creator TEXT , update_ts INTEGER ) 执行sql时失败,经测试需要改为如下才可以: CREATE TABLE IF NOT EXISTSuser
(" index " INTEGER PRIMARY KEY AUTOINCREMENT , id TEXT , username TEXT , password TEXT , role TEXT , enable INTEGER , creator TEXT , update_ts INTEGER ) 在index外套上双引号