def post(self): try: conn = mysql.connect() cursor = conn.cursor() _json = request.json _client_name = _json['client_name'] _client_status = _json['client_status'] _mobile_phone = _json['mobile_phone'] _email_address = _json['email_address'] _city = _json['city'] if not isinstance(conn, str): query = "INSERT INTO client(client_name, client_status, mobile_phone, email_address, city) VALUES(%s, %s, %s, %s, %s)" bindData = (_client_name, _client_status, _mobile_phone, _email_address, _city) cursor = conn.cursor() cursor.execute(query, bindData) conn.commit() close_connection(conn, cursor) return api_success(None, "Client saved successfully") else: return api_failure(str(conn)) except Exception as error: return api_failure(str(error))
def put(self): try: conn = mysql.connect() cursor = conn.cursor() _json = request.json _client_id = _json['client_id'] _client_name = _json['client_name'] _client_status = _json['client_status'] _mobile_phone = _json['mobile_phone'] _email_address = _json['email_address'] _city = _json['city'] cursor.execute("SELECT count(*) FROM client WHERE client_id=%s", (_client_id, )) check_record_exist = cursor.fetchone().get('count(*)') if check_record_exist: if not isinstance(conn, str): query = "UPDATE client set client_name=%s, client_status=%s, mobile_phone=%s, email_address=%s, city=%s where client_id = %s" bindData = (_client_name, _client_status, _mobile_phone, _email_address, _city, _client_id) cursor = conn.cursor() cursor.execute(query, bindData) conn.commit() close_connection(conn, cursor) return api_success(None, "Client updated successfully") else: return api_failure(str(conn)) else: return {"message": "Record not found"}, 404 except Exception as error: return api_failure(str(error))
def post(self, *args, **kwargs): _json = request.json _username = _json.get('username', None) _password = _json.get('password', None) try: conn = mysql.connect() cursor = conn.cursor() cursor.execute("SELECT id, username, password FROM user") db_users = cursor.fetchall() username_table = {u.get('username', None): u for u in db_users} userid_table = {u.get('id', None): u for u in db_users} user = username_table.get(_username, None) if user and safe_str_cmp(user.get('password'), _password): access_token = create_access_token( identity=user.get('username'), fresh=True) refresh_token = create_refresh_token( identity=user.get('username')) return { "access_token": access_token, "refresh_token": refresh_token }, 200 return {"message": "Invalid Credentials!"}, 401 except Exception as e: return {"message": str(e)}, 400
def get(self): try: conn = mysql.connect() cursor = conn.cursor() client_id = int(request.headers.get('client_id')) cursor.execute("SELECT count(*) FROM client WHERE client_id=%s", (client_id, )) check_record_exist = cursor.fetchone().get('count(*)') if check_record_exist: if not isinstance(conn, str): query = "SELECT client_id, client_name, client_status, mobile_phone, email_address, city FROM client \ WHERE client_id = {client_id}".format( client_id=client_id) cursor.execute(query) clientRow = cursor.fetchone() close_connection(conn, cursor) return api_success(clientRow, "Client details fetched successfully") else: return api_failure(str(conn)) else: return {"message": "Record not found"}, 404 except Exception as error: return api_failure(str(error))
def put(self): try: conn = mysql.connect() cursor = conn.cursor() _json = request.json _product_id = _json['product_id'] _product_name = _json['product_name'] _product_status = _json['product_status'] cursor.execute("SELECT count(*) FROM product WHERE product_id=%s", (_product_id,)) check_record_exist = cursor.fetchone().get('count(*)') if check_record_exist: if not isinstance(conn, str): query = "UPDATE product set product_name=%s, product_status=%s where product_id = %s" bindData = (_product_name, _product_status, _product_id) cursor.execute(query, bindData) conn.commit() close_connection(conn, cursor) return api_success(None, "Product updated successfully") else: return api_failure(str(conn)) else: return { "message": "Record not found" }, 404 except Exception as error: return api_failure(str(error))
def get(self): try: conn = mysql.connect() cursor = conn.cursor() if not isinstance(conn, str): cursor.execute("SELECT product_id, product_name, product_status FROM product") productRows = cursor.fetchall() close_connection(conn, cursor) return api_success(productRows, "Products lists fetched successfully") else: return api_failure(str(conn)) except Exception as error: return api_failure(str(error))
def get(self): try: conn = mysql.connect() cursor = conn.cursor() if not isinstance(conn, str): cursor.execute("SELECT client_id, client_name, mobile_phone, email_address, city FROM client") clientRows = cursor.fetchall() close_connection(conn, cursor) return api_success(clientRows, "Clients lists fetched successfully") else: return api_failure(str(conn)) except Exception as error: return api_failure(str(error))
def post(self): try: conn = mysql.connect() cursor = conn.cursor() _json = request.json _product_name = _json['product_name'] _product_status = _json['product_status'] if not isinstance(conn, str): query = "INSERT INTO product(product_name, product_status) VALUES(%s, %s)" bindData = (_product_name, _product_status) cursor = conn.cursor() cursor.execute(query, bindData) conn.commit() close_connection(conn, cursor) return api_success(None, "Product saved successfully") else: return api_failure(str(conn)) except Exception as error: return api_failure(str(error))
def delete(self): try: conn = mysql.connect() cursor = conn.cursor() _product_id = int(request.headers.get('product_id')) cursor.execute("SELECT count(*) FROM product WHERE product_id=%s", (_product_id,)) check_record_exist = cursor.fetchone().get('count(*)') if check_record_exist: if not isinstance(conn, str): query = "DELETE FROM product WHERE product_id =%s" bindData = (_product_id, ) cursor.execute(query, bindData) conn.commit() close_connection(conn, cursor) return api_success(None, "Products deleted successfully") else: return api_failure(str(conn)) else: return { "message": "Record not found" }, 404 except Exception as error: return api_failure(str(error))
def get(self): try: conn = mysql.connect() cursor = conn.cursor() product_id = int(request.headers.get('product_id')) cursor.execute("SELECT count(*) FROM product WHERE product_id=%s", (product_id,)) check_record_exist = cursor.fetchone().get('count(*)') if check_record_exist: if not isinstance(conn, str): query = "SELECT product_id, product_name, product_status FROM product \ WHERE product_id = {product_id}".format(product_id = product_id) cursor.execute(query) productRow = cursor.fetchone() close_connection(conn, cursor) return api_success(productRow, "Products details fetched successfully") else: return api_failure(str(conn)) else: return { "message": "Record not found" }, 404 except Exception as error: return api_failure(str(error))