Coverage for /pythoncovmergedfiles/medio/medio/usr/local/lib/python3.8/site-packages/pygments/lexers/_postgres

1"""

2 pygments.lexers._postgres_builtins

3 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

5 Self-updating data files for PostgreSQL lexer.

7 Run with `python -I` to update itself.

10 :license: BSD, see LICENSE for details.

11"""

13# Autogenerated: please edit them if you like wasting your time.

15KEYWORDS = (

16 'ABORT',

17 'ABSOLUTE',

18 'ACCESS',

19 'ACTION',

20 'ADD',

21 'ADMIN',

22 'AFTER',

23 'AGGREGATE',

24 'ALL',

25 'ALSO',

26 'ALTER',

27 'ALWAYS',

28 'ANALYSE',

29 'ANALYZE',

30 'AND',

31 'ANY',

32 'ARRAY',

33 'AS',

34 'ASC',

35 'ASENSITIVE',

36 'ASSERTION',

37 'ASSIGNMENT',

38 'ASYMMETRIC',

39 'AT',

40 'ATOMIC',

41 'ATTACH',

42 'ATTRIBUTE',

43 'AUTHORIZATION',

44 'BACKWARD',

45 'BEFORE',

46 'BEGIN',

47 'BETWEEN',

48 'BIGINT',

49 'BINARY',

50 'BIT',

51 'BOOLEAN',

52 'BOTH',

53 'BREADTH',

54 'BY',

55 'CACHE',

56 'CALL',

57 'CALLED',

58 'CASCADE',

59 'CASCADED',

60 'CASE',

61 'CAST',

62 'CATALOG',

63 'CHAIN',

64 'CHAR',

65 'CHARACTER',

66 'CHARACTERISTICS',

67 'CHECK',

68 'CHECKPOINT',

69 'CLASS',

70 'CLOSE',

71 'CLUSTER',

72 'COALESCE',

73 'COLLATE',

74 'COLLATION',

75 'COLUMN',

76 'COLUMNS',

77 'COMMENT',

78 'COMMENTS',

79 'COMMIT',

80 'COMMITTED',

81 'COMPRESSION',

82 'CONCURRENTLY',

83 'CONFIGURATION',

84 'CONFLICT',

85 'CONNECTION',

86 'CONSTRAINT',

87 'CONSTRAINTS',

88 'CONTENT',

89 'CONTINUE',

90 'CONVERSION',

91 'COPY',

92 'COST',

93 'CREATE',

94 'CROSS',

95 'CSV',

96 'CUBE',

97 'CURRENT',

98 'CURRENT_CATALOG',

99 'CURRENT_DATE',

100 'CURRENT_ROLE',

101 'CURRENT_SCHEMA',

102 'CURRENT_TIME',

103 'CURRENT_TIMESTAMP',

104 'CURRENT_USER',

105 'CURSOR',

106 'CYCLE',

107 'DATA',

108 'DATABASE',

109 'DAY',

110 'DEALLOCATE',

111 'DEC',

112 'DECIMAL',

113 'DECLARE',

114 'DEFAULT',

115 'DEFAULTS',

116 'DEFERRABLE',

117 'DEFERRED',

118 'DEFINER',

119 'DELETE',

120 'DELIMITER',

121 'DELIMITERS',

122 'DEPENDS',

123 'DEPTH',

124 'DESC',

125 'DETACH',

126 'DICTIONARY',

127 'DISABLE',

128 'DISCARD',

129 'DISTINCT',

130 'DO',

131 'DOCUMENT',

132 'DOMAIN',

133 'DOUBLE',

134 'DROP',

135 'EACH',

136 'ELSE',

137 'ENABLE',

138 'ENCODING',

139 'ENCRYPTED',

140 'END',

141 'ENUM',

142 'ESCAPE',

143 'EVENT',

144 'EXCEPT',

145 'EXCLUDE',

146 'EXCLUDING',

147 'EXCLUSIVE',

148 'EXECUTE',

149 'EXISTS',

150 'EXPLAIN',

151 'EXPRESSION',

152 'EXTENSION',

153 'EXTERNAL',

154 'EXTRACT',

155 'FALSE',

156 'FAMILY',

157 'FETCH',

158 'FILTER',

159 'FINALIZE',

160 'FIRST',

161 'FLOAT',

162 'FOLLOWING',

163 'FOR',

164 'FORCE',

165 'FOREIGN',

166 'FORWARD',

167 'FREEZE',

168 'FROM',

169 'FULL',

170 'FUNCTION',

171 'FUNCTIONS',

172 'GENERATED',

173 'GLOBAL',

174 'GRANT',

175 'GRANTED',

176 'GREATEST',

177 'GROUP',

178 'GROUPING',

179 'GROUPS',

180 'HANDLER',

181 'HAVING',

182 'HEADER',

183 'HOLD',

184 'HOUR',

185 'IDENTITY',

186 'IF',

187 'ILIKE',

188 'IMMEDIATE',

189 'IMMUTABLE',

190 'IMPLICIT',

191 'IMPORT',

192 'IN',

193 'INCLUDE',

194 'INCLUDING',

195 'INCREMENT',

196 'INDEX',

197 'INDEXES',

198 'INHERIT',

199 'INHERITS',

200 'INITIALLY',

201 'INLINE',

202 'INNER',

203 'INOUT',

204 'INPUT',

205 'INSENSITIVE',

206 'INSERT',

207 'INSTEAD',

208 'INT',

209 'INTEGER',

210 'INTERSECT',

211 'INTERVAL',

212 'INTO',

213 'INVOKER',

214 'IS',

215 'ISNULL',

216 'ISOLATION',

217 'JOIN',

218 'KEY',

219 'LABEL',

220 'LANGUAGE',

221 'LARGE',

222 'LAST',

223 'LATERAL',

224 'LEADING',

225 'LEAKPROOF',

226 'LEAST',

227 'LEFT',

228 'LEVEL',

229 'LIKE',

230 'LIMIT',

231 'LISTEN',

232 'LOAD',

233 'LOCAL',

234 'LOCALTIME',

235 'LOCALTIMESTAMP',

236 'LOCATION',

237 'LOCK',

238 'LOCKED',

239 'LOGGED',

240 'MAPPING',

241 'MATCH',

242 'MATERIALIZED',

243 'MAXVALUE',

244 'METHOD',

245 'MINUTE',

246 'MINVALUE',

247 'MODE',

248 'MONTH',

249 'MOVE',

250 'NAME',

251 'NAMES',

252 'NATIONAL',

253 'NATURAL',

254 'NCHAR',

255 'NEW',

256 'NEXT',

257 'NFC',

258 'NFD',

259 'NFKC',

260 'NFKD',

261 'NO',

262 'NONE',

263 'NORMALIZE',

264 'NORMALIZED',

265 'NOT',

266 'NOTHING',

267 'NOTIFY',

268 'NOTNULL',

269 'NOWAIT',

270 'NULL',

271 'NULLIF',

272 'NULLS',

273 'NUMERIC',

274 'OBJECT',

275 'OF',

276 'OFF',

277 'OFFSET',

278 'OIDS',

279 'OLD',

280 'ON',

281 'ONLY',

282 'OPERATOR',

283 'OPTION',

284 'OPTIONS',

285 'OR',

286 'ORDER',

287 'ORDINALITY',

288 'OTHERS',

289 'OUT',

290 'OUTER',

291 'OVER',

292 'OVERLAPS',

293 'OVERLAY',

294 'OVERRIDING',

295 'OWNED',

296 'OWNER',

297 'PARALLEL',

298 'PARSER',

299 'PARTIAL',

300 'PARTITION',

301 'PASSING',

302 'PASSWORD',

303 'PLACING',

304 'PLANS',

305 'POLICY',

306 'POSITION',

307 'PRECEDING',

308 'PRECISION',

309 'PREPARE',

310 'PREPARED',

311 'PRESERVE',

312 'PRIMARY',

313 'PRIOR',

314 'PRIVILEGES',

315 'PROCEDURAL',

316 'PROCEDURE',

317 'PROCEDURES',

318 'PROGRAM',

319 'PUBLICATION',

320 'QUOTE',

321 'RANGE',

322 'READ',

323 'REAL',

324 'REASSIGN',

325 'RECHECK',

326 'RECURSIVE',

327 'REF',

328 'REFERENCES',

329 'REFERENCING',

330 'REFRESH',

331 'REINDEX',

332 'RELATIVE',

333 'RELEASE',

334 'RENAME',

335 'REPEATABLE',

336 'REPLACE',

337 'REPLICA',

338 'RESET',

339 'RESTART',

340 'RESTRICT',

341 'RETURN',

342 'RETURNING',

343 'RETURNS',

344 'REVOKE',

345 'RIGHT',

346 'ROLE',

347 'ROLLBACK',

348 'ROLLUP',

349 'ROUTINE',

350 'ROUTINES',

351 'ROW',

352 'ROWS',

353 'RULE',

354 'SAVEPOINT',

355 'SCHEMA',

356 'SCHEMAS',

357 'SCROLL',

358 'SEARCH',

359 'SECOND',

360 'SECURITY',

361 'SELECT',

362 'SEQUENCE',

363 'SEQUENCES',

364 'SERIALIZABLE',

365 'SERVER',

366 'SESSION',

367 'SESSION_USER',

368 'SET',

369 'SETOF',

370 'SETS',

371 'SHARE',

372 'SHOW',

373 'SIMILAR',

374 'SIMPLE',

375 'SKIP',

376 'SMALLINT',

377 'SNAPSHOT',

378 'SOME',

379 'SQL',

380 'STABLE',

381 'STANDALONE',

382 'START',

383 'STATEMENT',

384 'STATISTICS',

385 'STDIN',

386 'STDOUT',

387 'STORAGE',

388 'STORED',

389 'STRICT',

390 'STRIP',

391 'SUBSCRIPTION',

392 'SUBSTRING',

393 'SUPPORT',

394 'SYMMETRIC',

395 'SYSID',

396 'SYSTEM',

397 'TABLE',

398 'TABLES',

399 'TABLESAMPLE',

400 'TABLESPACE',

401 'TEMP',

402 'TEMPLATE',

403 'TEMPORARY',

404 'TEXT',

405 'THEN',

406 'TIES',

407 'TIME',

408 'TIMESTAMP',

409 'TO',

410 'TRAILING',

411 'TRANSACTION',

412 'TRANSFORM',

413 'TREAT',

414 'TRIGGER',

415 'TRIM',

416 'TRUE',

417 'TRUNCATE',

418 'TRUSTED',

419 'TYPE',

420 'TYPES',

421 'UESCAPE',

422 'UNBOUNDED',

423 'UNCOMMITTED',

424 'UNENCRYPTED',

425 'UNION',

426 'UNIQUE',

427 'UNKNOWN',

428 'UNLISTEN',

429 'UNLOGGED',

430 'UNTIL',

431 'UPDATE',

432 'USER',

433 'USING',

434 'VACUUM',

435 'VALID',

436 'VALIDATE',

437 'VALIDATOR',

438 'VALUE',

439 'VALUES',

440 'VARCHAR',

441 'VARIADIC',

442 'VARYING',

443 'VERBOSE',

444 'VERSION',

445 'VIEW',

446 'VIEWS',

447 'VOLATILE',

448 'WHEN',

449 'WHERE',

450 'WHITESPACE',

451 'WINDOW',

452 'WITH',

453 'WITHIN',

454 'WITHOUT',

455 'WORK',

456 'WRAPPER',

457 'WRITE',

458 'XML',

459 'XMLATTRIBUTES',

460 'XMLCONCAT',

461 'XMLELEMENT',

462 'XMLEXISTS',

463 'XMLFOREST',

464 'XMLNAMESPACES',

465 'XMLPARSE',

466 'XMLPI',

467 'XMLROOT',

468 'XMLSERIALIZE',

469 'XMLTABLE',

470 'YEAR',

471 'YES',

472 'ZONE',

473)

