openvax / datacache / 27778249944

79%

push

github

Fix #17: quote SQL table/column/index identifiers (#52)

Wrap every table, column, and index name in double quotes when building
SQL in database.py, via a new quote_identifier() helper that also escapes
embedded double quotes. This means identifiers containing spaces or
punctuation, or which collide with SQL keywords (e.g. "order", "group"),
no longer have to be sanitized down to alphanumeric + underscore.

Adds a regression test that creates and queries a table whose name and
columns contain spaces and reserved words.

Claude-Session: https://claude.ai/code/session_011bzfZPTzWnhAMVD7msyMg1

5 of 6 new or added lines in 1 file covered. (83.33%)

332 of 452 relevant lines covered (73.45%)

2.2 hits per line