add_sql_query_condition

pyhelpers.dbms.utils.add_sql_query_condition(sql_query, add_table_name=None, **kwargs)[source]

Add a condition to a given SQL query statement.

Parameters:

sql_query (str) – SQL query statement
add_table_name (str | None) – add a table name to each of the column names, defaults to None

Returns:

updated SQL query statement with specific conditions

Return type:

str

Examples:

>>> from pyhelpers.dbms.utils import add_sql_query_condition
>>> query = 'SELECT * FROM a_table'
>>> query
'SELECT * FROM a_table'
>>> add_sql_query_condition(query)
'SELECT * FROM a_table'
>>> add_sql_query_condition(query, COL_NAME_1='A')
'SELECT * FROM a_table WHERE "COL_NAME_1"='A''
>>> add_sql_query_condition(query, COL_NAME_1='A', COL_NAME_2=['B', 'C'])
'SELECT * FROM a_table WHERE "COL_NAME_1"='A' AND "COL_NAME_2" IN ('B', 'C')'
>>> add_sql_query_condition(query, COL_NAME_1='A', add_table_name='t1')
'SELECT * FROM a_table WHERE t1."COL_NAME_1"='A''