Example #1
0
    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()
Example #2
0
    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()
Example #3
0
 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()
Example #4
0
    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()
Example #5
0
    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()
Example #6
0
    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()
Example #7
0
 def setUpClass(cls):
     DomainTest.setUpClass()
     cls._ui = NFeUI()
Example #8
0
 def setUpClass(cls):
     DomainTest.setUpClass()
     cls._ui = NFeUI()