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

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

↳ Parent: BoxVendor

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 box

class BoxVendor(Base):

    __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()


1		from .model import *
2		from . import vendor
3		from . import box
4
5	View Code Duplication	class BoxVendor(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__ = 'box_vendors'
7
8		id = Column(Integer, primary_key=True, nullable=False)
9		vendor_id = Column(Integer, ForeignKey("vendors.id"), nullable=False)
10		box_id = Column(Integer, ForeignKey("boxes.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_(BoxVendor.vendor_id==Vendor.id, BoxVendor.enabled==True)",
18		backref="boxes"
19		)
20		box = relationship(
21		box.Box,
22		primaryjoin="and_(BoxVendor.box_id==Box.id, BoxVendor.enabled==True)",
23		backref="vendors"
24		)
25
26
27		def __init__(self, vendor, box, item_number, enabled=True):
28		self.vendor_id = vendor.id
29		self.box_id = box.id
30		self.item_number = item_number
31		self.enabled = enabled
32
33		@classmethod
34		def from_id(cls, id):
35		return DBSession.query(cls).filter(cls.id == id).one()
36
37		@classmethod
38		def from_number_fuzzy(cls, number):
39		return DBSession.query(cls).filter(cls.item_number.like('%{}%'.format(number))).all()
40

um-cseg / chez-betty

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

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

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