// chat_server.cpp

#include "sql_wrapper.h"

int main()

{

sql_wrapper sql_("tcp://127.0.0.1:3306", "root", "111222", "game");

bool ret_ = false;

// 创建

ret_ = sql_.create("create table test (id_ double, name_ varchar(64), password_ varchar(64)); ");

// 添加

ret_ = sql_.insert("insert into test (id_, name_, password_) values (0.1, '0.2', '0.3');"),

// 添加 —> 带参数

ret_ = sql_.insert("insert into test (id_, name_, password_) values (?, ?, ?);",

std::tuple<double, std::string, std::string>(0.11118, "0.2", "0.2"));

// 添加 —> 带参数

ret_ = sql_.insert("insert into test (id_, name_, password_) values (?, ?, ?);",

std::tuple<double, std::string, std::string>(0.8, "0.2", "0.2"));

// 删除

ret_ = sql_.remove("delete from test where id_ = '0.3';");

// 删除 —> 带参数

ret_ = sql_.remove("delete from test where id_ = ?;", std::tuple<std::string>("0.11118"));

// 更新

ret_ = sql_.update("update test set id_ = 0.1, name_ = 'test' where password_ = 0.1;"),

// 更新 —> 带参数

ret_ = sql_.update("update test set id_ = ?, name_ = ? where password_ = ?;",

std::tuple<double, std::string, std::string>(0.2, "humorly", "0.2"));

std::vector<std::tuple<double, std::string, std::string>> user_content_;

// 查询

ret_ = sql_.select("select * from test;",

std::tuple<>(),

std::tuple<std::string, std::string, std::string>("id_", "name_", "password_"),

user_content_);

std::cout << "content:" << std::endl;

for (auto &val : user_content_)

{

std::cout << "id_ = " << std::get<0>(val) << ", ";

std::cout << "name_ = " << std::get<1>(val) << ", ";

std::cout << "password_ = " << std::get<2>(val) << std::endl;

}

// 查询 —> 带参数

user_content_.clear();

ret_ = sql_.select("select id_, name_, password_ from test where password_ = ?;",

std::tuple<std::string>("0.2"),

std::tuple<std::string, std::string, std::string>("id_", "name_", "password_"),

user_content_);

std::cout << "content:" << std::endl;

for (auto &val : user_content_)

{

std::cout << "id_ = " << std::get<0>(val) << ", ";

std::cout << "name_ = " << std::get<1>(val) << ", ";

std::cout << "password_ = " << std::get<2>(val) << std::endl;

}

return 0;

}