474

475DATATYPES = (

476 'bigint',

477 'bigserial',

478 'bit',

479 'bit varying',

480 'bool',

481 'boolean',

482 'box',

483 'bytea',

484 'char',

485 'character',

486 'character varying',

487 'cidr',

488 'circle',

489 'date',

490 'decimal',

491 'double precision',

492 'float4',

493 'float8',

494 'inet',

495 'int',

496 'int2',

497 'int4',

498 'int8',

499 'integer',

500 'interval',

501 'json',

502 'jsonb',

503 'line',

504 'lseg',

505 'macaddr',

506 'macaddr8',

507 'money',

508 'numeric',

509 'path',

510 'pg_lsn',

511 'pg_snapshot',

512 'point',

513 'polygon',

514 'real',

515 'serial',

516 'serial2',

517 'serial4',

518 'serial8',

519 'smallint',

520 'smallserial',

521 'text',

522 'time',

523 'timestamp',

524 'timestamptz',

525 'timetz',

526 'tsquery',

527 'tsvector',

528 'txid_snapshot',

529 'uuid',

530 'varbit',

531 'varchar',

532 'with time zone',

533 'without time zone',

534 'xml',

535)

536

537PSEUDO_TYPES = (

538 'any',

539 'anyarray',

540 'anycompatible',

541 'anycompatiblearray',

542 'anycompatiblemultirange',

543 'anycompatiblenonarray',

544 'anycompatiblerange',

545 'anyelement',

546 'anyenum',

547 'anymultirange',

548 'anynonarray',

549 'anyrange',

550 'cstring',

551 'event_trigger',

552 'fdw_handler',

553 'index_am_handler',

554 'internal',

555 'language_handler',

556 'pg_ddl_command',

557 'record',

558 'table_am_handler',

559 'trigger',

560 'tsm_handler',

561 'unknown',

562 'void',

563)

