From 2fb8cd3fd08b05a25570d0f7c453ff8611fe77d4 Mon Sep 17 00:00:00 2001
From: Olly Cope <olly@ollycope.com>
Date: Sun, 2 Oct 2022 20:41:01 +0000
Subject: Make backend.quote_identifier more robust

---
 yoyo/backends/base.py | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/yoyo/backends/base.py b/yoyo/backends/base.py
index f288d19..3c1f9a7 100644
--- a/yoyo/backends/base.py
+++ b/yoyo/backends/base.py
@@ -225,7 +225,9 @@ class DatabaseBackend:
         raise NotImplementedError()
 
     def quote_identifier(self, s):
-        return '"{}"'.format(s)
+        assert "\x00" not in s
+        quoted = s.replace('"', '""')
+        return f'"{quoted}"'
 
     def _check_transactional_ddl(self):
         """
-- 
cgit v1.2.1