I'm trying to make a (Django) query to my database using the following syntax:
Derp.objects.all()
I have a production database and a default (development) database. So obviously, by default, that query above will use the default database.
I'm having trouble figuring out how to select my other database. A coworker suggested the following:
Derp.objects.all(using="development")
But that returns a TypeError:
all() got an unexpected keyword argument 'using'
Can someone tell me what the proper syntax is? I can't seem to find what parameters the all() method will actually accept.
Martin Thurau
7,6847 gold badges46 silver badges80 bronze badges
asked Dec 27, 2011 at 18:39
tnw
13.9k15 gold badges73 silver badges114 bronze badges
-
The syntax and wording look like you are using the Django ORM. If so it would be helpful to know what version.Mark Lavin– Mark Lavin2011年12月27日 18:45:14 +00:00Commented Dec 27, 2011 at 18:45
-
@MarkLavin django.VERSION prints (1, 3, 0, 'final', 0)tnw– tnw2011年12月27日 18:52:15 +00:00Commented Dec 27, 2011 at 18:52
1 Answer 1
Your syntax is slightly off:
Derp.objects.using('production').all()
Obviously, the 'production' key needs to match whatever you've labeled your DB in settings.py.
answered Dec 27, 2011 at 18:52
Jordan
32.7k6 gold badges59 silver badges67 bronze badges
Sign up to request clarification or add additional context in comments.
1 Comment
Jordan
Also, the database type (PostgreSQL) itself should be irrelevant since you're connecting through ORM.
default