BadScan.get_scans_with_counts() - Code Metrics - Inspection of "track bad scans" - um-cseg/chez-betty - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( ef6531...309daa )

unknown

created 2016-09-05 02:38 UTC

BadScan.get_scans_with_counts() A

↳ Parent: BadScan

Complexity

Conditions

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	2
c	1
b	0
f	0
dl	0
loc	18
rs	9.4285

from .model import *

from sqlalchemy_utils import ArrowType

class BadScan(Base):
    __tablename__ = 'badscans'

    id        = Column(Integer, primary_key=True, nullable=False)
    timestamp = Column(ArrowType, nullable=False, default=datetime.datetime.utcnow)
    badscan   = Column(String(255), nullable=False)

    def __init__(self, scan):
        self.badscan = scan

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

    @classmethod
    def all(cls):
        return DBSession.query(cls)\
                        .order_by(cls.timestamp).all()

    @classmethod
    def get_scans_with_counts(cls):
        out = []
        badscans = DBSession.query(cls.badscan, func.count(cls.badscan).label('count'))\
                        .group_by(cls.badscan)\
                        .all()
        for badscan in badscans:
            most_recent = DBSession.query(cls)\
                            .filter(cls.badscan==badscan.badscan)\
                            .order_by(cls.timestamp.desc())\
                            .first()
            out.append({
                'badscan': badscan.badscan,
                'count': badscan.count,
                'timestamp': most_recent.timestamp
            })

        return out


1			from .model import *
2
3			from sqlalchemy_utils import ArrowType
4
5			class BadScan(Base):
6			__tablename__ = 'badscans'
7
8			id = Column(Integer, primary_key=True, nullable=False)
9			timestamp = Column(ArrowType, nullable=False, default=datetime.datetime.utcnow)
10			badscan = Column(String(255), nullable=False)
11
12			def __init__(self, scan):
13			self.badscan = scan
14
15			@classmethod
16			def from_id(cls, id):
17			return DBSession.query(cls).filter(cls.id == id).one()
18
19			@classmethod
20			def all(cls):
21			return DBSession.query(cls)\
22			.order_by(cls.timestamp).all()
23
24			@classmethod
25			def get_scans_with_counts(cls):
26			out = []
27			badscans = DBSession.query(cls.badscan, func.count(cls.badscan).label('count'))\
28			.group_by(cls.badscan)\
29			.all()
30			for badscan in badscans:
31			most_recent = DBSession.query(cls)\
32			.filter(cls.badscan==badscan.badscan)\
33			.order_by(cls.timestamp.desc())\
34			.first()
35			out.append({
36			'badscan': badscan.badscan,
37			'count': badscan.count,
38			'timestamp': most_recent.timestamp
39			})
40
41			return out
42

um-cseg / chez-betty

Push — master ( ef6531...309daa )

BadScan.get_scans_with_counts() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like