Django Multi Table/Database queryset

Question

I have two Model

class User(models.Model)
    id = models.IntegerField(primary_key=True)
    username = models.CharField(max_length=20, unique=True)

class Blog(models.Model)
    id = models.BigIntegerField(primary_key=True)
    user_id = models.IntegerField()
    ...

Because User in db User, and Blog in db Blog_1, Blog_2...Blog8, so without ForeignKey

In bloglist views, I want to show blogs with username. How do it with one query? or must have multi queryset? Blog.objects.all() get the user_id, and query every username by user_id ?

And bloglist views show the blogs from the user following, I have a blogid list, but blogs from multi db, so:

for id in blogid_list
    Blog.objects.get(pk=id).using('Blog_%d' % (id % 8))

How combine in one list? I think the code is inefficient, any Suggestions?

Thomas Schwärzl · Accepted Answer · 2012-11-25 07:54:35Z

2

You need to get the user_id as an integer and then query your blog-database in a second step.

Django does not support cross-database relationships. See the docs here

answered Nov 25, 2012 at 7:54

Thomas Schwärzl

9,9576 gold badges49 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Django Multi Table/Database queryset

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related