h8'h0dZddlZddlZddlZddlddlmZejddk7rddlm Z n ddl m Z e jejee jej"ee jej$ee j&ZGddeZGd d eeZGd d eeZy#e $r ddl m Z YwxYw) a Peewee integration with pysqlcipher. Project page: https://github.com/leapcode/pysqlcipher/ **WARNING!!! EXPERIMENTAL!!!** * Although this extention's code is short, it has not been properly peer-reviewed yet and may have introduced vulnerabilities. Also note that this code relies on pysqlcipher and sqlcipher, and the code there might have vulnerabilities as well, but since these are widely used crypto modules, we can expect "short zero days" there. Example usage: from peewee.playground.ciphersql_ext import SqlCipherDatabase db = SqlCipherDatabase('/path/to/my.db', passphrase="don'tuseme4real") * `passphrase`: should be "long enough". Note that *length beats vocabulary* (much exponential), and even a lowercase-only passphrase like easytorememberyethardforotherstoguess packs more noise than 8 random printable characters and *can* be memorized. When opening an existing database, passphrase should be the one used when the database was created. If the passphrase is incorrect, an exception will only be raised **when you access the database**. If you need to ask for an interactive passphrase, here's example code you can put after the `db = ...` line: try: # Just access the database so that it checks the encryption. db.get_tables() # We're looking for a DatabaseError with a specific error message. except peewee.DatabaseError as e: # Check whether the message *means* "passphrase is wrong" if e.args[0] == 'file is encrypted or is not a database': raise Exception('Developer should Prompt user for passphrase ' 'again.') else: # A different DatabaseError. Raise it. raise e See a more elaborate example with this code at https://gist.github.com/thedod/11048875 N)*)SqliteExtDatabase)dbapi2c"eZdZeZdZdZdZy)_SqlCipherDatabasec4t|j}|jddjdd}t j |j fddi|} |r|jd|z|j||S#|jxYw)N passphrase'''isolation_levelzPRAGMA key='%s') dictconnect_paramspopreplace sqlcipherconnectdatabaseexecute_add_conn_hooksclose)selfparamsr conns S/var/www/html/trade_iq/venv/lib/python3.12/site-packages/playhouse/sqlcipher_ext.py_connectz_SqlCipherDatabase._connectFsd))*ZZ b199#tD   OOO  .;<   &   JJL s 'BBcX|js td||jd<y)NzmCannot set passphrase when database is open. To change passphrase of an open database use the rekey() method.r ) is_closedImproperlyConfiguredrrr s rset_passphrasez!_SqlCipherDatabase.set_passphraseTs3~~&(OP P-7L)c|jr|j|jd|jddz||jd<y)NzPRAGMA rekey='%s'r r r T)rr execute_sqlrrr!s rrekeyz_SqlCipherDatabase.rekey\sI >>  LLN ,z/A/A#t/LLM,6L)r#N)__name__ __module__ __qualname____sqlcipher_version__server_versionrr"r&r#rrrCs*N 7r#rc eZdZy)SqlCipherDatabaseNr'r(r)r,r#rr.r.er#r.c eZdZy)SqlCipherExtDatabaseNr/r,r#rr2r2ir0r#r2)__doc__datetimedecimalsyspeeweeplayhouse.sqlite_extr version_info pysqlcipherrr sqlcipher3 ImportError pysqlcipher3register_adapterDecimalstrdatetimesqlite_version_infor*objectrSqliteDatabaser.r2r,r#rrFs-\ 2A!/52 7??C0 8==#. 8==#.!55D *N  -/@ _ 545sC CC