rattail-project/rattail Changeset

Changeset - 2f408c18736e

Parent rev.

Child rev.

[Not reviewed]

0 4 1

Lance Edgar - 6 years ago 2019-03-08 14:33:01
ledgar@techsupport.coop

Add `ProductVolatile` model, for "volatile" product attributes

at least that's the idea...hopefully this table "wins the war" for this concept

5 files changed with 100 insertions and 1 deletions:

rattail/db/alembic/versions/5b393c108673_add_product_volatile.py

rattail/db/model/__init__.py

rattail/db/model/products.py

rattail/importing/model.py

rattail/importing/rattail.py

0 comments (0 inline, 0 general)

rattail/db/alembic/versions/5b393c108673_add_product_volatile.py

➞

Show inline comments

@@ new file 100644 @@
 # -*- coding: utf-8; -*-
 """add product_volatile
 Revision ID: 5b393c108673
 Revises: 6118198dc4db
 Create Date: 2019-03-08 13:14:11.645892
 """
 from __future__ import unicode_literals, absolute_import
 # revision identifiers, used by Alembic.
 revision = '5b393c108673'
 down_revision = '6118198dc4db'
 branch_labels = None
 depends_on = None
 from alembic import op
 import sqlalchemy as sa
 import rattail.db.types
 def upgrade():
     # product_volatile
     op.create_table('product_volatile',
                     sa.Column('uuid', sa.String(length=32), nullable=False),
                     sa.Column('product_uuid', sa.String(length=32), nullable=False),
                     sa.Column('true_cost', sa.Numeric(precision=9, scale=5), nullable=True),
                     sa.Column('true_margin', sa.Numeric(precision=8, scale=5), nullable=True),
                     sa.ForeignKeyConstraint(['product_uuid'], ['product.uuid'], name='product_volatile_fk_product'),
                     sa.PrimaryKeyConstraint('uuid')
+    )
 def downgrade():
     # product_volatile
     op.drop_table('product_volatile')

rattail/db/model/__init__.py

➞

Show inline comments

@@ @@ -44,7 +44,8 @@ from .shifts import ScheduledShift, WorkedShift @@
 from .vendors import Vendor, VendorPhoneNumber, VendorEmailAddress, VendorContact
 from .products import (Brand, Tax, Product, ProductImage, ProductCode,
                        ProductCost, ProductFutureCost, ProductPrice,
                        ProductInventory, ProductStoreInfo, InventoryAdjustmentReason)
                        ProductInventory, ProductStoreInfo, ProductVolatile,
                        InventoryAdjustmentReason)
 from .purchase import (PurchaseBase, PurchaseItemBase, PurchaseCreditBase,
                        Purchase, PurchaseItem, PurchaseCredit)

rattail/db/model/products.py

➞

Show inline comments

@@ @@ -845,6 +845,53 @@ class ProductStoreInfo(Base): @@
     """)
 class ProductVolatile(Base):
     """
     This is the place to find "volatile" data for a given product, or at least
     it should be...  As of this writing there are a couple other places to look
     but hopefully this table can eventually be "the" place.
     Whether any given value in a given record, applies to the "current" app
     node only, or if it applies to all nodes, is up to app logic.
     Note that a custom app should (most likely) *not* bother "extending" this
     table, but rather should create a separate table with similar pattern.
     """
     __tablename__ = 'product_volatile'
     __table_args__ = (
         sa.ForeignKeyConstraint(['product_uuid'], ['product.uuid'], name='product_volatile_fk_product'),
+    )
     uuid = uuid_column()
     product_uuid = sa.Column(sa.String(length=32), nullable=False)
     product = orm.relationship(
         Product,
         doc="""
         Product to which this "volatile" data record pertains.
         """,
         backref=orm.backref(
             'volatile',
             uselist=False,
             cascade='all, delete-orphan',
             doc="""
             "Volatile" data record for the product, if any.
             """))
     true_cost = sa.Column(sa.Numeric(precision=9, scale=5), nullable=True, doc="""
     "True" unit cost for the item, if known.  This might include certain
     "allowances" (discounts) currently in effect etc.; really anything which
     might not be reflected in "official" unit cost for the product.  Usually,
     this value is quite easily calculated and so this field serves as more of
     a cache, for sake of SQL access to the values.
     """)
     true_margin = sa.Column(sa.Numeric(precision=8, scale=5), nullable=True, doc="""
     "True" profit margin for the "regular" unit price vs. the "true" unit cost
     (:attr:`true_cost`).
     """)
 @six.python_2_unicode_compatible
 class InventoryAdjustmentReason(Base):
     """

rattail/importing/model.py

➞

Show inline comments

@@ @@ -2242,6 +2242,13 @@ class ProductStoreInfoImporter(ToRattail): @@
     model_class = model.ProductStoreInfo
 class ProductVolatileImporter(ToRattail):
     """
     Data importer for :class:`~rattail.db.model.products.ProductVolatile`.
     """
     model_class = model.ProductVolatile
 class LabelProfileImporter(ToRattail):
     """
     Importer for LabelProfile data

rattail/importing/rattail.py

➞

Show inline comments

@@ @@ -112,6 +112,7 @@ class FromRattailToRattailBase(object): @@
         importers['ProductCost'] = ProductCostImporter
         importers['ProductPrice'] = ProductPriceImporter
         importers['ProductStoreInfo'] = ProductStoreInfoImporter
         importers['ProductVolatile'] = ProductVolatileImporter
         importers['ProductImage'] = ProductImageImporter
         importers['LabelProfile'] = LabelProfileImporter
         return importers
 class ProductStoreInfoImporter(FromRattail, model.ProductStoreInfoImporter):
     pass
 class ProductVolatileImporter(FromRattail, model.ProductVolatileImporter):
     pass
 class ProductImageImporter(FromRattail, model.ProductImageImporter):
     """

0 comments (0 inline, 0 general)