Needs Django support

[adityaprakashgupta]

Always showing "django.db.utils.ProgrammingError: tenant_id needs to be included in primary key and unique constraints defined on a tenant-aware table" while running django default migrations.

[gwenshap]

Agree, we need Django support! We are looking into this. As you noticed, Nile requires tenant_id to be part of the primary key in all "tenant aware" tables (this is how we distribute the data into virtual databases).
Django doesn't have great support for multi-column (composite) primary keys, but it does have support for multi-column unique keys by using the Meta inner class in your model.

Something like this:

class MyTable(models.Model):
    class Meta:
        UniqueConstraint(fields = ['id', 'tenant_id'], name = 'mytable_id_unique')

    id = models.UUIDField(primary_key=True, default=uuid7)
    tenant_id = models.UUIDField()

We'll have a more complete template in a few days, but I hope this helps unblock you.

[gwenshap]

Agree.
I believe those should be shared tables - sessions and auth is usually related to users (also a shared table) and don't have a tenant_id column. Because of this, primary key should not be an issue for these models.

[adityaprakashgupta]

In django all models have a default Id field with primary key constant. So, doesn't allow to migrate into Nile, above error occurred when running django default migrations still I have not created any of my own model.

[gwenshap]

After some testing, you are right. Nile currently does not work with Django. The issue isn't even the models themselves, the error "django.db.utils.ProgrammingError: tenant_id needs to be included in primary key and unique constraints defined on a tenant-aware table" is encountered while Django is creating its own migrations table ("django_content_type"). Of course without the migrations tables, migrations can't run - regardless of their contents.

We are actively working on resolving this.

[adityaprakashgupta]

Kindly resolve it soon, wating for Django X Nile

[Sanni-Damilola]

can someone help me with this
how can i use the handle404Route in pratice/myapp/views
https://github.com/Sanni-Damilola/Django_start

[Sanni-Damilola]

can someone help me with this
how can i use the handle404Route in pratice/myapp/views
https://github.com/Sanni-Damilola/Django_start

[adityaprakashgupta]

You have to set handler404 = path.to.your.view to your root URLconf file.
You may refer to this guild handler404

[Sanni-Damilola]

@adityaprakashgupta
Would you mind creating a branch and adding it for me?
Am a beginner

[adityaprakashgupta]

done