Coverage for snekql/sqlite/identifiers.py: 100%

1"""SQLite SQL identifier helpers.""" 

2 

3from __future__ import annotations 

4 

5 

6def quote_identifier(identifier: str) -> str: 

7 """Quote a SQLite identifier with double-quote escaping. 

8 

9 >>> quote_identifier('user') 

10 '"user"' 

11 >>> quote_identifier('weird"name') 

12 '"weird""name"' 

13 """ 

14 

15 escaped_identifier = identifier.replace('"', '""') 

16 return f'"{escaped_identifier}"'