CREATE TABLE IF NOT EXISTS
%s (
date DATE NOT NULL,
state VARCHAR(11) NOT NULL,
priority INT,
cumulative_total INT NOT NULL
);
""" % TABLE_NAME
# Connect to and setup db:
db = MySQLdb.connect(host='localhost',
user='******',
passwd=CONFIG.MYSQL_PASSWORD,
db='businessmetrics',
port=3306)
Helper.create_table(db, SCHEMA)
stats = GithubStats()
# Process results from github:
today = date.today()
opened_bugs = defaultdict(lambda: defaultdict(int))
closed_bugs = defaultdict(lambda: defaultdict(int))
for issue in stats.query(date_field='created', query='repo:vector-im/riot-web is:issue label:bug'):
opened = issue.created_at.date()
closed = issue.closed_at.date() if issue.closed_at is not None else today + timedelta(days=1)
for date in [opened + timedelta(days=n)
for n in range((closed - opened).days)]:
SCHEMA = """
CREATE TABLE IF NOT EXISTS
%s (
date DATE NOT NULL,
col VARCHAR(255) NOT NULL,
cardcount INT NOT NULL
);
""" % TABLE_NAME
# Connect to and setup db:
db = MySQLdb.connect(host='localhost',
user='******',
passwd=CONFIG.MYSQL_PASSWORD,
db='businessmetrics',
port=3306)
Helper.create_table(db, SCHEMA)
# Pull stats
counts = ProjectStats.get_column_counts(CONFIG.GITHUB_TOKEN,
'vector-im/riot-web/projects/11',
archived_state={'Done': 'all'})
# Persist stats
cursor = db.cursor()
today = date.today()
clear_today = """
DELETE FROM riotweb_cfd_columns
WHERE `date` = %s
"""
cursor.execute(clear_today, (today, ))
CREATE TABLE IF NOT EXISTS
%s (
date DATE NOT NULL,
state VARCHAR(11) NOT NULL,
priority INT,
bugtotal INT NOT NULL
);
""" % TABLE_NAME
# Connect to and setup db:
db = MySQLdb.connect(host='localhost',
user='******',
passwd=CONFIG.MYSQL_PASSWORD,
db='businessmetrics',
port=3306)
Helper.create_table(db, SCHEMA)
stats = GithubStats()
# Process results from github:
opened_bugs = defaultdict(lambda: defaultdict(int))
closed_bugs = defaultdict(lambda: defaultdict(int))
for issue in stats.query(date_field='created',
query='repo:vector-im/riot-web is:issue label:bug'):
opened_bugs[issue.created_at.date()][Helper.get_priority(issue)] += 1
if issue.closed_at is not None:
closed_bugs[issue.closed_at.date()][Helper.get_priority(issue)] += 1
# Persist to db:
cursor = db.cursor()