bool insert(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_text._dirty)
field2Val["text"] =
toSQLString(_f_text._base);
if (_f_em_type._dirty)
field2Val["em_type"] =
toSQLString(_f_em_type._base);
if (_f_page_id._dirty)
field2Val["page_id"] =
toSQLString(_f_page_id._base);
if (_f_account_id._dirty)
field2Val["account_id"] =
toSQLString(_f_account_id._base);
if (DBFace::instance()->
insert("emphases", field2Val,
_f_id._base.serialization()))
{
_f_id._dirty = false;
_f_text._dirty = false;
_f_em_type._dirty = false;
_f_page_id._dirty = false;
_f_account_id._dirty = false;
return true;
}
else
return false;
}
bool insert(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_text._dirty)
field2Val["text"] =
toSQLString(_f_text._base);
if (_f_frequency._dirty)
field2Val["frequency"] =
toSQLString(_f_frequency._base);
if (_f_language_id._dirty)
field2Val["language_id"] =
toSQLString(_f_language_id._base);
if (DBFace::instance()->
insert("dictionary_words", field2Val,
_f_id._base.serialization()))
{
_f_id._dirty = false;
_f_text._dirty = false;
_f_frequency._dirty = false;
_f_language_id._dirty = false;
return true;
}
else
return false;
}
bool insert(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_url._dirty)
field2Val["url"] =
toSQLString(_f_url._base);
if (_f_page_id._dirty)
field2Val["page_id"] =
toSQLString(_f_page_id._base);
if (_f_account_id._dirty)
field2Val["account_id"] =
toSQLString(_f_account_id._base);
if (DBFace::instance()->
insert("backlinks", field2Val,
_f_id._base.serialization()))
{
_f_id._dirty = false;
_f_url._dirty = false;
_f_page_id._dirty = false;
_f_account_id._dirty = false;
return true;
}
else
return false;
}
bool insertAllFields(std::vector<O_User>::const_iterator begin,
std::vector<O_User>::const_iterator end)
{
std::vector<std::string> fields;
fields.push_back(std::string("name"));
fields.push_back(std::string("created_at"));
fields.push_back(std::string("updated_at"));
std::vector<std::vector<std::string> > rows;
for (; begin != end; ++begin){
const O_User& r = *begin;
std::vector<std::string> row;
row.push_back(toSQLString(r._name()));
row.push_back(toSQLString(r._created_at()));
row.push_back(toSQLString(r._updated_at()));
rows.push_back(row);
}
return DBFace::instance()->insert("users",
fields, rows);
}
bool update(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_url._dirty)
field2Val["url"] =
toSQLString(_f_url._base);
if (_f_page_id._dirty)
field2Val["page_id"] =
toSQLString(_f_page_id._base);
if (_f_account_id._dirty)
field2Val["account_id"] =
toSQLString(_f_account_id._base);
std::string where =
"id=" + toSQLString(_f_id._base);
if (DBFace::instance()->update("backlinks",
field2Val, where))
{
_f_id._dirty = false;
_f_url._dirty = false;
_f_page_id._dirty = false;
_f_account_id._dirty = false;
return true;
}
else
return false;
}
bool insert(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_text._dirty)
field2Val["text"] =
toSQLString(_f_text._base);
if (_f_exclusion_type._dirty)
field2Val["exclusion_type"] =
toSQLString(_f_exclusion_type._base);
if (DBFace::instance()->
insert("keyword_exclusions", field2Val,
_f_id._base.serialization()))
{
_f_id._dirty = false;
_f_text._dirty = false;
_f_exclusion_type._dirty = false;
return true;
}
else
return false;
}
bool update(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_name._dirty)
field2Val["name"] =
toSQLString(_f_name._base);
if (_f_account_id._dirty)
field2Val["account_id"] =
toSQLString(_f_account_id._base);
if (_f_selected._dirty)
field2Val["selected"] =
toSQLString(_f_selected._base);
std::string where =
"id=" + toSQLString(_f_id._base);
if (DBFace::instance()->update("subdomains",
field2Val, where))
{
_f_id._dirty = false;
_f_name._dirty = false;
_f_account_id._dirty = false;
_f_selected._dirty = false;
return true;
}
else
return false;
}
bool update(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_text._dirty)
field2Val["text"] =
toSQLString(_f_text._base);
if (_f_frequency._dirty)
field2Val["frequency"] =
toSQLString(_f_frequency._base);
if (_f_language_id._dirty)
field2Val["language_id"] =
toSQLString(_f_language_id._base);
std::string where =
"id=" + toSQLString(_f_id._base);
if (DBFace::instance()->update("dictionary_words",
field2Val, where))
{
_f_id._dirty = false;
_f_text._dirty = false;
_f_frequency._dirty = false;
_f_language_id._dirty = false;
return true;
}
else
return false;
}
bool insert(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_name._dirty)
field2Val["name"] =
toSQLString(_f_name._base);
if (_f_account_id._dirty)
field2Val["account_id"] =
toSQLString(_f_account_id._base);
if (_f_selected._dirty)
field2Val["selected"] =
toSQLString(_f_selected._base);
if (DBFace::instance()->
insert("subdomains", field2Val,
_f_id._base.serialization()))
{
_f_id._dirty = false;
_f_name._dirty = false;
_f_account_id._dirty = false;
_f_selected._dirty = false;
return true;
}
else
return false;
}
bool insert(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_stock_id._dirty)
field2Val["stock_id"] =
toSQLString(_f_stock_id._base);
if (_f_ticker._dirty)
field2Val["ticker"] =
toSQLString(_f_ticker._base);
if (_f_sclass._dirty)
field2Val["sclass"] =
toSQLString(_f_sclass._base);
if (_f_votes._dirty)
field2Val["votes"] =
toSQLString(_f_votes._base);
if (_f_nshares._dirty)
field2Val["nshares"] =
toSQLString(_f_nshares._base);
if (_f_float_date._dirty)
field2Val["float_date"] =
toSQLString(_f_float_date._base);
if (_f_mul_factor._dirty)
field2Val["mul_factor"] =
toSQLString(_f_mul_factor._base);
if (_f_note._dirty)
field2Val["note"] =
toSQLString(_f_note._base);
field2Val["created_at"] = "NOW()";
if (_f_updated_at._dirty)
field2Val["updated_at"] =
toSQLString(_f_updated_at._base);
if (DBFace::instance()->
insert("share_classes", field2Val,
_f_id._base.serialization()))
{
_f_id._dirty = false;
_f_stock_id._dirty = false;
_f_ticker._dirty = false;
_f_sclass._dirty = false;
_f_votes._dirty = false;
_f_nshares._dirty = false;
_f_float_date._dirty = false;
_f_mul_factor._dirty = false;
_f_note._dirty = false;
_f_created_at._dirty = false;
_f_updated_at._dirty = false;
return true;
}
else
return false;
}
bool update(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_size._dirty)
field2Val["size"] =
toSQLString(_f_size._base);
if (_f_text._dirty)
field2Val["text"] =
toSQLString(_f_text._base);
if (_f_frequency._dirty)
field2Val["frequency"] =
toSQLString(_f_frequency._base);
if (_f_relevance._dirty)
field2Val["relevance"] =
toSQLString(_f_relevance._base);
if (_f_position._dirty)
field2Val["position"] =
toSQLString(_f_position._base);
if (_f_directory._dirty)
field2Val["directory"] =
toSQLString(_f_directory._base);
if (_f_page_id._dirty)
field2Val["page_id"] =
toSQLString(_f_page_id._base);
if (_f_account_id._dirty)
field2Val["account_id"] =
toSQLString(_f_account_id._base);
std::string where =
"id=" + toSQLString(_f_id._base);
if (DBFace::instance()->update("keywords",
field2Val, where))
{
_f_id._dirty = false;
_f_size._dirty = false;
_f_text._dirty = false;
_f_frequency._dirty = false;
_f_relevance._dirty = false;
_f_position._dirty = false;
_f_directory._dirty = false;
_f_page_id._dirty = false;
_f_account_id._dirty = false;
return true;
}
else
return false;
}
bool insertDirtyFields(std::vector<O_Language>::const_iterator begin,
std::vector<O_Language>::const_iterator end)
{
if (begin == end)
return true;
FieldsToRows fields2Rows;
for (std::vector<O_Language>::const_iterator it = begin;
it != end; ++it)
{
std::vector<std::string> fields;
std::vector<std::string> row;
if (it->_f_name._dirty) {
fields.push_back(std::string("name"));
row.push_back(toSQLString(it->_name()));
}
fields2Rows[fields].push_back(row);
}
bool ret = true;
for (FieldsToRows::const_iterator it = fields2Rows.begin();
it != fields2Rows.end(); ++it)
{
ret = DBFace::instance()->insert("languages",
it->first, it->second) && ret;
}
return ret;
}
bool update(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_name._dirty)
field2Val["name"] =
toSQLString(_f_name._base);
std::string where =
"id=" + toSQLString(_f_id._base);
if (DBFace::instance()->update("languages",
field2Val, where))
{
_f_id._dirty = false;
_f_name._dirty = false;
return true;
}
else
return false;
}
bool insert(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_name._dirty)
field2Val["name"] =
toSQLString(_f_name._base);
if (DBFace::instance()->
insert("languages", field2Val,
_f_id._base.serialization()))
{
_f_id._dirty = false;
_f_name._dirty = false;
return true;
}
else
return false;
}
bool update(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_text._dirty)
field2Val["text"] =
toSQLString(_f_text._base);
if (_f_em_type._dirty)
field2Val["em_type"] =
toSQLString(_f_em_type._base);
if (_f_page_id._dirty)
field2Val["page_id"] =
toSQLString(_f_page_id._base);
if (_f_account_id._dirty)
field2Val["account_id"] =
toSQLString(_f_account_id._base);
std::string where =
"id=" + toSQLString(_f_id._base);
if (DBFace::instance()->update("emphases",
field2Val, where))
{
_f_id._dirty = false;
_f_text._dirty = false;
_f_em_type._dirty = false;
_f_page_id._dirty = false;
_f_account_id._dirty = false;
return true;
}
else
return false;
}
bool update(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_start._dirty)
field2Val["start"] =
toSQLString(_f_start._base);
if (_f_end._dirty)
field2Val["end"] =
toSQLString(_f_end._base);
if (_f_command._dirty)
field2Val["command"] =
toSQLString(_f_command._base);
if (_f_model_id._dirty)
field2Val["model_id"] =
toSQLString(_f_model_id._base);
if (_f_param._dirty)
field2Val["param"] =
toSQLString(_f_param._base);
if (_f_log_file_name._dirty)
field2Val["log_file_name"] =
toSQLString(_f_log_file_name._base);
if (_f_pid._dirty)
field2Val["pid"] =
toSQLString(_f_pid._base);
std::string where =
"id=" + toSQLString(_f_id._base);
if (DBFace::instance()->update("drive_back_logs",
field2Val, where))
{
_f_id._dirty = false;
_f_start._dirty = false;
_f_end._dirty = false;
_f_command._dirty = false;
_f_model_id._dirty = false;
_f_param._dirty = false;
_f_log_file_name._dirty = false;
_f_pid._dirty = false;
return true;
}
else
return false;
}
bool insertDirtyFields(std::vector<O_Fighter>::const_iterator begin,
std::vector<O_Fighter>::const_iterator end)
{
if (begin == end)
return true;
FieldsToRows fields2Rows;
for (std::vector<O_Fighter>::const_iterator it = begin;
it != end; ++it)
{
std::vector<std::string> fields;
std::vector<std::string> row;
if (it->_f_name._dirty){
fields.push_back(std::string("name"));
row.push_back(toSQLString(it->_name()));
}
if (it->_f_created_at._dirty){
fields.push_back(std::string("created_at"));
row.push_back(toSQLString(it->_created_at()));
}
if (it->_f_updated_at._dirty){
fields.push_back(std::string("updated_at"));
row.push_back(toSQLString(it->_updated_at()));
}
if (it->_f_full_data._dirty){
fields.push_back(std::string("full_data"));
row.push_back(toSQLString(it->_full_data()));
}
if (it->_f_url._dirty){
fields.push_back(std::string("url"));
row.push_back(toSQLString(it->_url()));
}
if (it->_f_for_delete._dirty){
fields.push_back(std::string("for_delete"));
row.push_back(toSQLString(it->_for_delete()));
}
fields2Rows[fields].push_back(row);
}
bool ret = true;
for (FieldsToRows::const_iterator it = fields2Rows.begin();
it != fields2Rows.end(); ++it)
{
ret = DBFace::instance()->insert("fighters",
it->first, it->second) && ret;
}
return ret;
}
bool insert(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_stock_id._dirty)
field2Val["stock_id"] =
toSQLString(_f_stock_id._base);
if (_f_year._dirty)
field2Val["year"] =
toSQLString(_f_year._base);
if (_f_shares._dirty)
field2Val["shares"] =
toSQLString(_f_shares._base);
field2Val["created_at"] = "NOW()";
if (_f_updated_at._dirty)
field2Val["updated_at"] =
toSQLString(_f_updated_at._base);
if (DBFace::instance()->
insert("numshares", field2Val,
_f_id._base.serialization()))
{
_f_id._dirty = false;
_f_stock_id._dirty = false;
_f_year._dirty = false;
_f_shares._dirty = false;
_f_created_at._dirty = false;
_f_updated_at._dirty = false;
return true;
}
else
return false;
}
bool update(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_text._dirty)
field2Val["text"] =
toSQLString(_f_text._base);
if (_f_exclusion_type._dirty)
field2Val["exclusion_type"] =
toSQLString(_f_exclusion_type._base);
std::string where =
"id=" + toSQLString(_f_id._base);
if (DBFace::instance()->update("keyword_exclusions",
field2Val, where))
{
_f_id._dirty = false;
_f_text._dirty = false;
_f_exclusion_type._dirty = false;
return true;
}
else
return false;
}
bool insert(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_start._dirty)
field2Val["start"] =
toSQLString(_f_start._base);
if (_f_end._dirty)
field2Val["end"] =
toSQLString(_f_end._base);
if (_f_command._dirty)
field2Val["command"] =
toSQLString(_f_command._base);
if (_f_model_id._dirty)
field2Val["model_id"] =
toSQLString(_f_model_id._base);
if (_f_param._dirty)
field2Val["param"] =
toSQLString(_f_param._base);
if (_f_log_file_name._dirty)
field2Val["log_file_name"] =
toSQLString(_f_log_file_name._base);
if (_f_pid._dirty)
field2Val["pid"] =
toSQLString(_f_pid._base);
if (DBFace::instance()->
insert("drive_back_logs", field2Val,
_f_id._base.serialization()))
{
_f_id._dirty = false;
_f_start._dirty = false;
_f_end._dirty = false;
_f_command._dirty = false;
_f_model_id._dirty = false;
_f_param._dirty = false;
_f_log_file_name._dirty = false;
_f_pid._dirty = false;
return true;
}
else
return false;
}
bool insertAllFields(std::vector<O_Page_Link>::const_iterator begin,
std::vector<O_Page_Link>::const_iterator end)
{
std::vector<std::string> fields;
fields.push_back(std::string("text"));
fields.push_back(std::string("href"));
fields.push_back(std::string("nofollow"));
fields.push_back(std::string("relevant_text"));
fields.push_back(std::string("is_image"));
fields.push_back(std::string("page_id"));
fields.push_back(std::string("account_id"));
fields.push_back(std::string("target_page_id"));
std::vector<std::vector<std::string> > rows;
for (; begin != end; ++begin){
const O_Page_Link& r = *begin;
std::vector<std::string> row;
row.push_back(toSQLString(r._text()));
row.push_back(toSQLString(r._href()));
row.push_back(toSQLString(r._nofollow()));
row.push_back(toSQLString(r._relevant_text()));
row.push_back(toSQLString(r._is_image()));
row.push_back(toSQLString(r._page_id()));
row.push_back(toSQLString(r._account_id()));
row.push_back(toSQLString(r._target_page_id()));
rows.push_back(row);
}
return DBFace::instance()->insert("links",
fields, rows);
}
bool insertAllFields(std::vector<O_Language>::const_iterator begin,
std::vector<O_Language>::const_iterator end)
{
std::vector<std::string> fields;
fields.push_back(std::string("name"));
std::vector<std::vector<std::string> > rows;
for (; begin != end; ++begin) {
const O_Language& r = *begin;
std::vector<std::string> row;
row.push_back(toSQLString(r._name()));
rows.push_back(row);
}
return DBFace::instance()->insert("languages",
fields, rows);
}
bool insertAllFields(std::vector<O_Dividend>::const_iterator begin,
std::vector<O_Dividend>::const_iterator end)
{
std::vector<std::string> fields;
fields.push_back(std::string("stock_id"));
fields.push_back(std::string("ex_date"));
fields.push_back(std::string("amount"));
fields.push_back(std::string("source"));
fields.push_back(std::string("created_at"));
fields.push_back(std::string("updated_at"));
fields.push_back(std::string("pay_date"));
std::vector<std::vector<std::string> > rows;
for (; begin != end; ++begin){
const O_Dividend& r = *begin;
std::vector<std::string> row;
row.push_back(toSQLString(r._stock_id()));
row.push_back(toSQLString(r._ex_date()));
row.push_back(toSQLString(r._amount()));
row.push_back(toSQLString(r._source()));
row.push_back(toSQLString(r._created_at()));
row.push_back(toSQLString(r._updated_at()));
row.push_back(toSQLString(r._pay_date()));
rows.push_back(row);
}
return DBFace::instance()->insert("dividends",
fields, rows);
}
bool insertDirtyFields(std::vector<O_Setting>::const_iterator begin,
std::vector<O_Setting>::const_iterator end)
{
if (begin == end)
return true;
FieldsToRows fields2Rows;
for (std::vector<O_Setting>::const_iterator it = begin;
it != end; ++it)
{
std::vector<std::string> fields;
std::vector<std::string> row;
if (it->_f_prop_group._dirty){
fields.push_back(std::string("prop_group"));
row.push_back(toSQLString(it->_prop_group()));
}
if (it->_f_name._dirty){
fields.push_back(std::string("name"));
row.push_back(toSQLString(it->_name()));
}
if (it->_f_short_name._dirty){
fields.push_back(std::string("short_name"));
row.push_back(toSQLString(it->_short_name()));
}
if (it->_f_value._dirty){
fields.push_back(std::string("value"));
row.push_back(toSQLString(it->_value()));
}
if (it->_f_default_val._dirty){
fields.push_back(std::string("default_val"));
row.push_back(toSQLString(it->_default_val()));
}
if (it->_f_prop_type._dirty){
fields.push_back(std::string("prop_type"));
row.push_back(toSQLString(it->_prop_type()));
}
fields2Rows[fields].push_back(row);
}
bool ret = true;
for (FieldsToRows::const_iterator it = fields2Rows.begin();
it != fields2Rows.end(); ++it)
{
ret = DBFace::instance()->insert("settings",
it->first, it->second) && ret;
}
return ret;
}
bool update(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_stock_id._dirty)
field2Val["stock_id"] =
toSQLString(_f_stock_id._base);
if (_f_year._dirty)
field2Val["year"] =
toSQLString(_f_year._base);
if (_f_pertains_to._dirty)
field2Val["pertains_to"] =
toSQLString(_f_pertains_to._base);
if (_f_note._dirty)
field2Val["note"] =
toSQLString(_f_note._base);
if (_f_created_at._dirty)
field2Val["created_at"] =
toSQLString(_f_created_at._base);
field2Val["updated_at"] = "NOW()";
std::string where =
"id=" + toSQLString(_f_id._base);
if (DBFace::instance()->update("notes",
field2Val, where))
{
_f_id._dirty = false;
_f_stock_id._dirty = false;
_f_year._dirty = false;
_f_pertains_to._dirty = false;
_f_note._dirty = false;
_f_created_at._dirty = false;
_f_updated_at._dirty = false;
return true;
}
else
return false;
}
bool insert() {
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_stock_id._dirty)
field2Val["stock_id"] =
toSQLString(_f_stock_id._base);
if (_f_date._dirty)
field2Val["date"] =
toSQLString(_f_date._base);
if (_f_base._dirty)
field2Val["base"] =
toSQLString(_f_base._base);
if (_f_into._dirty)
field2Val["into"] =
toSQLString(_f_into._base);
field2Val["created_at"] = "NOW()";
if (_f_updated_at._dirty)
field2Val["updated_at"] =
toSQLString(_f_updated_at._base);
if (DBFace::instance()->
insert("splits", field2Val,
_f_id._base.serialization()))
{
_f_id._dirty = false;
_f_stock_id._dirty = false;
_f_date._dirty = false;
_f_base._dirty = false;
_f_into._dirty = false;
_f_created_at._dirty = false;
_f_updated_at._dirty = false;
return true;
}
else
return false;
}
bool update(){
std::map<std::string, std::string> field2Val;
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_page_id._dirty)
field2Val["page_id"] =
toSQLString(_f_page_id._base);
if (_f_account_id._dirty)
field2Val["account_id"] =
toSQLString(_f_account_id._base);
if (_f_num_flash._dirty)
field2Val["num_flash"] =
toSQLString(_f_num_flash._base);
if (_f_num_javascript._dirty)
field2Val["num_javascript"] =
toSQLString(_f_num_javascript._base);
if (_f_deleted._dirty)
field2Val["deleted"] =
toSQLString(_f_deleted._base);
std::string where =
"id=" + toSQLString(_f_id._base);
if (DBFace::instance()->update("non_htmls",
field2Val, where))
{
_f_id._dirty = false;
_f_page_id._dirty = false;
_f_account_id._dirty = false;
_f_num_flash._dirty = false;
_f_num_javascript._dirty = false;
_f_deleted._dirty = false;
return true;
}
else
return false;
}
bool update(){
std::map<std::string, std::string> field2Val;
if (_f_account_id._dirty)
field2Val["account_id"] =
toSQLString(_f_account_id._base);
if (_f_issue_id._dirty)
field2Val["issue_id"] =
toSQLString(_f_issue_id._base);
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_impact._dirty)
field2Val["impact"] =
toSQLString(_f_impact._base);
if (_f_number_of_pages._dirty)
field2Val["number_of_pages"] =
toSQLString(_f_number_of_pages._base);
if (_f_priority._dirty)
field2Val["priority"] =
toSQLString(_f_priority._base);
std::string where =
"id=" + toSQLString(_f_id._base);
if (DBFace::instance()->update("account_issues",
field2Val, where))
{
_f_account_id._dirty = false;
_f_issue_id._dirty = false;
_f_id._dirty = false;
_f_impact._dirty = false;
_f_number_of_pages._dirty = false;
_f_priority._dirty = false;
return true;
}
else
return false;
}
bool insertAllFields(std::vector<O_Setting>::const_iterator begin,
std::vector<O_Setting>::const_iterator end)
{
std::vector<std::string> fields;
fields.push_back(std::string("prop_group"));
fields.push_back(std::string("name"));
fields.push_back(std::string("short_name"));
fields.push_back(std::string("value"));
fields.push_back(std::string("default_val"));
fields.push_back(std::string("prop_type"));
std::vector<std::vector<std::string> > rows;
for (; begin != end; ++begin){
const O_Setting& r = *begin;
std::vector<std::string> row;
row.push_back(toSQLString(r._prop_group()));
row.push_back(toSQLString(r._name()));
row.push_back(toSQLString(r._short_name()));
row.push_back(toSQLString(r._value()));
row.push_back(toSQLString(r._default_val()));
row.push_back(toSQLString(r._prop_type()));
rows.push_back(row);
}
return DBFace::instance()->insert("settings",
fields, rows);
}
bool insert(){
std::map<std::string, std::string> field2Val;
if (_f_account_id._dirty)
field2Val["account_id"] =
toSQLString(_f_account_id._base);
if (_f_issue_id._dirty)
field2Val["issue_id"] =
toSQLString(_f_issue_id._base);
if (_f_id._dirty)
field2Val["id"] =
toSQLString(_f_id._base);
if (_f_impact._dirty)
field2Val["impact"] =
toSQLString(_f_impact._base);
if (_f_number_of_pages._dirty)
field2Val["number_of_pages"] =
toSQLString(_f_number_of_pages._base);
if (_f_priority._dirty)
field2Val["priority"] =
toSQLString(_f_priority._base);
if (DBFace::instance()->
insert("account_issues", field2Val,
_f_id._base.serialization()))
{
_f_account_id._dirty = false;
_f_issue_id._dirty = false;
_f_id._dirty = false;
_f_impact._dirty = false;
_f_number_of_pages._dirty = false;
_f_priority._dirty = false;
return true;
}
else
return false;
}
