Code Duplication - myems/myems-api - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 16-16 lines in 8 locations

reports/equipmentefficiency.py 1 location


                              " FROM tbl_equipments "
                              " WHERE id = %s ", (equipment_id,))
        row_equipment = cursor_system.fetchone()
        if row_equipment is None:
            if cursor_system:
                cursor_system.close()
            if cnx_system:
                cnx_system.disconnect()

            if cursor_energy:
                cursor_energy.close()
            if cnx_energy:
                cnx_energy.disconnect()

            if cnx_historical:
                cnx_historical.close()
            if cursor_historical:
                cursor_historical.disconnect()
            raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', description='API.EQUIPMENT_NOT_FOUND')

        equipment = dict()
        equipment['id'] = row_equipment[0]

reports/equipmentenergyitem.py 1 location


                              " FROM tbl_equipments "
                              " WHERE id = %s ", (equipment_id,))
        row_equipment = cursor_system.fetchone()
        if row_equipment is None:
            if cursor_system:
                cursor_system.close()
            if cnx_system:
                cnx_system.disconnect()

            if cursor_energy:
                cursor_energy.close()
            if cnx_energy:
                cnx_energy.disconnect()

            if cnx_historical:
                cnx_historical.close()
            if cursor_historical:
                cursor_historical.disconnect()
            raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', description='API.EQUIPMENT_NOT_FOUND')

        equipment = dict()
        equipment['id'] = row_equipment[0]

reports/equipmentincome.py 1 location


                              " FROM tbl_equipments "
                              " WHERE id = %s ", (equipment_id,))
        row_equipment = cursor_system.fetchone()
        if row_equipment is None:
            if cursor_system:
                cursor_system.close()
            if cnx_system:
                cnx_system.disconnect()

            if cursor_energy:
                cursor_energy.close()
            if cnx_energy:
                cnx_energy.disconnect()

            if cnx_historical:
                cnx_historical.close()
            if cursor_historical:
                cursor_historical.disconnect()
            raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', description='API.EQUIPMENT_NOT_FOUND')

        equipment = dict()
        equipment['id'] = row_equipment[0]

reports/equipmentenergycategory.py 1 location


                              " FROM tbl_equipments "
                              " WHERE id = %s ", (equipment_id,))
        row_equipment = cursor_system.fetchone()
        if row_equipment is None:
            if cursor_system:
                cursor_system.close()
            if cnx_system:
                cnx_system.disconnect()

            if cursor_energy:
                cursor_energy.close()
            if cnx_energy:
                cnx_energy.disconnect()

            if cnx_historical:
                cnx_historical.close()
            if cursor_historical:
                cursor_historical.disconnect()
            raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', description='API.EQUIPMENT_NOT_FOUND')

        equipment = dict()
        equipment['id'] = row_equipment[0]

reports/equipmentcost.py 1 location


                              " FROM tbl_equipments "
                              " WHERE id = %s ", (equipment_id,))
        row_equipment = cursor_system.fetchone()
        if row_equipment is None:
            if cursor_system:
                cursor_system.close()
            if cnx_system:
                cnx_system.disconnect()

            if cursor_energy:
                cursor_energy.close()
            if cnx_energy:
                cnx_energy.disconnect()

            if cnx_historical:
                cnx_historical.close()
            if cursor_historical:
                cursor_historical.disconnect()
            raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', description='API.EQUIPMENT_NOT_FOUND')

        equipment = dict()
        equipment['id'] = row_equipment[0]

reports/equipmentstatistics.py 1 location


                              " FROM tbl_equipments "
                              " WHERE id = %s ", (equipment_id,))
        row_equipment = cursor_system.fetchone()
        if row_equipment is None:
            if cursor_system:
                cursor_system.close()
            if cnx_system:
                cnx_system.disconnect()

            if cursor_energy:
                cursor_energy.close()
            if cnx_energy:
                cnx_energy.disconnect()

            if cnx_historical:
                cnx_historical.close()
            if cursor_historical:
                cursor_historical.disconnect()
            raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', description='API.EQUIPMENT_NOT_FOUND')

        equipment = dict()
        equipment['id'] = row_equipment[0]

reports/equipmentload.py 1 location


                              " FROM tbl_equipments "
                              " WHERE id = %s ", (equipment_id,))
        row_equipment = cursor_system.fetchone()
        if row_equipment is None:
            if cursor_system:
                cursor_system.close()
            if cnx_system:
                cnx_system.disconnect()

            if cursor_energy:
                cursor_energy.close()
            if cnx_energy:
                cnx_energy.disconnect()

            if cnx_historical:
                cnx_historical.close()
            if cursor_historical:
                cursor_historical.disconnect()
            raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', description='API.EQUIPMENT_NOT_FOUND')

        equipment = dict()
        equipment['id'] = row_equipment[0]

