A bit messy. We can't use the sqlparse package as __temp__ could be used in quite a few locations (e.g. from, joins, where). I've used it to validate and clean queries though.
Have made it so check_sql fails if you pass more than one sql query separated by a ;. I've added some cleaning in that removes new lines from queries as this was messing some stuff up.
Have made it so replacing temp with dbname doesnt make everything lower case. The continued cleaning of strings is to stop newlines or trailing spaces causing errors.
A bit messy. We can't use the
sqlparsepackage as__temp__could be used in quite a few locations (e.g. from, joins, where). I've used it to validate and clean queries though.Have made it so
check_sqlfails if you pass more than one sql query separated by a;. I've added some cleaning in that removes new lines from queries as this was messing some stuff up.Have made it so replacing temp with dbname doesnt make everything lower case. The continued cleaning of strings is to stop newlines or trailing spaces causing errors.
Also added a bunch of tests.
Need to add docstring to
check_sqlfunction