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