Coverage for /pythoncovmergedfiles/medio/medio/usr/local/lib/python3.8/site-packages/sqlalchemy/dialects/mysql/reserved

1# mysql/reserved_words.py

3# <see AUTHORS file>

5# This module is part of SQLAlchemy and is released under

6# the MIT License: https://www.opensource.org/licenses/mit-license.php

8# generated using:

9# https://gist.github.com/kkirsche/4f31f2153ed7a3248be1ec44ca6ddbc9

10#

11# https://mariadb.com/kb/en/reserved-words/

12# includes: Reserved Words, Oracle Mode (separate set unioned)

13# excludes: Exceptions, Function Names

14RESERVED_WORDS_MARIADB = {

15 "accessible",

16 "add",

17 "all",

18 "alter",

19 "analyze",

20 "and",

21 "as",

22 "asc",

23 "asensitive",

24 "before",

25 "between",

26 "bigint",

27 "binary",

28 "blob",

29 "both",

30 "by",

31 "call",

32 "cascade",

33 "case",

34 "change",

35 "char",

36 "character",

37 "check",

38 "collate",

39 "column",

40 "condition",

41 "constraint",

42 "continue",

43 "convert",

44 "create",

45 "cross",

46 "current_date",

47 "current_role",

48 "current_time",

49 "current_timestamp",

50 "current_user",

51 "cursor",

52 "database",

53 "databases",

54 "day_hour",

55 "day_microsecond",

56 "day_minute",

57 "day_second",

58 "dec",

59 "decimal",

60 "declare",

61 "default",

62 "delayed",

63 "delete",

64 "desc",

65 "describe",

66 "deterministic",

67 "distinct",

68 "distinctrow",

69 "div",

70 "do_domain_ids",

71 "double",

72 "drop",

73 "dual",

74 "each",

75 "else",

76 "elseif",

77 "enclosed",

78 "escaped",

79 "except",

80 "exists",

81 "exit",

82 "explain",

83 "false",

84 "fetch",

85 "float",

86 "float4",

87 "float8",

88 "for",

89 "force",

90 "foreign",

91 "from",

92 "fulltext",

93 "general",

94 "grant",

95 "group",

96 "having",

97 "high_priority",

98 "hour_microsecond",

99 "hour_minute",

100 "hour_second",

101 "if",

102 "ignore",

103 "ignore_domain_ids",

104 "ignore_server_ids",

105 "in",

106 "index",

107 "infile",

108 "inner",

109 "inout",

110 "insensitive",

111 "insert",

112 "int",

113 "int1",

114 "int2",

115 "int3",

116 "int4",

117 "int8",

118 "integer",

119 "intersect",

120 "interval",

121 "into",

122 "is",

123 "iterate",

124 "join",

125 "key",

126 "keys",

127 "kill",

128 "leading",

129 "leave",

130 "left",

131 "like",

132 "limit",

133 "linear",

134 "lines",

135 "load",

136 "localtime",

137 "localtimestamp",

138 "lock",

139 "long",

140 "longblob",

141 "longtext",

142 "loop",

143 "low_priority",

144 "master_heartbeat_period",

145 "master_ssl_verify_server_cert",

146 "match",

147 "maxvalue",

148 "mediumblob",

149 "mediumint",

150 "mediumtext",

151 "middleint",

152 "minute_microsecond",

153 "minute_second",

154 "mod",

155 "modifies",

156 "natural",

157 "no_write_to_binlog",

158 "not",

159 "null",

160 "numeric",

161 "offset",

162 "on",

163 "optimize",

164 "option",

165 "optionally",

166 "or",

167 "order",

168 "out",

169 "outer",

170 "outfile",

171 "over",

172 "page_checksum",

173 "parse_vcol_expr",

174 "partition",

175 "position",

176 "precision",

177 "primary",

178 "procedure",

179 "purge",

180 "range",

181 "read",

182 "read_write",

183 "reads",

184 "real",

185 "recursive",

186 "ref_system_id",

187 "references",

188 "regexp",

189 "release",

190 "rename",

191 "repeat",

192 "replace",

193 "require",

194 "resignal",

195 "restrict",

196 "return",

197 "returning",

198 "revoke",

199 "right",

200 "rlike",

201 "rows",

202 "schema",

203 "schemas",

204 "second_microsecond",

205 "select",

206 "sensitive",

207 "separator",

208 "set",

209 "show",

210 "signal",

211 "slow",

212 "smallint",

213 "spatial",

214 "specific",

215 "sql",

216 "sql_big_result",

217 "sql_calc_found_rows",

218 "sql_small_result",

219 "sqlexception",

220 "sqlstate",

221 "sqlwarning",

222 "ssl",

223 "starting",

224 "stats_auto_recalc",

225 "stats_persistent",

226 "stats_sample_pages",

227 "straight_join",

228 "table",

229 "terminated",

230 "then",

231 "tinyblob",

232 "tinyint",

233 "tinytext",

234 "to",

235 "trailing",

236 "trigger",

237 "true",

238 "undo",

239 "union",

240 "unique",

241 "unlock",

242 "unsigned",

243 "update",

244 "usage",

245 "use",

246 "using",

247 "utc_date",

248 "utc_time",

249 "utc_timestamp",

250 "values",

251 "varbinary",

252 "varchar",

253 "varcharacter",

254 "varying",

255 "when",

256 "where",

257 "while",

258 "window",

259 "with",

260 "write",

261 "xor",

262 "year_month",

263 "zerofill",

264}.union(

265 {

266 "body",

267 "elsif",

268 "goto",

269 "history",

270 "others",

271 "package",

272 "period",

273 "raise",

274 "rowtype",

275 "system",

276 "system_time",

277 "versioning",

278 "without",

279 }

280)

