Changeset 9299cd4 in pycorepos

Timestamp:

08/10/2020 03:57:32 PM (2 years ago)

Author:

Lance Edgar <lance@…>

Branches:

master

Children:

472f438

Parents:

ef1a25f

Message:

Add "origin" models for office_op schema

File:

• corepos/db/office_op/model.py (modified) (1 diff)

corepos/db/office_op/model.py

@@ -311 +311 @@
 
 
+class OriginCountry(Base):
+    """
+    Represents a country which relates to the "origin" for some product(s).
+    """
+    __tablename__ = 'originCountry'
+
+    id = sa.Column('countryID', sa.Integer(), primary_key=True, autoincrement=True, nullable=False)
+
+    name = sa.Column(sa.String(length=50), nullable=True)
+
+    abbreviation = sa.Column('abbr', sa.String(length=5), nullable=True)
+
+    def __str__(self):
+        return self.name or self.abbreviation or ""
+
+
+class OriginStateProv(Base):
+    """
+    Represents a state/province which relates to the "origin" for some product(s).
+    """
+    __tablename__ = 'originStateProv'
+
+    id = sa.Column('stateProvID', sa.Integer(), primary_key=True, autoincrement=True, nullable=False)
+
+    name = sa.Column(sa.String(length=50), nullable=True)
+
+    abbreviation = sa.Column('abbr', sa.String(length=5), nullable=True)
+
+    def __str__(self):
+        return self.name or self.abbreviation or ""
+
+
+class OriginCustomRegion(Base):
+    """
+    Represents a custom region which relates to the "origin" for some product(s).
+    """
+    __tablename__ = 'originCustomRegion'
+
+    id = sa.Column('customID', sa.Integer(), primary_key=True, autoincrement=True, nullable=False)
+
+    name = sa.Column(sa.String(length=50), nullable=True)
+
+    def __str__(self):
+        return self.name or ""
+
+
+class Origin(Base):
+    """
+    Represents a location which is the "origin" for some product(s).
+    """
+    __tablename__ = 'origins'
+    __table_args__ = (
+        sa.ForeignKeyConstraint(['countryID'], ['originCountry.countryID']),
+        sa.ForeignKeyConstraint(['stateProvID'], ['originStateProv.stateProvID']),
+        sa.ForeignKeyConstraint(['customID'], ['originCustomRegion.customID']),
+    )
+
+    id = sa.Column('originID', sa.Integer(), primary_key=True, autoincrement=True, nullable=False)
+
+    country_id = sa.Column('countryID', sa.Integer(), nullable=True)
+    country = orm.relationship(OriginCountry)
+
+    state_prov_id = sa.Column('stateProvID', sa.Integer(), nullable=True)
+    state_prov = orm.relationship(OriginStateProv)
+
+    custom_id = sa.Column('customID', sa.Integer(), nullable=True)
+    custom_region = orm.relationship(OriginCustomRegion)
+
+    local = sa.Column(sa.Boolean(), nullable=True, default=0)
+
+    name = sa.Column(sa.String(length=100), nullable=True)
+
+    short_name = sa.Column('shortName', sa.String(length=50), nullable=True)
+
+    def __str__(self):
+        return self.name or self.short_name or ""
+
+
 class Product(Base):
     """