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))