564

565# Remove 'trigger' from types

566PSEUDO_TYPES = tuple(sorted(set(PSEUDO_TYPES) - set(map(str.lower, KEYWORDS))))

567

568PLPGSQL_KEYWORDS = (

569 'ALIAS', 'CONSTANT', 'DIAGNOSTICS', 'ELSIF', 'EXCEPTION', 'EXIT',

570 'FOREACH', 'GET', 'LOOP', 'NOTICE', 'OPEN', 'PERFORM', 'QUERY', 'RAISE',

571 'RETURN', 'REVERSE', 'SQLSTATE', 'WHILE',

572)

573

574# Most of these keywords are from ExplainNode function

575# in src/backend/commands/explain.c

576

577EXPLAIN_KEYWORDS = (

578 'Aggregate',

579 'Append',

580 'Bitmap Heap Scan',

581 'Bitmap Index Scan',

582 'BitmapAnd',

583 'BitmapOr',

584 'CTE Scan',

585 'Custom Scan',

586 'Delete',

587 'Foreign Scan',

588 'Function Scan',

589 'Gather Merge',

590 'Gather',

591 'Group',

592 'GroupAggregate',

593 'Hash Join',

594 'Hash',

595 'HashAggregate',

596 'Incremental Sort',

597 'Index Only Scan',

598 'Index Scan',

599 'Insert',

600 'Limit',

601 'LockRows',

602 'Materialize',

603 'Memoize',

604 'Merge Append',

605 'Merge Join',

606 'Merge',

607 'MixedAggregate',

608 'Named Tuplestore Scan',

609 'Nested Loop',

610 'ProjectSet',

611 'Recursive Union',

612 'Result',

613 'Sample Scan',

614 'Seq Scan',

615 'SetOp',

616 'Sort',

617 'SubPlan',

618 'Subquery Scan',

619 'Table Function Scan',

620 'Tid Range Scan',

621 'Tid Scan',

622 'Unique',

623 'Update',

624 'Values Scan',

625 'WindowAgg',

626 'WorkTable Scan',

627)

