def update_user(cls, email, user_info):
result = None
user_info.pop("override", None)
try:
sql, args = data_adaptor.create_update(table_name="e6156.users",
new_values=user_info,
template={"email": email})
# sql, args = data_adaptor.create_insert(table_name="users", row=user_info)
res, data = data_adaptor.run_q(sql, args)
if res != 1:
result = None
else:
result = user_info['id']
except pymysql.err.IntegrityError as ie:
if ie.args[0] == 1062:
raise (DataException(DataException.duplicate_key))
else:
raise DataException()
except Exception as e:
raise DataException()
return result
def update_profile_entry(cls, profile_entry):
required = {
"userid", "element_type", "element_subtype", "element_value",
"profileid"
}
cleaned_info = {key: profile_entry[key] for key in required}
result = None
try:
sql, args = data_adaptor.create_update(
"profiles", cleaned_info,
{"element_value": profile_entry["old_element_value"]})
res, data = data_adaptor.run_q(sql, args)
if res != 1:
result = None
else:
result = "Updated successfully"
except pymysql.err.IntegrityError as ie:
if ie.args[0] == 1062:
raise (DataException(DataException.duplicate_key))
else:
raise DataException()
except Exception as e:
raise DataException()
return result
def update_user(cls, email, new_values):
result = None
# this makes sure we don't update a value marked as 'DELETED'. get_by_email()
user_info = UsersRDB.get_by_email(email)
if not user_info:
return "No such user exists, homie."
try:
sql, args = data_adaptor.create_update(table_name="users",
new_values=new_values,
template={"email": email})
res, data = data_adaptor.run_q(sql, args)
if res != 1:
result = None
else:
result = user_info['id']
except pymysql.err.IntegrityError as ie:
if ie.args[0] == 1062:
raise (DataException(DataException.duplicate_key))
else:
raise DataException()
except Exception as e:
raise DataException()
return result
def update_user(cls, email, data):
try:
template = {"email": email}
sql, args = data_adaptor.create_update("ebdb.users", data,
template)
data_adaptor.run_q(sql=sql, args=args, fetch=True)
return "Resource updated successfully"
except Exception as e:
print(e)
return None
def update_profile(cls, data, uuid, stype, maintype):
try:
template = {"user_id": uuid, "subtype": stype, "type": maintype}
sql, args = data_adaptor.create_update("ebdb.profile", data,
template)
data_adaptor.run_q(sql=sql, args=args, fetch=True)
return "Resource updated successfully"
except Exception as e:
print(e)
return None
def update_profile(cls, param_profile, update_template, data):
result = None
conn = None
cursor = None
try:
conn = data_adaptor._get_default_connection()
cursor = conn.cursor()
# a wrapper function helps to pass params
def run_q(sql_, args_):
return data_adaptor.run_q(sql_,
args_,
cur=cursor,
conn=conn,
commit=False)
sql, args = data_adaptor.create_select(
table_name="profile_entries", template=update_template)
_, prev_data = run_q(sql, args)
if prev_data is not None and len(prev_data) > 0:
sql, args = data_adaptor.create_update(
table_name="profile_entries",
new_values=data,
template=update_template)
res, _ = run_q(sql, args)
if res != 1:
raise Exception('cannot update data!')
else:
# get new Etag
new_data = prev_data[0]
for k, v in data.items():
new_data[k] = v
result = new_data['profile_entry_id']
conn.commit()
else:
raise Exception('cannot retrieve data')
except Exception as e:
# rollback
conn.rollback()
raise e
finally:
# closing database connection.
if cursor:
cursor.close()
if conn:
conn.close()
return result
def update_user(cls, user_info, email):
sql, arg = data_adaptor.create_update(table_name="users",
new_values=user_info,
template={'email': email})
res, data = data_adaptor.run_q(sql=sql, args=arg, fetch=True)
if res:
res = "Successful update"
else:
res = "Failed"
return res
def delete_user(cls,user_info):
try:
sql, args = data_adaptor.create_update(table_name="users",new_values={"status":"deleted"},template=user_info)
res, data = data_adaptor.run_q(sql, args)
except pymysql.err.IntegrityError as ie:
if ie.args[0] == 1062:
raise (DataException(DataException.duplicate_key))
else:
raise DataException()
except Exception as e:
raise DataException()
return res
def update_by_email(cls, new_values, email):
try:
sql, args = data_adaptor.create_update(table_name="users",new_values=new_values,template={"email":email})
res, data = data_adaptor.run_q(sql, args)
except pymysql.err.IntegrityError as ie:
if ie.args[0] == 1062:
raise (DataException(DataException.duplicate_key))
else:
raise DataException()
except Exception as e:
raise DataException()
return res
def update_user(cls, user_info, template):
try:
sql, args = data_adaptor.create_update(table_name="users",
new_values=user_info,
template=template)
res, data = data_adaptor.run_q(sql, args)
if res != 1:
result = None
else:
result = res
except Exception as exp:
raise DataException()
return result
def update_user(cls, user_info, template):
result = None
try:
sql, args = data_adaptor.create_update(table_name="e6156.users", new_values = user_info, template = template)
res, data = data_adaptor.run_q(sql, args)
if res != 1:
result = None
else:
result = user_info
except pymysql.err.IntegrityError as ie:
if ie.args[0] == 1062:
raise (DataException(DataException.duplicate_key))
else:
raise DataException()
except Exception as e:
raise DataException()
return result
def delete_user(cls, email):
# try:
# sql = "delete from ebdb.users where email=%s"
# data_adaptor.run_q(sql=sql, args=(email), fetch=False)
# return "User deleted successfully"
# except Exception as e:
# print(e)
# return None
try:
template = {"email": email}
data = {"status": "DELETED"}
sql, args = data_adaptor.create_update("ebdb.users", data,
template)
data_adaptor.run_q(sql=sql, args=args, fetch=True)
return "Resource updated successfully"
except Exception as e:
print(e)
return None
def update_profile_entry(cls, profile_entry_id, body):
result = None
try:
sql, args = data_adaptor.create_update(
table_name="e6156.profile_entries",
new_values=body,
template={"profile_entry_id": profile_entry_id})
# sql, args = data_adaptor.create_insert(table_name="users", row=user_info)
res, data = data_adaptor.run_q(sql, args)
result = profile_entry_id
except pymysql.err.IntegrityError as ie:
if ie.args[0] == 1062:
raise (DataException(DataException.duplicate_key))
else:
raise DataException()
except Exception as e:
raise DataException()
return result
def update_user(cls, email, data):
result = None
try:
sql, args = data_adaptor.create_update(table_name="baseball.users",
new_values=data,
template={"email": email})
res, data = data_adaptor.run_q(sql, args)
if data is not None and len(data) > 0:
result = data[0]
else:
result = None
except pymysql.err.IntegrityError as ie:
if ie.args[0] == 1062:
raise (DataException(DataException.duplicate_key))
else:
raise DataException()
except Exception as e:
raise DataException()
return result
def update_user(cls, user_info):
result = None
try:
sql, args = data_adaptor.create_update(
"users", user_info, {"email": user_info['email']})
res, data = data_adaptor.run_q(sql, args)
if res != 1:
result = None
else:
result = "Updated successfully"
except pymysql.err.IntegrityError as ie:
if ie.args[0] == 1062:
raise (DataException(DataException.duplicate_key))
else:
raise DataException()
except Exception as e:
raise DataException()
return result
def delete_user(cls, user_info):
result = None
try:
sql, args = data_adaptor.create_update(
table_name="users",
new_values={"status": "DELETED"},
template={"email": user_info["email"]})
res, data = data_adaptor.run_q(sql, args)
if data is not None and len(data) > 0:
result = data[0]
else:
result = None
except pymysql.err.IntegrityError as ie:
if ie.args[0] == 1062:
raise (DataException(DataException.duplicate_key))
else:
raise DataException()
except Exception as e:
raise DataException()
return result
def update_profile(cls, profileid, data):
result = None
try:
sql, args = data_adaptor.create_update(table_name="baseball.profile",\
new_values=data, \
template={"profileid":profileid})
res, data = data_adaptor.run_q(sql, args)
if data is not None and len(data) > 0:
result = data[0]
else:
result = None
except pymysql.err.IntegrityError as ie:
if ie.args[0] == 1062:
raise (DataException(DataException.duplicate_key))
else:
raise DataException()
except Exception as e:
raise DataException()
return result