def send_data():
search = get_search()
cursor = get_db_connection()
cursor.execute("SELECT name, surname, phone, zipcode from users")
data = cursor.fetchall()
list_users = {"users": list()}
for row in data:
response_msg = dict()
response_msg["name"] = row[0]
response_msg["surname"] = row[1]
response_msg["phone"] = row[2]
response_msg["zipcode"] = row[3]
list_users["users"].append(response_msg)
zipcode = search.by_zipcode(response_msg["zipcode"])
zipcode = zipcode.to_dict()
state = states[zipcode["state"]].lower()
county = zipcode["county"].replace(" County", "").lower()
url = "http://arielms.pythonanywhere.com/query/{state}/{county}".format(
state=state, county=county)
response = requests.get(url)
response_dict = json.loads(response.text)
# returns a list with 1 object
# keys are Confirmed, Deaths, Recovered, Active, Date
# print(response_dict)
# TODO Add twilio request below
return (''), 200
def update_user():
cursor = get_db_connection()
data = request
if data.form:
data = data.form
else:
data = data.get_json()
last_phone = data["last_phone"]
if exists(last_phone):
name = data["first_name"]
surname = data["last_name"]
new_phone = data["new_phone"]
zipcode = data["zipcode"]
sql = "UPDATE users SET name = '{name}', surname = '{surname}', phone = '{phone}', zipcode = '{zipcode}' WHERE phone = {last_phone}".format(
name=str(name),
surname=str(surname),
phone=str(new_phone),
zipcode=str(zipcode),
last_phone=str(last_phone))
cursor.execute(sql)
db.commit()
return (''), 200
else:
return "error: user doesn't exist", 400
def unsubscribe_user(phone):
global db
cursor = get_db_connection()
sql_check = f"SELECT FROM users WHERE phone = %s"
cursor.execute(sql, [phone])
data = cursor.fetchall()
if not data:
return "error: user doesn't exist", 404
sql = f"DELETE FROM users WHERE phone = %s"
cursor.execute(sql, [phone])
db.commit()
return "sucess", 204
def exists(phone):
try:
print('gets here1')
sql = "SELECT * FROM users WHERE phone = '{phone}'".format(
phone=str(phone))
cursor = get_db_connection()
cursor.execute(sql)
data = cursor.fetchall()
data = data[0]
name = data[0]
surname = data[1]
phone = data[2]
zipcode = data[3]
return True
except:
return False
def register_user():
global db
cursor = get_db_connection()
data = request
if data.form:
data = data.form
else:
data = data.get_json()
try:
name = data["first_name"]
surname = data["last_name"]
phone = data["phone"]
zipcode = data["zipcode"]
sql = f"INSERT INTO users (name, surname, phone, zipcode) VALUES (%s, %s, %s, %s)"
cursor.execute(sql, [name, surname, phone, zipcode])
db.commit()
return (''), 200
except:
return "error: couldn't register user", 400
def slash():
db_connection = get_db_connection()
if db_connection is not None:
db_connection.close()
return "hi its working"