Connecting and importing models from multiple database connections Django

Question

In a django app, I have two postgresql databases connected through settings.py: one is default and other is AppDb. AppDb is placed on a remote machine.

I want to query from a 'Courses' model from AppDb using 'using()' and 'Courses' model is not available in default database.

So my query goes like this:

courseInfo = Courses.objects.using('AppDb').filter(cuser_id = 12)

But I am getting NameError for 'Courses'

Can I have a solution for such queries without using routers

Make sure you have imported your model class first: `from .models import Courses`. — Burhan Khalid, Jul 18 '14 at 09:58
Is there a way to import models from an app which is on remote machine? — escapee, Jul 18 '14 at 11:39
What is the actual problem you are trying to solve? Your question is a bit odd. — Burhan Khalid, Jul 18 '14 at 12:08
I am trying to connect to remote database which is not default database of an app and querying using it. But models are not getting recognised. I i don't know how to import them — escapee, Jul 18 '14 at 12:21

score 0 · Answer 1 · answered Jul 18 '14 at 13:04

0

If you have an existing database, you still need to create an app and models for that database in order to use the ORM.

To help you create the model classes, you can use the inspectdb management command which will try to guess the models from an existing database and create the models.py for you. Its not perfect, but it will save you some time.

You will still have to make sure the models have a primary key and are written in the correct order (so that foreign keys will work correctly).

answered Jul 18 '14 at 13:04

Burhan Khalid

169,990
18
245
284

Thank you for adding answer. I tried some part of it and works out that I will use cursor.connection method. As creating models and app doesn't make sense for me without having data stored in it. – escapee Jul 21 '14 at 10:39

Connecting and importing models from multiple database connections Django

1 Answers1