excelexporters.spacestatistics.export() - Code Metrics - Inspection of "Merge branch 'develop'" - myems/myems-api - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( e592d8...f72fc8 )

by Guangyu

created 2021-02-08 07:32 UTC

excelexporters.spacestatistics.export() B

↳ Parent: excelexporters.spacestatistics

Complexity

Conditions

Size

Total Lines	39
Code Lines	25

Duplication

Lines	39
Ratio	100 %

Importance

Changes

Metric	Value
cc	5
eloc	25
nop	5
dl	39
loc	39
rs	8.8133
c	0
b	0
f	0

import base64
import uuid
import os
from openpyxl.chart import (
        PieChart,
        BarChart,
        Reference,
    )
from openpyxl.styles import PatternFill, Border, Side, Alignment, Font
from openpyxl.drawing.image import Image
from openpyxl import Workbook
from openpyxl.chart.label import DataLabelList

####################################################################################################################
# PROCEDURES
# Step 1: Validate the report data
# Step 2: Generate excel file
# Step 3: Encode the excel file bytes to Base64
####################################################################################################################


def export(report,

           name,
           reporting_start_datetime_local,
           reporting_end_datetime_local,
           period_type):
    ####################################################################################################################
    # Step 1: Validate the report data
    ####################################################################################################################
    if report is None:
        return None
    print(report)

    ####################################################################################################################
    # Step 2: Generate excel file from the report data
    ####################################################################################################################
    filename = generate_excel(report,
                              name,
                              reporting_start_datetime_local,
                              reporting_end_datetime_local,
                              period_type)
    ####################################################################################################################
    # Step 3: Encode the excel file to Base64
    ####################################################################################################################
    try:
        with open(filename, 'rb') as binary_file:
            binary_file_data = binary_file.read()
    except IOError as ex:
        pass

    # Base64 encode the bytes
    base64_encoded_data = base64.b64encode(binary_file_data)

    # get the Base64 encoded data using human-readable characters.
    base64_message = base64_encoded_data.decode('utf-8')
    # delete the file from server
    try:
        os.remove(filename)
    except NotImplementedError as ex:
        pass
    return base64_message


def generate_excel(report,
                   name,
                   reporting_start_datetime_local,
                   reporting_end_datetime_local,
                   period_type):

    wb = Workbook()

    filename = str(uuid.uuid4()) + '.xlsx'
    wb.save(filename)

    return filename


1		import base64
2		import uuid
3		import os
4		from openpyxl.chart import (
5		PieChart,
6		BarChart,
7		Reference,
8		)
9		from openpyxl.styles import PatternFill, Border, Side, Alignment, Font
10		from openpyxl.drawing.image import Image
11		from openpyxl import Workbook
12		from openpyxl.chart.label import DataLabelList
13
14		####################################################################################################################
15		# PROCEDURES
16		# Step 1: Validate the report data
17		# Step 2: Generate excel file
18		# Step 3: Encode the excel file bytes to Base64
19		####################################################################################################################
20
21
22	View Code Duplication	def export(report,
		0 ignored issues – show Duplication introduced 2021-02-08 07:34 UTC by Report Bug Copy Issue Report This code seems to be duplicated in your project. Loading history...
23		name,
24		reporting_start_datetime_local,
25		reporting_end_datetime_local,
26		period_type):
27		####################################################################################################################
28		# Step 1: Validate the report data
29		####################################################################################################################
30		if report is None:
31		return None
32		print(report)
33
34		####################################################################################################################
35		# Step 2: Generate excel file from the report data
36		####################################################################################################################
37		filename = generate_excel(report,
38		name,
39		reporting_start_datetime_local,
40		reporting_end_datetime_local,
41		period_type)
42		####################################################################################################################
43		# Step 3: Encode the excel file to Base64
44		####################################################################################################################
45		try:
46		with open(filename, 'rb') as binary_file:
47		binary_file_data = binary_file.read()
48		except IOError as ex:
49		pass
50
51		# Base64 encode the bytes
52		base64_encoded_data = base64.b64encode(binary_file_data)
		0 ignored issues – show introduced 2021-02-08 07:34 UTC by Report Bug Copy Issue Report The variable `binary_file_data` does not seem to be defined for all execution paths. Loading history...
53		# get the Base64 encoded data using human-readable characters.
54		base64_message = base64_encoded_data.decode('utf-8')
55		# delete the file from server
56		try:
57		os.remove(filename)
58		except NotImplementedError as ex:
59		pass
60		return base64_message
61
62
63		def generate_excel(report,
64		name,
65		reporting_start_datetime_local,
66		reporting_end_datetime_local,
67		period_type):
68
69		wb = Workbook()
70
71		filename = str(uuid.uuid4()) + '.xlsx'
72		wb.save(filename)
73
74		return filename
75

myems / myems-api

Push — master ( e592d8...f72fc8 )

excelexporters.spacestatistics.export() B

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like