def show_clientes(self): _c = Cliente() _cBO = ClienteBO() print 'Pesquisar por: Codigo(c); Nome(n); Status(1,2,3); Geral(a)' resp = str(raw_input(': ')) if resp is 'c': while 1: try: _c.codigo = int(raw_input('Codigo: ')) break except: print 'Use somente numeros inteiros' cc = _cBO.cod_select(_c.codigo) print cc.codigo, cc.nome elif resp is 'a': _cBO.select() elif resp is 'n': nome = str(raw_input('nome: ')) _cBO.name_select(nome) elif resp is 's': while 1: try: _c.status = int(raw_input('status: ')) break except: print 'Use somente numeros inteiros' _cBO.status_select(_c.status) else: print 'problemas'
def cod_select(self, codigo): c = Cliente() self.conexao.cursor.execute("select * from pessoa where pes_codigo='" + str(codigo) + "'") for row in self.conexao.cursor: c.codigo = row[0] c.nome = row[1] c.email = row[2] c.site = row[3] c.telefone = row[4] c.celular = row[5] c.cpf = row[6] c.rg = row[7] c.aniversario = row[8] c.data_cadastro = row[9] return c