Django dynamic model fields

👻 Check our latest review to choose the best laptop for Machine Learning engineers and Deep learning tasks!

I"m working on a multi-tenanted application in which some users can define their own data fields (via the admin) to collect additional data in forms and report on the data. The latter bit makes JSONField not a great option, so instead I have the following solution:

class CustomDataField(models.Model):
    """
    Abstract specification for arbitrary data fields.
    Not used for holding data itself, but metadata about the fields.
    """
    site = models.ForeignKey(Site, default=settings.SITE_ID)
    name = models.CharField(max_length=64)

    class Meta:
        abstract = True

class CustomDataValue(models.Model):
    """
    Abstract specification for arbitrary data.
    """
    value = models.CharField(max_length=1024)

    class Meta:
        abstract = True

Note how CustomDataField has a ForeignKey to Site - each Site will have a different set of custom data fields, but use the same database. Then the various concrete data fields can be defined as:

class UserCustomDataField(CustomDataField):
    pass

class UserCustomDataValue(CustomDataValue):
    custom_field = models.ForeignKey(UserCustomDataField)
    user = models.ForeignKey(User, related_name="custom_data")

    class Meta:
        unique_together=(("user","custom_field"),)

This leads to the following use:

custom_field = UserCustomDataField.objects.create(name="zodiac", site=my_site) #probably created in the admin
user = User.objects.create(username="foo")
user_sign = UserCustomDataValue(custom_field=custom_field, user=user, data="Libra")
user.custom_data.add(user_sign) #actually, what does this even do?

But this feels very clunky, particularly with the need to manually create the related data and associate it with the concrete model. Is there a better approach?

Options that have been pre-emptively discarded:

• Custom SQL to modify tables on-the-fly. Partly because this won"t scale and partly because it"s too much of a hack.
• Schema-less solutions like NoSQL. I have nothing against them, but they"re still not a good fit. Ultimately this data is typed, and the possibility exists of using a third-party reporting application.
• JSONField, as listed above, as it"s not going to work well with queries.

👻 Read also: what is the best laptop for engineering students?

Django dynamic model fields __del__: Questions

import time
time.sleep(5)   # Delays for 5 seconds. You can also use a float value.

import time
while True:
    print("This prints once a minute.")
    time.sleep(60) # Delay for 1 minute (60 seconds).

from time import sleep
sleep(0.1) # Time in seconds

Django dynamic model fields __del__: Questions

We hope this article has helped you to resolve the problem. Apart from Django dynamic model fields, check other __del__-related topics.

Want to excel in Python? See our review of the best Python online courses 2023. If you are interested in Data Science, check also how to learn programming in R.

By the way, this material is also available in other languages:

• Italiano Django dynamic model fields
• Deutsch Django dynamic model fields
• Français Django dynamic model fields
• Español Django dynamic model fields
• Türk Django dynamic model fields
• Русский Django dynamic model fields
• Português Django dynamic model fields
• Polski Django dynamic model fields
• Nederlandse Django dynamic model fields
• 中文 Django dynamic model fields
• 한국어 Django dynamic model fields
• 日本語 Django dynamic model fields
• हिन्दी Django dynamic model fields