def work_add():
#args/input
args = request.form
name = args['name']
content = args['content']
myDB = WEBDB(dbfile, {'logging': 'on', 'type': 'sqlite'})
#add to table_content
content_id = myDB.insertQueryBlob(
'INSERT INTO table_content (content_blob) VALUES (?)', content)
print(content_id)
#add to table_work
sql_work_insert = """
INSERT INTO table_work (name, content_id, createdate, lastdate, active)
VALUES (
\'""" + name + """\',
""" + str(content_id) + """,
datetime(\'now\'),
datetime(\'now\'),
1
)
"""
work_id = myDB.insertQuery(sql_work_insert)
return json.dumps([])
def work_get_all():
myDB = WEBDB(dbfile, {'logging': 'on', 'type': 'sqlite'})
query = """
SELECT id, name, content_id, createdate, lastdate, active
FROM
table_work
"""
results = myDB.executeQueryDict(query)
return json.dumps(results)
def work_delete(id):
myDB = WEBDB(dbfile, {'logging': 'on', 'type': 'sqlite'})
query = """
UPDATE table_work
SET active = 0
WHERE
id = """ + str(id) + """
"""
myDB.updateQuery(query)
return json.dumps([])
def run_main():
myDB = WEBDB(dbfile, {'logging': 'on', 'type': 'sqlite'})
myQuery = """
SELECT *
FROM table_work
"""
results = myDB.executeQueryDict(myQuery)
return render_template('main.html',
title='My Title',
main='My Main',
results=results)
def work_get_all():
myDB = WEBDB(dbfile, {'logging': 'on', 'type': 'sqlite'})
query = """
SELECT name, content_id, createdate, lastdate, active
FROM
table_work
"""
results = myDB.executeQueryDict(query)
return render_template('main.html',
title='My Title',
main='My Main',
results=results)
def work_get(id):
myDB = WEBDB(dbfile, {'logging': 'on', 'type': 'sqlite'})
workquery = """
SELECT w.id, w.name, w.content_id, w.createdate, w.lastdate, w.active, c.content_blob
FROM
table_work w,
table_content c
WHERE
w.content_id = c.id AND
w.id = """ + str(id) + """
"""
results = myDB.executeQueryDict(workquery)
return json.dumps(results)
def main():
#db config
dbfile = 'db/nhldata.db'
myDB = WEBDB(dbfile, {'logging': 'on', 'type': 'sqlite'})
#parser properites config
f = open('properties.json', 'r')
props = json.loads(f.read())
#insertGames only needs to be run once a season to load all games
insertGames(
myDB, '2018',
'https://www.hockey-reference.com/leagues/NHL_2018_games.html', props)
def work_update(id):
args = request.form
name = args['name']
content = args['content']
myDB = WEBDB(dbfile, {'logging': 'on', 'type': 'sqlite'})
#update to table_content
myDB.updateQueryBlob(
'UPDATE table_content SET content_blob=(?) WHERE id=' + str(id),
content)
#update to table_work
sql_work_update = """
UPDATE table_work
SET name ='""" + name + """',
lastdate=datetime(\'now\')
WHERE id = """ + str(id) + """
"""
work_id = myDB.insertQuery(sql_work_update)
return json.dumps([])
def main():
#db config
dbfile = 'db/nhldata.db'
myDB = WEBDB(dbfile, {'logging': 'on', 'type': 'sqlite'})
#parser properites config
f = open('properties.json', 'r')
props = json.loads(f.read())
playerfields = props['playerFields']
goaliefields = props['goalieFields']
#get all unparsed games
games = getGames(myDB, '2018')
for game in games:
id = game['id']
link = game['link']
vteam = game['vteam']
hteam = game['hteam']
print(link)
stats = Boxscore(link, props).getBoxscore()
vplayers = stats['vteam']['players']
hplayers = stats['hteam']['players']
vgoalies = stats['vteam']['goalies']
hgoalies = stats['hteam']['goalies']
for vplayer in vplayers:
insertPlayerStats(myDB, id, vteam, hteam, vplayer, playerfields)
for hplayer in hplayers:
insertPlayerStats(myDB, id, hteam, vteam, hplayer, playerfields)
for vgoalie in vgoalies:
insertGoalieStats(myDB, id, vteam, hteam, vgoalie, goaliefields)
for hgoalie in hgoalies:
insertGoalieStats(myDB, id, hteam, vteam, hgoalie, goaliefields)
updateGameParsed(myDB, id)
time.sleep(2)
def getApp():
#gets the APP object
myDB = WEBDB(dbfile, {'logging': 'on', 'type': 'sqlite'})
myApp = APP(myDB, [])
return myApp
def work_add():
myDB = WEBDB(dbfile, {'logging': 'on', 'type': 'sqlite'})
