#include "stdafx.h"
|
#include "SaveSQL.h"
|
|
|
SaveSQL::SaveSQL()
|
{
|
}
|
|
|
SaveSQL::~SaveSQL()
|
{
|
}
|
|
int SaveSQL::get_file_ID(std::string filename)
|
{
|
// Õâ¸öÓï¾äÓÐsql×¢ÈëÎÊÌ⣬Êý¾Ý¿â²»Ó¦¸ÃÌṩ½Ó¿Ú°ïÎÒÃDzåÈëÂð£¿
|
std::string sql = "select file_id from files where name=\'" + filename + "\'";
|
int file_id = -1;
|
vector<vector<string>> rets;
|
int ret = sqlDb.query(sql, rets);
|
if (ret != 0) {
|
return file_id;
|
}
|
if (!rets.empty() && !rets[0].empty()) {
|
string firstField = rets[0][0];
|
file_id = std::stoi(firstField);
|
cout << "First field of first row: " << firstField << endl;
|
}
|
// µ÷ÓÃÊý¾Ý¿âº¯Êý......
|
return file_id;
|
}
|
|
int SaveSQL::create_InsFiles(SQLFiles fileInfo)
|
{
|
std::string sql = "INSERT INTO `files` (`name`, `current_version`) VALUES ('"
|
+ fileInfo.filename + "','"
|
+ fileInfo.current_ver + "')";
|
|
// µ÷ÓÃÊý¾Ý¿âº¯Êý......
|
int ret = sqlDb.insert_del_update(sql);
|
return ret;
|
}
|
|
int SaveSQL::create_InsVersions(SQLVersions versionInfo)
|
{
|
std::string sql = "INSERT INTO `versions` (`file_id`, `change_description`) VALUES ('"
|
+ versionInfo.file_id + "','"
|
+ versionInfo.desc + "')";
|
|
// µ÷ÓÃÊý¾Ý¿âº¯Êý......
|
int ret = sqlDb.insert_del_update(sql);
|
return ret;
|
}
|
