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) """)
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(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 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) """)
def setUp(self):
self.ds = datasource(os.getenv("ORMTEST_PGSQL_CONN"))
self.ds.execute("""CREATE TABLE person (
id SERIAL,
firstname VARCHAR,
lastname VARCHAR,
attributes VARCHAR ) """)
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) """)
def setUp(self):
self.ds = datasource(os.getenv("ORMTEST_PGSQL_CONN"))
self.ds.execute(
"""CREATE TABLE person (
id SERIAL,
name VARCHAR,
image 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) """)
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)
) """)
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 (
firstname VARCHAR(100), -- MySQL needs to know
lastname VARCHAR(100), -- the key length
height INTEGER,
PRIMARY KEY(firstname, lastname)
) """)
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")
self.ds.execute("""CREATE TABLE host (
id INTEGER NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
fqhn TEXT,
ip 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 person (
id SERIAL,
firstname TEXT,
lastname TEXT,
height INTEGER,
gender CHAR(1)) """)
self.insert_unicode_person()
def ds(self):
"""
Return a t4.orm.datasource.datasource instance or None, if no
database connection could be established.
"""
if self._ds is None or not self._ds.ping():
try:
self._ds = datasource(self.options.dsn)
self.created_new_datasource(self._ds)
except Exception, e:
self.log_traceback()
return None
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")
self.ds.execute("""CREATE TABLE person (
id INTEGER NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
firstname TEXT,
lastname TEXT,
height INTEGER,
gender CHAR(1)) """)
def setUp(self):
self.ds = datasource(os.getenv("ORMTEST_PGSQL_CONN"))
self.ds.execute("""CREATE TABLE domain (
domain VARCHAR,
tld VARCHAR
)""")
self.ds.execute("""CREATE TABLE email (
id SERIAL,
local_part VARCHAR,
remote_part_domain VARCHAR,
remote_part_tld VARCHAR
)""")
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 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)) """)
try:
self.ds.execute("DROP GENERATOR GEN_PK_PERSON")
except:
pass
self.ds.execute("CREATE GENERATOR GEN_PK_PERSON")
self.ds.commit()
self.insert_unicode_person()
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 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):
self.ds = datasource("adapter=gadfly")
def connect(self):
# ORMTEST_MYSQL_CONN="adapter=mysql host=localhost dbname=test"
self.ds = datasource(os.getenv("ORMTEST_MYSQL_CONN"))
def connect(self):
# ORMTEST_PGSQL_CONN="adapter=pgsql host=localhost"
self.ds = datasource(os.getenv("ORMTEST_PGSQL_CONN"))