reports/equipmentoutput.py 1 location


                              " FROM tbl_equipments "
                              " WHERE id = %s ", (equipment_id,))
        row_equipment = cursor_system.fetchone()
        if row_equipment is None:
            if cursor_system:
                cursor_system.close()
            if cnx_system:
                cnx_system.disconnect()

            if cursor_energy:
                cursor_energy.close()
            if cnx_energy:
                cnx_energy.disconnect()

            if cnx_historical:
                cnx_historical.close()
            if cursor_historical:
                cursor_historical.disconnect()
            raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', description='API.EQUIPMENT_NOT_FOUND')

        equipment = dict()
        equipment['id'] = row_equipment[0]

		@@ 137-152 (lines=16) @@
134		" FROM tbl_equipments "
135		" WHERE id = %s ", (equipment_id,))
136		row_equipment = cursor_system.fetchone()
137		if row_equipment is None:
138		if cursor_system:
139		cursor_system.close()
140		if cnx_system:
141		cnx_system.disconnect()
142
143		if cursor_energy:
144		cursor_energy.close()
145		if cnx_energy:
146		cnx_energy.disconnect()
147
148		if cnx_historical:
149		cnx_historical.close()
150		if cursor_historical:
151		cursor_historical.disconnect()
152		raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', description='API.EQUIPMENT_NOT_FOUND')
153
154		equipment = dict()
155		equipment['id'] = row_equipment[0]

		@@ 135-150 (lines=16) @@
132		" FROM tbl_equipments "
133		" WHERE id = %s ", (equipment_id,))
134		row_equipment = cursor_system.fetchone()
135		if row_equipment is None:
136		if cursor_system:
137		cursor_system.close()
138		if cnx_system:
139		cnx_system.disconnect()
140
141		if cursor_energy:
142		cursor_energy.close()
143		if cnx_energy:
144		cnx_energy.disconnect()
145
146		if cnx_historical:
147		cnx_historical.close()
148		if cursor_historical:
149		cursor_historical.disconnect()
150		raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', description='API.EQUIPMENT_NOT_FOUND')
151
152		equipment = dict()
153		equipment['id'] = row_equipment[0]

		@@ 135-150 (lines=16) @@
132		" FROM tbl_equipments "
133		" WHERE id = %s ", (equipment_id,))
134		row_equipment = cursor_system.fetchone()
135		if row_equipment is None:
136		if cursor_system:
137		cursor_system.close()
138		if cnx_system:
139		cnx_system.disconnect()
140
141		if cursor_energy:
142		cursor_energy.close()
143		if cnx_energy:
144		cnx_energy.disconnect()
145
146		if cnx_historical:
147		cnx_historical.close()
148		if cursor_historical:
149		cursor_historical.disconnect()
150		raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', description='API.EQUIPMENT_NOT_FOUND')
151
152		equipment = dict()
153		equipment['id'] = row_equipment[0]

		@@ 135-150 (lines=16) @@
132		" FROM tbl_equipments "
133		" WHERE id = %s ", (equipment_id,))
134		row_equipment = cursor_system.fetchone()
135		if row_equipment is None:
136		if cursor_system:
137		cursor_system.close()
138		if cnx_system:
139		cnx_system.disconnect()
140
141		if cursor_energy:
142		cursor_energy.close()
143		if cnx_energy:
144		cnx_energy.disconnect()
145
146		if cnx_historical:
147		cnx_historical.close()
148		if cursor_historical:
149		cursor_historical.disconnect()
150		raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', description='API.EQUIPMENT_NOT_FOUND')
151
152		equipment = dict()
153		equipment['id'] = row_equipment[0]

		@@ 135-150 (lines=16) @@
132		" FROM tbl_equipments "
133		" WHERE id = %s ", (equipment_id,))
134		row_equipment = cursor_system.fetchone()
135		if row_equipment is None:
136		if cursor_system:
137		cursor_system.close()
138		if cnx_system:
139		cnx_system.disconnect()
140
141		if cursor_energy:
142		cursor_energy.close()
143		if cnx_energy:
144		cnx_energy.disconnect()
145
146		if cnx_historical:
147		cnx_historical.close()
148		if cursor_historical:
149		cursor_historical.disconnect()
150		raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', description='API.EQUIPMENT_NOT_FOUND')
151
152		equipment = dict()
153		equipment['id'] = row_equipment[0]

myems / myems-api

Code Duplication Length = 16-16 lines in 8 locations

reports/equipmentefficiency.py 1 location

reports/equipmentenergyitem.py 1 location

reports/equipmentincome.py 1 location

reports/equipmentenergycategory.py 1 location

reports/equipmentcost.py 1 location

reports/equipmentstatistics.py 1 location

reports/equipmentload.py 1 location

reports/equipmentoutput.py 1 location