Python-сообщество

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.
        'NAME': '/var/www/working/db.sqlite3',                      # Or path to database file if using sqlite3.
        'USER': '',                      # Not used with sqlite3.
        'PASSWORD': '',                  # Not used with sqlite3.
        'HOST': '',                      # Set to empty string for localhost. Not used with sqlite3.
        'PORT': '',                      # Set to empty string for default. Not used with sqlite3.
    },
    'okato': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': '/var/www/testing/okato.sqlite3',
        'USER': '',
        'PASSWORD': '',
        'HOST': '',
        'PORT': '',
    }
}

./manage.py dbshell
.databases

0 main /var/www/working/db.sqlite3

./manage.py inspectdb > inspected_models.py

CREATE TABLE `class_okato` (
`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL ,
`name` VARCHAR(512)  NOT NULL ,
`code` VARCHAR(11)  NOT NULL ,
`control_number` SMALLINT  NOT NULL ,
`parent_id` INT  NULL DEFAULT NULL,
`parent_code` VARCHAR(11)  NULL DEFAULT NULL,
`node_count` SMALLINT  NOT NULL DEFAULT 0,
`additional_info` VARCHAR(128)  NULL DEFAULT NULL,
CONSTRAINT `class_okato_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES class_okato (`id`));

>>> # This will run on the 'other' database.
>>> Author.objects.using('okato').all()

./manage.py inspectdb --database=okato > inspected_models.py

from django.db import models
class ClassOkato(models.Model):
    id = models.IntegerField(primary_key=True)
    name = models.CharField(max_length=512)
    code = models.CharField(max_length=11)
    control_number = models.SmallIntegerField()
    parent_id = models.IntegerField(null=True, blank=True)
    parent_code = models.CharField(max_length=11, blank=True)
    node_count = models.SmallIntegerField()
    additional_info = models.CharField(max_length=128, blank=True)
    class Meta:
        db_table = u'class_okato'

CONSTRAINT `class_okato_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES class_okato (`id`));