def find_user_alert(email, rate_kind) -> dict:
"""
功能:返回 用户的关注的所有货币
"""
return Database.find(Alert.collection_name,
query={
"email": email,
"rate_kind": rate_kind
})
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])
def find_user_alert(email, rate_exchange):
return Database.find(collection="all_alert",
query={
"email": email,
"rate_exchange": rate_exchange
})
def find_user_alert(email, rate_exchange):
return Database.find(collection="all_alert", query={"email": email, "rate_exchange": rate_exchange})
