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(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 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 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 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 email (
id INTEGER,
local_part VARCHAR,
remote_part VARCHAR
)""")
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 (
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 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):
# 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 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 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 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 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_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_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 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", 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 ) """,
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 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=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 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_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_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_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 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_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):
# 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"))
