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