���ѧۧݧ�ӧ�� �ާ֧ߧ֧էا֧� - ���֧էѧܧ�ڧ��ӧѧ�� - /home/ukubnwwtacc0unt/chapelbellstudios.com/uploads/cover/sqlite3.tar
���ѧ٧ѧ�
__init__.py 0000644 00000001772 15204113705 0006662 0 ustar 00 # pysqlite2/__init__.py: the pysqlite2 package. # # Copyright (C) 2005 Gerhard Häring <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 sqlite3.dbapi2 import * dbapi2.py 0000644 00000005177 15204113706 0006270 0 ustar 00 # pysqlite2/dbapi2.py: the DB-API 2.0 interface # # Copyright (C) 2004-2005 Gerhard Häring <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 datetime import time import collections.abc 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 = memoryview collections.abc.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(b"-"))) def convert_timestamp(val): datepart, timepart = val.split(b" ") year, month, day = map(int, datepart.split(b"-")) timepart_full = timepart.split(b".") hours, minutes, seconds = map(int, timepart_full[0].split(b":")) 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) __pycache__/__init__.cpython-36.opt-2.pyc 0000644 00000000232 15204113706 0014075 0 ustar 00 3 \� � @ s d dl T dS )� )�*N)Zsqlite3.dbapi2� r r �(/usr/lib64/python3.6/sqlite3/__init__.py�<module> s __pycache__/dbapi2.cpython-36.pyc 0000644 00000004651 15204113706 0012550 0 ustar 00 3 \ � @ s� d dl Z d dlZd dlZd dlT dZdZdZe jZ e jZ e j Z dd� Z dd � Z d d � Zed d � ejd�D ��Zedd � ejd�D ��ZeZejjje� dd� Ze� [dS )� N)�*Zqmark� z2.0c C s t tj| �d d� � S )N� )�Date�time� localtime)�ticks� r �&/usr/lib64/python3.6/sqlite3/dbapi2.py� DateFromTicks) s r c C s t tj| �dd� � S )Nr � )�Timer r )r r r r � TimeFromTicks, s r c C s t tj| �d d� � S )Nr )� Timestampr r )r r r r �TimestampFromTicks/ s r c C s g | ] }t |��qS r )�int)�.0�xr r r � <listcomp>2 s r �.c C s g | ] }t |��qS r )r )r r r r r r 3 s c C sP dd� } dd� }dd� }dd� }t tj| � t tj|� td |� td |� d S ) Nc S s | j � S )N)� isoformat)�valr r r � adapt_date9 s z4register_adapters_and_converters.<locals>.adapt_datec S s | j d�S )N� )r )r r r r �adapt_datetime< s z8register_adapters_and_converters.<locals>.adapt_datetimec S s t jtt| jd��� S )N� -)�datetime�date�mapr �split)r r r r � convert_date? s z6register_adapters_and_converters.<locals>.convert_datec S s� | j d�\}}tt|j d��\}}}|j d�}tt|d j d��\}}} t|�dkrltdj|d j� ��} nd} tj|||||| | �} | S ) N� r � .r � :� z{:0<6.6}r )r r r �len�format�decoder ) r ZdatepartZtimepartZyearZmonthZdayZ timepart_fullZhoursZminutesZsecondsZ microsecondsr r r �convert_timestampB s z;register_adapters_and_converters.<locals>.convert_timestampr Z timestamp)Zregister_adapterr r Zregister_converter)r r r r( r r r � register_adapters_and_converters8 s r) ) r r �collections.abc� collectionsZ_sqlite3Z paramstyleZ threadsafetyZapilevelr r r r r r r �tuple�versionr � version_infoZsqlite_versionZsqlite_version_info� memoryviewZBinary�abc�Sequence�registerZRowr) r r r r �<module> s& __pycache__/dump.cpython-36.opt-2.pyc 0000644 00000003110 15204113706 0013301 0 ustar 00 3 \ � @ s d d� Z dS )c c s | j � }dV d}|j|�}x�|j� D ]�\}}}|dkr@dV n*|dkrPdV n|jd�r^q&n dj|�V |jd d �}|jd j|��}d d � |j� D �} dj|djdd� | D ���}|j|�} x | D ]} dj| d �V q�W q&W d}|j|�}x"|j� D ]\} }}dj|�V q�W dV d S )NzBEGIN TRANSACTION;z� SELECT "name", "type", "sql" FROM "sqlite_master" WHERE "sql" NOT NULL AND "type" == 'table' ORDER BY "name" Zsqlite_sequencez DELETE FROM "sqlite_sequence";Z sqlite_stat1zANALYZE "sqlite_master";Zsqlite_z{0};�"z""zPRAGMA table_info("{0}")c S s g | ]}t |d ��qS )� )�str)�.0Z table_info� r �$/usr/lib64/python3.6/sqlite3/dump.py� <listcomp>3 s z _iterdump.<locals>.<listcomp>z2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";�,c s s | ]}d j |jdd��V qdS )z'||quote("{0}")||'r z""N)�format�replace)r �colr r r � <genexpr>6 s z _iterdump.<locals>.<genexpr>� z� SELECT "name", "type", "sql" FROM "sqlite_master" WHERE "sql" NOT NULL AND "type" IN ('index', 'trigger', 'view') zCOMMIT;)ZcursorZexecuteZfetchall� startswithr r �join) Z connectionZcu�qZ schema_resZ table_name�typeZsqlZtable_name_ident�resZ column_namesZ query_res�row�namer r r � _iterdump s4 r N)r r r r r �<module> s __pycache__/dbapi2.cpython-36.opt-1.pyc 0000644 00000004651 15204113706 0013507 0 ustar 00 3 \ � @ s� d dl Z d dlZd dlZd dlT dZdZdZe jZ e jZ e j Z dd� Z dd � Z d d � Zed d � ejd�D ��Zedd � ejd�D ��ZeZejjje� dd� Ze� [dS )� N)�*Zqmark� z2.0c C s t tj| �d d� � S )N� )�Date�time� localtime)�ticks� r �&/usr/lib64/python3.6/sqlite3/dbapi2.py� DateFromTicks) s r c C s t tj| �dd� � S )Nr � )�Timer r )r r r r � TimeFromTicks, s r c C s t tj| �d d� � S )Nr )� Timestampr r )r r r r �TimestampFromTicks/ s r c C s g | ] }t |��qS r )�int)�.0�xr r r � <listcomp>2 s r �.c C s g | ] }t |��qS r )r )r r r r r r 3 s c C sP dd� } dd� }dd� }dd� }t tj| � t tj|� td |� td |� d S ) Nc S s | j � S )N)� isoformat)�valr r r � adapt_date9 s z4register_adapters_and_converters.<locals>.adapt_datec S s | j d�S )N� )r )r r r r �adapt_datetime< s z8register_adapters_and_converters.<locals>.adapt_datetimec S s t jtt| jd��� S )N� -)�datetime�date�mapr �split)r r r r � convert_date? s z6register_adapters_and_converters.<locals>.convert_datec S s� | j d�\}}tt|j d��\}}}|j d�}tt|d j d��\}}} t|�dkrltdj|d j� ��} nd} tj|||||| | �} | S ) N� r � .r � :� z{:0<6.6}r )r r r �len�format�decoder ) r ZdatepartZtimepartZyearZmonthZdayZ timepart_fullZhoursZminutesZsecondsZ microsecondsr r r �convert_timestampB s z;register_adapters_and_converters.<locals>.convert_timestampr Z timestamp)Zregister_adapterr r Zregister_converter)r r r r( r r r � register_adapters_and_converters8 s r) ) r r �collections.abc� collectionsZ_sqlite3Z paramstyleZ threadsafetyZapilevelr r r r r r r �tuple�versionr � version_infoZsqlite_versionZsqlite_version_info� memoryviewZBinary�abc�Sequence�registerZRowr) r r r r �<module> s& __pycache__/dump.cpython-36.opt-1.pyc 0000644 00000003574 15204113706 0013316 0 ustar 00 3 \ � @ s d d� Z dS )c c s | j � }dV d}|j|�}x�|j� D ]�\}}}|dkr@dV n*|dkrPdV n|jd�r^q&n dj|�V |jd d �}|jd j|��}d d � |j� D �} dj|djdd� | D ���}|j|�} x | D ]} dj| d �V q�W q&W d}|j|�}x"|j� D ]\} }}dj|�V q�W dV dS )a/ 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(). zBEGIN TRANSACTION;z� SELECT "name", "type", "sql" FROM "sqlite_master" WHERE "sql" NOT NULL AND "type" == 'table' ORDER BY "name" Zsqlite_sequencez DELETE FROM "sqlite_sequence";Z sqlite_stat1zANALYZE "sqlite_master";Zsqlite_z{0};�"z""zPRAGMA table_info("{0}")c S s g | ]}t |d ��qS )� )�str)�.0Z table_info� r �$/usr/lib64/python3.6/sqlite3/dump.py� <listcomp>3 s z _iterdump.<locals>.<listcomp>z2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";�,c s s | ]}d j |jdd��V qdS )z'||quote("{0}")||'r z""N)�format�replace)r �colr r r � <genexpr>6 s z _iterdump.<locals>.<genexpr>� z� SELECT "name", "type", "sql" FROM "sqlite_master" WHERE "sql" NOT NULL AND "type" IN ('index', 'trigger', 'view') zCOMMIT;N)ZcursorZexecuteZfetchall� startswithr r �join) Z connectionZcu�qZ schema_resZ table_name�typeZsqlZtable_name_ident�resZ column_namesZ query_res�row�namer r r � _iterdump s4 r N)r r r r r �<module> s __pycache__/dbapi2.cpython-36.opt-2.pyc 0000644 00000004651 15204113706 0013510 0 ustar 00 3 \ � @ s� d dl Z d dlZd dlZd dlT dZdZdZe jZ e jZ e j Z dd� Z dd � Z d d � Zed d � ejd�D ��Zedd � ejd�D ��ZeZejjje� dd� Ze� [dS )� N)�*Zqmark� z2.0c C s t tj| �d d� � S )N� )�Date�time� localtime)�ticks� r �&/usr/lib64/python3.6/sqlite3/dbapi2.py� DateFromTicks) s r c C s t tj| �dd� � S )Nr � )�Timer r )r r r r � TimeFromTicks, s r c C s t tj| �d d� � S )Nr )� Timestampr r )r r r r �TimestampFromTicks/ s r c C s g | ] }t |��qS r )�int)�.0�xr r r � <listcomp>2 s r �.c C s g | ] }t |��qS r )r )r r r r r r 3 s c C sP dd� } dd� }dd� }dd� }t tj| � t tj|� td |� td |� d S ) Nc S s | j � S )N)� isoformat)�valr r r � adapt_date9 s z4register_adapters_and_converters.<locals>.adapt_datec S s | j d�S )N� )r )r r r r �adapt_datetime< s z8register_adapters_and_converters.<locals>.adapt_datetimec S s t jtt| jd��� S )N� -)�datetime�date�mapr �split)r r r r � convert_date? s z6register_adapters_and_converters.<locals>.convert_datec S s� | j d�\}}tt|j d��\}}}|j d�}tt|d j d��\}}} t|�dkrltdj|d j� ��} nd} tj|||||| | �} | S ) N� r � .r � :� z{:0<6.6}r )r r r �len�format�decoder ) r ZdatepartZtimepartZyearZmonthZdayZ timepart_fullZhoursZminutesZsecondsZ microsecondsr r r �convert_timestampB s z;register_adapters_and_converters.<locals>.convert_timestampr Z timestamp)Zregister_adapterr r Zregister_converter)r r r r( r r r � register_adapters_and_converters8 s r) ) r r �collections.abc� collectionsZ_sqlite3Z paramstyleZ threadsafetyZapilevelr r r r r r r �tuple�versionr � version_infoZsqlite_versionZsqlite_version_info� memoryviewZBinary�abc�Sequence�registerZRowr) r r r r �<module> s& __pycache__/__init__.cpython-36.pyc 0000644 00000000232 15204113706 0013135 0 ustar 00 3 \� � @ s d dl T dS )� )�*N)Zsqlite3.dbapi2� r r �(/usr/lib64/python3.6/sqlite3/__init__.py�<module> s __pycache__/__init__.cpython-36.opt-1.pyc 0000644 00000000232 15204113706 0014074 0 ustar 00 3 \� � @ s d dl T dS )� )�*N)Zsqlite3.dbapi2� r r �(/usr/lib64/python3.6/sqlite3/__init__.py�<module> s __pycache__/dump.cpython-36.pyc 0000644 00000003574 15204113706 0012357 0 ustar 00 3 \ � @ s d d� Z dS )c c s | j � }dV d}|j|�}x�|j� D ]�\}}}|dkr@dV n*|dkrPdV n|jd�r^q&n dj|�V |jd d �}|jd j|��}d d � |j� D �} dj|djdd� | D ���}|j|�} x | D ]} dj| d �V q�W q&W d}|j|�}x"|j� D ]\} }}dj|�V q�W dV dS )a/ 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(). zBEGIN TRANSACTION;z� SELECT "name", "type", "sql" FROM "sqlite_master" WHERE "sql" NOT NULL AND "type" == 'table' ORDER BY "name" Zsqlite_sequencez DELETE FROM "sqlite_sequence";Z sqlite_stat1zANALYZE "sqlite_master";Zsqlite_z{0};�"z""zPRAGMA table_info("{0}")c S s g | ]}t |d ��qS )� )�str)�.0Z table_info� r �$/usr/lib64/python3.6/sqlite3/dump.py� <listcomp>3 s z _iterdump.<locals>.<listcomp>z2SELECT 'INSERT INTO "{0}" VALUES({1})' FROM "{0}";�,c s s | ]}d j |jdd��V qdS )z'||quote("{0}")||'r z""N)�format�replace)r �colr r r � <genexpr>6 s z _iterdump.<locals>.<genexpr>� z� SELECT "name", "type", "sql" FROM "sqlite_master" WHERE "sql" NOT NULL AND "type" IN ('index', 'trigger', 'view') zCOMMIT;N)ZcursorZexecuteZfetchall� startswithr r �join) Z connectionZcu�qZ schema_resZ table_name�typeZsqlZtable_name_ident�resZ column_namesZ query_res�row�namer r r � _iterdump s4 r N)r r r r r �<module> s dump.py 0000644 00000005411 15204113706 0006063 0 ustar 00 # 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('{0};'.format(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("{0};".format(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('{0};'.format(sql)) yield('COMMIT;')
| ver. 1.4 |
Github
|
.
| PHP 8.1.34 | ���֧ߧ֧�ѧ�ڧ� ����ѧߧڧ��: 0.2 |
proxy
|
phpinfo
|
���ѧ����ۧܧ