How to create tables in multiple databases using Django models.py

Question

I would like to create table "A" in one database (assume in SQL Server 2008) and another table in "B" (My SQL) using models.py through Django.

Both the tables structures "A" and "B" may differ. I have verified that through router.py can achieve this.

I want to do it without "router.py" file.

Could anyone guide me on this please.

Thanks, Shiva.

Why do you want to do it without a router file? – Steve Jalim Sep 01 '12 at 12:11 — Steve Jalim, Sep 01 '12 at 12:11

Zulu · Accepted Answer · 2012-09-03T10:40:11.403

0

Try to use super in save() method.
When you save, it will launch others commands like write in other database.

For example :

You have :

class Chair(models.Model) :
  name = models.Charfield(max_length=30)

You can implement save() def like that :

class Chair(models.Model) :
  name = models.Charfield(max_length=30)

  def save(self, *args, **kwargs):
    <your cmd here>
    super(Chair, self).save(*args, **kwargs)

It could seems impossible like that, but you can use arguments for make anything you want.

edited Sep 03 '12 at 10:40

answered Sep 01 '12 at 17:55

Zulu

8,765
9
49
56

Dear Zulu,can you please explain me in detail with an example – shiva Sep 03 '12 at 04:46

How to create tables in multiple databases using Django models.py

1 Answers1