ItemVendor.from_id() - Code Metrics - um-cseg/chez-betty - Measure and Improve Code Quality continuously with Scrutinizer

ItemVendor.from_id() A
last analyzed 2018-05-24 22:12 UTC

↳ Parent: ItemVendor

Complexity

Conditions

Size

Total Lines

Duplication

Lines	3
Ratio	100 %

Importance

Changes

Metric	Value
cc	1
dl	3
loc	3
rs	10
c	0
b	0
f	0

from .model import *
from . import vendor
from . import item

class ItemVendor(Base):

    __tablename__ = 'item_vendors'

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

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

    vendor      = relationship(
                      vendor.Vendor,
                      primaryjoin="and_(ItemVendor.vendor_id==Vendor.id, ItemVendor.enabled==True)",
                      backref="items"
                  )
    item         = relationship(
                      item.Item,
                      primaryjoin="and_(ItemVendor.item_id==Item.id, ItemVendor.enabled==True)",
                      backref="vendors"
                  )

    def __init__(self, vendor, item, item_number, enabled=True):
        self.vendor_id   = vendor.id
        self.item_id     = item.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()


1		from .model import *
2		from . import vendor
3		from . import item
4
5	View Code Duplication	class ItemVendor(Base):
		0 ignored issues – show Duplication introduced 2016-04-28 02:58 UTC by Report Bug Copy Issue Report This code seems to be duplicated in your project. Loading history...
6		__tablename__ = 'item_vendors'
7
8		id = Column(Integer, primary_key=True, nullable=False)
9		vendor_id = Column(Integer, ForeignKey("vendors.id"), nullable=False)
10		item_id = Column(Integer, ForeignKey("items.id"), nullable=False)
11		item_number = Column(String(255), nullable=False)
12
13		enabled = Column(Boolean, default=True, nullable=False)
14
15		vendor = relationship(
16		vendor.Vendor,
17		primaryjoin="and_(ItemVendor.vendor_id==Vendor.id, ItemVendor.enabled==True)",
18		backref="items"
19		)
20		item = relationship(
21		item.Item,
22		primaryjoin="and_(ItemVendor.item_id==Item.id, ItemVendor.enabled==True)",
23		backref="vendors"
24		)
25
26		def __init__(self, vendor, item, item_number, enabled=True):
27		self.vendor_id = vendor.id
28		self.item_id = item.id
29		self.item_number = item_number
30		self.enabled = enabled
31
32		@classmethod
33		def from_id(cls, id):
34		return DBSession.query(cls).filter(cls.id == id).one()
35
36		@classmethod
37		def from_number_fuzzy(cls, number):
38		return DBSession.query(cls).filter(cls.item_number.like('%{}%'.format(number))).all()
39

um-cseg / chez-betty

ItemVendor.from_id() A last analyzed 2018-05-24 22:12 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

ItemVendor.from_id() A
last analyzed 2018-05-24 22:12 UTC