Beispiel #1
0
 def setUp(self):
     mkdir(TEST_DIR)
     db.settings.data_path = TEST_DIR
     self.conn = db._connect(path.join(TEST_DIR, TEST_DB), True)
     self.conn.execute(TEST_TABLESQL)
     self.conn.close()
     self.conn = None
Beispiel #2
0
 def setUp(self):
     mkdir(TEST_DIR)
     db.settings.data_path = TEST_DIR
     self.conn = db._connect(path.join(TEST_DIR,TEST_DB),True)
     self.conn.execute(TEST_TABLESQL)
     self.conn.close()
     self.conn = None
Beispiel #3
0
 def setUp(self):
     mkdir(TEST_DIR)
     db.settings.data_path = TEST_DIR
     self.conn = db._connect(path.join(TEST_DIR, TEST_DB), True)
Beispiel #4
0
 def testconnectwithcreate(self):
     conn = db._connect(TEST_DB, True)
     self.assertNotEqual(conn, None, '_connect returned None')
     conn.close()
Beispiel #5
0
 def setUp(self):
     mkdir(TEST_DIR)
     db.settings.data_path = TEST_DIR
     self.conn = db._connect(path.join(TEST_DIR,TEST_DB),True)
Beispiel #6
0
 def testconnectwithcreate(self):
     conn = db._connect(TEST_DB, True)
     self.assertNotEqual(conn, None, '_connect returned None')
     conn.close()
Beispiel #7
0
#! /usr/local/bin/python
import db

conn = db._connect()
c = conn.cursor()

try:
    c.execute('CREATE TABLE code (email, code)')
except:
    print("Can't create table code")
    pass

try:
    c.execute('CREATE TABLE rsvp ({})'.format(
        ', '.join(db._guest_fields + ['email']), ))
except:
    print("Can't create table rsvp")
    pass

try:
    c.execute('CREATE TABLE password (password, guest_type)')
except:
    print("Can't create table password")
    pass

try:
    c.execute('CREATE TABLE message (email, message)')
except:
    print("Can't create table message")
    pass