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='')