[feat] Inventory tracking and location-awareness

[tsdobbs]

Add functionality in the data model to store the location of plasmids, strains, and labware.

Applications include:

• Allowing operators to quickly look up where to find things at job time
• Presenting only jobs that can be done at a site to that site (e.g. you can only print with aeBlue in some cases)
• Informing a PAML execution engine of which equipment is available when actualizing a protocol

Trick is to efficiently lump together all of the different object models that can be inventoried. Use a super-classing method of the plasmid, strain, and labware tables: https://docs.sqlalchemy.org/en/14/orm/inheritance.html

[tsdobbs]

Some starter code for the data model:

class LabLocationModel(SurrogatePK, Model):
    """
    A location somewhere where we can find plasmids or strains.
    The site is constrained, but the specific location is purposefully
    qualitative. This better supports small-scale operations where
    humans will likely retrieve the materials.
    """
    __tablename__ = 'lab_locations'
    
    site = Column(db.String(30), nullable=False)
    location = Column(db.String(20), nullable=False)
    contact = Column(db.String(30))
    notes = Column(db.String(140))
    inventory = relationship('InventoryModel', backref='location', lazy='dynamic')

class InventoryModel(SurrogatePK, Model):
    """
    An inventory is a collection of real plasmids, strains, or labware
    that exists in a specific real-world place where someone can go
    get it. In addition to referencing a plasmid, strain, or labware
    and the location that thing is in, it has a 
    """
    __tablename__ = 'inventories'
    
    #item = [some reference to super-class of "stuff" that includes plasmids, strains, and lab_objects]
    #   would need to set up something like this: https://docs.sqlalchemy.org/en/14/orm/inheritance.html
    amount = Column(db.Float)
    units = Column(db.String(10))
    previous_location = relationship('LabLocationModel')
    contact = Column(db.String(30))
    notes = Column(db.String(140))