def tearDownClass(cls) -> None:
sql1 = "delete log.* from mb_member_login_log log inner join mb_member ber on log.member_id = ber.id where log.member_name = '18212345676';"
DBUtils.execute_sql(sql1)
sql2 = "delete reg.* from mb_member_register_log reg inner join mb_member ber on reg.member_name = ber.phone where reg.phone = '18212345676';"
DBUtils.execute_sql(sql2)
sql3 = "delete fo.* from mb_member_info fo left join mb_member ber on fo.member_id = ber.id where fo.member_name = '18212345676';"
DBUtils.execute_sql(sql3)
sql4 = "delete from mb_member where name = '18212345676';"
DBUtils.execute_sql(sql4)
def setUpClass(cls) -> None:
sql1 = "delete log.* from mb_member_login_log log inner join mb_member ber on log.member_id = ber.id where log.member_name in ('18212345670','18212345671','18212345672','18212345673','18212345674','18212345675','18212345676');"
DBUtils.execute_sql(sql1)
logging.info("sql1={}".format(sql1))
sql2 = "delete reg.* from mb_member_register_log reg inner join mb_member ber on reg.member_name = ber.phone where reg.phone in ('18212345670','18212345671','18212345672','18212345673','18212345674','18212345675','18212345676');"
DBUtils.execute_sql(sql2)
logging.info("sql2={}".format(sql2))
sql3 = "delete fo.* from mb_member_info fo left join mb_member ber on fo.member_id = ber.id where fo.member_name in ('18212345670','18212345671','18212345672','18212345673','18212345674','18212345675','18212345676');"
DBUtils.execute_sql(sql3)
logging.info("sql3={}".format(sql3))
sql4 = "delete from mb_member where name in ('18212345670','18212345671','18212345672','18212345673','18212345674','18212345675','18212345676');"
DBUtils.execute_sql(sql4)
logging.info("sql4={}".format(sql4))
