26#include <plugin/json_server/sql_generator.h>
38 std::string jsonScalarToString(
const Json::Value &value)
41 return value.asString();
44 Json::FastWriter writer;
45 std::string rendered= writer.write(value);
46 std::string::size_type newline= rendered.find(
'\n');
47 if (newline != std::string::npos)
48 rendered.erase(newline);
63 if(
type==EVHTTP_REQ_GET)
65 else if(
type==EVHTTP_REQ_POST)
67 else if(
type==EVHTTP_REQ_DELETE)
73 _sql=
"SELECT * FROM `";
78 const Json::Value& id_val=
_json_in[
"_id"];
79 if (!id_val.isNull() && !(id_val.isString() && id_val.asString().empty()))
81 _sql.append(
" WHERE _id = ");
82 _sql.append(jsonScalarToString(id_val));
91 _sql.append(
"CREATE TABLE ");
95 _sql.append(
" (_id BIGINT PRIMARY KEY auto_increment,");
97 Json::Value::Members createKeys(
_json_in.getMemberNames() );
98 for ( Json::Value::Members::iterator it = createKeys.begin(); it != createKeys.end(); ++it )
100 const std::string &key = *it;
106 _sql.append(
" TEXT");
107 if( it !=createKeys.end()-1 && key !=
"_id")
119 _sql.append(
"REPLACE INTO `");
123 _sql.append(
"` SET ");
125 Json::Value::Members keys(
_json_in.getMemberNames() );
127 for ( Json::Value::Members::iterator it = keys.begin(); it != keys.end(); ++it )
129 if ( it != keys.begin() )
133 const std::string &key = *it;
136 Json::StyledWriter writeobject;
139 case Json::nullValue:
143 case Json::uintValue:
144 case Json::realValue:
145 case Json::booleanValue:
148 case Json::stringValue:
153 case Json::arrayValue:
154 case Json::objectValue:
169 const Json::Value& id_val=
_json_in[
"_id"];
170 if (!id_val.isNull() && !(id_val.isString() && id_val.asString().empty()))
172 _sql=
"DELETE FROM `";
177 _sql.append(
" WHERE _id = ");
178 _sql.append(jsonScalarToString(id_val));
184 _sql.append(
"DROP TABLE `");
SQLGenerator(const Json::Value json_in, const char *schema, const char *table)
void generateCreateTableSql()
void generateSql(enum evhttp_cmd_type type)
Convert from decimal to binary representation.