()
| 311 | |
| 312 | |
| 313 | def test_grouping_alias(): |
| 314 | s = 'select foo as bar from mytable' |
| 315 | p = sqlparse.parse(s)[0] |
| 316 | assert str(p) == s |
| 317 | assert p.tokens[2].get_real_name() == 'foo' |
| 318 | assert p.tokens[2].get_alias() == 'bar' |
| 319 | s = 'select foo from mytable t1' |
| 320 | p = sqlparse.parse(s)[0] |
| 321 | assert str(p) == s |
| 322 | assert p.tokens[6].get_real_name() == 'mytable' |
| 323 | assert p.tokens[6].get_alias() == 't1' |
| 324 | s = 'select foo::integer as bar from mytable' |
| 325 | p = sqlparse.parse(s)[0] |
| 326 | assert str(p) == s |
| 327 | assert p.tokens[2].get_alias() == 'bar' |
| 328 | s = ('SELECT DISTINCT ' |
| 329 | '(current_database())::information_schema.sql_identifier AS view') |
| 330 | p = sqlparse.parse(s)[0] |
| 331 | assert str(p) == s |
| 332 | assert p.tokens[4].get_alias() == 'view' |
| 333 | |
| 334 | |
| 335 | def test_grouping_alias_case(): |
nothing calls this directly
no test coverage detected
searching dependent graphs…