symposion_app Changeset - dba37736362d

Changeset - dba37736362d

Parent rev.

Child rev.

[Not reviewed]

0 1 1

Christopher Neugebauer - 8 years ago 2016-04-06 12:59:00
chrisjrn@gmail.com

Adds db indices

2 files changed with 72 insertions and 4 deletions:

registrasion/migrations/0012_auto_20160406_1212.py

registrasion/models.py

0 comments (0 inline, 0 general)

registrasion/migrations/0012_auto_20160406_1212.py

➞

Show inline comments

 new file 100644
 # -*- coding: utf-8 -*-
 # Generated by Django 1.9.2 on 2016-04-06 12:12
 from __future__ import unicode_literals
 from django.db import migrations, models
 class Migration(migrations.Migration):
     dependencies = [
         ('registrasion', '0011_auto_20160401_0943'),
+    ]
     operations = [
         migrations.AlterField(
             model_name='cart',
             name='active',
             field=models.BooleanField(db_index=True, default=True),
         ),
         migrations.AlterField(
             model_name='cart',
             name='released',
             field=models.BooleanField(db_index=True, default=False),
         ),
         migrations.AlterField(
             model_name='cart',
             name='time_last_updated',
             field=models.DateTimeField(db_index=True),
         ),
         migrations.AlterField(
             model_name='category',
             name='order',
             field=models.PositiveIntegerField(db_index=True, verbose_name='Display order'),
         ),
         migrations.AlterField(
             model_name='product',
             name='order',
             field=models.PositiveIntegerField(db_index=True, verbose_name='Display order'),
         ),
         migrations.AlterField(
             model_name='productitem',
             name='quantity',
             field=models.PositiveIntegerField(db_index=True),
         ),
         migrations.AlterIndexTogether(
             name='cart',
             index_together=set([('active', 'released'), ('released', 'user'), ('active', 'user'), ('active', 'time_last_updated')]),
         ),
+    ]

registrasion/models.py

➞

Show inline comments

@@ ... / @@ -78,96 +78,98 @@ class Category(models.Model): @@
+    ]
     name = models.CharField(
         max_length=65,
         verbose_name=_("Name"),
+    )
     description = models.CharField(
         max_length=255,
         verbose_name=_("Description"),
+    )
     limit_per_user = models.PositiveIntegerField(
         null=True,
         blank=True,
         verbose_name=_("Limit per user"),
         help_text=_("The total number of items from this category one "
                     "attendee may purchase."),
+    )
     required = models.BooleanField(
         blank=True,
         help_text=_("If enabled, a user must select an "
                     "item from this category."),
+    )
     order = models.PositiveIntegerField(
         verbose_name=("Display order"),
         db_index=True,
+    )
     render_type = models.IntegerField(
         choices=CATEGORY_RENDER_TYPES,
         verbose_name=_("Render type"),
         help_text=_("The registration form will render this category in this "
                     "style."),
+    )
 @python_2_unicode_compatible
 class Product(models.Model):
     ''' Registration products '''
     def __str__(self):
         return "%s - %s" % (self.category.name, self.name)
     name = models.CharField(
         max_length=65,
         verbose_name=_("Name"),
+    )
     description = models.CharField(
         max_length=255,
         verbose_name=_("Description"),
         null=True,
         blank=True,
+    )
     category = models.ForeignKey(
         Category,
         verbose_name=_("Product category")
+    )
     price = models.DecimalField(
         max_digits=8,
         decimal_places=2,
         verbose_name=_("Price"),
+    )
     limit_per_user = models.PositiveIntegerField(
         null=True,
         blank=True,
         verbose_name=_("Limit per user"),
+    )
     reservation_duration = models.DurationField(
         default=datetime.timedelta(hours=1),
         verbose_name=_("Reservation duration"),
         help_text=_("The length of time this product will be reserved before "
                     "it is released for someone else to purchase."),
+    )
     order = models.PositiveIntegerField(
         verbose_name=("Display order"),
         db_index=True,
+    )
 @python_2_unicode_compatible
 class Voucher(models.Model):
     ''' Registration vouchers '''
     # Vouchers reserve a cart for a fixed amount of time, so that
     # items may be added without the voucher being swiped by someone else
     RESERVATION_DURATION = datetime.timedelta(hours=1)
     def __str__(self):
         return "Voucher for %s" % self.recipient
     @classmethod
     def normalise_code(cls, code):
         return code.upper()
     def save(self, *a, **k):
         ''' Normalise the voucher code to be uppercase '''
         self.code = self.normalise_code(self.code)
         super(Voucher, self).save(*a, **k)
     recipient = models.CharField(max_length=64, verbose_name=_("Recipient"))
