PK =��\2z�� � __init__.pynu �[��� # pysqlite2/__init__.py: the pysqlite2 package.
#
# Copyright (C) 2005 Gerhard Haering <gh@ghaering.de>
#
# This file is part of pysqlite.
#
# This software is provided 'as-is', without any express or implied
# warranty. In no event will the authors be held liable for any damages
# arising from the use of this software.
#
# Permission is granted to anyone to use this software for any purpose,
# including commercial applications, and to alter it and redistribute it
# freely, subject to the following restrictions:
#
# 1. The origin of this software must not be misrepresented; you must not
# claim that you wrote the original software. If you use this software
# in a product, an acknowledgment in the product documentation would be
# appreciated but is not required.
# 2. Altered source versions must be plainly marked as such, and must not be
# misrepresented as being the original software.
# 3. This notice may not be removed or altered from any source distribution.
from dbapi2 import *
PK =��\l���
�
dump.pynu �[��� # Mimic the sqlite3 console shell's .dump command
# Author: Paul Kippes <kippesp@gmail.com>
# Every identifier in sql is quoted based on a comment in sqlite
# documentation "SQLite adds new keywords from time to time when it
# takes on new features. So to prevent your code from being broken by
# future enhancements, you should normally quote any identifier that
# is an English language word, even if you do not have to."
def _iterdump(connection):
"""
Returns an iterator to the dump of the database in an SQL text format.
Used to produce an SQL dump of the database. Useful to save an in-memory
database for later restoration. This function should not be called
directly but instead called from the Connection method, iterdump().
"""
cu = connection.cursor()
yield('BEGIN TRANSACTION;')
# sqlite_master table contains the SQL CREATE statements for the database.
q = """
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" == 'table'
ORDER BY "name"
"""
schema_res = cu.execute(q)
for table_name, type, sql in schema_res.fetchall():
if table_name == 'sqlite_sequence':
yield('DELETE FROM "sqlite_sequence";')
elif table_name == 'sqlite_stat1':
yield('ANALYZE "sqlite_master";')
elif table_name.startswith('sqlite_'):
continue
# NOTE: Virtual table support not implemented
#elif sql.startswith('CREATE VIRTUAL TABLE'):
# qtable = table_name.replace("'", "''")
# yield("INSERT INTO sqlite_master(type,name,tbl_name,rootpage,sql)"\
# "VALUES('table','{0}','{0}',0,'{1}');".format(
# qtable,
# sql.replace("''")))
else:
yield('%s;' % sql)
# Build the insert statement for each row of the current table
table_name_ident = table_name.replace('"', '""')
res = cu.execute('PRAGMA table_info("{0}")'.format(table_name_ident))
column_names = [str(table_info[1]) for table_info in res.fetchall()]
q = """SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";""".format(
table_name_ident,
",".join("""'||quote("{0}")||'""".format(col.replace('"', '""')) for col in column_names))
query_res = cu.execute(q)
for row in query_res:
yield("%s;" % row[0])
# Now when the type is 'index', 'trigger', or 'view'
q = """
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" IN ('index', 'trigger', 'view')
"""
schema_res = cu.execute(q)
for name, type, sql in schema_res.fetchall():
yield('%s;' % sql)
yield('COMMIT;')
PK =��\%H! dump.pyonu �[��� �
{ fc @ s
d � Z d S( c c sx | j � } d Vd } | j | � } x| j � D]� \ } } } | d k rV d Vn2 | d k rj d Vn | j d � r q3 n d | V| j d d
� } | j d j | � � } g | j � D] } t | d � ^ q� }
d
j | d j d � |
D� � � } | j | � } x | D] } d | d VqWq3 Wd } | j | � } x& | j � D] \ }
} } d | VqSWd Vd S( s/
Returns an iterator to the dump of the database in an SQL text format.
Used to produce an SQL dump of the database. Useful to save an in-memory
database for later restoration. This function should not be called
directly but instead called from the Connection method, iterdump().
s BEGIN TRANSACTION;s�
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" == 'table'
ORDER BY "name"
t sqlite_sequences DELETE FROM "sqlite_sequence";t sqlite_stat1s ANALYZE "sqlite_master";t sqlite_s %s;t "s ""s PRAGMA table_info("{0}")i s2 SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";t ,c s s* | ] } d j | j d d � � Vq d S( s '||quote("{0}")||'R s ""N( t formatt replace( t .0t col( ( s$ /usr/lib64/python2.7/sqlite3/dump.pys <genexpr>6 s i s�
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" IN ('index', 'trigger', 'view')
s COMMIT;N( t cursort executet fetchallt
startswithR R t strt join( t
connectiont cut qt
schema_rest
table_namet typet sqlt table_name_identt rest
table_infot column_namest query_rest rowt name( ( s$ /usr/lib64/python2.7/sqlite3/dump.pyt _iterdump
s4 )
N( R ( ( ( s$ /usr/lib64/python2.7/sqlite3/dump.pyt <module>
t PK =��\Z�n
n
dbapi2.pynu �[��� # pysqlite2/dbapi2.py: the DB-API 2.0 interface
#
# Copyright (C) 2004-2005 Gerhard Haering <gh@ghaering.de>
#
# This file is part of pysqlite.
#
# This software is provided 'as-is', without any express or implied
# warranty. In no event will the authors be held liable for any damages
# arising from the use of this software.
#
# Permission is granted to anyone to use this software for any purpose,
# including commercial applications, and to alter it and redistribute it
# freely, subject to the following restrictions:
#
# 1. The origin of this software must not be misrepresented; you must not
# claim that you wrote the original software. If you use this software
# in a product, an acknowledgment in the product documentation would be
# appreciated but is not required.
# 2. Altered source versions must be plainly marked as such, and must not be
# misrepresented as being the original software.
# 3. This notice may not be removed or altered from any source distribution.
import collections
import datetime
import time
from _sqlite3 import *
paramstyle = "qmark"
threadsafety = 1
apilevel = "2.0"
Date = datetime.date
Time = datetime.time
Timestamp = datetime.datetime
def DateFromTicks(ticks):
return Date(*time.localtime(ticks)[:3])
def TimeFromTicks(ticks):
return Time(*time.localtime(ticks)[3:6])
def TimestampFromTicks(ticks):
return Timestamp(*time.localtime(ticks)[:6])
version_info = tuple([int(x) for x in version.split(".")])
sqlite_version_info = tuple([int(x) for x in sqlite_version.split(".")])
Binary = buffer
collections.Sequence.register(Row)
def register_adapters_and_converters():
def adapt_date(val):
return val.isoformat()
def adapt_datetime(val):
return val.isoformat(" ")
def convert_date(val):
return datetime.date(*map(int, val.split("-")))
def convert_timestamp(val):
datepart, timepart = val.split(" ")
year, month, day = map(int, datepart.split("-"))
timepart_full = timepart.split(".")
hours, minutes, seconds = map(int, timepart_full[0].split(":"))
if len(timepart_full) == 2:
microseconds = int('{:0<6.6}'.format(timepart_full[1].decode()))
else:
microseconds = 0
val = datetime.datetime(year, month, day, hours, minutes, seconds, microseconds)
return val
register_adapter(datetime.date, adapt_date)
register_adapter(datetime.datetime, adapt_datetime)
register_converter("date", convert_date)
register_converter("timestamp", convert_timestamp)
register_adapters_and_converters()
# Clean up namespace
del(register_adapters_and_converters)
PK =��\��+�� � __init__.pyonu �[��� �
{ fc @ s d d l Td S( i����( t *N( t dbapi2( ( ( s( /usr/lib64/python2.7/sqlite3/__init__.pyt <module> t PK =��\ ���
�
dbapi2.pyonu �[��� �
{ fc @ s� d d l Z d d l Z d d l Z d d l Td Z d Z d Z e j Z e j Z e j Z
d � Z d � Z d � Z
e g e j d � D] Z e e � ^ q� � Z e g e j d � D] Z e e � ^ q� � Z e Z e j j e � d
� Z e � [ d S( i����N( t *t qmarki s 2.0c C s t t j | � d � S( Ni ( t Datet timet localtime( t ticks( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt
DateFromTicks) s c C s t t j | � d d !� S( Ni i ( t TimeR R ( R ( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt
TimeFromTicks, s c C s t t j | � d � S( Ni ( t TimestampR R ( R ( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt TimestampFromTicks/ s t .c C sb d � } d � } d � } d � } t t j | � t t j | � t d | � t d | � d S( Nc S s
| j � S( N( t isoformat( t val( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt
adapt_date9 s c S s
| j d � S( Nt ( R ( R
( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt adapt_datetime< s c S s t j t t | j d � � � S( Nt -( t datetimet datet mapt intt split( R
( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt convert_date? s c S s� | j d � \ } } t t | j d � � \ } } } | j d � } t t | d j d � � \ } } } t | � d k r� t d j | d j � � � }
n d }
t j | | | | | | |
� } | S( NR R R i t :i s {:0<6.6}i ( R R R t lent formatt decodeR ( R
t datepartt timepartt yeart montht dayt
timepart_fullt hourst minutest secondst microseconds( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt convert_timestampB s !%"!R t timestamp( t register_adapterR R t register_converter( R R R R& ( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt register_adapters_and_converters8 s
( t collectionsR R t _sqlite3t
paramstylet threadsafetyt apilevelR R R R R R R
t tuplet versionR t xR t version_infot sqlite_versiont sqlite_version_infot buffert Binaryt Sequencet registert RowR* ( ( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt <module> s&
.. PK =��\ ���
�
dbapi2.pycnu �[��� �
{ fc @ s� d d l Z d d l Z d d l Z d d l Td Z d Z d Z e j Z e j Z e j Z
d � Z d � Z d � Z
e g e j d � D] Z e e � ^ q� � Z e g e j d � D] Z e e � ^ q� � Z e Z e j j e � d
� Z e � [ d S( i����N( t *t qmarki s 2.0c C s t t j | � d � S( Ni ( t Datet timet localtime( t ticks( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt
DateFromTicks) s c C s t t j | � d d !� S( Ni i ( t TimeR R ( R ( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt
TimeFromTicks, s c C s t t j | � d � S( Ni ( t TimestampR R ( R ( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt TimestampFromTicks/ s t .c C sb d � } d � } d � } d � } t t j | � t t j | � t d | � t d | � d S( Nc S s
| j � S( N( t isoformat( t val( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt
adapt_date9 s c S s
| j d � S( Nt ( R ( R
( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt adapt_datetime< s c S s t j t t | j d � � � S( Nt -( t datetimet datet mapt intt split( R
( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt convert_date? s c S s� | j d � \ } } t t | j d � � \ } } } | j d � } t t | d j d � � \ } } } t | � d k r� t d j | d j � � � }
n d }
t j | | | | | | |
� } | S( NR R R i t :i s {:0<6.6}i ( R R R t lent formatt decodeR ( R
t datepartt timepartt yeart montht dayt
timepart_fullt hourst minutest secondst microseconds( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt convert_timestampB s !%"!R t timestamp( t register_adapterR R t register_converter( R R R R& ( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt register_adapters_and_converters8 s
( t collectionsR R t _sqlite3t
paramstylet threadsafetyt apilevelR R R R R R R
t tuplet versionR t xR t version_infot sqlite_versiont sqlite_version_infot buffert Binaryt Sequencet registert RowR* ( ( ( s& /usr/lib64/python2.7/sqlite3/dbapi2.pyt <module> s&
.. PK =��\��+�� � __init__.pycnu �[��� �
{ fc @ s d d l Td S( i����( t *N( t dbapi2( ( ( s( /usr/lib64/python2.7/sqlite3/__init__.pyt <module> t PK =��\%H! dump.pycnu �[��� �
{ fc @ s
d � Z d S( c c sx | j � } d Vd } | j | � } x| j � D]� \ } } } | d k rV d Vn2 | d k rj d Vn | j d � r q3 n d | V| j d d
� } | j d j | � � } g | j � D] } t | d � ^ q� }
d
j | d j d � |
D� � � } | j | � } x | D] } d | d VqWq3 Wd } | j | � } x& | j � D] \ }
} } d | VqSWd Vd S( s/
Returns an iterator to the dump of the database in an SQL text format.
Used to produce an SQL dump of the database. Useful to save an in-memory
database for later restoration. This function should not be called
directly but instead called from the Connection method, iterdump().
s BEGIN TRANSACTION;s�
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" == 'table'
ORDER BY "name"
t sqlite_sequences DELETE FROM "sqlite_sequence";t sqlite_stat1s ANALYZE "sqlite_master";t sqlite_s %s;t "s ""s PRAGMA table_info("{0}")i s2 SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";t ,c s s* | ] } d j | j d d � � Vq d S( s '||quote("{0}")||'R s ""N( t formatt replace( t .0t col( ( s$ /usr/lib64/python2.7/sqlite3/dump.pys <genexpr>6 s i s�
SELECT "name", "type", "sql"
FROM "sqlite_master"
WHERE "sql" NOT NULL AND
"type" IN ('index', 'trigger', 'view')
s COMMIT;N( t cursort executet fetchallt
startswithR R t strt join( t
connectiont cut qt
schema_rest
table_namet typet sqlt table_name_identt rest
table_infot column_namest query_rest rowt name( ( s$ /usr/lib64/python2.7/sqlite3/dump.pyt _iterdump
s4 )
N( R ( ( ( s$ /usr/lib64/python2.7/sqlite3/dump.pyt <module>
t PK =��\2z�� � __init__.pynu �[��� PK =��\l���
�
- dump.pynu �[��� PK =��\%H! X dump.pyonu �[��� PK =��\Z�n
n
� dbapi2.pynu �[��� PK =��\��+�� � N" __init__.pyonu �[��� PK =��\ ���
�
.# dbapi2.pyonu �[��� PK =��\ ���
�
�- dbapi2.pycnu �[��� PK =��\��+�� � �8 __init__.pycnu �[��� PK =��\%H! �9 dump.pycnu �[��� PK � �A