281

282# https://dev.mysql.com/doc/refman/8.0/en/keywords.html

283# https://dev.mysql.com/doc/refman/5.7/en/keywords.html

284# https://dev.mysql.com/doc/refman/5.6/en/keywords.html

285# includes: MySQL x.0 Keywords and Reserved Words

286# excludes: MySQL x.0 New Keywords and Reserved Words,

287# MySQL x.0 Removed Keywords and Reserved Words

288RESERVED_WORDS_MYSQL = {

289 "accessible",

290 "add",

291 "admin",

292 "all",

293 "alter",

294 "analyze",

295 "and",

296 "array",

297 "as",

298 "asc",

299 "asensitive",

300 "before",

301 "between",

302 "bigint",

303 "binary",

304 "blob",

305 "both",

306 "by",

307 "call",

308 "cascade",

309 "case",

310 "change",

311 "char",

312 "character",

313 "check",

314 "collate",

315 "column",

316 "condition",

317 "constraint",

318 "continue",

319 "convert",

320 "create",

321 "cross",

322 "cube",

323 "cume_dist",

324 "current_date",

325 "current_time",

326 "current_timestamp",

327 "current_user",

328 "cursor",

329 "database",

330 "databases",

331 "day_hour",

332 "day_microsecond",

333 "day_minute",

334 "day_second",

335 "dec",

336 "decimal",

337 "declare",

338 "default",

339 "delayed",

340 "delete",

341 "dense_rank",

342 "desc",

343 "describe",

344 "deterministic",

345 "distinct",

346 "distinctrow",

347 "div",

348 "double",

349 "drop",

350 "dual",

351 "each",

352 "else",

353 "elseif",

354 "empty",

355 "enclosed",

356 "escaped",

357 "except",

358 "exists",

359 "exit",

360 "explain",

361 "false",

362 "fetch",

363 "first_value",

364 "float",

365 "float4",

366 "float8",

367 "for",

368 "force",

369 "foreign",

370 "from",

371 "fulltext",

372 "function",

373 "general",

374 "generated",

375 "get",

376 "get_master_public_key",

377 "grant",

378 "group",

379 "grouping",

380 "groups",

381 "having",

382 "high_priority",

383 "hour_microsecond",

384 "hour_minute",

385 "hour_second",

386 "if",

387 "ignore",

388 "ignore_server_ids",

389 "in",

390 "index",

391 "infile",

392 "inner",

393 "inout",

394 "insensitive",

395 "insert",

396 "int",

397 "int1",

398 "int2",

399 "int3",

400 "int4",

401 "int8",

402 "integer",

403 "interval",

404 "into",

405 "io_after_gtids",

406 "io_before_gtids",

407 "is",

408 "iterate",

409 "join",

410 "json_table",

411 "key",

412 "keys",

413 "kill",

414 "lag",

415 "last_value",

416 "lateral",

417 "lead",

418 "leading",

419 "leave",

420 "left",

421 "like",

422 "limit",

423 "linear",

424 "lines",

425 "load",

426 "localtime",

427 "localtimestamp",

428 "lock",

429 "long",

430 "longblob",

431 "longtext",

432 "loop",

433 "low_priority",

434 "master_bind",

435 "master_heartbeat_period",

436 "master_ssl_verify_server_cert",

437 "match",

438 "maxvalue",

439 "mediumblob",

440 "mediumint",

441 "mediumtext",

442 "member",

443 "middleint",

444 "minute_microsecond",

445 "minute_second",

446 "mod",

447 "modifies",

448 "natural",

449 "no_write_to_binlog",

450 "not",

451 "nth_value",

452 "ntile",

453 "null",

454 "numeric",

455 "of",

456 "on",

457 "optimize",

458 "optimizer_costs",

459 "option",

460 "optionally",

461 "or",

462 "order",

463 "out",

464 "outer",

465 "outfile",

466 "over",

467 "parse_gcol_expr",

468 "partition",

469 "percent_rank",

470 "persist",

471 "persist_only",

472 "precision",

473 "primary",

474 "procedure",

475 "purge",

476 "range",

477 "rank",

478 "read",

479 "read_write",

480 "reads",

481 "real",

482 "recursive",

483 "references",

484 "regexp",

485 "release",

486 "rename",

487 "repeat",

488 "replace",

489 "require",

490 "resignal",

491 "restrict",

492 "return",

493 "revoke",

494 "right",

495 "rlike",

496 "role",

497 "row",

498 "row_number",

499 "rows",

500 "schema",

501 "schemas",

502 "second_microsecond",

503 "select",

504 "sensitive",

505 "separator",

506 "set",

507 "show",

508 "signal",

509 "slow",

510 "smallint",

511 "spatial",

512 "specific",

513 "sql",

514 "sql_after_gtids",

515 "sql_before_gtids",

516 "sql_big_result",

517 "sql_calc_found_rows",

518 "sql_small_result",

519 "sqlexception",

520 "sqlstate",

521 "sqlwarning",

522 "ssl",

523 "starting",

524 "stored",

525 "straight_join",

526 "system",

527 "table",

528 "terminated",

529 "then",

530 "tinyblob",

531 "tinyint",

532 "tinytext",

533 "to",

534 "trailing",

535 "trigger",

536 "true",

537 "undo",

538 "union",

539 "unique",

540 "unlock",

541 "unsigned",

542 "update",

543 "usage",

544 "use",

545 "using",

546 "utc_date",

547 "utc_time",

548 "utc_timestamp",

549 "values",

550 "varbinary",

551 "varchar",

552 "varcharacter",

553 "varying",

554 "virtual",

555 "when",

556 "where",

557 "while",

558 "window",

559 "with",

560 "write",

561 "xor",

562 "year_month",

563 "zerofill",

564}

Coverage for /pythoncovmergedfiles/medio/medio/usr/local/lib/python3.8/site-packages/sqlalchemy/dialects/mysql/reserved_words.py: 100%

2 statements