def get_brand(brand_id: int):
row_number = cursor.execute('SELECT * FROM tb_fqs_brand WHERE id=%s', brand_id)
if row_number == 0:
return None
else:
row = cursor.fetchone()
return TB_FQS_Brand(row['id'], row['brand_name'])
def get_ingredient(ingredient_id: int):
row_number = cursor.execute('SELECT * FROM tb_fqs_ingredient WHERE id=%s', ingredient_id)
if row_number == 0:
return None
else:
row = cursor.fetchone()
return TB_FQS_Ingredient(row['id'], row['ingredient_name'], row['ingredient_info'])
def get_type(type_id: int):
row_number = cursor.execute('SELECT * FROM tb_fqs_type WHERE id=%s',
type_id)
if row_number == 0:
return None
else:
row = cursor.fetchone()
return TB_FQS_Type(row['id'], row['type_name'])
def get_types(type_name: str, page_entity: PageEntity):
if page_entity is None:
page_entity = PageEntity()
if type_name is None or len(type_name.strip()) == 0:
sql = 'SELECT * FROM tb_fqs_type {0} {1}'.format(
'' if len(page_entity.order_by.strip()) == 0 else 'ORDER BY ' +
page_entity.order_by,
'' if page_entity.page_size == 0 else 'LIMIT ' + str(
(page_entity.page_index - 1) * page_entity.page_size) + ',' +
str(page_entity.page_size))
row_number = cursor.execute(sql)
if row_number == 0:
return None
else:
result = []
for i in range(0, row_number):
row = cursor.fetchone()
temp = TB_FQS_Type(row['id'], row['type_name'])
result.append(temp)
cursor.execute('SELECT COUNT(0) AS number FROM tb_fqs_type')
page_entity.total_row = cursor.fetchone()['number']
if page_entity.page_size != 0:
page_entity.page_count = math.ceil(page_entity.total_row /
page_entity.page_size)
return result
else:
sql = "SELECT * FROM tb_fqs_type WHERE type_name LIKE %s {0} {1}".format(
'' if len(page_entity.order_by.strip()) == 0 else 'ORDER BY ' +
page_entity.order_by,
'' if page_entity.page_size == 0 else 'LIMIT ' + str(
(page_entity.page_index - 1) * page_entity.page_size) + ',' +
str(page_entity.page_size))
row_number = cursor.execute(sql, '%' + type_name + '%')
if row_number == 0:
return None
else:
result = []
for i in range(0, row_number):
row = cursor.fetchone()
temp = TB_FQS_Type(row['id'], row['type_name'])
result.append(temp)
cursor.execute('SELECT COUNT(0) AS number FROM tb_fqs_type')
page_entity.total_row = cursor.fetchone()['number']
if page_entity.page_size != 0:
page_entity.page_count = math.ceil(page_entity.total_row /
page_entity.page_size)
return result
def delete_type(type_id: int):
return cursor.execute('DELETE FROM tb_fqs_type WHERE id=%s', type_id)
def update_type(type_id: int, type_name: str):
return cursor.execute('UPDATE tb_fqs_type SET type_name=%s WHERE id=%s',
(type_name, type_id))
def insert_type(type_name: str):
return cursor.execute('INSERT INTO tb_fqs_type(`type_name`) VALUES(%s)',
type_name)
def delete_brand(brand_id: int):
return cursor.execute('DELETE FROM tb_fqs_brand WHERE id=%s', brand_id)
def update_brand(brand_id: int, brand_name: str):
return cursor.execute('UPDATE tb_fqs_brand SET brand_name=%s WHERE id=%s', (brand_name, brand_id))
def insert_brand(brand_name: str):
return cursor.execute('INSERT INTO tb_fqs_brand(`brand_name`) VALUES(%s)', brand_name)
def delete_ingredient(ingredient_id: int):
return cursor.execute('DELETE FROM tb_fqs_ingredient WHERE id=%s', ingredient_id)
def update_ingredient(ingredient_id: int, ingredient_name: str, ingredient_info: str):
return cursor.execute(
'UPDATE tb_fqs_ingredient SET ingredient_name=%s,ingredient_info=%s WHERE id=%s',
(ingredient_name, ingredient_info, ingredient_id)
)
def insert_ingredient(ingredient_name: str, ingredient_info: str):
return cursor.execute(
'INSERT INTO tb_fqs_ingredient(`ingredient_name`,`ingredient_info`) VALUES(%s,%s)',
(ingredient_name, ingredient_info)
)
