report maker adder
diff --git a/.gitignore b/.gitignore
index db4561e..768d135 100644
--- a/.gitignore
+++ b/.gitignore
@@ -52,3 +52,4 @@
# PyBuilder
target/
+.idea/
\ No newline at end of file
diff --git a/config.py b/config.py
new file mode 100644
index 0000000..f6867ac
--- /dev/null
+++ b/config.py
@@ -0,0 +1,7 @@
+EMAIL = "xxx2@gmail.com"
+PASSWORD = "yyyy"
+DOCUMENT_ID = "1Xvd0aHA7mr-_b5C3b-sQ66BQsJiOGIT2UesP7kG26oU"
+SHEET_NAME = ""
+WORK_SHEET = "Worksheet"
+COL_COUNT = 2
+DEFAULT_FILE_PATH="test.json"
\ No newline at end of file
diff --git a/make_report.py b/make_report.py
new file mode 100644
index 0000000..8a8a0d0
--- /dev/null
+++ b/make_report.py
@@ -0,0 +1,31 @@
+import gspread
+import argparse
+import json
+
+from config import DEFAULT_FILE_PATH, PASSWORD, EMAIL, COL_COUNT, WORK_SHEET, DOCUMENT_ID
+
+
+def load_data(file_name):
+ with open(file_name) as f:
+ data = f.read()
+ return json.loads(data)
+
+
+def make_report(data):
+ gc = gspread.login(EMAIL, PASSWORD)
+ sh = gc.open_by_key(DOCUMENT_ID)
+ worksheet = sh.add_worksheet(title=WORK_SHEET, rows=len(data.keys()), cols=COL_COUNT)
+
+ i = 1
+ for k in data.keys():
+ worksheet.update_cell(i, 1, k)
+ worksheet.update_cell(i, 2, data[k])
+ i += 1
+
+
+if __name__ == '__main__':
+ parser = argparse.ArgumentParser()
+ parser.add_argument('-n', '--name', help='data file path', default=DEFAULT_FILE_PATH)
+ results = parser.parse_args()
+ data = load_data(results.name)
+ make_report(data)
diff --git a/requirements.txt b/requirements.txt
new file mode 100644
index 0000000..bedadd8
--- /dev/null
+++ b/requirements.txt
@@ -0,0 +1,3 @@
+argparse==1.2.1
+gspread==0.2.2
+wsgiref==0.1.2