def setUpClass(cls): DomainTest.setUpClass() RECREATE_SQL = """ DROP TABLE IF EXISTS dung; DROP TABLE IF EXISTS dong; DROP TABLE IF EXISTS ding; CREATE TABLE ding ( id uuid PRIMARY KEY DEFAULT uuid_generate_v1(), te_id bigint UNIQUE REFERENCES transaction_entry(id), int_field integer default 0, str_field text default '' ); CREATE TABLE dong ( id uuid PRIMARY KEY DEFAULT uuid_generate_v1(), te_id bigint UNIQUE REFERENCES transaction_entry(id), bool_field boolean default false, ding_id uuid REFERENCES ding(id) ON UPDATE CASCADE ); CREATE TABLE dung ( id uuid PRIMARY KEY DEFAULT uuid_generate_v1(), identifier SERIAL NOT NULL, te_id bigint UNIQUE REFERENCES transaction_entry(id), ding_id uuid REFERENCES ding(id) ON UPDATE CASCADE ); """ cls.store.execute(RECREATE_SQL) cls.store.commit()
def setUpClass(cls): DomainTest.setUpClass() RECREATE_SQL = """ DROP TABLE IF EXISTS ding; CREATE TABLE ding ( id uuid PRIMARY KEY DEFAULT uuid_generate_v1(), te_id bigint UNIQUE REFERENCES transaction_entry(id), int_field integer default 0, str_field text default '' ); """ cls.store.execute(RECREATE_SQL) cls.store.commit()
def setUpClass(cls): DomainTest.setUpClass() RECREATE_SQL = """ DROP TABLE IF EXISTS xml_table; CREATE TABLE xml_table ( id uuid PRIMARY KEY DEFAULT uuid_generate_v1(), te_id bigint UNIQUE REFERENCES transaction_entry(id), data xml ); """ cls.store.execute(RECREATE_SQL) cls.store.commit()
def setUpClass(cls): DomainTest.setUpClass() RECREATE_SQL = """ DROP TABLE IF EXISTS test_table; CREATE TABLE test_table ( id uuid PRIMARY KEY DEFAULT uuid_generate_v1(), te_id bigint UNIQUE REFERENCES transaction_entry(id), is_high BOOLEAN DEFAULT NULL, power_level INTEGER DEFAULT NULL ); """ cls.store.execute(RECREATE_SQL) cls.store.commit()
def setUpClass(cls): DomainTest.setUpClass() cls._ui = NFeUI()