blob: 0489c2dd70eac41f49e27aa522224bcb13d07260 (
plain)
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
|
---
redirect_from: "/MySQLtypesC++"
---
# MySQL Types C++
<div id="main-content" data-inline-comments-target="true" class="wiki-content">
<div class="table-wrap">
<table class="confluenceTable" resolved="">
<thead>
<tr>
<th colspan="4" class="confluenceTh">Mapping from types used in SQL queries</th>
</tr>
</thead>
<tbody>
<tr>
<th class="confluenceTh">
<p>MySQL type</p>
<th class="confluenceTh">Core type
</th>
<th class="confluenceTh">Example code</th>
<th colspan="1" class="confluenceTh">Variable operators</th>
</tr>
<tr>
<td colspan="1" class="confluenceTd">BIGINT</td>
<td colspan="1" class="confluenceTd">int64</td>
<td colspan="1" class="confluenceTd"><code>int64 val = fields[n].GetInt64();</code></td>
<td colspan="1" class="confluenceTd">%I64d (Capital i)</td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">BIGINT UNSIGNED</td>
<td colspan="1" class="confluenceTd">uint64</td>
<td colspan="1" class="confluenceTd"><code><span>uint64 val = fields[n].GetUInt64();</span></code>
</td>
<td colspan="1" class="confluenceTd">%I64u (Capital i)</td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">INT</td>
<td colspan="1" class="confluenceTd">int32</td>
<td colspan="1" class="confluenceTd"><code><span>int32 val = fields[n].GetInt32();</span></code>
</td>
<td colspan="1" class="confluenceTd"><span>%u</span></td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">INT UNSIGNED</td>
<td colspan="1" class="confluenceTd">uint32</td>
<td colspan="1" class="confluenceTd"><code><span>uint32 val = fields[n].GetUInt32();</span></code>
</td>
<td colspan="1" class="confluenceTd"><span>%u</span></td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">MEDIUMINT</td>
<td colspan="1" class="confluenceTd">int32</td>
<td colspan="1" class="confluenceTd"><code><span>int32 val = fields[n].GetInt32();</span></code>
</td>
<td colspan="1" class="confluenceTd"><span>%u</span></td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">MEDIUMINT UNSIGNED</td>
<td colspan="1" class="confluenceTd">uint32</td>
<td colspan="1" class="confluenceTd"><code><span>uint32 val = fields[n].GetUInt32();</span></code>
</td>
<td colspan="1" class="confluenceTd"><span>%u</span></td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">SMALLINT</td>
<td colspan="1" class="confluenceTd">int16</td>
<td colspan="1" class="confluenceTd"><code><span>int16 val = fields[n].GetInt16();</span></code>
</td>
<td colspan="1" class="confluenceTd"> </td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">SMALLINT UNSIGNED</td>
<td colspan="1" class="confluenceTd">uint16</td>
<td colspan="1" class="confluenceTd"><code><span>uint16 val = fields[n].GetUInt16();</span></code>
</td>
<td colspan="1" class="confluenceTd"> </td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">TINYINT</td>
<td colspan="1" class="confluenceTd">int8</td>
<td colspan="1" class="confluenceTd"><code><span>int16 val = fields[n].GetInt16();</span></code>
</td>
<td colspan="1" class="confluenceTd"> </td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">TINYINT UNSIGNED</td>
<td colspan="1" class="confluenceTd">uint8</td>
<td colspan="1" class="confluenceTd"><code><span>uint8 val = fields[n].GetUInt8();</span></code>
</td>
<td colspan="1" class="confluenceTd"> </td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">FLOAT</td>
<td rowspan="2" class="confluenceTd">float</td>
<td rowspan="2" class="confluenceTd"><code>float val = fields[n].GetFLOAT();</code></td>
<td colspan="1" class="confluenceTd"> </td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">FLOAT UNSIGNED</td>
<td class="confluenceTd"> </td>
</tr>
<tr>
<td class="confluenceTd">DOUBLE</td>
<td rowspan="2" class="confluenceTd">double</td>
<td rowspan="2" class="confluenceTd"><code>double val = fields[n].GetDouble();</code></td>
<td colspan="1" class="confluenceTd"> </td>
</tr>
<tr>
<td class="confluenceTd">DOUBLE UNSIGNED</td>
<td class="confluenceTd"> </td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">text</td>
<td rowspan="6" class="confluenceTd">
<p style="text-align: center;"><span>string (std::string)</span></p>
<p style="text-align: center;"><span>or</span></p>
<p style="text-align: center;"><span>cstring (char const*)</span></p>
</td>
<td rowspan="6" class="confluenceTd">
<p><code>std::string text = fields[n].GetString();</code></p>
<p><code>char const* text = fields[n].GetCString();</code></p>
</td>
<td colspan="1" class="confluenceTd">%s</td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">longtext</td>
<td class="confluenceTd"><span>%s</span></td>
</tr>
<tr>
<td colspan="1" class="confluenceTd"><span style="color: rgb(68,68,68);">tinytext</span></td>
<td class="confluenceTd"><span style="color: rgb(68,68,68);"><span>%s</span></span></td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">char(k)</td>
<td class="confluenceTd"><span>%s</span></td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">VARCHAR(k)</td>
<td class="confluenceTd"><span>%s</span></td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">blob</td>
<td class="confluenceTd"><span>%s</span></td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">COUNT(x)</td>
<td colspan="1" class="confluenceTd">uint64</td>
<td colspan="1" class="confluenceTd"><code><span>uint64 count = fields[n].GetUInt64();</span></code>
</td>
<td colspan="1" class="confluenceTd">%UI64FMT*</td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">MAX(x)</td>
<td rowspan="2" class="confluenceTd">uint32 or int32</td>
<td rowspan="2" class="confluenceTd">
<p><code>uint32 minmax = fields[n].GetUInt32();</code></p>
<p><code>int32 minmax = fields[n].GetInt32();</code></p>
</td>
<td colspan="1" class="confluenceTd">%u</td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">MIN(x)</td>
<td class="confluenceTd"><span>%u</span></td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">SUM(x)</td>
<td colspan="1" class="confluenceTd">
<p style="text-align: center;">string (std::string)</p>
<p style="text-align: center;">or</p>
<p style="text-align: center;">cstring (char const*)</p>
</td>
<td colspan="1" class="confluenceTd">
<p><code>INT sum;</code></p>
<p><code>if (const char* ch = fields[n].GetCString())</code></p>
<p><code> sum = atoi(ch);</code></p>
</td>
<td colspan="1" class="confluenceTd">
<p>%s</p>
<p> </p>
<p>%s</p>
</td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">UNIX_TIMESTAMP(x)</td>
<td colspan="1" class="confluenceTd">uint64</td>
<td colspan="1" class="confluenceTd"><code>uint64 unix_time = fields[n].GetUInt64();</code></td>
<td colspan="1" class="confluenceTd">
<p> </p>
</td>
</tr>
</tbody>
</table>
</div>
<p>1* %UI64FMT does not work with acore_string</p>
<p> </p>
<p> </p>
<div class="code panel pdl conf-macro output-block" style="border-width: 1px;" data-hasbody="true"
data-macro-name="code" data-macro-id="">
<div class="codeHeader panelHeader pdl" style="border-bottom-width: 1px;"><b>Example</b></div>
<div class="codeContent panelContent pdl"></div>
</div>
</div>
```cpp
// world database query 0 1 2 3 4
QueryResult result = WorldDatabase.Query("SELECT guid, entry, name, period, ScriptName FROM transports");
do
{
Field* fields = result->Fetch();
uint32 lowguid = fields[0].GetUInt32();
uint32 entry = fields[1].GetUInt32();
std::string name = fields[2].GetString();
uint32 period = fields[3].GetUInt32();
uint32 scriptId = sObjectMgr->GetScriptId(fields[4].GetCString());
// ...
}
while (result->NextRow());
```
|
