pip install sqlparse
python
import sqlparse
sql = "SELECT * FROM table WHERE id = 1"
parsed = sqlparse.parse(sql)
for statement in parsed:
print(statement.tokens)
python
import sqlparse
sql = "SELECT * FROM table WHERE id = 1"
formatted = sqlparse.format(sql, reindent=True, keyword_case='upper')
print(formatted)
python
import sqlparse
sql = "SELECT * FROM table WHERE id = 1"
parsed = sqlparse.parse(sql)
for statement in parsed:
for token in statement.tokens:
if token.ttype in sqlparse.tokens.Keyword:
elif token.ttype in sqlparse.tokens.Name:
python
import sqlparse
sql = "SELECT * FROM table1; SELECT * FROM table2;"
parsed = sqlparse.split(sql)
for statement in parsed:
parsed_statement = sqlparse.parse(statement)[0]
print(parsed_statement.tokens)
python
import sqlparse
import psycopg2
sql = "SELECT * FROM table WHERE id = 1"
formatted = sqlparse.format(sql, reindent=True, keyword_case='upper')
conn = psycopg2.connect(host="localhost", database="dbName", user="user", password="passwd")
cur = conn.cursor()
cur.execute(formatted)
result = cur.fetchall()
for row in result:
print(row)
cur.close()
conn.close()
python
import sqlparse
sql = "SELECT * FROM table WHERE id = 1 AND"
parsed = sqlparse.parse(sql)
for statement in parsed:
try:
valid = statement.is_valid()
except ValueError as e:
