BoxVendor

Complexity

Total Complexity

3

Size/Duplication

Total Lines	35
Duplicated Lines	100 %

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	from_id()	3	3	1
A	from_number_fuzzy()	3	3	1
A	__init__()	5	5	1

from .model import *
from . import vendor
from . import box

class BoxVendor(Base):

This code seems to be duplicated in your project.

    __tablename__ = 'box_vendors'

    id          = Column(Integer, primary_key=True, nullable=False)
    vendor_id   = Column(Integer, ForeignKey("vendors.id"), nullable=False)
    box_id      = Column(Integer, ForeignKey("boxes.id"), nullable=False)
    item_number = Column(String(255), nullable=False)

    enabled     = Column(Boolean, default=True, nullable=False)

    vendor      = relationship(
                      vendor.Vendor,
                      primaryjoin="and_(BoxVendor.vendor_id==Vendor.id, BoxVendor.enabled==True)",
                      backref="boxes"
                  )
    box         = relationship(
                      box.Box,
                      primaryjoin="and_(BoxVendor.box_id==Box.id, BoxVendor.enabled==True)",
                      backref="vendors"
                  )


    def __init__(self, vendor, box, item_number, enabled=True):
        self.vendor_id   = vendor.id
        self.box_id      = box.id
        self.item_number = item_number
        self.enabled     = enabled

    @classmethod
    def from_id(cls, id):
        return DBSession.query(cls).filter(cls.id == id).one()

    @classmethod
    def from_number_fuzzy(cls, number):
        return DBSession.query(cls).filter(cls.item_number.like('%{}%'.format(number))).all()