def setUp(self): self.ds = datasource("adapter=gadfly") self.ds.execute("""CREATE TABLE person ( id INTEGER, name VARCHAR, image VARCHAR ) """, modify=True)
def setUp(self): self.ds = datasource("adapter=gadfly") self.ds.execute("""CREATE TABLE person ( id INTEGER, name VARCHAR(100)) """, modify=True)
def setUp(self): self.ds = datasource(os.getenv("ORMTEST_PGSQL_CONN")) self.ds.execute("""CREATE TABLE domain ( id SERIAL PRIMARY KEY, fqdn TEXT UNIQUE )""") self.ds.execute("""CREATE TABLE mail_admin ( id SERIAL PRIMARY KEY, email TEXT UNIQUE, name TEXT )""") self.ds.execute("""CREATE TABLE mail_server ( id SERIAL PRIMARY KEY, fqhn TEXT UNIQUE )""") self.ds.execute("""CREATE TABLE domain_to_mail_admin ( domain_id INTEGER REFERENCES domain, mail_admin_id INTEGER REFERENCES mail_admin, UNIQUE(domain_id, mail_admin_id) )""") self.ds.execute("""CREATE TABLE mail_admin_to_mail_server ( admin_email TEXT REFERENCES mail_admin(email), server_hostname TEXT REFERENCES mail_server(fqhn) )""")
def setUp(self): self.ds = datasource("adapter=gadfly") self.ds.execute("""CREATE TABLE person ( firstname VARCHAR, lastname VARCHAR, height INTEGER ) """, modify=True)
def connect_and_create_table(self): self.ds = datasource("adapter=gadfly") self.ds.execute("""CREATE TABLE host ( id INTEGER, fqhn VARCHAR, ip INTEGER) """, modify=True)
def setUp(self): self.ds = datasource("adapter=gadfly") self.ds.execute("""CREATE TABLE domain ( id INTEGER, fqdn VARCHAR )""") self.ds.execute("""CREATE TABLE mail_admin ( id INTEGER, email VARCHAR, name VARCHAR )""") self.ds.execute("""CREATE TABLE mail_server ( id INTEGER, fqhn VARCHAR )""") self.ds.execute("""CREATE TABLE domain_to_mail_admin ( domain_id INTEGER, mail_admin_id INTEGER )""") self.ds.execute("""CREATE TABLE mail_admin_to_mail_server ( admin_email VARCHAR, server_hostname VARCHAR )""")
def connect_and_create_table(self): self.ds = datasource("adapter=pgsql") self.ds.execute("""CREATE TABLE users ( id SERIAL, login TEXT, roles TEXT)""")
def setUp(self): self.ds = datasource("adapter=gadfly") self.ds.execute("""CREATE TABLE person ( id INTEGER, firstname VARCHAR, lastname VARCHAR, attributes VARCHAR ) """, modify=True)
def setUp(self): # ORMTEST_PGSQL_CONN="adapter=pgsql host=localhost" self.ds = datasource(os.getenv("ORMTEST_PGSQL_CONN")) self.ds.execute("""CREATE TABLE person ( id SERIAL, firstname TEXT, lastname TEXT, height INTEGER ) """)
def connect_and_create_table(self): # ORMTEST_PGSQL_CONN = "adapter=pgsql host=localhost" self.ds = datasource(os.getenv("ORMTEST_PGSQL_CONN")) self.ds.execute("""CREATE TABLE host ( id SERIAL, fqhn TEXT, ip INTEGER) """, modify=True)
def setUp(self): self.ds = datasource("adapter=gadfly") self.ds.execute("CREATE TABLE domain ( id INTEGER, fqdn VARCHAR )") self.ds.execute("""CREATE TABLE email ( id INTEGER, local_part VARCHAR, remote_part VARCHAR )""")
def setUp(self): # ORMTEST_PGSQL_CONN = "adapter=pgsql host=localhost" self.ds = datasource(os.getenv("ORMTEST_PGSQL_CONN")) self.ds.execute("""CREATE TABLE person ( firstname TEXT, lastname TEXT, height INTEGER, PRIMARY KEY(firstname, lastname) ) """, modify=True)
def setUp(self): self.ds = datasource("adapter=gadfly") self.ds.execute("CREATE TABLE country (id INTEGER, name VARCHAR)") self.ds.execute("""CREATE TABLE city ( id INTEGER, name VARCHAR, country_id INTEGER )""")
def connect_and_create_table(self): self.ds = datasource("adapter=gadfly") self.ds.execute("""CREATE TABLE person ( id INTEGER, firstname VARCHAR, lastname VARCHAR, height INTEGER, gender VARCHAR) """, modify=True)
def setUp(self): # ORMTEST_PGSQL_CONN="adapter=pgsql host=localhost" self.ds = datasource(os.getenv("ORMTEST_PGSQL_CONN")) self.ds.execute("""CREATE TABLE person ( id SERIAL, firstname TEXT, lastname TEXT, height INTEGER ) """, modify=True)
def connect_and_create_table(self): # ORMTEST_FIREBIRD_CONN="adapter=firebird dsn=localhost:/tmp/test user=sysdba password=masterkey" self.ds = datasource(os.getenv("ORMTEST_FIREBIRD_CONN")) self.ds.execute("""RECREATE TABLE host ( id INTEGER NOT NULL, PRIMARY KEY(id), fqhn VARCHAR(100), ip INTEGER) """, modify=True)
def setUp(self): # ORMTEST_MYSQL_CONN="adapter=mysql host=localhost dbname=test" self.ds = datasource(os.getenv("ORMTEST_MYSQL_CONN")) self.ds.execute("DROP TABLE IF EXISTS person", modify=True) self.ds.execute("""CREATE TABLE person ( firstname VARCHAR(100), -- MySQL needs to know lastname VARCHAR(100), -- the key length height INTEGER, PRIMARY KEY(firstname, lastname) ) """, modify=True)
def setUp(self): # ORMTEST_MYSQL_CONN="adapter=mysql host=localhost dbname=test" self.ds = datasource(os.getenv("ORMTEST_MYSQL_CONN")) self.ds.execute("DROP TABLE IF EXISTS person") self.ds.execute("""CREATE TABLE person ( id INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), firstname TEXT, lastname TEXT, height INTEGER ) """)
def connect_and_create_table(self): # ORMTEST_PGSQL_CONN = "adapter=pgsql host=localhostq" self.ds = datasource(os.getenv("ORMTEST_PGSQL_CONN")) self.ds.execute("""CREATE TABLE datetest ( id SERIAL, PRIMARY KEY(id), dt DATE, tm TIME, dttm TIMESTAMP ) """, modify=True)
def connect_and_create_table(self): # ORMTEST_MYSQL_CONN="adapter=mysql host=localhost dbname=test" self.ds = datasource(os.getenv("ORMTEST_MYSQL_CONN")) self.ds.execute("DROP TABLE IF EXISTS host", modify=True) self.ds.execute("""CREATE TABLE host ( id INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), fqhn TEXT, ip INTEGER) """, modify=True)
def connect_and_create_table(self): # ORMTEST_PGSQL_CONN = "adapter=pgsql host=localhostq" self.ds = datasource(os.getenv("ORMTEST_PGSQL_CONN")) self.ds.execute("""CREATE TABLE datetest ( id SERIAL, PRIMARY KEY(id), dt DATE, tm TIME, dttm TIMESTAMP ) """)
def setUp(self): self.ds = datasource("adapter=gadfly") self.ds.execute("""CREATE TABLE city ( id INTEGER, name_en VARCHAR, name_de VARCHAR ) """) self.ds.execute("""INSERT INTO city VALUES (1, 'Cologne', 'Köln')""")
def connect_and_create_table(self): # ORMTEST_PGSQL_CONN = "adapter=pgsql host=localhost" self.ds = datasource(os.getenv("ORMTEST_PGSQL_CONN")) self.ds.execute("""CREATE TABLE person ( id SERIAL, firstname TEXT, lastname TEXT, height INTEGER, gender CHAR(1)) """, modify=True) self.insert_unicode_person()
def connect_and_create_table(self): # ORMTEST_MYSQL_CONN="adapter=mysql host=localhost dbname=test" self.ds = datasource(os.getenv("ORMTEST_MYSQL_CONN")) self.ds.execute("DROP TABLE IF EXISTS datetest") self.ds.execute("""CREATE TABLE datetest ( id SERIAL, PRIMARY KEY(id), dt DATE, tm TIME, dttm TIMESTAMP ) """)
def setUp(self): self.ds = datasource("adapter=gadfly") self.ds.execute("""CREATE TABLE city ( id INTEGER, name_en VARCHAR, name_de VARCHAR ) """, modify=True) self.ds.execute("""INSERT INTO city VALUES (1, 'Cologne', 'Köln')""")
def setUp(self): # ORMTEST_MYSQL_CONN="adapter=mysql host=localhost dbname=test" self.ds = datasource(os.getenv("ORMTEST_MYSQL_CONN")) self.ds.execute("DROP TABLE IF EXISTS person") self.ds.execute("""CREATE TABLE person ( id INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), firstname TEXT, lastname TEXT, height INTEGER ) """, modify=True)
def connect_and_create_table(self): # ORMTEST_MYSQL_CONN="adapter=mysql host=localhost dbname=test" self.ds = datasource(os.getenv("ORMTEST_MYSQL_CONN")) self.ds.execute("DROP TABLE IF EXISTS datetest", modify=True) self.ds.execute("""CREATE TABLE datetest ( id SERIAL, PRIMARY KEY(id), dt DATE, tm TIME, dttm TIMESTAMP ) """, modify=True)
def connect_and_create_table(self): # ORMTEST_MYSQL_CONN="adapter=mysql host=localhost dbname=test" self.ds = datasource(os.getenv("ORMTEST_MYSQL_CONN")) self.ds.execute("DROP TABLE IF EXISTS person", modify=True) self.ds.execute("""CREATE TABLE person ( id INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), firstname TEXT, lastname TEXT, height INTEGER, gender CHAR(1)) """, modify=True)
def setUp(self): # ORMTEST_PGSQL_CONN="adapter=pgsql host=localhost" self.ds = datasource(os.getenv("ORMTEST_PGSQL_CONN")) self.ds.execute("""CREATE TABLE country ( id SERIAL PRIMARY KEY, name TEXT )""") self.ds.execute("""CREATE TABLE city ( id SERIAL, name TEXT, country_id INTEGER REFERENCES country )""")
def setUp(self): # ORMTEST_PGSQL_CONN = "adapter=pgsql host=localhost" self.ds = datasource(os.getenv("ORMTEST_PGSQL_CONN")) self.ds.execute("""CREATE TABLE domain ( id SERIAL PRIMARY KEY, fqdn TEXT UNIQUE )""") self.ds.execute("""CREATE TABLE email ( id SERIAL PRIMARY KEY, local_part TEXT, remote_part TEXT REFERENCES domain(fqdn) )""")
def setUp(self): # ORMTEST_MYSQL_CONN="adapter=mysql host=localhost dbname=test" self.ds = datasource(os.getenv("ORMTEST_MYSQL_CONN")) self.ds.execute("DROP TABLE IF EXISTS country") self.ds.execute("DROP TABLE IF EXISTS city") self.ds.execute("""CREATE TABLE country ( id INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name TEXT )""") self.ds.execute("""CREATE TABLE city ( id INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name TEXT, country_id INTEGER REFERENCES country )""")
def setUp(self): # ORMTEST_FIREBIRD_CONN="adapter=firebird dsn=localhost:/tmp/test user=sysdba password=masterkey" self.ds = datasource(os.getenv("ORMTEST_FIREBIRD_CONN")) self.ds.execute("""RECREATE TABLE person ( id INTEGER NOT NULL, PRIMARY KEY(id), firstname VARCHAR(100), lastname VARCHAR(100), height INTEGER )""") self.ds.commit() try: self.ds.execute("DROP GENERATOR GEN_PK_PERSON") except: pass self.ds.execute("CREATE GENERATOR GEN_PK_PERSON") self.ds.commit()
def connect_and_create_table(self): # ORMTEST_FIREBIRD_CONN="adapter=firebird dsn=localhost:/tmp/test user=sysdba password=masterkey" self.ds = datasource(os.getenv("ORMTEST_FIREBIRD_CONN")) self.ds.execute("""RECREATE TABLE datetest ( id INTEGER NOT NULL, PRIMARY KEY(id), dt DATE, tm TIME, dttm TIMESTAMP ) """) try: self.ds.execute("DROP GENERATOR GEN_PK_DATETEST") except: pass self.ds.execute("CREATE GENERATOR GEN_PK_DATETEST") self.ds.commit()
def setUp(self): # ORMTEST_FIREBIRD_CONN="adapter=firebird dsn=localhost:/tmp/test user=sysdba password=masterkey" self.ds = datasource(os.getenv("ORMTEST_FIREBIRD_CONN")) self.ds.execute("""RECREATE TABLE test ( id INTEGER NOT NULL, s VARCHAR(100), PRIMARY KEY(id) )""", modify=True) self.ds.commit() try: self.ds.execute("DROP GENERATOR GEN_PK_TEST", modify=True) except: pass self.ds.execute("CREATE GENERATOR GEN_PK_TEST", modify=True) self.ds.commit()
def setUp(self): # ORMTEST_MYSQL_CONN="adapter=mysql host=localhost dbname=test" self.ds = datasource(os.getenv("ORMTEST_MYSQL_CONN")) self.ds.execute("DROP TABLE IF EXISTS domain") self.ds.execute("DROP TABLE IF EXISTS email") self.ds.execute("""CREATE TABLE domain ( id INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), fqdn VARCHAR(100) UNIQUE )""") self.ds.execute("""CREATE TABLE email ( id INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), local_part TEXT, remote_part TEXT REFERENCES domain(fqdn) )""")
def connect_and_create_table(self): # ORMTEST_FIREBIRD_CONN="adapter=firebird dsn=localhost:/tmp/test user=sysdba password=masterkey" self.ds = datasource(os.getenv("ORMTEST_FIREBIRD_CONN")) self.ds.execute("""RECREATE TABLE datetest ( id INTEGER NOT NULL, PRIMARY KEY(id), dt DATE, tm TIME, dttm TIMESTAMP ) """, modify=True) try: self.ds.execute("DROP GENERATOR GEN_PK_DATETEST", modify=True) except: pass self.ds.execute("CREATE GENERATOR GEN_PK_DATETEST", modify=True) self.ds.commit()
def setUp(self): # ORMTEST_PGSQL_CONN = "adapter=pgsql host=localhost" self.ds = datasource(os.getenv("ORMTEST_PGSQL_CONN")) self.ds.execute("""CREATE TABLE domain ( domain TEXT, tld TEXT, PRIMARY KEY (domain, tld) )""") self.ds.execute("""CREATE TABLE email ( id SERIAL, local_part VARCHAR, remote_part_domain TEXT, remote_part_tld TEXT, PRIMARY KEY (id), FOREIGN KEY (remote_part_domain, remote_part_tld) REFERENCES domain (domain, tld) )""")
def setUp(self): self.ds = datasource(os.getenv("ORMTEST_MYSQL_CONN")) self.ds.execute("DROP TABLE IF EXISTS domain") self.ds.execute("""CREATE TABLE domain ( id INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), fqdn VARCHAR(100) UNIQUE )""") self.ds.execute("DROP TABLE IF EXISTS mail_admin") self.ds.execute("""CREATE TABLE mail_admin ( id INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), email VARCHAR(100) UNIQUE, name VARCHAR(100) )""") self.ds.execute("DROP TABLE IF EXISTS mail_server") self.ds.execute("""CREATE TABLE mail_server ( id INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), fqhn VARCHAR(100) UNIQUE )""") self.ds.execute("DROP TABLE IF EXISTS domain_to_mail_admin") self.ds.execute("""CREATE TABLE domain_to_mail_admin ( domain_id INTEGER REFERENCES domain, mail_admin_id INTEGER REFERENCES mail_admin, UNIQUE(domain_id, mail_admin_id) )""") self.ds.execute("DROP TABLE IF EXISTS mail_admin_to_mail_Server") self.ds.execute("""CREATE TABLE mail_admin_to_mail_server ( admin_email VARCHAR(100) REFERENCES mail_admin(email), server_hostname VARCHAR(100) REFERENCES mail_server(fqhn) )""")
def connect_and_create_table(self): # ORMTEST_FIREBIRD_CONN="adapter=firebird dsn=localhost:/tmp/test user=sysdba password=masterkey" self.ds = datasource(os.getenv("ORMTEST_FIREBIRD_CONN")) self.ds.execute("""RECREATE TABLE person ( id INTEGER NOT NULL, PRIMARY KEY(id), firstname VARCHAR(100), lastname VARCHAR(100), height INTEGER, gender CHAR(1)) """, modify=True) try: self.ds.execute("DROP GENERATOR GEN_PK_PERSON", modify=True) except: pass self.ds.execute("CREATE GENERATOR GEN_PK_PERSON", modify=True) self.ds.commit() self.insert_unicode_person()
def setUp(self): # ORMTEST_MYSQL_CONN="adapter=mysql host=localhost dbname=test" self.ds = datasource(os.getenv("ORMTEST_MYSQL_CONN")) self.ds.execute("DROP TABLE IF EXISTS domain", modify=True) self.ds.execute("DROP TABLE IF EXISTS email", modify=True) self.ds.execute("""CREATE TABLE domain ( domain VARCHAR(255), tld VARCHAR(10), PRIMARY KEY (domain, tld) )""") self.ds.execute("""CREATE TABLE email ( id INTEGER NOT NULL AUTO_INCREMENT, local_part VARCHAR(100), remote_part_domain VARCHAR(255), remote_part_tld VARCHAR(10), PRIMARY KEY (id), FOREIGN KEY (remote_part_domain, remote_part_tld) REFERENCES domain (domain, tld) )""")
def connect(self): # ORMTEST_MYSQL_CONN="adapter=mysql host=localhost dbname=test" self.ds = datasource(os.getenv("ORMTEST_MYSQL_CONN"))