def setUp(self):
conn = pymysql.Connect(self.HOSTNAME, self.USER)
conn.query('create database %s;' % self.DB_NAME)
conn.close()
uri = 'mysql+pymysql://%s@%s/%s' % (self.USER, self.HOSTNAME, self.DB_NAME)
conf = DummyConfig(uri)
session.initialize(conf)
with session.Session() as sess:
with sess.begin():
tables.create_user(sess,
id=DUMMY_ID,
name=DUMMY_NAME)
with sess.begin():
tables.create_project(sess,
id=DUMMY_ID,
owner_id=DUMMY_ID,
name=DUMMY_NAME,
repository_uri='',
repository_type='')
with sess.begin():
tables.create_file(sess,
id=DUMMY_ID,
project_id=DUMMY_ID,
filepath=DUMMY_FILEPATH)
def test_project(self):
u'''
プロジェクトテーブルの定義テスト
'''
name = 'bbbb'
with session.Session() as sess:
with sess.begin():
proj = tables.create_project(sess,
owner_id=DUMMY_ID,
name=name,
repository_uri='',
repository_type='')
results = tables.search_project(sess, name=name)
self.assertEqual(len(results), 1)
# foreign key constraint
with self.assertRaises(exceptions.IntegrityError):
with session.Session() as sess:
with sess.begin():
proj = tables.create_project(sess,
owner_id=10000,
name=name,
repository_uri='',
repository_type='')
