CORD : Modeling Conventions

This page outlines our modeling conventions and how they map onto Django.

Modeling Basics

We first establish Django terminology, and how it relates to common object-related terminology. An Object Class is called a Model in Django. A Django Model consists of a set of Fields (equivalent to saying an Object Class is defined by a set of Attributes). Each Django Field has a Type and each Type has a set of Attributes. Some of these Attributes are core (common across all Types) and some are Type-specific. Relationships between Models are expressed by Fields with one of a set of distinguished relationship-oriented Types (e.g, OneToOneField). Finally, an Object is an instance (instantiation of) a Model, where each Object has a unique primary key (or more precisely, a primary index into the table that implements the Model). By convention, that index/key should be the Django AutoField id which is automatically created for any Model that has not identified a separate unique primary key. The Django default primary key is always “id” for system level tables, and “pk” for model tables.

Naming Conventions

Model names should use CamelCase without underscore. Model names should always be singular, never plural. For example: Slice, Network, NetworkTemplate.

Sometimes a model is used as a through relation to relate two other models, and should be named after the two models that it relates. For example, a model that relates the Controller and User models should be called ControllerUser.

Field names use lower case with underscores separating names. Examples of valid field names are: name, disk_formatcontroller_format.

Field Types

There are various built in Fields that may be specified at Class declaration. The basic field types commonly in use with XOS:

FieldTypeWhy to Use It?
BooleanFieldDisplays as a checkbox in GUI; limits input to valid possibilities. If None is a valid option, please use NullBooleanField which uses default widget of choice: None, Yes, No.
CharFieldAllows for String representation, additional required attributes are “max_length”. This should be used for small to large size strings. For mulitiple sentences, use TextField.
DateTimeFieldSpecial field that maps to python DateTime. May set optional attributes of auto_now (update field each time it is saved), auto_add_now(update field when created only)
EmailFieldAutomatically checks for well formed Emails based on RFC3696/5321. Note that for full compliance we need to set the length to 254; default is 75. [This is a bug in our model.]
FloatFieldUsed to represent a real number; default widget is TextInput.
IntegerFieldUsed to represent Integer values; default widget is TextInput. [We should review whether the IntegerFields should be changed to be PositiveIntegers, or PositiveSmalls accordingly.]
GenericIPAddressFieldAble to validate IPv4 and IPv6 flavors of addresses; default widget is TextInput.
URLFieldVerifies well formed URL, max_length is defaulted to 200. GUI convenience is that the value of the field is displayed as a clickable link above the input widget.
SlugFieldUsed to represent a short label for something containing only letters, numbers, underscores or hyphens. This should be used for the name of Tags so that there is a better chance of promoting the Tag to be an actual field attribute once the model has been solidified.

Core Field Attributes

List of Field level optional attributes currently in use:

AttributeEffect
verbose_name=”…”Provides a label to be used in the GUI display for this field. Differs from the field name itself, which is used to create the column in the database table.
verbose_name_plural=”…”Way to override the verbose name for this field.
help_text=”…”Provides some context-based help for the field; will show up in the GUI display.
default=…Allows a predefined default value to be specified.
choices=CHOICE_LISTAn interable (list or tuple). Allows the field to be filled in from an enumerated choice. For example, ROLE_CHOICES = ((‘admin’, ‘Admin’), (‘pi’, ‘Principle Investigator’), (‘user’,’User’))
unique=TrueRequires that the field be unique across all entries.
blank=TrueAllows the field to be present but empty.
null=TrueAllows the field to have a value of null if the field is blank.
editable=FalseIf you would like to make this a readOnly field to the user.

List of Field level optional attributes we should not use, or use judiciously:

AttributeWhy
primary_keySome of the plugins we use, particularly in the REST area, do not do well with CharField’s as the primary key. In general, it is best to use the system primary key instead, and put a db_index=True, unique=True on the CharField you would have used.
db_column, db_tablespaceConvention is to use the Field name as the db column, and use verbose_name if you want to change the display. For tablespace, all models should be defined within the application they are specified in – overwriting the tablespace will make it more challenging for the next developer to find and fix any issues that might arise.

List of Field level optional attributes we will likely need/want to use:

