def sql_user_integration(phone):
inte = mysqler.query(
f" SELETE integration FROM user WHERE phone=\'{phone}\'")[0][0]
print(inte)
return inte
def sql_fix_openid(signin_id):
res = mysqler.query(
f"UPDATE bbc_enter_name SET openid = 'o-12n0z07Zc6aLI9sAYouWkAojmA' WHERE id = \'{signin_id}\'"
)
return res
def sql_usercouponid(user_id, coupon_id):
tmp = f"SELECT id FROM usercoupon uc WHERE userId = '{user_id}' AND couponRule = '{coupon_id}';"
res = mysqler.query(tmp)
return res
def sql_matchid():
match_id = mysqler.query(
f"SELECT id FROM bbc_match ORDER BY create_time DESC LIMIT 1")[0][0]
return match_id
def sql_payrecordid_to_outtradeno(prid):
out_trade_no = mysqler.query(
f"SELECT pr.outTradeNo FROM payrecord pr INNER JOIN goodsorder go ON pr.goodsOrderId = go.id WHERE pr.id = '{prid}';"
)[0][0]
return out_trade_no
def sql_phone_to_userid(phone):
user_id = mysqler.query(
f"SELECT id FROM user WHERE user.phone = \'{phone}\'")[0][0]
return user_id
def sql_examid_to_uuid(exam_id):
uuid = mysqler.query(
f"SELECT uuid FROM bbc_examination be WHERE be.id = \'{exam_id}\'"
)[0][0]
print(uuid)
return uuid
project_name_1 = 'zuopin7'
user.send_sms2(phone)
user.register(phone)
user.gz_login(phone)
res4 = project.save_scratch_project_for_user(project_name_1)
project_id_1 = res4.sdata.get('id')
res5 = project.publish(project_name_1, project_id_1)
assert res5.sdata.get('status') == 'P'
@pytest.mark.single
# @pytest.mark.parametrize("outTradeNo", '202103251226456923966257')
def test_user_add_project(self):
phone = '18844550007'
project_name_1 = 'zuopin8'
user.gz_login(phone)
res4 = project.save_scratch_project_for_user(project_name_1)
project_id_1 = res4.sdata.get('id')
res5 = project.publish(project_name_1, project_id_1)
assert res5.sdata.get('status') == 'P'
if __name__ == '__main__':
# pytest.main(["-q", "-s", "test_add_project.py::TestLeadsAddProject::test_user_add_project"])
phone = '13006166591'
user_id = mysqler.query("SELECT id FROM user WHERE phone=\'" + phone + "\'")[0][0]
print(user_id)