cur.execute() syntax error

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: cur.execute() syntax error
Date: 2022-04-04 22:02:40
Message-ID: 9471b149-dd21-5040-3693-c6f54ddc3b36@appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

This MWE (test_combobox.py) produces a syntax error and I'm not seeing why:
-----
import tkinter as tk
from tkinter import ttk

import psycopg2

class ContactDataForm(tk.Frame):
# set up postgres
# the connection
con = psycopg2.connect(database='bustrac')
# the cursor
cur = con.cursor()

def __init__(self, parent, *args, **kwargs):
super().__init__(parent, *args, **kwargs)
# A dict to keep track of input widgets
self.inputs = {}

self.inputs['Contact Type'] = LabelInput(
ContactDataForm, 'contact_type',
# query to fetch data from contacttypes table
fetch_all = "SELECT * from contacttypes"
cur.execute(fetch_all)
# fetching all rows
rows = cur.fetchall()
input_class=ttk.Combobox([values = rows])
input_var=tk.StringVar()
# get selected value and bind it to a method
cont_type = self.get() # selected value by mouse click
con.close()
)
self.inputs['Contact Type'].grid(row0, column1)
ContactDataForm.grid(row=0, column=0, sticky='we')
-----

When run from the shell:
$ python test_combobox.py
File "test_combobox.py", line 24
cur.execute(fetch_all)
^
SyntaxError: invalid syntax

Here python is python3 by default.

What am I not seeing?

Rich

Responses

Browse psycopg by date

  From Date Subject
Next Message Christophe Pettus 2022-04-04 22:07:41 Re: cur.execute() syntax error
Previous Message Paolo De Stefani 2022-03-19 19:30:32 Re: Query with boolean parameter