python manage.py migrate_schemas about django-tenant-schemas HOT 6 CLOSED

You can not have a foreign key between a public and a tenant schema

2013/7/26 Toni Salaet Larrull [email protected]

Hi!

My settings :
SHARED_APPS=(
'tenant_schemas',
'South',
.
.
.
#now I add new app
'Tariff',
)
TENANT_APPS=(
'Core',# Core has a class with a attribute with foreingkey with newapp
'South',
)

When I perform :
$ python manage.py sync_schemas

the tenant schema that has name demo

=== Running syncdb for schema demo

Syncing...

Creating tables ...

Creating table Core_metering_element_data

Creating table Core_metering_element_tariff

DatabaseError: relation "Tariff_company_tariff" does not exist

Anybody knows why I can update my schemas?

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/54
.

Bernardo Pires Carneiro

from django-tenant-schemas.

Bernardo!

And how I can share the same data with tenants?

from django-tenant-schemas.

You put it on public. You just can't join tables between public and tenant

2013/7/26 Toni Salaet Larrull [email protected]

Bernardo!

And how I can share the same data with tenants?

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/54#issuecomment-21630740
.

Bernardo Pires Carneiro

from django-tenant-schemas.

Thanks Bernardo

Example Scenario:

Public apps:

Manufacturer ={item,price}

Tenant apps:

Item={Manufacturer[price],stock]

I need to add relation with Manufacturer that's common with all tenants to get some attributes and do a relation with
tenant Items.

Which is the best way to do this?

from django-tenant-schemas.

Sorry, that is not possible with a join. This is a limitation of this app,
but postgresql actually allows what you want to do (foreign key between
different schemas). The problem is that when syncing the tenant apps, the
public schema is not visible. At the same time, it is exactly the fact that
the public schema is not visible when syncing the tenants that allows
django-tenant-schema to work.

2013/7/26 Toni Salaet Larrull [email protected]

Thanks Bernardo

Example Scenario:

Public apps:

Manufacturer ={item,price}

Tenant apps:

Item={Manufacturer[price],stock]

I need to add relation with Manufacturer that's common with all tenants to
get some attributes and do a relation with tenant Items.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/54#issuecomment-21632086
.

Bernardo Pires Carneiro

from django-tenant-schemas.

OK bernardo!

thanks!

from django-tenant-schemas.