Overriding Django Admin get_queryset with raw() results in DatabaseError

Question

To speed up my admin page, I've decided to override my get_queryset() with a raw query however it results in:

Database error: Something’s wrong with your database installation. Make sure the appropriate database tables have been created, and make sure the database is readable by the appropriate user.

Is there some step I'm missing?. I've already confirmed that the query works in PSQL so I don't see what's going wrong. I've tried cutting it down to just the following but it still errors out.

def get_queryset(self, request):
    return MyObject.objects.raw('SELECT * FROM myapp_myobject')

The problem is actually saying what exact happened - your table name is `clients_orderticket` where you're trying to fetch records from `myapp_myobject`. — Charnel, Mar 24 '20 at 08:06
Nono, I only used `MyObject` and `myapp_myobject` to explain the problem but my actual query uses the correct names — Lorenzo Ang, Mar 24 '20 at 08:08
Ok, is that possible actuall table name have mixed-case lettering? — Charnel, Mar 24 '20 at 08:13
As I mentioned previously, the query is correct. I can run it perfectly fine through PgAdmin and running `print(queryset[0])` is okay but returning it through `get_queryset()` is not — Lorenzo Ang, Mar 24 '20 at 08:17
Ah sorry, now I realized what's wrong - I'll post this in answer. — Charnel, Mar 24 '20 at 08:24

score 2 · Accepted Answer · answered Mar 24 '20 at 08:30

The problem is that raw return not a QuerySet instance but a RawQuerySet that do have iterator protocol and representation implemented but doesn't have a bunch of other methods used by Django views under the hood.

I advice to use extra instead or simply select ID column only from your raw query and then hit another one like MyObject.objects.filter(id__in=your_ids_list_from_raw)

Overriding Django Admin get_queryset with raw() results in DatabaseError

1 Answers1

Linked