def test_connect_db(): from libs.store import connect_mysql conn = connect_mysql() cursor = conn.cursor() cursor.execute("select * from codedouban_hooks") r = cursor.fetchone() assert r is None, "unittest database should not have rows"
def test_insert_into_db(self): from libs.store import connect_mysql conn = connect_mysql() cursor = conn.cursor() cursor.execute("select * from codedouban_hooks") assert cursor.fetchall() == () ok = cursor.execute( "insert into codedouban_hooks (project_id, url) values " "(1, 'test')") assert ok conn.commit() cursor.execute("select * from codedouban_hooks") assert len(cursor.fetchall()) == 1 cursor.execute("delete from codedouban_hooks") conn.commit()