def create_user(cls, user_info):
result = None
try:
sql, args = data_adaptor.create_insert(table_name="users",
row=user_info)
res, data = data_adaptor.run_q(sql, args)
msg = {"customers_email": user_info['email']}
notification.publish_it(msg)
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 create_profile_entry(cls, entry_info):
required = {
"userid", "element_type", "element_subtype", "element_value",
"profileid"
}
entry_info = {key: entry_info[key] for key in required}
result = None
try:
sql, args = data_adaptor.create_insert(table_name="profiles",
row=entry_info)
res, data = data_adaptor.run_q(sql, args)
if res != 1:
result = None
else:
result = "Profile Entry Created"
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 create_user(cls, user_info):
result = None
try:
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['email']
except pymysql.err.IntegrityError as ie:
print(ie)
if ie.args[0] == 1062:
raise (DataException(DataException.duplicate_key))
else:
raise DataException()
except Exception as e:
log_msg = "DataObjectCreate_user: Exception = " + str(e)
print(log_msg)
raise DataException()
return result
def registrations():
status = "PENDING"
id = str(uuid4())
last_name = request.json.get("last_name")
first_name = request.json.get("first_name")
email = request.json.get("email")
password = request.json.get("password")
new_usr = {
"last_name": last_name,
"first_name": first_name,
"id": id,
"email": email,
"status": status,
"password": password
}
try:
sql, args = data_adaptor.create_insert(table_name="users", row=new_usr)
res, data = data_adaptor.run_q(sql, args)
message = {"result": res, "data": data}
response = Response(json.dumps(message),
status=200,
content_type="application/json")
return response
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()
def create_profile(cls, profile_info, commit=False):
result = None
try:
for el in profile_info['entries']:
el['userid'] = profile_info['userid']
el['profileid'] = profile_info['profileid']
#res = cls.create_profile_element(el, commit=False, conn=conn, cur=cur)
sql, args = data_adaptor.create_insert(table_name="profile",
row=el)
res, data = data_adaptor.run_q(sql, args)
if res != 1:
result = None
else:
result = profile_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 create_post(cls, content):
try:
sql, args = data_adaptor.create_insert(table_name="posts",
row=content)
res, data = data_adaptor.run_q(sql, args)
except Exception as e:
raise DataException()
return res
def create_profile_or_update(cls, profile_info):
try:
sql, args = data_adaptor.create_insert(table_name="profile", row=profile_info)
sql += ' on duplicate key update element_value = values(element_value)'
res, data = data_adaptor.run_q(sql, args)
result = profile_info['uid']
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 create_comment(cls, content):
try:
sql, args = data_adaptor.create_insert(table_name="comments",
row=content)
res, data = data_adaptor.run_q(sql, args)
if res != 1:
result = json.dumps([])
else:
result = json.dumps(data,
indent=4,
sort_keys=True,
default=str)
except Exception as exp:
raise DataException()
return result
def create_user(cls, user_info):
try:
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 exp:
raise DataException()
return result
def create_profile_entry(cls, entries):
result = None
try:
sql, args = data_adaptor.create_insert(
table_name="profile_entries", row=entries)
res, data = data_adaptor.run_q(sql, args)
if res != 1:
result = None
else:
result = entries['user_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 insert(cls, data):
t_info = cls._get_table_info()
t_name = t_info['table_name']
q, args = da.create_insert(t_name, data)
res, data = da.run_q(q,args)
return res