AttributeEffect
db_index=TrueAllows for quicker queries if you are going to order by, or filter by, the specified field.
error_messages={…}Pass in a dictionary of error keys, and the message you want to display if the error occurs. For example: null, blank, invalid, invalid_choice, and unique. Other error messages may be present per FieldType.
validators=[…]Allows a list of validators to be run before committing the value of this field to the model (https://docs.djangoproject.com/en/dev/ref/validators/).

Expressing Relationships

There are a few different types of Relationship based fields offered in Django.

FieldTypeWhen to Use it
ForeignKeyFieldUsed to represent a 1-to-Many relationship. For example: Instance’s may have 1 and only 1 Node; Node’s may have 0 or more Instances. Can also be used to represent recursive relationships for the same object types by providing “self” as the relationship (first position) parameter.
ManyToManyFieldUsed to represent an N-to-N relationship. For example: Deployments may have 0 or more Sites; Sites may have 0 or more Deployments.
OneToOneFieldNot currently in use, but would be useful for applications that wanted to augment a core class with their own additional settings. This has the same affect as a ForeignKey with unique=True. The difference is that the reverse side of the relationship will always be 1 object (not a list).
GenericForeignKeyNot currently in use, but can be used to specify a non specific relation to “another object.” Meaning object A relates to any other object. This relationship requires a reverse attribute in the “other” object to see the relationship – but would primarily be accessed through the GenericForeignKey owner Model. For example, https://docs.djangoproject.com/en/dev/ref/contrib/contenttypes/#id1. The nuances of these relationships is brought about by the additional optional attributes that can be ascribed to each Field.

Note that we should likely convert our Tags to use GenericForeignKey so that all objects can be extensible during development, but then converted/promoted to attributes once the model has stabilized.

Optional Attribute Side Effects

AttributeKey TypeWhy
limit_choices_toForeignKeyField, ManyToManyFieldNot currently in use. Good to limit the possible selection choices for a remote relationship by some constraint. Constraints may either be expressed by a dictionary of lookups, or by a Q object. (See https://docs.djangoproject.com/en/dev/topics/db/queries/#complex-lookups-with-q.) Example of data limit for another object:limit_choices_to = {‘pub_date__lte’: datetime.date.today}
relate_nameForeignKeyField, ManyToManyFieldThe name to use for the relation back to this one. This is extremely useful both to provide additional context in the way the objects are related but also when you have the same objects and object types related in different contexts to the same instance. It allows for lookups and incorporation into Admin Forms based on the relationship. For example, SliceMembership: user = models.ForeignKey(‘User’, related_name=’slice_memberships’) slice = models.ForeignKey(‘Slice’, related_name=’slice_memberships’). “+” is a special meaning in this field. As the only character (or the trailing character of the field) it has the effect of eclipsing the backward relationship so that it is unseen by the related object.
on_deleteForeignKeyFieldDefault behavior is to behave like “ON DELETE CASCADE.” This may be turned of so long as the null=True, blank=True options are also set. For example, user = models.ForeignKey(User, blank=True, null=True, on_delete=models.SET_NULL)
symmetricalManyToManyFieldOnly used when ManyToManyField definition is against “self.” For example, class Person: friends = models.ManyToManyField(“self”) would mean that if Person Alice is friended to Person Brian, then Brian is also Friends with Alice.
throughManyToManyFieldDjango automatically creates a mapping table for ManyToMany relationships. By using this field, you can specify the exact mapping table you would like to use, therefore allowing you to augment/extend that table with additional data. For example, https://docs.djangoproject.com/en/dev/topics/db/models/#intermediary-manytomany.
parent_linkOneToOneFieldUsed only for multiple inheritance (specifically from a concrete class) to avoid additional/extra OneToOneFields being created via subclassing. Django documentation for Related Fields can be found at: https://docs.djangoproject.com/en/dev/ref/models/fields/#module-django.db.models.fields.related.

Avoid List

Avoid using the following optional attributes as they can have adverse effects on data integrity and REST relationships:

AttributeEffect
to_fieldWould allow the relationship to exist against a field other than the primary key in the remote object.
db_constraintControls whether or not a constraint should be created in the database for the foreignKey relationship. It defaults to True. If you set it to False you could cause database pointers to non-existent data. We should avoid this.

Model-Specific MetaData

Model SettingWhen to use it
abstractUsed to specify that the defined model is not intended/able to be instantiated directly. For example, PlCoreBase, which is used to ensure that created, updated, and enacted fields will be provided for all XOS participating objects.
app_labelNecessary if models are defined in modules other than models.py In our core application we split out the model definitions into their own modules for clarity – each of the models not derived from the PlCoreBase needs to explicitly state the “core” as the application this object is associated to. For example, PlCoreBase and User.
order_with_respect_to 
orderingDefines the default column to order lists of the object type by. For example, Users => email.

Model CheckList 

After creating a new model, here are the additional changes required for your new model to fully take effect and be visible in XOS:

Where to goWhy  
/opt/xos/core/models/init.pyAdd your new model into the python package.  
/opt/xos/core/admin.pyRegister your model with the admin interface, until this is complete your model will not be visible in the Admin interface. For example,admin.site.register(Deployment). You may also want a custom Admin Page rather than the auto-generated page so that you can tailor the view to just the fields and display widgets you prefer. To do that useadmin.site.register(Deployment, DeploymentAdmin) and see the Tips and Tricks for GUI Views for more detailed instructions.  
/opt/xos/xos/urls.pyREST related. Add in the url paths to tie in to callbacks for CRUD. Typically there are 2 different urls to expose: (1) Creation at the directory/container level to handle POST commands; and (2) RetrieveUpdateDestroy path based on GETPUTDELETE commands. For example,url(r’^xos/sites/$’, SiteListCreate.as_view(), name=’site-list’), *url(r’^xos/sites/(?P[a-zA-Z0-9_\-]+)/$', SiteRetrieveUpdateDestroy.as_view(), name='site-detail')*.
/opt/xos/core/viewsREST related. Add classes to support the Create, Read, Update and Destroy needs for your new model when it is accessed via REST.  
/opt/xos/core/serializers.pyREST related. Add a class to specify the fields that are exposed via the REST api for your model. In particular, the serialization preferences if other than default for the field type would also be specified here.