Untitled

def show_section3(self):#TELA DE LISTA CLIENTES
        self.clear_content()

        frm = tk.Frame(self.content, bg='white', height=1280)
        frm.pack(padx=10, pady=10)

        columns = ("id", "cliente", "whatsapp", "debito", "a_vista", "chave_pix", "status", "data")
        tree = ttk.Treeview(frm, columns=columns, show='headings')

        for col in columns:
            tree.heading(col, text=col.capitalize())
            tree.column(col, width=80)

        tree.grid(row=0, column=0, sticky='w')

        vsb = ttk.Scrollbar(frm, orient="vertical", command=tree.yview)
        vsb.grid(row=0, column=1, sticky='ns')
        tree.configure(yscrollcommand=vsb.set)

        hsb = ttk.Scrollbar(frm, orient="horizontal", command=tree.xview)
        hsb.grid(row=1, column=0, sticky='ew')
        tree.configure(xscrollcommand=hsb.set)

        rows = execute_db_query('SELECT id, cliente, whatsapp, debito, a_vista, chave_pix, status, data FROM clientes')
        for row in rows:
            tree.insert("", "end", values=row)

        # Função para editar o cliente selecionado
        def editar_cliente():
            selected_item = tree.selection()
            if not selected_item:
                messagebox.showwarning("Seleção inválida", "Nenhum cliente selecionado.")
                return

            item = tree.item(selected_item[0])
            cliente_id = item['values'][0]
            cliente = item['values'][1]
            whatsapp = item['values'][2]
            debito = item['values'][3]
            a_vista = item['values'][4]
            chave_pix = item['values'][5]

            self.show_edit_form(cliente_id, cliente, whatsapp, debito, a_vista, chave_pix)

        ttk.Button(frm, text='Editar Cliente', command=editar_cliente).grid(column=0, row=2, sticky=W, padx=5, pady=5)
        ttk.Button(frm, text='Limpar Lista', command=remover_e_recriar_tabela).grid(column=0, row=2, sticky=W, padx=125, pady=5)
        ttk.Button(frm, text='Atualizar', command=self.show_section3).grid(column=0, row=2, sticky=W, padx=250, pady=5)
        ttk.Button(frm, text='Cobrar', command=lista_cli).grid(column=0, row=2, sticky=W, padx=375, pady=5)