MCPcopy
hub / github.com/andialbrecht/sqlparse / test_configurable_regex

Function test_configurable_regex

tests/test_parse.py:584–611  ·  view source on GitHub ↗
()

Source from the content-addressed store, hash-verified

582
583
584def test_configurable_regex():
585 lex = Lexer.get_default_instance()
586 lex.clear()
587
588 my_regex = (r"ZORDER\s+BY\b", sqlparse.tokens.Keyword)
589
590 lex.set_SQL_REGEX(
591 keywords.SQL_REGEX[:38]
592 + [my_regex]
593 + keywords.SQL_REGEX[38:]
594 )
595 lex.add_keywords(keywords.KEYWORDS_COMMON)
596 lex.add_keywords(keywords.KEYWORDS_ORACLE)
597 lex.add_keywords(keywords.KEYWORDS_PLPGSQL)
598 lex.add_keywords(keywords.KEYWORDS_HQL)
599 lex.add_keywords(keywords.KEYWORDS_MSACCESS)
600 lex.add_keywords(keywords.KEYWORDS)
601
602 tokens = sqlparse.parse("select * from foo zorder by bar;")[0]
603
604 # reset the syntax for later tests.
605 Lexer.get_default_instance().default_initialization()
606
607 assert list(
608 (t.ttype, t.value)
609 for t in tokens
610 if t.ttype not in sqlparse.tokens.Whitespace
611 )[4] == (sqlparse.tokens.Keyword, "zorder by")
612
613
614@pytest.mark.parametrize('sql', [

Callers

nothing calls this directly

Calls 5

get_default_instanceMethod · 0.80
clearMethod · 0.80
set_SQL_REGEXMethod · 0.80
add_keywordsMethod · 0.80

Tested by

no test coverage detected

Used in the wild real call sites across dependent graphs

searching dependent graphs…