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"))