@@ ... / @@ -292,48 +294,49 @@ class TimeOrStockLimitDiscount(DiscountBase): @@
         help_text=_("This discount will only be available after this time."),
+    )
     end_time = models.DateTimeField(
         null=True,
         blank=True,
         verbose_name=_("End time"),
         help_text=_("This discount will only be available before this time."),
+    )
     limit = models.PositiveIntegerField(
         null=True,
         blank=True,
         verbose_name=_("Limit"),
         help_text=_("This discount may only be applied this many times."),
+    )
 class VoucherDiscount(DiscountBase):
     ''' Discounts that are enabled when a voucher code is in the current
     cart. '''
     voucher = models.OneToOneField(
         Voucher,
         on_delete=models.CASCADE,
         verbose_name=_("Voucher"),
         db_index=True,
+    )
 class IncludedProductDiscount(DiscountBase):
     ''' Discounts that are enabled because another product has been purchased.
     e.g. A conference ticket includes a free t-shirt. '''
     class Meta:
         verbose_name = _("Product inclusion")
     enabling_products = models.ManyToManyField(
         Product,
         verbose_name=_("Including product"),
         help_text=_("If one of these products are purchased, the discounts "
                     "below will be enabled."),
+    )
 class RoleDiscount(object):
     ''' Discounts that are enabled because the active user has a specific
     role. This is for e.g. volunteers who can get a discount ticket. '''
     # TODO: implement RoleDiscount
     pass
@@ ... / @@ -437,83 +440,99 @@ class VoucherEnablingCondition(EnablingConditionBase): @@
     ''' The condition is met because a Voucher is present. This is for e.g.
     enabling sponsor tickets. '''
     def __str__(self):
         return "Enabled by voucher: %s" % self.voucher
     voucher = models.OneToOneField(Voucher)
 # @python_2_unicode_compatible
 class RoleEnablingCondition(object):
     ''' The condition is met because the active user has a particular Role.
     This is for e.g. enabling Team tickets. '''
     # TODO: implement RoleEnablingCondition
     pass
 # Commerce Models
 @python_2_unicode_compatible
 class Cart(models.Model):
     ''' Represents a set of product items that have been purchased, or are
     pending purchase. '''
     class Meta:
         index_together = [
             ("active", "time_last_updated"),
             ("active", "released"),
             ("active", "user"),
             ("released", "user"),
+        ]
     def __str__(self):
         return "%d rev #%d" % (self.id, self.revision)
     user = models.ForeignKey(User)
     # ProductItems (foreign key)
     vouchers = models.ManyToManyField(Voucher, blank=True)
     time_last_updated = models.DateTimeField()
     time_last_updated = models.DateTimeField(
         db_index=True,
+    )
     reservation_duration = models.DurationField()
     revision = models.PositiveIntegerField(default=1)
     active = models.BooleanField(default=True)
     released = models.BooleanField(default=False)  # Refunds etc
     active = models.BooleanField(
         default=True,
         db_index=True,
+    )
     released = models.BooleanField(
         default=False,
         db_index=True
     )  # Refunds etc
     @classmethod
     def reserved_carts(cls):
         ''' Gets all carts that are 'reserved' '''
         return Cart.objects.filter(
             (Q(active=True) &
                 Q(time_last_updated__gt=(
                     timezone.now()-F('reservation_duration')
                                         ))) |
             (Q(active=False) & Q(released=False))
+        )
 @python_2_unicode_compatible
 class ProductItem(models.Model):
     ''' Represents a product-quantity pair in a Cart. '''
     def __str__(self):
         return "product: %s * %d in Cart: %s" % (
             self.product, self.quantity, self.cart)
     cart = models.ForeignKey(Cart)
     product = models.ForeignKey(Product)
     quantity = models.PositiveIntegerField()
+    quantity = models.PositiveIntegerField(db_index=True)
 @python_2_unicode_compatible
 class DiscountItem(models.Model):
     ''' Represents a discount-product-quantity relation in a Cart. '''
     def __str__(self):
         return "%s: %s * %d in Cart: %s" % (
             self.discount, self.product, self.quantity, self.cart)
     cart = models.ForeignKey(Cart)
     product = models.ForeignKey(Product)
     discount = models.ForeignKey(DiscountBase)
     quantity = models.PositiveIntegerField()
 @python_2_unicode_compatible
 class Invoice(models.Model):
     ''' An invoice. Invoices can be automatically generated when checking out
     a Cart, in which case, it is attached to a given revision of a Cart. '''
     def __str__(self):
         return "Invoice #%d" % self.id

0 comments (0 inline, 0 general)