628

629

630if __name__ == '__main__': # pragma: no cover

631 import re

632 from urllib.request import urlopen

633

634 from pygments.util import format_lines

635

636 # One man's constant is another man's variable.

637 SOURCE_URL = 'https://github.com/postgres/postgres/raw/master'

638 KEYWORDS_URL = SOURCE_URL + '/src/include/parser/kwlist.h'

639 DATATYPES_URL = SOURCE_URL + '/doc/src/sgml/datatype.sgml'

640

641 def update_myself():

642 content = urlopen(DATATYPES_URL).read().decode('utf-8', errors='ignore')

643 data_file = list(content.splitlines())

644 datatypes = parse_datatypes(data_file)

645 pseudos = parse_pseudos(data_file)

646

647 content = urlopen(KEYWORDS_URL).read().decode('utf-8', errors='ignore')

648 keywords = parse_keywords(content)

649

650 update_consts(__file__, 'DATATYPES', datatypes)

651 update_consts(__file__, 'PSEUDO_TYPES', pseudos)

652 update_consts(__file__, 'KEYWORDS', keywords)

653

654 def parse_keywords(f):

655 kw = []

656 for m in re.finditer(r'PG_KEYWORD\("(.+?)"', f):

657 kw.append(m.group(1).upper())

658

659 if not kw:

