JezK
Edit File: pysqlcipher.pyc
� 1��fc @@ sf d Z d d l m Z d d l m Z d d l m Z d d l m Z d e f d � � YZ e Z d S( sQ .. dialect:: sqlite+pysqlcipher :name: pysqlcipher :dbapi: sqlcipher 3 or pysqlcipher :connectstring: sqlite+pysqlcipher://:passphrase@/file_path[?kdf_iter=<iter>] Dialect for support of DBAPIs that make use of the `SQLCipher <https://www.zetetic.net/sqlcipher>`_ backend. Driver ------ Current dialect selection logic is: * If the :paramref:`_sa.create_engine.module` parameter supplies a DBAPI module, that module is used. * Otherwise for Python 3, choose https://pypi.org/project/sqlcipher3/ * If not available, fall back to https://pypi.org/project/pysqlcipher3/ * For Python 2, https://pypi.org/project/pysqlcipher/ is used. .. warning:: The ``pysqlcipher3`` and ``pysqlcipher`` DBAPI drivers are no longer maintained; the ``sqlcipher3`` driver as of this writing appears to be current. For future compatibility, any pysqlcipher-compatible DBAPI may be used as follows:: import sqlcipher_compatible_driver from sqlalchemy import create_engine e = create_engine( "sqlite+pysqlcipher://:password@/dbname.db", module=sqlcipher_compatible_driver ) These drivers make use of the SQLCipher engine. This system essentially introduces new PRAGMA commands to SQLite which allows the setting of a passphrase and other encryption parameters, allowing the database file to be encrypted. Connect Strings --------------- The format of the connect string is in every way the same as that of the :mod:`~sqlalchemy.dialects.sqlite.pysqlite` driver, except that the "password" field is now accepted, which should contain a passphrase:: e = create_engine('sqlite+pysqlcipher://:testing@/foo.db') For an absolute file path, two leading slashes should be used for the database name:: e = create_engine('sqlite+pysqlcipher://:testing@//path/to/foo.db') A selection of additional encryption-related pragmas supported by SQLCipher as documented at https://www.zetetic.net/sqlcipher/sqlcipher-api/ can be passed in the query string, and will result in that PRAGMA being called for each new connection. Currently, ``cipher``, ``kdf_iter`` ``cipher_page_size`` and ``cipher_use_hmac`` are supported:: e = create_engine('sqlite+pysqlcipher://:testing@/foo.db?cipher=aes-256-cfb&kdf_iter=64000') .. warning:: Previous versions of sqlalchemy did not take into consideration the encryption-related pragmas passed in the url string, that were silently ignored. This may cause errors when opening files saved by a previous sqlalchemy version if the encryption options do not match. Pooling Behavior ---------------- The driver makes a change to the default pool behavior of pysqlite as described in :ref:`pysqlite_threading_pooling`. The pysqlcipher driver has been observed to be significantly slower on connection than the pysqlite driver, most likely due to the encryption overhead, so the dialect here defaults to using the :class:`.SingletonThreadPool` implementation, instead of the :class:`.NullPool` pool used by pysqlite. As always, the pool implementation is entirely configurable using the :paramref:`_sa.create_engine.poolclass` parameter; the :class:`. StaticPool` may be more feasible for single-threaded use, or :class:`.NullPool` may be used to prevent unencrypted connections from being held open for long periods of time, at the expense of slower startup time for new connections. i ( t absolute_importi ( t SQLiteDialect_pysqlitei ( t pool( t utilt SQLiteDialect_pysqlcipherc B@ sJ e Z d Z e Z d Z e d � � Z e d � � Z d � Z d � Z RS( t pysqlciphert kdf_itert ciphert cipher_page_sizet cipher_use_hmacc C@ sX t j rD y d d l } Wn t k r, n X| Sd d l m } n d d l m } | S( Ni ( t dbapi2( R t py3kt sqlcipher3t ImportErrort pysqlcipher3R R ( t clst sqlcipher( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sqlite/pysqlcipher.pyt dbapin s c C@ s t j S( N( R t SingletonThreadPool( R t url( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sqlite/pysqlcipher.pyt get_pool_class s c @ sR t t � � j | � � | j p$ d � t | j � � � � � � f d � } | S( Nt c @ s� | j � } | j d � � xI � j D]> } � j | d � } | d k r' | j d | | f � q' q' W| j � � r� � | � n d S( Ns pragma key="%s"s pragma %s="%s"( t cursort executet pragmast gett Nonet close( t connR t pragt value( t passphraset selft super_on_connectt url_query( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sqlite/pysqlcipher.pyt on_connect� s ( t superR t on_connect_urlt passwordt dictt query( R R R# ( ( R R R! R" sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sqlite/pysqlcipher.pyR% � s c C@ s: | j d d � } | j | j � } t t | � j | � S( NR& ( t _replaceR t difference_update_queryR R$ R t create_connect_args( R R t plain_url( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sqlite/pysqlcipher.pyR+ � s ( R R R R ( t __name__t __module__t drivert Truet supports_statement_cacheR t classmethodR R R% R+ ( ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sqlite/pysqlcipher.pyR h s N( t __doc__t __future__R t pysqliteR R R R R t dialect( ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sqlite/pysqlcipher.pyt <module>_ s <