-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathPlayers.h
284 lines (264 loc) · 10 KB
/
Players.h
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
/**
*
* Players.h
* DO NOT EDIT. This file is generated by drogon_ctl
*
*/
#pragma once
#include <drogon/orm/Field.h>
#include <drogon/orm/Mapper.h>
#include <drogon/orm/Result.h>
#include <drogon/orm/Row.h>
#include <drogon/orm/SqlBinder.h>
#ifdef __cpp_impl_coroutine
#include <drogon/orm/CoroMapper.h>
#endif
#include <json/json.h>
#include <stdint.h>
#include <trantor/utils/Date.h>
#include <trantor/utils/Logger.h>
#include <iostream>
#include <memory>
#include <string>
#include <tuple>
#include <vector>
namespace drogon {
namespace orm {
class DbClient;
using DbClientPtr = std::shared_ptr<DbClient>;
} // namespace orm
} // namespace drogon
namespace drogon_model {
namespace cavoke_orm {
class Sessions;
class Users;
class Players {
public:
struct Cols {
static const std::string _session_id;
static const std::string _user_id;
static const std::string _player_id;
static const std::string _score;
static const std::string _playerstate;
};
const static int primaryKeyNumber;
const static std::string tableName;
const static bool hasPrimaryKey;
const static std::vector<std::string> primaryKeyName;
using PrimaryKeyType =
std::tuple<std::string, std::string>; // session_id,user_id
PrimaryKeyType getPrimaryKey() const;
/**
* @brief constructor
* @param r One row of records in the SQL query result.
* @param indexOffset Set the offset to -1 to access all columns by column
* names, otherwise access all columns by offsets.
* @note If the SQL is not a style of 'select * from table_name ...' (select
* all columns by an asterisk), please set the offset to -1.
*/
explicit Players(const drogon::orm::Row &r,
const ssize_t indexOffset = 0) noexcept;
/**
* @brief constructor
* @param pJson The json object to construct a new instance.
*/
explicit Players(const Json::Value &pJson) noexcept(false);
/**
* @brief constructor
* @param pJson The json object to construct a new instance.
* @param pMasqueradingVector The aliases of table columns.
*/
Players(
const Json::Value &pJson,
const std::vector<std::string> &pMasqueradingVector) noexcept(false);
Players() = default;
void updateByJson(const Json::Value &pJson) noexcept(false);
void updateByMasqueradedJson(
const Json::Value &pJson,
const std::vector<std::string> &pMasqueradingVector) noexcept(false);
static bool validateJsonForCreation(const Json::Value &pJson,
std::string &err);
static bool validateMasqueradedJsonForCreation(
const Json::Value &,
const std::vector<std::string> &pMasqueradingVector,
std::string &err);
static bool validateJsonForUpdate(const Json::Value &pJson,
std::string &err);
static bool validateMasqueradedJsonForUpdate(
const Json::Value &,
const std::vector<std::string> &pMasqueradingVector,
std::string &err);
static bool validJsonOfField(size_t index,
const std::string &fieldName,
const Json::Value &pJson,
std::string &err,
bool isForCreation);
/** For column session_id */
/// Get the value of the column session_id, returns the default value if the
/// column is null
const std::string &getValueOfSessionId() const noexcept;
/// Return a shared_ptr object pointing to the column const value, or an
/// empty shared_ptr object if the column is null
const std::shared_ptr<std::string> &getSessionId() const noexcept;
/// Set the value of the column session_id
void setSessionId(const std::string &pSessionId) noexcept;
void setSessionId(std::string &&pSessionId) noexcept;
/** For column user_id */
/// Get the value of the column user_id, returns the default value if the
/// column is null
const std::string &getValueOfUserId() const noexcept;
/// Return a shared_ptr object pointing to the column const value, or an
/// empty shared_ptr object if the column is null
const std::shared_ptr<std::string> &getUserId() const noexcept;
/// Set the value of the column user_id
void setUserId(const std::string &pUserId) noexcept;
void setUserId(std::string &&pUserId) noexcept;
/** For column player_id */
/// Get the value of the column player_id, returns the default value if the
/// column is null
const int32_t &getValueOfPlayerId() const noexcept;
/// Return a shared_ptr object pointing to the column const value, or an
/// empty shared_ptr object if the column is null
const std::shared_ptr<int32_t> &getPlayerId() const noexcept;
/// Set the value of the column player_id
void setPlayerId(const int32_t &pPlayerId) noexcept;
/** For column score */
/// Get the value of the column score, returns the default value if the
/// column is null
const int32_t &getValueOfScore() const noexcept;
/// Return a shared_ptr object pointing to the column const value, or an
/// empty shared_ptr object if the column is null
const std::shared_ptr<int32_t> &getScore() const noexcept;
/// Set the value of the column score
void setScore(const int32_t &pScore) noexcept;
void setScoreToNull() noexcept;
/** For column playerstate */
/// Get the value of the column playerstate, returns the default value if
/// the column is null
const std::string &getValueOfPlayerstate() const noexcept;
/// Return a shared_ptr object pointing to the column const value, or an
/// empty shared_ptr object if the column is null
const std::shared_ptr<std::string> &getPlayerstate() const noexcept;
/// Set the value of the column playerstate
void setPlayerstate(const std::string &pPlayerstate) noexcept;
void setPlayerstate(std::string &&pPlayerstate) noexcept;
static size_t getColumnNumber() noexcept {
return 5;
}
static const std::string &getColumnName(size_t index) noexcept(false);
Json::Value toJson() const;
Json::Value toMasqueradedJson(
const std::vector<std::string> &pMasqueradingVector) const;
/// Relationship interfaces
void getSession(const drogon::orm::DbClientPtr &clientPtr,
const std::function<void(Sessions)> &rcb,
const drogon::orm::ExceptionCallback &ecb) const;
void getUser(const drogon::orm::DbClientPtr &clientPtr,
const std::function<void(Users)> &rcb,
const drogon::orm::ExceptionCallback &ecb) const;
private:
friend drogon::orm::Mapper<Players>;
#ifdef __cpp_impl_coroutine
friend drogon::orm::CoroMapper<Players>;
#endif
static const std::vector<std::string> &insertColumns() noexcept;
void outputArgs(drogon::orm::internal::SqlBinder &binder) const;
const std::vector<std::string> updateColumns() const;
void updateArgs(drogon::orm::internal::SqlBinder &binder) const;
/// For mysql or sqlite3
void updateId(const uint64_t id);
std::shared_ptr<std::string> sessionId_;
std::shared_ptr<std::string> userId_;
std::shared_ptr<int32_t> playerId_;
std::shared_ptr<int32_t> score_;
std::shared_ptr<std::string> playerstate_;
struct MetaData {
const std::string colName_;
const std::string colType_;
const std::string colDatabaseType_;
const ssize_t colLength_;
const bool isAutoVal_;
const bool isPrimaryKey_;
const bool notNull_;
};
static const std::vector<MetaData> metaData_;
bool dirtyFlag_[5] = {false};
public:
static const std::string &sqlForFindingByPrimaryKey() {
static const std::string sql =
"select * from " + tableName +
" where session_id = $1 and user_id = $2";
return sql;
}
static const std::string &sqlForDeletingByPrimaryKey() {
static const std::string sql =
"delete from " + tableName +
" where session_id = $1 and user_id = $2";
return sql;
}
std::string sqlForInserting(bool &needSelection) const {
std::string sql = "insert into " + tableName + " (";
size_t parametersCount = 0;
needSelection = false;
if (dirtyFlag_[0]) {
sql += "session_id,";
++parametersCount;
}
if (dirtyFlag_[1]) {
sql += "user_id,";
++parametersCount;
}
if (dirtyFlag_[2]) {
sql += "player_id,";
++parametersCount;
}
if (dirtyFlag_[3]) {
sql += "score,";
++parametersCount;
}
if (dirtyFlag_[4]) {
sql += "playerstate,";
++parametersCount;
}
if (parametersCount > 0) {
sql[sql.length() - 1] = ')';
sql += " values (";
} else
sql += ") values (";
int placeholder = 1;
char placeholderStr[64];
size_t n = 0;
if (dirtyFlag_[0]) {
n = sprintf(placeholderStr, "$%d,", placeholder++);
sql.append(placeholderStr, n);
}
if (dirtyFlag_[1]) {
n = sprintf(placeholderStr, "$%d,", placeholder++);
sql.append(placeholderStr, n);
}
if (dirtyFlag_[2]) {
n = sprintf(placeholderStr, "$%d,", placeholder++);
sql.append(placeholderStr, n);
}
if (dirtyFlag_[3]) {
n = sprintf(placeholderStr, "$%d,", placeholder++);
sql.append(placeholderStr, n);
}
if (dirtyFlag_[4]) {
n = sprintf(placeholderStr, "$%d,", placeholder++);
sql.append(placeholderStr, n);
}
if (parametersCount > 0) {
sql.resize(sql.length() - 1);
}
if (needSelection) {
sql.append(") returning *");
} else {
sql.append(1, ')');
}
LOG_TRACE << sql;
return sql;
}
};
} // namespace cavoke_orm
} // namespace drogon_model