ó ]óYc@sªddlZddlZddlZd \ZZdd„ZyeƒZeZ ej Z Wne Z dZ nXej je ddeƒZd„Zd „Zd „ZdS( iÿÿÿÿNtpostgrest localhostcCs+tjdtdtd|ƒ}t|_|S(Ntuserthosttdatabase(tpsycopg2tconnectt POSTGRES_USERt POSTGRES_HOSTtTruet autocommit(tdbnametconn((s+/Users/irina/src/pgspecial/tests/dbutils.pyt db_connection s  itreasons=Need a postgres instance at localhost accessible by user '%s'cCs7tƒjƒ"}y|jdƒWnnXWdQXdS(NsCREATE DATABASE _test_db(R tcursortexecute(R tcur((s+/Users/irina/src/pgspecial/tests/dbutils.pyt create_db s cCsÜ|jƒÊ}|jdƒ|jdƒ|jdƒ|jdƒ|jdƒ|jdƒ|jdƒ|jdƒ|jd ƒ|jd ƒ|jd ƒ|jd ƒ|jd ƒ|jdƒ|jdƒWdQXdS(Nscreate schema schema1screate schema schema2sTcreate table tbl1(id1 integer, txt1 text, CONSTRAINT id_text PRIMARY KEY(id1, txt1))s(create table tbl2(id2 serial, txt2 text)s4create table schema1.s1_tbl1(id1 integer, txt1 text)s=create table tbl3(c3 circle, exclude using gist (c3 with &&))s3create table "Inh1"(value1 integer) inherits (tbl1)s7create table inh2(value2 integer) inherits (tbl1, tbl2)s%create view vw1 as select * from tbl1sRcreate view schema1.s1_vw1 as select * from schema1.s1_tbl1s3create materialized view mvw1 as select * from tbl1s`create materialized view schema1.s1_mvw1 as select * from schema1.s1_tbl1s"create type foo AS (a int, b text)sWcreate function func1() returns int language sql as $$select 1$$sbcreate function schema1.s1_func1() returns int language sql as $$select 2$$(RR(R R((s+/Users/irina/src/pgspecial/tests/dbutils.pytsetup_db(s(           cCs&|jƒ}|jdƒWdQXdS(Ns¯ DROP SCHEMA public CASCADE; CREATE SCHEMA public; DROP SCHEMA IF EXISTS schema1 CASCADE; DROP SCHEMA IF EXISTS schema2 CASCADE(RR(R R((s+/Users/irina/src/pgspecial/tests/dbutils.pyt teardown_dbJs(RR(tpytestRtpsycopg2.extrasRRtNoneR R R tCAN_CONNECT_TO_DBtserver_versiontSERVER_VERSIONtFalsetmarktskipiftdbtestRRR(((s+/Users/irina/src/pgspecial/tests/dbutils.pyts$            "