从Dictionary表中获取text字段内容
bool fourssqlite::get_normalize_form_Dictionary(const std::string &name,const std::string &value,std::string &condition)
{
try
{
sqlite3pp::database db(m_fs_path.c_str());
std::string sqlstr = "SELECT normalize FROM Dictionary WHERE name = \"" + name + "\" and value = \"" + value+"\"";
std::cout << sqlstr << std::endl;
sqlite3pp::query qry(db, sqlstr.c_str());
for (sqlite3pp::query::iterator i = qry.begin(); i != qry.end(); ++i) {
const char* text;
condition = ((text = (*i).get<char const*>(0)) != nullptr ? std::string(text):"");
}
}
catch(std::exception &e)
{
std::cerr << "exception :" << e.what() << std::endl;
return false;
}
return true;
}
m_fs_path为db文件路径