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