def execute(self, sql=None):
"""
Execute a query and commit conn after
:param sql: query string
:return: None or Exception
"""
try:
cursor = self.conn.cursor()
cursor.execute(sql)
cursor.close()
self.conn.commit()
return None
except Exception as e:
Logger.exception(e)
return e
def query(self, sql=None):
"""
Execute a query and return data
:param sql: SQL query string
:return: array of tupples
"""
try:
cursor = self.conn.cursor()
cursor.execute(sql)
results = cursor.fetchall()
cursor.close()
return results
except Exception as e:
Logger.exception(e)
return e
def __init__(self,
host="172.0.0.1",
user="******",
password="******",
database="test"):
self.host = host
self.user = user
self.password = password
self.database = database
try:
self.conn = mysql.connector.connect(host=self.host,
user=self.user,
password=self.password,
database=self.database)
except Exception as e:
Logger.exception(e)
def __create_user__(self):
try:
raw_data = json.loads(self.data)
user = User(email=raw_data['email'], password=raw_data['password'])
user.create()
result = self.user_service.create_user(user=user)
if result is None:
raise HttpCreated(data=ResponseData(ex=None,
data={
'id': user.id,
'email': user.email
}))
elif isinstance(result, EmailExisted):
raise HttpFound(data=ResponseData(ex=result, data=None))
else:
raise HttpInternalError(
data=ResponseData(ex=result, data=None))
except Exception as e:
Logger.exception(e)
raise HttpBadRequest(data=ResponseData(ex=e, data=None))
