| 1 |
""" |
| 2 |
Callable defaults |
| 3 |
|
| 4 |
You can pass callable objects as the ``default`` parameter to a field. When |
| 5 |
the object is created without an explicit value passed in, Django will call |
| 6 |
the method to determine the default value. |
| 7 |
|
| 8 |
This example uses ``datetime.datetime.now`` as the default for the ``pub_date`` |
| 9 |
field. |
| 10 |
""" |
| 11 |
|
| 12 |
from datetime import datetime |
| 13 |
from decimal import Decimal |
| 14 |
|
| 15 |
from django.db import models |
| 16 |
from django.db.models.functions import Coalesce, ExtractYear, Now, Pi |
| 17 |
from django.db.models.lookups import GreaterThan |
| 18 |
|
| 19 |
|
| 20 |
class Article(models.Model): |
| 21 |
headline = models.CharField(max_length=100, default="Default headline") |
| 22 |
pub_date = models.DateTimeField(default=datetime.now) |
| 23 |
|
| 24 |
def __str__(self): |
| 25 |
return self.headline |
| 26 |
|
| 27 |
|
| 28 |
class DBArticle(models.Model): |
| 29 |
""" |
| 30 |
Values or expressions can be passed as the db_default parameter to a field. |
| 31 |
When the object is created without an explicit value passed in, the |
| 32 |
database will insert the default value automatically. |
| 33 |
""" |
| 34 |
|
| 35 |
headline = models.CharField(max_length=100, db_default="Default headline") |
| 36 |
pub_date = models.DateTimeField(db_default=Now()) |
| 37 |
cost = models.DecimalField( |
| 38 |
max_digits=3, decimal_places=2, db_default=Decimal("3.33") |
| 39 |
) |
| 40 |
|
| 41 |
class Meta: |
| 42 |
required_db_features = {"supports_expression_defaults"} |
| 43 |
|
| 44 |
|
| 45 |
class DBDefaults(models.Model): |
| 46 |
both = models.IntegerField(default=1, db_default=2) |
| 47 |
null = models.FloatField(null=True, db_default=1.1) |
| 48 |
|
| 49 |
|
| 50 |
class DBDefaultsFunction(models.Model): |
| 51 |
number = models.FloatField(db_default=Pi()) |
| 52 |
year = models.IntegerField(db_default=ExtractYear(Now())) |
| 53 |
added = models.FloatField(db_default=Pi() + 4.5) |
| 54 |
multiple_subfunctions = models.FloatField(db_default=Coalesce(4.5, Pi())) |
| 55 |
case_when = models.IntegerField( |
| 56 |
db_default=models.Case(models.When(GreaterThan(2, 1), then=3), default=4) |
| 57 |
) |
| 58 |
|
| 59 |
class Meta: |
| 60 |
required_db_features = {"supports_expression_defaults"} |
| 61 |
|
| 62 |
|
| 63 |
class DBDefaultsPK(models.Model): |
| 64 |
language_code = models.CharField(primary_key=True, max_length=2, db_default="en") |
| 65 |
|
| 66 |
|
| 67 |
class DBDefaultsFK(models.Model): |
| 68 |
language_code = models.ForeignKey( |
| 69 |
DBDefaultsPK, db_default="fr", on_delete=models.CASCADE |
| 70 |
) |