roundup-cc: collect_issues.py annotate

annotate collect_issues.py @ 21:7a523e13fcb3

Argpars added for the configuration file.

author	Magnus Schieder <mschieder@intevation.de>
date	Tue, 23 Oct 2018 13:06:16 +0200
parents	3bb3d9a9f1b7
children	10167e40a657 7161ce4e7ab1

rev	line source
1 2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	1 #!/usr/bin/env python3
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	2 """ Fetch issues from a roundup-tracker and save them in a databse.
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	3
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	4 author: Sascha L. Teichmann <sascha.teichmann@intevation.de>
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	5 author: Bernhard Reiter <bernhard@intevation.de>
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	6 author: Sean Engelhardt <sean.engelhardt@intevation.de>
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	7
15 d0c439d1e833 Prepare for tracker entries without priority. Bernhard Reiter <bernhard@intevation.de> parents: 9 diff changeset	8 (c) 2010, 2015, 2018 by Intevation GmbH
1 2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	9
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	10 This is Free Software unter the terms of the
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	11 GNU GENERAL PUBLIC LICENSE Version 3 or later.
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	12 See http://www.gnu.org/licenses/gpl-3.0.txt for details
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	13
17 adca5b3780d2 Add collecting no-prio issues. Restructure. Bernhard Reiter <bernhard@intevation.de> parents: 15 diff changeset	14 For usage see examples/.
1 2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	15 """
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	16
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	17 import http.cookiejar
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	18 import urllib.parse
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	19 import urllib.request
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	20 import csv
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	21 import io
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	22 import sqlite3 as db
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	23 import os
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	24
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	25
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	26 CHECK_ROUNDUP_ORDER = "priority?@action=export_csv&@columns=id,order"
20 3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	27 CHECK_KEYWORD_ORDER = "keyword?@action=export_csv&@columns=id,name"
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	28 CHECK_ROUNDUP_SEARCH_VALUES = "status?@action=export_csv&@columns=id,name&@filter=open&open=1"
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	29 SEARCH_ROUNDUP = "issue?@action=export_csv&@columns=priority&@filter=status,keyword&@pagesize=500&@startwith=0&status={search_values}&keyword={keyword_values}"
1 2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	30
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	31
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	32 def connect_to_server(params, baseurl):
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	33 enc_data = urllib.parse.urlencode(params).encode()
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	34 cj = http.cookiejar.CookieJar()
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	35 opener = urllib.request.build_opener(urllib.request.HTTPCookieProcessor(cj))
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	36 req = urllib.request.Request(url=baseurl, data=enc_data)
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	37 opener.open(req)
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	38 return opener
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	39
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	40
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	41 def get_csv_from_server(opener, roundup_url, sub_url):
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	42 csv_req = urllib.request.Request(url=roundup_url+sub_url)
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	43 f = opener.open(csv_req)
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	44 csv_reader = csv.DictReader(io.TextIOWrapper(f))
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	45 return csv_reader
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	46
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	47
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	48 def check_create_database(database_file, sql_create_db):
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	49 if not os.path.isfile(database_file):
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	50 con = None
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	51 cur = None
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	52 try:
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	53 con = db.connect(database_file)
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	54 cur = con.cursor()
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	55 try:
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	56 cur.execute(sql_create_db)
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	57 con.commit()
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	58 os.chmod(database_file, 0o644)
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	59 except:
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	60 con.rollback()
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	61 raise
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	62 finally:
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	63 if cur:
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	64 cur.close()
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	65 if con:
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	66 con.close()
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	67
20 3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	68 def get_keyword_ids(opener, baseurl, keywords):
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	69 if keywords == [""]:
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	70 return ""
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	71
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	72 keywords_csv = get_csv_from_server(opener, baseurl, CHECK_KEYWORD_ORDER)
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	73 keywords_dict = {}
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	74 for x in keywords_csv:
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	75 keywords_dict[x["name"]] = x["id"]
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	76
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	77 keywords_ids = []
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	78 for x in keywords:
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	79 keywords_ids.append(keywords_dict[x])
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	80
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	81 return ",".join(keywords_ids)
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	82
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	83 def get_status_ids(opener, baseurl, status):
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	84
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	85 status_csv = get_csv_from_server(opener, baseurl, CHECK_ROUNDUP_SEARCH_VALUES)
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	86
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	87 if status == [""]:
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	88 return ""
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	89
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	90 status_dict = {}
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	91 for x in status_csv:
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	92 status_dict[x["name"]] = x["id"]
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	93
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	94 staus_ids = ["-1"]
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	95 for x in status:
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	96 staus_ids.append(status_dict[x])
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	97
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	98 return ",".join(staus_ids)
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	99
1 2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	100
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	101 def issues_to_quantities(issue_csv, columns, orders_csv):
15 d0c439d1e833 Prepare for tracker entries without priority. Bernhard Reiter <bernhard@intevation.de> parents: 9 diff changeset	102 """Count issues per priority.
1 2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	103
15 d0c439d1e833 Prepare for tracker entries without priority. Bernhard Reiter <bernhard@intevation.de> parents: 9 diff changeset	104 Returns: a list of ints, containing how often a prio occurred [:-1]
d0c439d1e833 Prepare for tracker entries without priority. Bernhard Reiter <bernhard@intevation.de> parents: 9 diff changeset	105 in order of the priorities, with the last being the "None" prio
d0c439d1e833 Prepare for tracker entries without priority. Bernhard Reiter <bernhard@intevation.de> parents: 9 diff changeset	106 """
d0c439d1e833 Prepare for tracker entries without priority. Bernhard Reiter <bernhard@intevation.de> parents: 9 diff changeset	107
d0c439d1e833 Prepare for tracker entries without priority. Bernhard Reiter <bernhard@intevation.de> parents: 9 diff changeset	108 quantities = [0] * (len(columns) +1)
1 2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	109 order_dict = {}
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	110
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	111 #convert the csv-dict reader to real dict
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	112 for row in orders_csv:
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	113 order_dict[row["id"]] = int(float(row["order"])) # int(float()) because the order-value is indeed "1.0, 2.0" etc
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	114
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	115 for issue in issue_csv:
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	116 priority = issue["priority"]
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	117
2 3e9f4a6803d1 replaced funtion with string.isdigit. sean parents: 1 diff changeset	118 if priority.isdigit() == True :
1 2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	119 quantities[order_dict[priority] -1 ] += 1
15 d0c439d1e833 Prepare for tracker entries without priority. Bernhard Reiter <bernhard@intevation.de> parents: 9 diff changeset	120 else: # no priority set
d0c439d1e833 Prepare for tracker entries without priority. Bernhard Reiter <bernhard@intevation.de> parents: 9 diff changeset	121 quantities[-1] += 1
1 2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	122
15 d0c439d1e833 Prepare for tracker entries without priority. Bernhard Reiter <bernhard@intevation.de> parents: 9 diff changeset	123 # print("quantities : " + str(quantities))
1 2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	124
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	125 return quantities
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	126
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	127
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	128 def save_issues_to_db(quantities, database_file, sql_create_db, sql_insert_in_db):
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	129 check_create_database(database_file, sql_create_db)
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	130
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	131 cur = None
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	132 con = None
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	133
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	134 try:
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	135 con = db.connect(database_file)
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	136 cur = con.cursor()
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	137 try:
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	138 cur.execute(sql_insert_in_db, quantities)
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	139 con.commit()
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	140 except:
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	141 con.rollback()
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	142 raise
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	143 finally:
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	144 if cur:
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	145 cur.close()
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	146 if con:
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	147 con.close()
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	148
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	149
20 3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	150 def save_stats_in_db(login_parmeters, baseurl, db_file, columns, sql_create_db, sql_insert_in_db, keywords, status, include_no_prio=False):
1 2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	151 try:
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	152
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	153 opener = connect_to_server(login_parmeters, baseurl)
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	154
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	155 order_csv = get_csv_from_server(opener, baseurl, CHECK_ROUNDUP_ORDER)
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	156
20 3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	157 keywords_ids_url = get_keyword_ids(opener, baseurl, keywords)
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	158
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	159 status_ids_url = get_status_ids(opener, baseurl, status)
3bb3d9a9f1b7 Filter by keywords and states. Magnus Schieder <mschieder@intevation.de> parents: 17 diff changeset	160 formated_search_url = SEARCH_ROUNDUP.format(search_values=status_ids_url, keyword_values=keywords_ids_url)
1 2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	161
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	162 current_issues_csv = get_csv_from_server(opener, baseurl, formated_search_url)
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	163
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	164 opener.close()
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	165
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	166 quantities = issues_to_quantities(current_issues_csv, columns, order_csv)
15 d0c439d1e833 Prepare for tracker entries without priority. Bernhard Reiter <bernhard@intevation.de> parents: 9 diff changeset	167 if not include_no_prio:
d0c439d1e833 Prepare for tracker entries without priority. Bernhard Reiter <bernhard@intevation.de> parents: 9 diff changeset	168 quantities = quantities[:-1]
1 2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	169
9 e95f7bee8643 Really safe data. Bernhard Reiter <bernhard@intevation.de> parents: 2 diff changeset	170 save_issues_to_db(quantities, db_file, sql_create_db, sql_insert_in_db)
1 2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	171
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	172 except urllib.error.URLError as e:
2df45f6ecd81 new appereance (solid and dotted lines), resonsive layout, new legend, sean parents: diff changeset	173 print("No Valid Connection to server : " + baseurl + "\nerror: " + str(e))

Mercurial > roundup-cc

annotate collect_issues.py @ 21:7a523e13fcb3