sql – python syntax error making view and selecting data

hi and hope you have a good time , i was making an app in python and SQL and i’m getting a syntax error in SQL , can you help?

self.mycursor.execute(f'''CREATE VIEW [usable products] AS
            SELECT * FROM products
            WHERE {str(self.counts.value())}> (SELECT count FROM products)
            ''')

and the error is :

ight syntax to use near '[usable products] AS
            SELECT * FROM products
            WHER' at line 1

version for the right syntax to use near '[usable products] AS
            SELECT * FROM products
            WHER' at line 1

thank you!

Contents hide

Answers:

Method 1

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

Consider parameterizing your query and avoiding F-string interpolation. Also, the subquery is not necessary if count (not mistaken for COUNT() aggregate) is a column in products table.

Below assumes you are using pyodbc or sqlite3 which use qmarks, ?, for parameter placeholders. If using other DB-APIs (psycopg2, pymysql, etc.) use %s placeholder.

sql = (
    "CREATE VIEW [usable products] AS "
    "   SELECT * FROM products "
    "   WHERE count < ?"
)

self.mycursor.execute(sql, [self.counts.value()])

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes

Article Rating