660 raise ValueError('no keyword found')

661

662 kw.sort()

663 return kw

664

665 def parse_datatypes(f):

666 dt = set()

667 for line in f:

668 if '<sect1' in line:

669 break

670 if '<entry><type>' not in line:

671 continue

672

673 # Parse a string such as

674 # time [ (<replaceable>p</replaceable>) ] [ without time zone ]

675 # into types "time" and "without time zone"

676

677 # remove all the tags

678 line = re.sub("<replaceable>[^<]+</replaceable>", "", line)

679 line = re.sub("<[^>]+>", "", line)

680

681 # Drop the parts containing braces

682 for tmp in [t for tmp in line.split('[')

683 for t in tmp.split(']') if "(" not in t]:

684 for t in tmp.split(','):

685 t = t.strip()

686 if not t: continue

687 dt.add(" ".join(t.split()))

688

689 dt = list(dt)

690 dt.sort()

691 return dt

692

693 def parse_pseudos(f):

694 dt = []

695 re_start = re.compile(r'\s*<table id="datatype-pseudotypes-table">')

696 re_entry = re.compile(r'\s*<entry><type>(.+?)</type></entry>')

697 re_end = re.compile(r'\s*</table>')

698

699 f = iter(f)

700 for line in f:

701 if re_start.match(line) is not None:

702 break

703 else:

704 raise ValueError('pseudo datatypes table not found')

705

706 for line in f:

707 m = re_entry.match(line)

708 if m is not None:

709 dt.append(m.group(1))

710

711 if re_end.match(line) is not None:

712 break

713 else:

714 raise ValueError('end of pseudo datatypes table not found')

715

716 if not dt:

717 raise ValueError('pseudo datatypes not found')

718

719 dt.sort()

720 return dt

721

722 def update_consts(filename, constname, content):

723 with open(filename, encoding='utf-8') as f:

724 data = f.read()

725

726 # Line to start/end inserting

727 re_match = re.compile(r'^%s\s*=\s*$$.*?^\s*$$' % constname, re.M | re.S)

728 m = re_match.search(data)

729 if not m:

730 raise ValueError('Could not find existing definition for %s' %

731 (constname,))

732

733 new_block = format_lines(constname, content)

734 data = data[:m.start()] + new_block + data[m.end():]

735

736 with open(filename, 'w', encoding='utf-8', newline='\n') as f:

737 f.write(data)

738

739 update_myself()

Coverage for /pythoncovmergedfiles/medio/medio/usr/local/lib/python3.8/site-packages/pygments/lexers/_postgres_builtins.py: 100%

6 statements