def check_alert(): money_dict, position = Money.search_data() all_user = [] data = Database.find_all(collection="users") for user in data: all_user.append(user["email"]) for user in all_user: message = [] user_all_alert = Database.find(collection="all_alert", query={"email": user}) for user_alert in user_all_alert: if user_alert["rate_exchange"] == "cash": if money_dict[position[user_alert["currency"]]].cash_in != "-": if float(user_alert["price"][0]) >= float(money_dict[ position[user_alert["currency"]]].cash_in): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass elif money_dict[position[ user_alert["currency"]]].cash_out != "-": if float(user_alert["price"][0]) <= float(money_dict[ position[user_alert["currency"]]].cash_out): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass else: pass else: pass elif money_dict[position[ user_alert["currency"]]].cash_out != "-": if float(user_alert["price"][0]) <= float(money_dict[ position[user_alert["currency"]]].cash_out): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass else: pass else: pass if user_alert["rate_exchange"] == "sign": if money_dict[position[user_alert["currency"]]].sign_in != "-": if float(user_alert["price"][0]) >= float(money_dict[ position[user_alert["currency"]]].sign_in): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass elif money_dict[position[ user_alert["currency"]]].sign_out != "-": if float(user_alert["price"][0]) <= float(money_dict[ position[user_alert["currency"]]].sign_out): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass else: pass else: pass elif money_dict[position[ user_alert["currency"]]].sign_out != "-": if float(user_alert["price"][0]) <= float(money_dict[ position[user_alert["currency"]]].sign_out): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass else: pass else: pass else: pass print(user, " : ", message) requests.post( "https://api.mailgun.net/v3/sandbox1b96a1ed36554268902d683b941720e5.mailgun.org/messages", auth=("api", "d71c327fcef21d1ae76ab199208f2269-49a2671e-37cd89ca"), data={ "from": "Mailgun Sandbox <*****@*****.**>", "to": user, "subject": "汇率变动提醒", "text": "目前符合的货币为:{},具体请查看提醒页面!".format(str(message).strip("[]")) })
def check_alert(): moneydict, position = Money.search_data() all_user = [] data = Database.find_all(collection="users") for user in data: all_user.append(user["email"]) for user in all_user: print(user) message = [] user_all_alert = Database.find(collection="all_alert", query={"email": user}) for user_alert in user_all_alert: if user_alert["rate_exchange"] == "cash": if moneydict[position[user_alert["currency"]]].cash_in != "-": if float(user_alert["price"][0]) >= float(moneydict[position[user_alert["currency"]]].cash_in): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass elif moneydict[position[user_alert["currency"]]].cash_out != "-": if float(user_alert["price"][0]) <= float(moneydict[position[user_alert["currency"]]].cash_out): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass else: pass else: pass elif moneydict[position[user_alert["currency"]]].cash_out != "-": if float(user_alert["price"][0]) <= float(moneydict[position[user_alert["currency"]]].cash_out): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass else: pass else: pass if user_alert["rate_exchange"] == "sign": if moneydict[position[user_alert["currency"]]].sign_in != "-": if float(user_alert["price"][1]) >= float(moneydict[position[user_alert["currency"]]].sign_in): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass elif moneydict[position[user_alert["currency"]]].sign_out != "-": if float(user_alert["price"][1]) <= float(moneydict[position[user_alert["currency"]]].sign_out): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass else: pass else: pass elif moneydict[position[user_alert["currency"]]].sign_out != "-": if float(user_alert["price"][1]) <= float(moneydict[position[user_alert["currency"]]].sign_out): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass else: pass else: pass else: pass print(user,":",message) requests.post( "https://api.mailgun.net/v3/sandboxcf0f0204481f4e5db32ca491987d150f.mailgun.org/messages", auth=("api", "b7288f39ae1c25d533325c5181e0eada-4a62b8e8-809b3b07"), data={"from": "Mailgun Sandbox <*****@*****.**>", "to": user, "subject": "外幣通知", "text": "目前符合調的外幣為:{},請盡快至關網查看!".format(str(message).strip("[]"))})
def check_alert(): moneydict, position = Money.search_data() all_user = [] data = Database.find_all(collection="users") for user in data: all_user.append(user["email"]) for user in all_user: print(user) message = [] user_all_alert = Database.find(collection="all_alert", query={"email": user}) for user_alert in user_all_alert: if user_alert["rate_exchange"] == "cash": if moneydict[position[user_alert["currency"]]].cash_in != "-": if float(user_alert["price"][0]) >= float(moneydict[ position[user_alert["currency"]]].cash_in): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass elif moneydict[position[ user_alert["currency"]]].cash_out != "-": if float(user_alert["price"][0]) <= float(moneydict[ position[user_alert["currency"]]].cash_out): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass else: pass else: pass elif moneydict[position[ user_alert["currency"]]].cash_out != "-": if float(user_alert["price"][0]) <= float(moneydict[ position[user_alert["currency"]]].cash_out): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass else: pass else: pass if user_alert["rate_exchange"] == "sign": if moneydict[position[user_alert["currency"]]].sign_in != "-": if float(user_alert["price"][1]) >= float(moneydict[ position[user_alert["currency"]]].sign_in): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass elif moneydict[position[ user_alert["currency"]]].sign_out != "-": if float(user_alert["price"][1]) <= float(moneydict[ position[user_alert["currency"]]].sign_out): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass else: pass else: pass elif moneydict[position[ user_alert["currency"]]].sign_out != "-": if float(user_alert["price"][1]) <= float(moneydict[ position[user_alert["currency"]]].sign_out): if user_alert["currency"] not in message: message.append(user_alert["currency"]) else: pass else: pass else: pass else: pass print(user, ":", message) requests.post( "https://api.mailgun.net/v3/sandboxcf0f0204481f4e5db32ca491987d150f.mailgun.org/messages", auth=("api", "b7288f39ae1c25d533325c5181e0eada-4a62b8e8-809b3b07"), data={ "from": "Mailgun Sandbox <*****@*****.**>", "to": user, "subject": "外幣通知", "text": "目前符合調的外幣為:{},請盡快至關網查看!".format(str(message).strip("[]")) })
from modules.database import Database Database.initialize() Database.insert_one(collection="testdb", data={ "name": "hython", "age": "28", "sex": "male" }) Database.insert_many(collection="testdb", data=[{ "name": "hellen", "age": "32", "sex": "female" }, { "name": "jesica", "age": "18", "sex": "female" }]) print(Database.find(collection="testdb", query={"sex": "female"})[0]) print(Database.find_one(collection="testdb", query={"name": "hython"})) print(Database.find_all(collection="testdb")[1])