CODEWITHSUNDEEP
djangooperationalerror
Rokit
Rokit

Reputation: 1141

Django - no such table - custom sql

I don't understand why Django can access my table just fine when I use its built-in query functions, ie. Perk.objects.all(), but the moment I try to use custom sql, it says there is no such table.

def sql(self):
    queryset = Perk.objects.all() # works fine
    cursor = connection.cursor()
    cursor.execute("SELECT * FROM perk")  # Fails. No such table: perk.
    ...

Upvotes: 0

Views: 106

Answers (1)

Robert Moskal
Robert Moskal

Reputation: 22553

The default django naming convention for tables is "appname_classname". You can read about changing the defaults here:

Django table naming convention. Can I change its behavior?

Or look in the docs:

https://docs.djangoproject.com/en/1.9/ref/models/options/

And you might peek in your database to see what the table is actually called.

Upvotes: 2

Related Questions