def updateName(cod, name):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'update tblpizza set piz_name = ? where piz_cod = ?', (name, cod))
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def updateCity(cod, city):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'update tblcustomer set cus_city = ? where cus_cod = ?', (city, cod))
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def delete(cod):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'delete from tblcustomer where cus_cod = ?', (cod, ))
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def updateName(cod, name):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'update tblcustomer set cus_name = ? where cus_cod = ?', (name, cod))
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def updateCep(cod, cep):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'update tblcustomer set cus_cep = ? where cus_cod = ?', (cep, cod))
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def updateUf(cod, uf):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'update tblcustomer set cus_uf = ? where cus_cod = ?', (uf, cod))
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def updatePhone(cod, phone):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'update tblcustomer set cus_phone = ? where cus_cod = ?', (phone, cod))
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def updateType(cod, type):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'update tblpizza set piz_typecod = ? where piz_cod = ?', (type, cod))
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def updatePrice(cod, price):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'update tblpizza set piz_price = ? where piz_cod = ?', (price, cod))
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def updateComplement(cod, complement):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'update tblcustomer set cus_complement = ? where cus_cod = ?',
(complement, cod))
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def updateDistrict(cod, district):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'update tblcustomer set cus_district = ? where cus_cod = ?',
(district, cod))
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def deactivate(cod, date):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'update tblpizza set piz_inactivated = 1, piz_inactdate = ? where piz_cod = ?',
(date, cod))
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def updateIngredient(cod, ingredient):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'update tblpizza set piz_ingredients = ? where piz_cod = ?',
(ingredient, cod))
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def updateAddress(cod, address):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'update tblcustomer set cus_address = ? where cus_cod = ?',
(address, cod))
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def updateTotal(cod, total):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'update tblorder set ord_totalorder = ? where ord_cod = ?',
(total, cod))
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def deleteOrder(cod):
dict_connection = dbConnection()
dict_connection['cursor'].execute('delete from tblorder where ord_cod = ?',
[(cod)])
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def selectCountCustomer():
dict_connection = dbConnection()
dict_connection['cursor'].execute('select count(cus_cod) from tblcustomer')
countCustomer = dict_connection['cursor'].fetchone()
dict_connection['cursor'].close()
dict_connection['connection'].close()
return countCustomer
def selectAllCustomertInformation():
dict_connection = dbConnection()
dict_connection['cursor'].execute('select * from tblcustomer')
listAllClientInformation = dict_connection['cursor'].fetchall()
dict_connection['cursor'].close()
dict_connection['connection'].close()
return listAllClientInformation
def selectAllInformationTypePizza():
dict_connection = dbConnection()
dict_connection['cursor'].execute('select * from tblpizzatype')
listAllTypePizzaInformation = dict_connection['cursor'].fetchall()
dict_connection['cursor'].close()
dict_connection['connection'].close()
return listAllTypePizzaInformation
def save(data_client):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'insert into tblcustomer(cus_name, cus_address, cus_number, cus_complement, cus_district, cus_city, cus_uf, cus_cep, cus_phone, cus_cellphone) \
values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', data_client)
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def selectCountPizzas():
dict_connection = dbConnection()
dict_connection['cursor'].execute('select count(piz_cod) from tblpizza')
countPizzas = dict_connection['cursor'].fetchone()
dict_connection['cursor'].close()
dict_connection['connection'].close()
return countPizzas
def selectCountTypePizza():
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'select count(pit_cod) from tblpizzatype')
listAllTypePizzaInformation = dict_connection['cursor'].fetchone()
dict_connection['cursor'].close()
dict_connection['connection'].close()
return listAllTypePizzaInformation
def save(data_pizza):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'insert into tblpizza(piz_name, piz_ingredients, piz_price, piz_inactivated, piz_typecod) \
values(?, ?, ?, ?, ?)', data_pizza)
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def saveOrderItems(data_orderItens):
dict_connection = dbConnection()
dict_connection['cursor'].executemany(
'insert into tblorderitems(oit_ordercod, oit_pizzacod, oit_size, oit_uniprice, oit_totalprice) \
values(?, ?, ?, ?, ?)', data_orderItens)
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def saveOrder(codCustomer, date, time):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'insert into tblorder(ord_clicod, ord_date, ord_time) \
values(?, ?, ?)', (codCustomer, date, time))
dict_connection['connection'].commit()
dict_connection['cursor'].close()
dict_connection['connection'].close()
def selectCustomerByCod(cod):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'select * from tblcustomer where cus_cod = ?', (cod, ))
oneCustomer = dict_connection['cursor'].fetchone()
dict_connection['cursor'].close()
dict_connection['connection'].close()
return oneCustomer
def verifyTableItems():
dict_connection = dbConnection()
dict_connection['cursor'].execute(
"select name from sqlite_master where type='table' AND name='tblorderitems'"
)
nameTable = dict_connection['cursor'].fetchone()
dict_connection['cursor'].close()
dict_connection['connection'].close()
return nameTable
def selectCodOrder():
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'select ord_cod from tblorder order by ord_cod desc limit 1')
codOrder = dict_connection['cursor'].fetchone()
dict_connection['cursor'].close()
dict_connection['connection'].close()
return codOrder
def selectOrderCustomer(cod):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'select ord_clicod from tblorder where ord_clicod = ?', [(cod)])
orderCustomer = dict_connection['cursor'].fetchall()
dict_connection['cursor'].close()
dict_connection['connection'].close()
return orderCustomer
def searchClientByPhone(phoneClient):
dict_connection = dbConnection()
dict_connection['cursor'].execute(
'select * from tblcustomer where cus_phone like ? or cus_cellphone like ?',
('%' + phoneClient + '%', '%' + phoneClient + '%'))
oneClient = dict_connection['cursor'].fetchone()
dict_connection['cursor'].close()
dict_connection['connection'].close()
return oneClient
