From b141f9f3c8c5c7348daff5aa2a30850c3bf673ba Mon Sep 17 00:00:00 2001 From: Kevin Jurczyk Date: Tue, 8 Nov 2016 12:12:16 -0500 Subject: Add quotes around PRAGMA values in pysqlcipher connect. Arguments such as cipher, kdf_iter, cipher_page_size and cipher_use_hmac may (always?) require quotes within the PRAGMA directive. Change-Id: I2c808f34e1c44f0593b72b304e170e4af0a6035a Pull-request: https://github.com/zzzeek/sqlalchemy/pull/319 --- lib/sqlalchemy/dialects/sqlite/pysqlcipher.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'lib/sqlalchemy/dialects/sqlite') diff --git a/lib/sqlalchemy/dialects/sqlite/pysqlcipher.py b/lib/sqlalchemy/dialects/sqlite/pysqlcipher.py index bbafc8d60..4a501acac 100644 --- a/lib/sqlalchemy/dialects/sqlite/pysqlcipher.py +++ b/lib/sqlalchemy/dialects/sqlite/pysqlcipher.py @@ -100,7 +100,7 @@ class SQLiteDialect_pysqlcipher(SQLiteDialect_pysqlite): conn.execute('pragma key="%s"' % passphrase) for prag, value in pragmas.items(): if value is not None: - conn.execute('pragma %s=%s' % (prag, value)) + conn.execute('pragma %s="%s"' % (prag, value)) return conn -- cgit v1.2.1