multiple db in admin [how-to]

Hi guys,

Could you please advise in the following:

registry is the project, BGP is the app, default is the sqlite db, registry is a postgres db

the admin.py looks like this:

class MultiDBModelAdmin(admin.ModelAdmin):      # A handy constant for the name of the alternate database.      using = "registry"        def save_model(self, request, obj, form, change):          # Tell Django to save objects to the 'other' database.          obj.save(using=self.using)        def delete_model(self, request, obj):          # Tell Django to delete objects from the 'other' database          obj.delete(using=self.using)        def get_queryset(self, request):          # Tell Django to look for objects on the 'other' database.          return super(MultiDBModelAdmin, self).get_queryset(request).using(self.using)        def formfield_for_foreignkey(self, db_field, request, **kwargs):          # Tell Django to populate ForeignKey widgets using a query          # on the 'other' database.          return super(MultiDBModelAdmin, self).formfield_for_foreignkey(db_field, request, using=self.using, **kwargs)        def formfield_for_manytomany(self, db_field, request, **kwargs):          # Tell Django to populate ManyToMany widgets using a query          # on the 'other' database.          return super(MultiDBModelAdmin, self).formfield_for_manytomany(db_field, request, using=self.using, **kwargs)      class BGPcommunitiesAdmin(MultiDBModelAdmin):        list_display    = ("comm_name", "comm_value", "used_as", "label", "modified_on")      search_fields   = ("comm_name", "comm_value", "label")      list_filter     = ("used_as", "modified_on")      admin.site.register(BGPcommunities, BGPcommunitiesAdmin)    registryadmin = admin.AdminSite("registryadmin")  registryadmin.register(BGPcommunities, BGPcommunitiesAdmin)

and the urls.py looks like this:

from BGP.admin import registryadmin    urlpatterns = [      url(r'^admin/', admin.site.urls),      url(r'^registryadmin/', registryadmin.urls),  ]

The issue is that I cannot save any record in the database (the table is not found).

This can be fixed by tweaking /usr/lib/python2.7/site-packages/django/db/models/query.py:

def exists(self):      other_db = 'registry'      if self._result_cache is None:          try:              return self.query.has_results(using=self.db)          except:              return self.query.has_results(using=other_db)      return bool(self._result_cache)

The original version was:

def exists(self):      if self._result_cache is None:          return self.query.has_results(using=self.db)      return bool(self._result_cache)

Could you please advise who to solve this the proper way ? It seems that the connection tot he databases is not using the registry database, but the default one.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/750705f7-2e04-4ca8-9747-7552f2475c4b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.