D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
proc
/
thread-self
/
root
/
opt
/
python35
/
lib
/
python3.5
/
sqlite3
/
test
/
__pycache__
/
Filename :
dump.cpython-35.pyc
back
Copy
o��Y � @ s` d d l Z d d l Z Gd d � d e j � Z d d � Z d d � Z e d k r\ e � d S) � Nc @ s@ e Z d Z d d � Z d d � Z d d � Z d d � Z d S) � DumpTestsc C s( t j d � | _ | j j � | _ d S)Nz:memory:)�sqlite�connect�cx�cursor�cu)�self� r �#/opt/python35/lib/python3.5/dump.py�setUp s zDumpTests.setUpc C s | j j � d S)N)r �close)r r r r �tearDown s zDumpTests.tearDownc s� d d d d d d d d d d g � � f d d � � D� � j j � } d d � | D� � d g � d g � � � � f d d � t t � � � D� d S)Nz#CREATE TABLE "index"("index" blob);z"INSERT INTO "index" VALUES(X'01');z3CREATE TABLE "quoted""table"("quoted""field" text);z4INSERT INTO "quoted""table" VALUES('quoted''value');z�CREATE TABLE t1(id integer primary key, s1 text, t1_i1 integer not null, i2 integer, unique (s1), constraint t1_idx1 unique (i2));z'INSERT INTO "t1" VALUES(1,'foo',10,20);z(INSERT INTO "t1" VALUES(2,'foo2',30,30);ztCREATE TABLE t2(id integer, t2_i1 integer, t2_i2 integer, primary key (id),foreign key(t2_i1) references t1(t1_i1));zrCREATE TRIGGER trigger_1 update of t1_i1 on t1 begin update t2 set t2_i1 = new.t1_i1 where t2_i1 = old.t1_i1; end;z;CREATE VIEW v1 as select * from t1 left join t2 using (id);c s"