alt/echl15-16/echl15-16.py

   1 #!/usr/bin/env python
   2 # -*- coding: utf-8 -*-
   3
   4 import sqlite3
   5 import sys
   6 import os
   7 import re
   8
   9 leaguename = "ECHL"
  10 getforday = "24"
  11 getformonth = "10"
  12 getforyear = "2015"
  13
  14 print("Creating "+leaguename+" Database.")
  15
  16 if (len(sys.argv) == 0):
  17     sqlcon = sqlite3.connect("./echl15-16.db3")
  18 if (len(sys.argv) > 0):
  19     sqlcon = sqlite3.connect(sys.argv[1])
  20 sqlcur = sqlcon.cursor()
  21
  22 sqlcon.execute("PRAGMA encoding = \"UTF-8\";")
  23 sqlcon.execute("PRAGMA auto_vacuum = 1;")
  24 sqlcon.execute("PRAGMA foreign_keys = 1;")
  25
  26
  27 def GetLastTenGames(sqldatacon, teamname):
  28     global leaguename
  29     wins = 0
  30     losses = 0
  31     otlosses = 0
  32     getlastninegames = sqldatacon[0].execute("SELECT NumberPeriods, TeamWin FROM "+leaguename+"Games WHERE (HomeTeam=\""+str(
  33         teamname)+"\" OR AwayTeam=\""+str(teamname)+"\") ORDER BY id DESC LIMIT 10").fetchall()
  34     nmax = len(getlastninegames)
  35     nmin = 0
  36     while (nmin < nmax):
  37         if (teamname == str(getlastninegames[nmin][1])):
  38             wins = wins + 1
  39         if (teamname != str(getlastninegames[nmin][1])):
  40             if (int(getlastninegames[nmin][0]) == 3):
  41                 losses = losses + 1
  42             if (int(getlastninegames[nmin][0]) > 3):
  43                 otlosses = otlosses + 1
  44         nmin = nmin + 1
  45     return str(wins)+":"+str(losses)+":"+str(otlosses)
  46
  47
  48 def UpdateTeamData(sqldatacon, teamid, dataname, addtodata, addtype):
  49     global leaguename
  50     if (addtype == "="):
  51         TMPData = addtodata
  52     if (addtype == "+"):
  53         TMPData = int(sqldatacon[0].execute("SELECT "+dataname+" FROM " +
  54                       leaguename+"Teams WHERE id="+str(teamid)).fetchone()[0]) + addtodata
  55     if (addtype == "-"):
  56         TMPData = int(sqldatacon[0].execute("SELECT "+dataname+" FROM " +
  57                       leaguename+"Teams WHERE id="+str(teamid)).fetchone()[0]) - addtodata
  58     sqldatacon[0].execute("UPDATE "+leaguename+"Teams SET " +
  59                           dataname+"="+str(TMPData)+" WHERE id="+str(teamid))
  60     return int(TMPData)
  61
  62
  63 def UpdateTeamDataString(sqldatacon, teamid, dataname, newdata):
  64     global leaguename
  65     sqldatacon[0].execute("UPDATE "+leaguename+"Teams SET " +
  66                           dataname+"=\""+str(newdata)+"\" WHERE id="+str(teamid))
  67     return True
  68
  69
  70 def GetTeamData(sqldatacon, teamid, dataname, datatype):
  71     global leaguename
  72     if (datatype == "float"):
  73         TMPData = float(sqldatacon[0].execute(
  74             "SELECT "+dataname+" FROM "+leaguename+"Teams WHERE id="+str(teamid)).fetchone()[0])
  75     if (datatype == "int"):
  76         TMPData = int(sqldatacon[0].execute(
  77             "SELECT "+dataname+" FROM "+leaguename+"Teams WHERE id="+str(teamid)).fetchone()[0])
  78     if (datatype == "str"):
  79         TMPData = str(sqldatacon[0].execute(
  80             "SELECT "+dataname+" FROM "+leaguename+"Teams WHERE id="+str(teamid)).fetchone()[0])
  81     return TMPData
  82
  83
  84 def UpdateGameData(sqldatacon, gameid, dataname, addtodata, addtype):
  85     global leaguename
  86     if (addtype == "="):
  87         TMPData = addtodata
  88     if (addtype == "+"):
  89         TMPData = int(sqldatacon[0].execute("SELECT "+dataname+" FROM " +
  90                       leaguename+"Games WHERE id="+str(gameid)).fetchone()[0]) + addtodata
  91     if (addtype == "-"):
  92         TMPData = int(sqldatacon[0].execute("SELECT "+dataname+" FROM " +
  93                       leaguename+"Games WHERE id="+str(gameid)).fetchone()[0]) - addtodata
  94     sqldatacon[0].execute("UPDATE "+leaguename+"Games SET " +
  95                           dataname+"="+str(TMPData)+" WHERE id="+str(gameid))
  96     return int(TMPData)
  97
  98
  99 def UpdateGameDataString(sqldatacon, gameid, dataname, newdata):
 100     global leaguename
 101     sqldatacon[0].execute("UPDATE "+leaguename+"Games SET " +
 102                           dataname+"=\""+str(newdata)+"\" WHERE id="+str(gameid))
 103     return True
 104
 105
 106 def GetGameData(sqldatacon, gameid, dataname, datatype):
 107     global leaguename
 108     if (datatype == "float"):
 109         TMPData = float(sqldatacon[0].execute(
 110             "SELECT "+dataname+" FROM "+leaguename+"Games WHERE id="+str(gameid)).fetchone()[0])
 111     if (datatype == "int"):
 112         TMPData = int(sqldatacon[0].execute(
 113             "SELECT "+dataname+" FROM "+leaguename+"Games WHERE id="+str(gameid)).fetchone()[0])
 114     if (datatype == "str"):
 115         TMPData = str(sqldatacon[0].execute(
 116             "SELECT "+dataname+" FROM "+leaguename+"Games WHERE id="+str(gameid)).fetchone()[0])
 117     return TMPData
 118
 119
 120 def UpdateArenaData(sqldatacon, arenaid, dataname, addtodata, addtype):
 121     global leaguename
 122     if (addtype == "="):
 123         TMPData = addtodata
 124     if (addtype == "+"):
 125         TMPData = int(sqldatacon[0].execute("SELECT "+dataname+" FROM " +
 126                       leaguename+"Arenas WHERE id="+str(arenaid)).fetchone()[0]) + addtodata
 127     if (addtype == "-"):
 128         TMPData = int(sqldatacon[0].execute("SELECT "+dataname+" FROM " +
 129                       leaguename+"Arenas WHERE id="+str(arenaid)).fetchone()[0]) - addtodata
 130     sqldatacon[0].execute("UPDATE "+leaguename+"Arenas SET " +
 131                           dataname+"="+str(TMPData)+" WHERE id="+str(arenaid))
 132     return int(TMPData)
 133
 134
 135 def UpdateArenaDataString(sqldatacon, arenaid, dataname, newdata):
 136     global leaguename
 137     sqldatacon[0].execute("UPDATE "+leaguename+"Arenas SET " +
 138                           dataname+"=\""+str(newdata)+"\" WHERE id="+str(arenaid))
 139     return True
 140
 141
 142 def GetArenaData(sqldatacon, arenaid, dataname, datatype):
 143     global leaguename
 144     if (datatype == "float"):
 145         TMPData = float(sqldatacon[0].execute(
 146             "SELECT "+dataname+" FROM "+leaguename+"Arenas WHERE id="+str(arenaid)).fetchone()[0])
 147     if (datatype == "int"):
 148         TMPData = int(sqldatacon[0].execute(
 149             "SELECT "+dataname+" FROM "+leaguename+"Arenas WHERE id="+str(arenaid)).fetchone()[0])
 150     if (datatype == "str"):
 151         TMPData = str(sqldatacon[0].execute(
 152             "SELECT "+dataname+" FROM "+leaguename+"Arenas WHERE id="+str(arenaid)).fetchone()[0])
 153     return TMPData
 154
 155
 156 def UpdateConferenceData(sqldatacon, conference, dataname, addtodata, addtype):
 157     global leaguename
 158     if (addtype == "="):
 159         TMPData = addtodata
 160     if (addtype == "+"):
 161         TMPData = int(sqldatacon[0].execute("SELECT "+dataname+" FROM "+leaguename +
 162                       "Conferences WHERE Conference=\""+str(conference)+"\"").fetchone()[0]) + addtodata
 163     if (addtype == "-"):
 164         TMPData = int(sqldatacon[0].execute("SELECT "+dataname+" FROM "+leaguename +
 165                       "Conferences WHERE Conference=\""+str(conference)+"\"").fetchone()[0]) - addtodata
 166     sqldatacon[0].execute("UPDATE "+leaguename+"Conferences SET "+dataname +
 167                           "="+str(TMPData)+" WHERE Conference=\""+str(conference)+"\"")
 168     return int(TMPData)
 169
 170
 171 def UpdateDivisionData(sqldatacon, division, dataname, addtodata, addtype):
 172     global leaguename
 173     if (addtype == "="):
 174         TMPData = addtodata
 175     if (addtype == "+"):
 176         TMPData = int(sqldatacon[0].execute("SELECT "+dataname+" FROM "+leaguename +
 177                       "Divisions WHERE Division=\""+str(division)+"\"").fetchone()[0]) + addtodata
 178     if (addtype == "-"):
 179         TMPData = int(sqldatacon[0].execute("SELECT "+dataname+" FROM "+leaguename +
 180                       "Divisions WHERE Division=\""+str(division)+"\"").fetchone()[0]) - addtodata
 181     sqldatacon[0].execute("UPDATE "+leaguename+"Divisions SET " +
 182                           dataname+"="+str(TMPData)+" WHERE Division=\""+str(division)+"\"")
 183     return int(TMPData)
 184
 185
 186 print("Creating "+leaguename+" Conference Table.")
 187 print("Inserting "+leaguename+" Conference Data.")
 188
 189 sqlcon.execute("DROP TABLE IF EXISTS "+leaguename+"Conferences")
 190 sqlcur.execute("CREATE TABLE "+leaguename +
 191                "Conferences(id INTEGER PRIMARY KEY, Conference TEXT, NumberOfTeams INTEGER)")
 192 sqlcon.commit()
 193
 194
 195 def MakeHockeyConferences(sqldatacon, conference):
 196     global leaguename
 197     print("Conference Name: "+conference)
 198     print(" ")
 199     sqldatacon[0].execute("INSERT INTO "+leaguename +
 200                           "Conferences(Conference, NumberOfTeams) VALUES(\""+str(conference)+"\", 0)")
 201     return True
 202
 203
 204 MakeHockeyConferences((sqlcur, sqlcon), "Eastern")
 205 MakeHockeyConferences((sqlcur, sqlcon), "Western")
 206 sqlcon.commit()
 207
 208 print("Creating "+leaguename+" Division Table.")
 209 print("Inserting "+leaguename+" Division Data.")
 210
 211 sqlcon.execute("DROP TABLE IF EXISTS "+leaguename+"Divisions")
 212 sqlcur.execute("CREATE TABLE "+leaguename +
 213                "Divisions(id INTEGER PRIMARY KEY, Division TEXT, Conference TEXT, NumberOfTeams INTEGER)")
 214 sqlcon.commit()
 215
 216
 217 def MakeHockeyDivisions(sqldatacon, division, conference):
 218     global leaguename
 219     print("Conference Name: "+conference)
 220     print("Division Name: "+division)
 221     print(" ")
 222     sqldatacon[0].execute("INSERT INTO "+leaguename+"Divisions(Division, Conference, NumberOfTeams) VALUES(\"" +
 223                           str(division)+"\", \""+str(conference)+"\", 0)")
 224     return True
 225
 226
 227 MakeHockeyDivisions((sqlcur, sqlcon), "East", "Eastern")
 228 MakeHockeyDivisions((sqlcur, sqlcon), "North", "Eastern")
 229 MakeHockeyDivisions((sqlcur, sqlcon), "South", "Eastern")
 230 MakeHockeyDivisions((sqlcur, sqlcon), "Midwest", "Western")
 231 MakeHockeyDivisions((sqlcur, sqlcon), "Central", "Western")
 232 MakeHockeyDivisions((sqlcur, sqlcon), "West", "Western")
 233
 234 print("Creating "+leaguename+" Team Table.")
 235 print("Inserting "+leaguename+" Team Data.")
 236
 237 sqlcon.execute("DROP TABLE IF EXISTS "+leaguename+"Arenas")
 238 sqlcur.execute("CREATE TABLE "+leaguename +
 239                "Arenas(id INTEGER PRIMARY KEY, CityName TEXT, AreaName TEXT, FullCityName TEXT, ArenaName TEXT, FullArenaName TEXT, GamesPlayed INTEGER)")
 240 sqlcon.commit()
 241
 242 sqlcon.execute("DROP TABLE IF EXISTS "+leaguename+"Teams")
 243 sqlcur.execute("CREATE TABLE "+leaguename+"Teams(id INTEGER PRIMARY KEY, Date INTEGER, FullName TEXT, CityName TEXT, TeamPrefix TEXT, AreaName TEXT, FullCityName TEXT, TeamName TEXT, Conference TEXT, Division TEXT, ArenaName TEXT, FullArenaName TEXT, Affiliates TEXT, GamesPlayed INTEGER, GamesPlayedHome INTEGER, GamesPlayedAway INTEGER, Wins INTEGER, OTWins INTEGER, SOWins INTEGER, OTSOWins INTEGER, TWins INTEGER, Losses INTEGER, OTLosses INTEGER, SOLosses INTEGER, OTSOLosses INTEGER, TLosses INTEGER, ROW INTEGER, ROT INTEGER, ShutoutWins INTEGER, ShutoutLosses INTEGER, HomeRecord TEXT, AwayRecord TEXT, Shootouts TEXT, GoalsFor INTEGER, GoalsAgainst INTEGER, GoalsDifference INTEGER, SOGFor INTEGER, SOGAgainst INTEGER, SOGDifference INTEGER, ShotsBlockedFor INTEGER, ShotsBlockedAgainst INTEGER, ShotsBlockedDifference INTEGER, Points INTEGER, PCT REAL, LastTen TEXT, Streak TEXT)")
 244 sqlcon.execute("DROP TABLE IF EXISTS "+leaguename+"Stats")
 245 sqlcur.execute("CREATE TABLE "+leaguename+"Stats(id INTEGER PRIMARY KEY, TeamID  INTEGER, Date INTEGER, FullName TEXT, CityName TEXT, TeamPrefix TEXT, AreaName TEXT, FullCityName TEXT, TeamName TEXT, Conference TEXT, Division TEXT, ArenaName TEXT, FullArenaName TEXT, Affiliates TEXT, GamesPlayed INTEGER, GamesPlayedHome INTEGER, GamesPlayedAway INTEGER, Wins INTEGER, OTWins INTEGER, SOWins INTEGER, OTSOWins INTEGER, TWins INTEGER, Losses INTEGER, OTLosses INTEGER, SOLosses INTEGER, OTSOLosses INTEGER, TLosses INTEGER, ROW INTEGER, ROT INTEGER, ShutoutWins INTEGER, ShutoutLosses INTEGER, HomeRecord TEXT, AwayRecord TEXT, Shootouts TEXT, GoalsFor INTEGER, GoalsAgainst INTEGER, GoalsDifference INTEGER, SOGFor INTEGER, SOGAgainst INTEGER, SOGDifference INTEGER, ShotsBlockedFor INTEGER, ShotsBlockedAgainst INTEGER, ShotsBlockedDifference INTEGER, Points INTEGER, PCT REAL, LastTen TEXT, Streak TEXT)")
 246 sqlcon.commit()
 247
 248
 249 def MakeHockeyTeams(sqldatacon, cityname, areaname, teamname, conference, division, arenaname, teamnameprefix, teamaffiliates):
 250     global leaguename
 251     print("Team Name: "+teamname)
 252     print("Arena Name: "+arenaname)
 253     print("City Name: "+cityname)
 254     print("Full City Name: "+cityname+", "+areaname)
 255     print("Full Name: "+teamnameprefix+" "+teamname)
 256     print("Conference: "+conference)
 257     print("Division: "+division)
 258     print(" ")
 259     sqldatacon[0].execute("INSERT INTO "+leaguename+"Teams(Date, FullName, CityName, TeamPrefix, AreaName, FullCityName, TeamName, Conference, Division, ArenaName, FullArenaName, Affiliates, GamesPlayed, GamesPlayedHome, GamesPlayedAway, Wins, OTWins, SOWins, OTSOWins, TWins, Losses, OTLosses, SOLosses, OTSOLosses, TLosses, ROW, ROT, ShutoutWins, ShutoutLosses, HomeRecord, AwayRecord, Shootouts, GoalsFor, GoalsAgainst, GoalsDifference, SOGFor, SOGAgainst, SOGDifference, ShotsBlockedFor, ShotsBlockedAgainst, ShotsBlockedDifference, Points, PCT, LastTen, Streak) VALUES(\"20151001\", \"" +
 260                           str(teamnameprefix+" "+teamname)+"\", \""+str(cityname)+"\", \""+str(teamnameprefix)+"\", \""+str(areaname)+"\", \""+str(cityname+", "+areaname)+"\", \""+str(teamname)+"\", \""+str(conference)+"\", \""+str(division)+"\", \""+str(arenaname)+"\", \""+str(arenaname+", "+cityname)+"\", \""+str(teamaffiliates)+"\", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, \"0:0:0\", \"0:0:0\", \"0:0\", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, \"0:0:0\", \"None\")")
 261     sqldatacon[0].execute("INSERT INTO "+leaguename+"Stats (TeamID, Date, FullName, CityName, TeamPrefix, AreaName, FullCityName, TeamName, Conference, Division, ArenaName, FullArenaName, Affiliates, GamesPlayed, GamesPlayedHome, GamesPlayedAway, Wins, OTWins, SOWins, OTSOWins, TWins, Losses, OTLosses, SOLosses, OTSOLosses, TLosses, ROW, ROT, ShutoutWins, ShutoutLosses, HomeRecord, AwayRecord, Shootouts, GoalsFor, GoalsAgainst, GoalsDifference, SOGFor, SOGAgainst, SOGDifference, ShotsBlockedFor, ShotsBlockedAgainst, ShotsBlockedDifference, Points, PCT, LastTen, Streak) SELECT id, Date, FullName, CityName, TeamPrefix, AreaName, FullCityName, TeamName, Conference, Division, ArenaName, FullArenaName, Affiliates, GamesPlayed, GamesPlayedHome, GamesPlayedAway, Wins, OTWins, SOWins, OTSOWins, TWins, Losses, OTLosses, SOLosses, OTSOLosses, TLosses, ROW, ROT, ShutoutWins, ShutoutLosses, HomeRecord, AwayRecord, Shootouts, GoalsFor, GoalsAgainst, GoalsDifference, SOGFor, SOGAgainst, SOGDifference, ShotsBlockedFor, ShotsBlockedAgainst, ShotsBlockedDifference, Points, PCT, LastTen, Streak FROM "+leaguename+"Teams WHERE FullName=\""+teamnameprefix+" "+teamname+"\";")
 262     sqldatacon[0].execute("INSERT INTO "+leaguename+"Arenas(CityName, AreaName, FullCityName, ArenaName, FullArenaName, GamesPlayed) VALUES(\""+str(
 263         cityname)+"\", \""+str(areaname)+"\", \""+str(cityname+", "+areaname)+"\", \""+str(arenaname)+"\", \""+str(arenaname+", "+cityname)+"\", 0)")
 264     UpdateConferenceData((sqlcur, sqlcon), conference, "NumberOfTeams", 1, "+")
 265     UpdateDivisionData((sqlcur, sqlcon), division, "NumberOfTeams", 1, "+")
 266     return True
 267
 268
 269 def MakeHockeyArena(sqldatacon, cityname, areaname, arenaname, teamnameprefix):
 270     global leaguename
 271     print("Arena Name: "+arenaname)
 272     print("City Name: "+cityname)
 273     print("Full City Name: "+cityname+", "+areaname)
 274     print(" ")
 275     sqldatacon[0].execute("INSERT INTO "+leaguename+"Arenas(CityName, AreaName, FullCityName, ArenaName, FullArenaName, GamesPlayed) VALUES(\""+str(
 276         cityname)+"\", \""+str(areaname)+"\", \""+str(cityname+", "+areaname)+"\", \""+str(arenaname)+"\", \""+str(arenaname+", "+cityname)+"\", 0)")
 277     return True
 278
 279
 280 print("Inserting "+leaguename+" Teams From Eastern Conference.")
 281 print("Inserting "+leaguename+" Teams From East Division.\n")
 282 MakeHockeyTeams((sqlcur, sqlcon), "Elmira", "NY", "Jackals", "Eastern", "East",
 283                 "First Arena", "Elmira", "AHL:Rochester Americans,NHL:Buffalo Sabres ")
 284 MakeHockeyTeams((sqlcur, sqlcon), "Reading", "PA", "Royals", "Eastern", "East",
 285                 "Santander Arena", "Reading", "AHL:Lehigh Valley Phantoms,NHL:Philadelphia Flyers")
 286 MakeHockeyTeams((sqlcur, sqlcon), "Norfolk", "VA", "Admirals", "Eastern", "East",
 287                 "Norfolk Scope", "Norfolk", "AHL:Bakersfield Condors,NHL:Edmonton Oilers")
 288 MakeHockeyTeams((sqlcur, sqlcon), "Glens Falls", "NY", "Thunder", "Eastern", "East",
 289                 "Glens Falls Civic Center", "Adirondack", "AHL:Stockton Heat,NHL:Calgary Flames")
 290 MakeHockeyTeams((sqlcur, sqlcon), "Manchester", "NH", "Monarchs", "Eastern", "East",
 291                 "Verizon Wireless Arena", "Manchester", "AHL:Ontario Reign,NHL:Los Angeles Kings")
 292
 293 print("Inserting "+leaguename+" Teams From North Division.\n")
 294 MakeHockeyTeams((sqlcur, sqlcon), "Kalamazoo", "MI", "Wings", "Eastern", "North",
 295                 "Wings Event Center", "Kalamazoo", "AHL:Lake Erie Monsters,NHL:Columbus Blue Jackets")
 296 MakeHockeyTeams((sqlcur, sqlcon), "Toledo", "OH", "Walleye", "Eastern", "North",
 297                 "Huntington Center", "Toledo", "AHL:Grand Rapids Griffins,NHL:Detroit Red Wings")
 298 MakeHockeyTeams((sqlcur, sqlcon), "Wheeling", "WV", "Nailers", "Eastern", "North",
 299                 "WesBanco Arena", "Wheeling", "AHL:Wilkes-Barre/Scranton Penguins,NHL:Pittsburgh Penguins")
 300 MakeHockeyTeams((sqlcur, sqlcon), "Brampton", "ON", "Beast", "Eastern", "North",
 301                 "Powerade Centre", "Brampton", "AHL:St. John's IceCaps,NHL:Montreal Canadiens")
 302
 303 print("Inserting "+leaguename+" Teams From South Division.\n")
 304 MakeHockeyTeams((sqlcur, sqlcon), "Duluth", "GA", "Gladiators", "Eastern", "South",
 305                 "Infinite Energy Arena", "Atlanta", "AHL:Providence Bruins,NHL:Boston Bruins")
 306 MakeHockeyTeams((sqlcur, sqlcon), "Greenville", "SC", "Swamp Rabbits", "Eastern", "South",
 307                 "Bon Secours Wellness Arena", "Greenville", "AHL:Hartford Wolf Pack,NHL:New York Rangers")
 308 MakeHockeyTeams((sqlcur, sqlcon), "Estero", "FL", "Everblades", "Eastern", "South",
 309                 "Germain Arena", "Florida", "AHL:Charlotte Checkers,NHL:Carolina Hurricanes")
 310 MakeHockeyTeams((sqlcur, sqlcon), "Orlando", "FL", "Solar Bears", "Eastern", "South",
 311                 "Amway Center", "Orlando", "AHL:Toronto Marlies,NHL:Toronto Maple Leafs")
 312 MakeHockeyTeams((sqlcur, sqlcon), "North Charleston", "SC", "Stingrays", "Eastern", "South",
 313                 "North Charleston Coliseum", "South Carolina", "AHL:Hershey Bears,NHL:Washington Capitals")
 314
 315 print("Inserting "+leaguename+" Teams From Western Conference.")
 316 print("Inserting "+leaguename+" Teams From Midwest Division.\n")
 317 MakeHockeyTeams((sqlcur, sqlcon), "Moline", "IL", "Mallards", "Western", "Midwest",
 318                 "iWireless Center", "Quad City", "AHL:Iowa Wild,NHL:Minnesota Wild")
 319 MakeHockeyTeams((sqlcur, sqlcon), "Evansville", "IN", "IceMen", "Western", "Midwest",
 320                 "Ford Center", "Evansville", "AHL:Binghamton Senators,NHL:Ottawa Senators")
 321 MakeHockeyTeams((sqlcur, sqlcon), "Indianapolis", "IN", "Fuel", "Western", "Midwest",
 322                 "Indiana Farmers Coliseum", "Indy", "AHL:Rockford IceHogs,NHL:Chicago Blackhawks")
 323 MakeHockeyTeams((sqlcur, sqlcon), "Fort Wayne", "IN", "Komets", "Western", "Midwest",
 324                 "Allen County War Memorial Coliseum", "Fort Wayne", "AHL:San Antonio Rampage,NHL:Colorado Avalanche")
 325 MakeHockeyTeams((sqlcur, sqlcon), "Cincinnati", "OH", "Cyclones", "Western", "Midwest",
 326                 "US Bank Arena", "Cincinnati", "AHL:Milwaukee Admirals,NHL:Nashville Predators")
 327
 328 print("Inserting "+leaguename+" Teams From Central Division.\n")
 329 MakeHockeyTeams((sqlcur, sqlcon), "Wichita", "KS", "Thunder", "Western",
 330                 "Central", "Intrust Bank Arena", "Wichita", "AHL:None,NHL:None")
 331 MakeHockeyTeams((sqlcur, sqlcon), "Allen", "TX", "Americans", "Western", "Central",
 332                 "Allen Event Center", "Allen", "AHL:San Jose Barracuda,NHL:San Jose Sharks")
 333 MakeHockeyTeams((sqlcur, sqlcon), "Tulsa", "OK", "Oilers", "Western",
 334                 "Central", "BOK Center", "Tulsa", "AHL:Manitoba Moose,NHL:Winnipeg Jets")
 335 MakeHockeyTeams((sqlcur, sqlcon), "Independence", "MO", "Mavericks", "Western", "Central",
 336                 "Silverstein Eye Centers Arena", "Missouri", "AHL:Bridgeport Sound Tigers,NHL:New York Islanders")
 337
 338 print("Inserting "+leaguename+" Teams From West Division.\n")
 339 MakeHockeyTeams((sqlcur, sqlcon), "Anchorage", "AK", "Aces", "Western",
 340                 "West", "Sullivan Arena", "Alaska", "AHL:None,NHL:None")
 341 MakeHockeyTeams((sqlcur, sqlcon), "Boise", "ID", "Steelheads", "Western",
 342                 "West", "CenturyLink Arena", "Idaho", "AHL:Texas Stars,NHL:Dallas Stars")
 343 MakeHockeyTeams((sqlcur, sqlcon), "West Valley City", "UT", "Grizzlies", "Western",
 344                 "West", "Maverik Center", "Utah", "AHL:San Diego Gulls,NHL:Anaheim Ducks")
 345 MakeHockeyTeams((sqlcur, sqlcon), "Loveland", "CO", "Eagles", "Western",
 346                 "West", "Budweiser Events Center", "Colorado", "AHL:None,NHL:None")
 347 MakeHockeyTeams((sqlcur, sqlcon), "Rapid City", "SD", "Rush", "Western", "West",
 348                 "Rushmore Plaza Civic Center", "Rapid City", "AHL:Springfield Falcons,NHL:Arizona Coyotes")
 349
 350 sqlcon.commit()
 351
 352
 353 def GetNum2Team(sqldatacon, TeamNum, ReturnVar):
 354     global leaguename
 355     return str(sqldatacon[0].execute("SELECT "+ReturnVar+" FROM "+leaguename+"Teams WHERE id="+str(TeamNum)).fetchone()[0])
 356
 357
 358 def GetTeam2Num(sqldatacon, TeamName):
 359     global leaguename
 360     return int(sqldatacon[0].execute("SELECT id FROM "+leaguename+"Teams WHERE FullName=\""+str(TeamName)+"\"").fetchone()[0])
 361
 362
 363 def GetNum2Arena(sqldatacon, ArenaNum, ReturnVar):
 364     global leaguename
 365     return str(sqldatacon[0].execute("SELECT "+ReturnVar+" FROM "+leaguename+"Arenas WHERE id="+str(ArenaNum)).fetchone()[0])
 366
 367
 368 def GetArena2Num(sqldatacon, ArenaName):
 369     global leaguename
 370     return int(sqldatacon[0].execute("SELECT id FROM "+leaguename+"Arenas WHERE FullArenaName=\""+str(ArenaName)+"\"").fetchone()[0])
 371
 372
 373 print("DONE! All Team Data Inserted.")
 374
 375 print("Creating "+leaguename+" Game Table.")
 376
 377 sqlcon.execute("DROP TABLE IF EXISTS "+leaguename+"Games")
 378 sqlcur.execute("CREATE TABLE "+leaguename+"Games(id INTEGER PRIMARY KEY, Date INTEGER, HomeTeam Text, AwayTeam Text, AtArena Text, TeamScorePeriods TEXT, TeamFullScore Text, ShotsOnGoal TEXT, FullShotsOnGoal TEXT, ShotsBlocked TEXT, FullShotsBlocked TEXT, NumberPeriods INTEGER, TeamWin Text, IsPlayOffGame INTEGER)")
 379 sqlcon.commit()
 380
 381
 382 def MakeHockeyGame(sqldatacon, date, hometeam, awayteam, periodsscore, shotsongoal, atarena, isplayoffgame):
 383     global leaguename
 384     isplayoffgsql = "0"
 385     if (isplayoffgame == True):
 386         isplayoffgsql = "1"
 387     if (isplayoffgame == False):
 388         isplayoffsql = "0"
 389     periodssplit = periodsscore.split(",")
 390     periodcounting = 0
 391     numberofperiods = int(len(periodssplit))
 392     homescore = 0
 393     awayscore = 0
 394     homeperiodscore = ""
 395     awayperiodscore = ""
 396     while (periodcounting < numberofperiods):
 397         periodscoresplit = periodssplit[periodcounting].split(":")
 398         homeperiodscore = homeperiodscore+" "+str(periodscoresplit[0])
 399         awayperiodscore = awayperiodscore+" "+str(periodscoresplit[1])
 400         if (periodcounting <= 3):
 401             homescore = homescore + int(periodscoresplit[0])
 402             awayscore = awayscore + int(periodscoresplit[1])
 403         if (isplayoffgame == True and periodcounting > 3):
 404             homescore = homescore + int(periodscoresplit[0])
 405             awayscore = awayscore + int(periodscoresplit[1])
 406         if (isplayoffgame == False and periodcounting > 3):
 407             if (periodscoresplit[0] > periodscoresplit[1]):
 408                 homescore = homescore + 1
 409             if (periodscoresplit[0] < periodscoresplit[1]):
 410                 awayscore = awayscore + 1
 411         periodcounting = periodcounting + 1
 412     totalscore = str(homescore)+":"+str(awayscore)
 413     teamscores = totalscore.split(":")
 414     shotsongoalsplit = shotsongoal.split(",")
 415     periodssplits = periodsscore.split(",")
 416     numberofsogperiods = int(len(shotsongoalsplit))
 417     periodsogcounting = 0
 418     homesog = 0
 419     awaysog = 0
 420     hometsb = 0
 421     awaytsb = 0
 422     sbstr = ""
 423     homeperiodsog = ""
 424     awayperiodsog = ""
 425     while (periodsogcounting < numberofsogperiods):
 426         periodsogsplit = shotsongoalsplit[periodsogcounting].split(":")
 427         periodscoresplit = periodssplits[periodsogcounting].split(":")
 428         homesog = homesog + int(periodsogsplit[0])
 429         homesb = int(periodsogsplit[0]) - int(periodscoresplit[0])
 430         hometsb = homesb + hometsb
 431         awaysog = awaysog + int(periodsogsplit[1])
 432         awaysb = int(periodsogsplit[1]) - int(periodscoresplit[1])
 433         awaytsb = awaysb + awaytsb
 434         sbstr = sbstr+str(homesb)+":"+str(awaysb)+" "
 435         periodsogcounting = periodsogcounting + 1
 436     sbstr = sbstr.rstrip()
 437     sbstr = sbstr.replace(" ", ",")
 438     tsbstr = str(hometsb)+":"+str(awaytsb)
 439     totalsog = str(homesog)+":"+str(awaysog)
 440     teamssog = totalsog.split(":")
 441     hometeamname = hometeam
 442     hometeam = GetTeam2Num(sqldatacon, hometeam)
 443     awayteamname = awayteam
 444     awayteam = GetTeam2Num(sqldatacon, awayteam)
 445     if (atarena == 0):
 446         atarena = hometeam
 447         atarenaname = GetTeamData(sqldatacon, hometeam, "FullArenaName", "str")
 448     if (isinstance(atarena, int) and atarena > 0):
 449         atarenaname = GetNum2Arena(sqldatacon, atarena, "FullArenaName")
 450     if (isinstance(atarena, str)):
 451         atarenaname = atarena
 452         atarena = GetArena2Num(sqldatacon, atarenaname)
 453     print("Home Arena: "+str(atarenaname))
 454     print("Home Team: "+GetNum2Team(sqldatacon, int(hometeam), "FullName"))
 455     print("Home Period Scores:"+homeperiodscore)
 456     print("Home Score: "+str(teamscores[0]))
 457     print("Away Team: "+GetNum2Team(sqldatacon, int(awayteam), "FullName"))
 458     print("Away Period Scores:"+awayperiodscore)
 459     print("Away Score: "+str(teamscores[1]))
 460     print("Number Of Periods: "+str(numberofperiods))
 461     if (teamscores[0] > teamscores[1]):
 462         print("Winning Team: "+GetNum2Team(sqldatacon, int(hometeam), "FullName"))
 463         print("Losing Team: "+GetNum2Team(sqldatacon, int(awayteam), "FullName"))
 464         losingteam = awayteam
 465         winningteam = hometeam
 466         winningteamname = hometeamname
 467         losingteamname = awayteamname
 468     if (teamscores[0] < teamscores[1]):
 469         print("Winning Team: "+GetNum2Team(sqldatacon, int(awayteam), "FullName"))
 470         print("Losing Team: "+GetNum2Team(sqldatacon, int(hometeam), "FullName"))
 471         losingteam = hometeam
 472         winningteam = awayteam
 473         winningteamname = awayteamname
 474         losingteamname = hometeamname
 475     print(" ")
 476     sqldatacon[0].execute("INSERT INTO "+leaguename+"Games(Date, HomeTeam, AwayTeam, AtArena, TeamScorePeriods, TeamFullScore, ShotsOnGoal, FullShotsOnGoal, ShotsBlocked, FullShotsBlocked, NumberPeriods, TeamWin, IsPlayOffGame) VALUES("+str(date)+", \""+str(hometeamname)+"\", \""+str(
 477         awayteamname)+"\", \""+str(atarenaname)+"\", \""+str(periodsscore)+"\", \""+str(totalscore)+"\", \""+str(shotsongoal)+"\", \""+str(totalsog)+"\", \""+str(sbstr)+"\", \""+str(tsbstr)+"\", "+str(numberofperiods)+", \""+str(winningteamname)+"\", "+str(isplayoffgsql)+")")
 478     UpdateArenaData(sqldatacon, atarena, "GamesPlayed", 1, "+")
 479     UpdateTeamData(sqldatacon, hometeam, "Date", int(date), "=")
 480     UpdateTeamData(sqldatacon, hometeam, "GamesPlayed", 1, "+")
 481     UpdateTeamData(sqldatacon, hometeam, "GamesPlayedHome", 1, "+")
 482     UpdateTeamData(sqldatacon, hometeam, "GoalsFor", int(teamscores[0]), "+")
 483     UpdateTeamData(sqldatacon, hometeam, "GoalsAgainst",
 484                    int(teamscores[1]), "+")
 485     UpdateTeamData(sqldatacon, hometeam, "GoalsDifference",
 486                    int(int(teamscores[0]) - int(teamscores[1])), "+")
 487     UpdateTeamData(sqldatacon, hometeam, "SOGFor", int(teamssog[0]), "+")
 488     UpdateTeamData(sqldatacon, hometeam, "SOGAgainst", int(teamssog[1]), "+")
 489     UpdateTeamData(sqldatacon, hometeam, "SOGDifference",
 490                    int(int(teamssog[0]) - int(teamssog[1])), "+")
 491     UpdateTeamData(sqldatacon, hometeam, "ShotsBlockedFor", int(hometsb), "+")
 492     UpdateTeamData(sqldatacon, hometeam,
 493                    "ShotsBlockedAgainst", int(awaytsb), "+")
 494     UpdateTeamData(sqldatacon, hometeam, "ShotsBlockedDifference",
 495                    int(int(hometsb) - int(awaytsb)), "+")
 496     UpdateTeamData(sqldatacon, awayteam, "Date", int(date), "=")
 497     UpdateTeamData(sqldatacon, awayteam, "GamesPlayed", 1, "+")
 498     UpdateTeamData(sqldatacon, awayteam, "GamesPlayedAway", 1, "+")
 499     UpdateTeamData(sqldatacon, awayteam, "GoalsFor", int(teamscores[1]), "+")
 500     UpdateTeamData(sqldatacon, awayteam, "GoalsAgainst",
 501                    int(teamscores[0]), "+")
 502     UpdateTeamData(sqldatacon, awayteam, "GoalsDifference",
 503                    int(int(teamscores[1]) - int(teamscores[0])), "+")
 504     UpdateTeamData(sqldatacon, awayteam, "SOGFor", int(teamssog[1]), "+")
 505     UpdateTeamData(sqldatacon, awayteam, "SOGAgainst", int(teamssog[0]), "+")
 506     UpdateTeamData(sqldatacon, awayteam, "SOGDifference",
 507                    int(int(teamssog[1]) - int(teamssog[0])), "+")
 508     UpdateTeamData(sqldatacon, awayteam, "ShotsBlockedFor", int(awaytsb), "+")
 509     UpdateTeamData(sqldatacon, awayteam,
 510                    "ShotsBlockedAgainst", int(hometsb), "+")
 511     UpdateTeamData(sqldatacon, awayteam, "ShotsBlockedDifference",
 512                    int(int(awaytsb) - int(hometsb)), "+")
 513     if (winningteam == hometeam and int(teamscores[1]) == 0):
 514         UpdateTeamData(sqldatacon, hometeam, "ShutoutWins", 1, "+")
 515         UpdateTeamData(sqldatacon, awayteam, "ShutoutLosses", 1, "+")
 516     if (winningteam == awayteam and int(teamscores[0]) == 0):
 517         UpdateTeamData(sqldatacon, awayteam, "ShutoutWins", 1, "+")
 518         UpdateTeamData(sqldatacon, hometeam, "ShutoutLosses", 1, "+")
 519     UpdateTeamDataString(sqldatacon, winningteam, "LastTen",
 520                          GetLastTenGames(sqldatacon, winningteamname))
 521     UpdateTeamDataString(sqldatacon, losingteam, "LastTen",
 522                          GetLastTenGames(sqldatacon, losingteamname))
 523     GetWinningStreak = GetTeamData(sqldatacon, winningteam, "Streak", "str")
 524     GetWinningStreakNext = "Won 1"
 525     if (GetWinningStreak != "None"):
 526         GetWinningStreakSplit = re.findall(
 527             "([a-zA-Z]+) ([0-9]+)", GetWinningStreak)
 528         if (GetWinningStreakSplit[0][0] == "Won"):
 529             GetWinningStreakNext = "Won " + \
 530                 str(int(GetWinningStreakSplit[0][1]) + 1)
 531         if (GetWinningStreakSplit[0][0] == "Lost"):
 532             GetWinningStreakNext = "Won 1"
 533         if (GetWinningStreakSplit[0][0] == "OT"):
 534             GetWinningStreakNext = "Won 1"
 535     UpdateTeamDataString(sqldatacon, winningteam,
 536                          "Streak", GetWinningStreakNext)
 537     GetLosingStreak = GetTeamData(sqldatacon, losingteam, "Streak", "str")
 538     if (numberofperiods == 3):
 539         GetLosingStreakNext = "Lost 1"
 540     if (numberofperiods > 3):
 541         GetLosingStreakNext = "OT 1"
 542     if (GetLosingStreak != "None"):
 543         GetLosingStreakSplit = re.findall(
 544             "([a-zA-Z]+) ([0-9]+)", GetLosingStreak)
 545         if (GetLosingStreakSplit[0][0] == "Won"):
 546             if (numberofperiods == 3):
 547                 GetLosingStreakNext = "Lost 1"
 548             if (numberofperiods > 3):
 549                 GetLosingStreakNext = "OT 1"
 550         if (GetLosingStreakSplit[0][0] == "Lost"):
 551             if (numberofperiods == 3):
 552                 GetLosingStreakNext = "Lost " + \
 553                     str(int(GetLosingStreakSplit[0][1]) + 1)
 554             if (numberofperiods > 3):
 555                 GetLosingStreakNext = "OT 1"
 556         if (GetLosingStreakSplit[0][0] == "OS"):
 557             if (numberofperiods == 3):
 558                 GetLosingStreakNext = "Lost 1"
 559             if (numberofperiods > 3):
 560                 GetLosingStreakNext = "OT " + \
 561                     str(int(GetLosingStreakSplit[0][1]) + 1)
 562     UpdateTeamDataString(sqldatacon, losingteam, "Streak", GetLosingStreakNext)
 563     if ((isplayoffgame == False and numberofperiods < 5) or (isplayoffgame == True)):
 564         UpdateTeamData(sqldatacon, winningteam, "ROW", 1, "+")
 565         UpdateTeamData(sqldatacon, losingteam, "ROT", 1, "+")
 566     if (numberofperiods == 3):
 567         UpdateTeamData(sqldatacon, winningteam, "Wins", 1, "+")
 568         UpdateTeamData(sqldatacon, winningteam, "TWins", 1, "+")
 569         UpdateTeamData(sqldatacon, winningteam, "Points", 2, "+")
 570         UpdateTeamData(sqldatacon, losingteam, "Losses", 1, "+")
 571         UpdateTeamData(sqldatacon, losingteam, "TLosses", 1, "+")
 572         UpdateTeamData(sqldatacon, losingteam, "Points", 0, "+")
 573         if (winningteam == hometeam):
 574             HomeTeamRecord = GetTeamData(
 575                 sqldatacon, winningteam, "HomeRecord", "str")
 576             HTRSpit = [int(n) for n in HomeTeamRecord.split(":")]
 577             NewHTR = str(HTRSpit[0] + 1)+":" + \
 578                 str(HTRSpit[1])+":"+str(HTRSpit[2])
 579             UpdateTeamDataString(sqldatacon, winningteam, "HomeRecord", NewHTR)
 580             AwayTeamRecord = GetTeamData(
 581                 sqldatacon, losingteam, "AwayRecord", "str")
 582             ATRSpit = [int(n) for n in AwayTeamRecord.split(":")]
 583             NewATR = str(ATRSpit[0])+":" + \
 584                 str(ATRSpit[1] + 1)+":"+str(ATRSpit[2])
 585             UpdateTeamDataString(sqldatacon, losingteam, "AwayRecord", NewATR)
 586         if (losingteam == hometeam):
 587             HomeTeamRecord = GetTeamData(
 588                 sqldatacon, winningteam, "AwayRecord", "str")
 589             HTRSpit = [int(n) for n in HomeTeamRecord.split(":")]
 590             NewHTR = str(HTRSpit[0] + 1)+":" + \
 591                 str(HTRSpit[1])+":"+str(HTRSpit[2])
 592             UpdateTeamDataString(sqldatacon, winningteam, "AwayRecord", NewHTR)
 593             AwayTeamRecord = GetTeamData(
 594                 sqldatacon, losingteam, "HomeRecord", "str")
 595             ATRSpit = [int(n) for n in AwayTeamRecord.split(":")]
 596             NewATR = str(ATRSpit[0])+":" + \
 597                 str(ATRSpit[1] + 1)+":"+str(ATRSpit[2])
 598             UpdateTeamDataString(sqldatacon, losingteam, "HomeRecord", NewATR)
 599     if (numberofperiods > 3):
 600         if ((numberofperiods == 4 and isplayoffgame == False) or (numberofperiods > 4 and isplayoffgame == True)):
 601             UpdateTeamData(sqldatacon, winningteam, "OTWins", 1, "+")
 602         UpdateTeamData(sqldatacon, winningteam, "OTSOWins", 1, "+")
 603         UpdateTeamData(sqldatacon, winningteam, "TWins", 1, "+")
 604         UpdateTeamData(sqldatacon, winningteam, "Points", 2, "+")
 605         if ((numberofperiods == 4 and isplayoffgame == False) or (numberofperiods > 4 and isplayoffgame == True)):
 606             UpdateTeamData(sqldatacon, losingteam, "OTLosses", 1, "+")
 607         UpdateTeamData(sqldatacon, losingteam, "OTSOLosses", 1, "+")
 608         UpdateTeamData(sqldatacon, losingteam, "TLosses", 1, "+")
 609         UpdateTeamData(sqldatacon, losingteam, "Points", 1, "+")
 610         if (winningteam == hometeam):
 611             HomeTeamRecord = GetTeamData(
 612                 sqldatacon, winningteam, "HomeRecord", "str")
 613             HTRSpit = [int(n) for n in HomeTeamRecord.split(":")]
 614             NewHTR = str(HTRSpit[0] + 1)+":" + \
 615                 str(HTRSpit[1])+":"+str(HTRSpit[2])
 616             UpdateTeamDataString(sqldatacon, winningteam, "HomeRecord", NewHTR)
 617             AwayTeamRecord = GetTeamData(
 618                 sqldatacon, losingteam, "AwayRecord", "str")
 619             ATRSpit = [int(n) for n in AwayTeamRecord.split(":")]
 620             NewATR = str(ATRSpit[0])+":"+str(ATRSpit[1]) + \
 621                 ":"+str(ATRSpit[2] + 1)
 622             UpdateTeamDataString(sqldatacon, losingteam, "AwayRecord", NewATR)
 623         if (losingteam == hometeam):
 624             HomeTeamRecord = GetTeamData(
 625                 sqldatacon, winningteam, "AwayRecord", "str")
 626             HTRSpit = [int(n) for n in HomeTeamRecord.split(":")]
 627             NewHTR = str(HTRSpit[0] + 1)+":" + \
 628                 str(HTRSpit[1])+":"+str(HTRSpit[2])
 629             UpdateTeamDataString(sqldatacon, winningteam, "AwayRecord", NewHTR)
 630             AwayTeamRecord = GetTeamData(
 631                 sqldatacon, losingteam, "HomeRecord", "str")
 632             ATRSpit = [int(n) for n in AwayTeamRecord.split(":")]
 633             NewATR = str(ATRSpit[0])+":"+str(ATRSpit[1]) + \
 634                 ":"+str(ATRSpit[2] + 1)
 635             UpdateTeamDataString(sqldatacon, losingteam, "HomeRecord", NewATR)
 636     if (isplayoffgame == False and numberofperiods > 4):
 637         UpdateTeamData(sqldatacon, winningteam, "SOWins", 1, "+")
 638         UpdateTeamData(sqldatacon, losingteam, "SOLosses", 1, "+")
 639         WinningTeamShootouts = GetTeamData(
 640             sqldatacon, winningteam, "Shootouts", "str")
 641         WTSoSplit = [int(n) for n in WinningTeamShootouts.split(":")]
 642         NewWTSo = str(WTSoSplit[0] + 1)+":"+str(WTSoSplit[1])
 643         UpdateTeamDataString(sqldatacon, winningteam, "Shootouts", NewWTSo)
 644         LosingTeamShootouts = GetTeamData(
 645             sqldatacon, losingteam, "Shootouts", "str")
 646         LTSoSplit = [int(n) for n in LosingTeamShootouts.split(":")]
 647         NewLTSo = str(LTSoSplit[0])+":"+str(LTSoSplit[1] + 1)
 648         UpdateTeamDataString(sqldatacon, losingteam, "Shootouts", NewLTSo)
 649     HomeOTLossesPCT = float("%.2f" % float(float(
 650         0.5) * float(GetTeamData((sqlcur, sqlcon), hometeam, "OTSOLosses", "float"))))
 651     HomeWinsPCT = float("%.3f" % float(float(GetTeamData((sqlcur, sqlcon), hometeam, "TWins", "float") +
 652                         HomeOTLossesPCT) / float(GetTeamData((sqlcur, sqlcon), hometeam, "GamesPlayed", "float"))))
 653     AwayOTLossesPCT = float("%.2f" % float(float(
 654         0.5) * float(GetTeamData((sqlcur, sqlcon), awayteam, "OTSOLosses", "float"))))
 655     AwayWinsPCT = float("%.3f" % float(float(GetTeamData((sqlcur, sqlcon), awayteam, "TWins", "float") +
 656                         AwayOTLossesPCT) / float(GetTeamData((sqlcur, sqlcon), awayteam, "GamesPlayed", "float"))))
 657     UpdateTeamData(sqldatacon, hometeam, "PCT", HomeWinsPCT, "=")
 658     UpdateTeamData(sqldatacon, awayteam, "PCT", AwayWinsPCT, "=")
 659     sqldatacon[1].commit()
 660     sqldatacon[0].execute("INSERT INTO "+leaguename+"Stats (TeamID, Date, FullName, CityName, TeamPrefix, AreaName, FullCityName, TeamName, Conference, Division, ArenaName, FullArenaName, Affiliates, GamesPlayed, GamesPlayedHome, GamesPlayedAway, Wins, OTWins, SOWins, OTSOWins, TWins, Losses, OTLosses, SOLosses, OTSOLosses, TLosses, ROW, ROT, ShutoutWins, ShutoutLosses, HomeRecord, AwayRecord, Shootouts, GoalsFor, GoalsAgainst, GoalsDifference, SOGFor, SOGAgainst, SOGDifference, ShotsBlockedFor, ShotsBlockedAgainst, ShotsBlockedDifference, Points, PCT, LastTen, Streak) SELECT id, Date, FullName, CityName, TeamPrefix, AreaName, FullCityName, TeamName, Conference, Division, ArenaName, FullArenaName, Affiliates, GamesPlayed, GamesPlayedHome, GamesPlayedAway, Wins, OTWins, SOWins, OTSOWins, TWins, Losses, OTLosses, SOLosses, OTSOLosses, TLosses, ROW, ROT, ShutoutWins, ShutoutLosses, HomeRecord, AwayRecord, Shootouts, GoalsFor, GoalsAgainst, GoalsDifference, SOGFor, SOGAgainst, SOGDifference, ShotsBlockedFor, ShotsBlockedAgainst, ShotsBlockedDifference, Points, PCT, LastTen, Streak FROM "+leaguename+"Teams WHERE FullName=\""+hometeamname+"\";")
 661     sqldatacon[0].execute("INSERT INTO "+leaguename+"Stats (TeamID, Date, FullName, CityName, TeamPrefix, AreaName, FullCityName, TeamName, Conference, Division, ArenaName, FullArenaName, Affiliates, GamesPlayed, GamesPlayedHome, GamesPlayedAway, Wins, OTWins, SOWins, OTSOWins, TWins, Losses, OTLosses, SOLosses, OTSOLosses, TLosses, ROW, ROT, ShutoutWins, ShutoutLosses, HomeRecord, AwayRecord, Shootouts, GoalsFor, GoalsAgainst, GoalsDifference, SOGFor, SOGAgainst, SOGDifference, ShotsBlockedFor, ShotsBlockedAgainst, ShotsBlockedDifference, Points, PCT, LastTen, Streak) SELECT id, Date, FullName, CityName, TeamPrefix, AreaName, FullCityName, TeamName, Conference, Division, ArenaName, FullArenaName, Affiliates, GamesPlayed, GamesPlayedHome, GamesPlayedAway, Wins, OTWins, SOWins, OTSOWins, TWins, Losses, OTLosses, SOLosses, OTSOLosses, TLosses, ROW, ROT, ShutoutWins, ShutoutLosses, HomeRecord, AwayRecord, Shootouts, GoalsFor, GoalsAgainst, GoalsDifference, SOGFor, SOGAgainst, SOGDifference, ShotsBlockedFor, ShotsBlockedAgainst, ShotsBlockedDifference, Points, PCT, LastTen, Streak FROM "+leaguename+"Teams WHERE FullName=\""+awayteamname+"\";")
 662     sqldatacon[1].commit()
 663     return True
 664
 665
 666 print("Inserting "+leaguename+" Game Data From 10/7/2015.\n")
 667 MakeHockeyGame((sqlcur, sqlcon), 20151007, "Indy Fuel",
 668                "Fort Wayne Komets", "2:0,0:1,1:0", "16:9,10:10,7:10", 0, False)
 669 MakeHockeyGame((sqlcur, sqlcon), 20151007, "Cincinnati Cyclones",
 670                "Wheeling Nailers", "0:1,2:0,4:0", "9:6,8:5,18:7", 0, False)
 671
 672 print("Inserting "+leaguename+" Game Data From 10/9/2015.\n")
 673 MakeHockeyGame((sqlcur, sqlcon), 20151009, "Elmira Jackals",
 674                "Reading Royals", "1:1,3:1,1:0", "8:12,8:10,12:7", 0, False)
 675 MakeHockeyGame((sqlcur, sqlcon), 20151009, "South Carolina Stingrays",
 676                "Greenville Swamp Rabbits", "0:1,0:2,0:2", "6:7,7:9,7:8", 0, False)
 677 MakeHockeyGame((sqlcur, sqlcon), 20151009, "Toledo Walleye",
 678                "Kalamazoo Wings", "1:0,2:0,0:0", "9:8,12:9,12:6", 0, False)
 679 MakeHockeyGame((sqlcur, sqlcon), 20151009, "Florida Everblades",
 680                "Orlando Solar Bears", "1:0,1:0,0:2,1:0", "15:6,11:8,9:13,1:0", 0, False)
 681 MakeHockeyGame((sqlcur, sqlcon), 20151009, "Wheeling Nailers",
 682                "Cincinnati Cyclones", "2:1,0:3,0:0", "6:9,11:9,12:7", 0, False)
 683 MakeHockeyGame((sqlcur, sqlcon), 20151009, "Fort Wayne Komets",
 684                "Evansville IceMen", "2:2,2:2,2:1", "15:11,13:10,14:13", 0, False)
 685 MakeHockeyGame((sqlcur, sqlcon), 20151009, "Colorado Eagles",
 686                "Rapid City Rush", "1:0,0:0,2:0", "13:7,9:5,14:7", 0, False)
 687 MakeHockeyGame((sqlcur, sqlcon), 20151009, "Idaho Steelheads",
 688                "Utah Grizzlies", "3:2,1:0,3:1", "7:6,10:10,8:7", 0, False)
 689
 690 print("Inserting "+leaguename+" Game Data From 10/10/2015.\n")
 691 MakeHockeyGame((sqlcur, sqlcon), 20151010, "Wichita Thunder",
 692                "Allen Americans", "4:1,1:1,2:0", "12:15,6:10,15:11", 0, False)
 693 MakeHockeyGame((sqlcur, sqlcon), 20151010, "Adirondack Thunder",
 694                "Manchester Monarchs", "0:1,4:2,0:1,0:1", "13:9,12:6,5:11,1:2", 0, False)
 695 MakeHockeyGame((sqlcur, sqlcon), 20151010, "Florida Everblades",
 696                "Orlando Solar Bears", "1:0,0:2,1:0,0:1", "8:8,8:13,13:7,1:8", 0, False)
 697 MakeHockeyGame((sqlcur, sqlcon), 20151010, "Kalamazoo Wings",
 698                "Toledo Walleye", "0:1,1:1,0:0", "6:9,8:6,15:7", 0, False)
 699 MakeHockeyGame((sqlcur, sqlcon), 20151010, "Reading Royals",
 700                "Norfolk Admirals", "1:2,3:1,1:1", "12:15,9:13,10:4", 0, False)
 701 MakeHockeyGame((sqlcur, sqlcon), 20151010, "South Carolina Stingrays",
 702                "Atlanta Gladiators", "0:1,0:3,0:0", "4:8,8:13,6:6", 0, False)
 703 MakeHockeyGame((sqlcur, sqlcon), 20151010, "Fort Wayne Komets",
 704                "Evansville IceMen", "2:1,1:0,3:1", "10:10,7:10,20:6", 0, False)
 705 MakeHockeyGame((sqlcur, sqlcon), 20151010, "Utah Grizzlies",
 706                "Idaho Steelheads", "1:3,1:0,1:1", "12:14,17:8,9:5", 0, False)
 707 MakeHockeyGame((sqlcur, sqlcon), 20151010, "Rapid City Rush",
 708                "Colorado Eagles", "0:2,1:1,2:2", "10:9,6:15,7:5", 0, False)
 709
 710 print("Inserting "+leaguename+" Game Data From 10/11/2015.\n")
 711 MakeHockeyGame((sqlcur, sqlcon), 20151011, "Indy Fuel",
 712                "Quad City Mallards", "1:0,1:0,1:0", "11:7,7:6,7:7", 0, False)
 713 MakeHockeyGame((sqlcur, sqlcon), 20151011, "Manchester Monarchs",
 714                "Adirondack Thunder", "1:0,1:2,0:0,0:1", "11:9,5:7,8:7,1:3", 0, False)
 715 MakeHockeyGame((sqlcur, sqlcon), 20151011, "Atlanta Gladiators",
 716                "Greenville Swamp Rabbits", "0:2,2:1,2:2", "5:8,14:8,7:8", 0, False)
 717
 718 print("Inserting "+leaguename+" Game Data From 10/12/2015.\n")
 719 MakeHockeyGame((sqlcur, sqlcon), 20151012, "Alaska Aces",
 720                "Missouri Mavericks", "1:1,1:2,0:2", "7:9,9:14,10:7", 0, False)
 721
 722 print("Inserting "+leaguename+" Game Data From 10/13/2015.\n")
 723 MakeHockeyGame((sqlcur, sqlcon), 20151013, "Alaska Aces",
 724                "Missouri Mavericks", "0:1,1:0,2:0", "9:12,11:5,8:9", 0, False)
 725
 726 print("Inserting "+leaguename+" Game Data From 10/16/2015.\n")
 727 MakeHockeyGame((sqlcur, sqlcon), 20151016, "Manchester Monarchs",
 728                "Brampton Beast", "0:0,0:1,2:0", "10:8,12:5,11:11", 0, False)
 729 MakeHockeyGame((sqlcur, sqlcon), 20151016, "Elmira Jackals",
 730                "Adirondack Thunder", "0:1,0:1,1:2", "10:6,8:12,12:8", 0, False)
 731 MakeHockeyGame((sqlcur, sqlcon), 20151016, "Kalamazoo Wings",
 732                "Fort Wayne Komets", "0:1,2:1,1:3", "10:8,18:10,9:7", 0, False)
 733 MakeHockeyGame((sqlcur, sqlcon), 20151016, "Norfolk Admirals",
 734                "Wheeling Nailers", "0:0,0:1,0:2", "10:9,6:20,7:8", 0, False)
 735 MakeHockeyGame((sqlcur, sqlcon), 20151016, "Florida Everblades",
 736                "Atlanta Gladiators", "3:1,0:0,0:2,1:0", "10:9,7:10,13:12,1:1", 0, False)
 737 MakeHockeyGame((sqlcur, sqlcon), 20151016, "Indy Fuel", "Toledo Walleye",
 738                "2:2,0:0,0:0,0:0,1:0", "8:7,4:11,10:11,1:2,1:0", 0, False)
 739 MakeHockeyGame((sqlcur, sqlcon), 20151016, "Tulsa Oilers",
 740                "Wichita Thunder", "0:0,0:2,2:1", "9:4,3:13,12:7", 0, False)
 741 MakeHockeyGame((sqlcur, sqlcon), 20151016, "Allen Americans",
 742                "Quad City Mallards", "0:1,0:1,1:0", "11:9,12:12,11:3", 0, False)
 743 MakeHockeyGame((sqlcur, sqlcon), 20151016, "Colorado Eagles",
 744                "Utah Grizzlies", "1:0,0:2,2:1,0:1", "6:10,13:8,17:10,5:2", 0, False)
 745 MakeHockeyGame((sqlcur, sqlcon), 20151016, "Idaho Steelheads",
 746                "Rapid City Rush", "1:0,1:0,3:1", "10:7,6:11,7:5", 0, False)
 747 MakeHockeyGame((sqlcur, sqlcon), 20151016, "Alaska Aces",
 748                "Missouri Mavericks", "1:0,1:0,1:1", "12:13,7:16,10:11", 0, False)
 749
 750 print("Inserting "+leaguename+" Game Data From 10/17/2015.\n")
 751 MakeHockeyGame((sqlcur, sqlcon), 20151017, "Orlando Solar Bears",
 752                "Greenville Swamp Rabbits", "2:1,1:0,3:2", "7:9,13:7,10:10", 0, False)
 753 MakeHockeyGame((sqlcur, sqlcon), 20151017, "Florida Everblades",
 754                "Atlanta Gladiators", "3:1,3:0,0:0", "20:7,8:11,9:12", 0, False)
 755 MakeHockeyGame((sqlcur, sqlcon), 20151017, "Elmira Jackals",
 756                "Brampton Beast", "2:0,1:1,1:1", "17:4,7:10,8:7", 0, False)
 757 MakeHockeyGame((sqlcur, sqlcon), 20151017, "South Carolina Stingrays",
 758                "Reading Royals", "1:0,1:0,0:1", "5:9,8:8,12:12", 0, False)
 759 MakeHockeyGame((sqlcur, sqlcon), 20151017, "Norfolk Admirals",
 760                "Wheeling Nailers", "3:0,0:0,1:2", "11:9,5:19,8:12", 0, False)
 761 MakeHockeyGame((sqlcur, sqlcon), 20151017, "Fort Wayne Komets",
 762                "Kalamazoo Wings", "2:1,0:0,1:0", "12:5,15:9,14:6", 0, False)
 763 MakeHockeyGame((sqlcur, sqlcon), 20151017, "Cincinnati Cyclones",
 764                "Toledo Walleye", "1:0,1:0,3:1", "12:8,11:8,8:10", 0, False)
 765 MakeHockeyGame((sqlcur, sqlcon), 20151017, "Wichita Thunder", "Quad City Mallards",
 766                "1:1,2:2,1:1,0:0,1:0", "11:6,6:11,4:11,3:2,1:0", 0, False)
 767 MakeHockeyGame((sqlcur, sqlcon), 20151017, "Allen Americans",
 768                "Tulsa Oilers", "1:1,1:0,2:1", "10:4,8:16,8:8", 0, False)
 769 MakeHockeyGame((sqlcur, sqlcon), 20151017, "Evansville IceMen",
 770                "Indy Fuel", "0:0,0:1,1:2", "9:11,10:8,15:10", 0, False)
 771 MakeHockeyGame((sqlcur, sqlcon), 20151017, "Colorado Eagles",
 772                "Utah Grizzlies", "1:1,1:2,0:2", "12:11,17:4,6:10", 0, False)
 773 MakeHockeyGame((sqlcur, sqlcon), 20151017, "Idaho Steelheads",
 774                "Rapid City Rush", "4:1,0:1,0:2,0:1", "14:12,6:8,7:10,2:3", 0, False)
 775 MakeHockeyGame((sqlcur, sqlcon), 20151017, "Alaska Aces",
 776                "Missouri Mavericks", "0:2,0:1,0:0", "10:13,11:10,4:7", 0, False)
 777
 778 print("Inserting "+leaguename+" Game Data From 10/18/2015.\n")
 779 MakeHockeyGame((sqlcur, sqlcon), 20151018, "South Carolina Stingrays",
 780                "Reading Royals", "0:3,0:1,0:2", "11:17,6:6,3:11", 0, False)
 781 MakeHockeyGame((sqlcur, sqlcon), 20151018, "Tulsa Oilers",
 782                "Allen Americans", "1:1,1:0,1:0", "10:13,10:10,10:9", 0, False)
 783 MakeHockeyGame((sqlcur, sqlcon), 20151018, "Alaska Aces",
 784                "Missouri Mavericks", "0:0,0:2,1:1", "11:9,7:7,11:15", 0, False)
 785
 786 print("Inserting "+leaguename+" Game Data From 10/21/2015.\n")
 787 MakeHockeyGame((sqlcur, sqlcon), 20151021, "Florida Everblades",
 788                "Norfolk Admirals", "0:0,3:1,3:0", "8:6,12:11,17:11", 0, False)
 789 MakeHockeyGame((sqlcur, sqlcon), 20151021, "Colorado Eagles",
 790                "Allen Americans", "0:0,1:0,0:3", "6:5,15:6,8:6", 0, False)
 791 MakeHockeyGame((sqlcur, sqlcon), 20151021, "Alaska Aces", "Idaho Steelheads",
 792                "1:2,0:0,2:1,0:0,0:1", "13:14,7:15,17:8,1:2,0:1", 0, False)
 793
 794 print("Inserting "+leaguename+" Game Data From 10/22/2015.\n")
 795 MakeHockeyGame((sqlcur, sqlcon), 20151022, "Orlando Solar Bears",
 796                "Norfolk Admirals", "3:2,0:1,3:0", "11:14,14:13,13:16", 0, False)
 797
 798 print("Inserting "+leaguename+" Game Data From 10/23/2015.\n")
 799 MakeHockeyGame((sqlcur, sqlcon), 20151023, "Greenville Swamp Rabbits",
 800                "South Carolina Stingrays", "3:1,0:1,2:1", "11:8,4:10,9:10", 0, False)
 801 MakeHockeyGame((sqlcur, sqlcon), 20151023, "Elmira Jackals",
 802                "Reading Royals", "1:1,0:2,0:2", "4:12,8:11,9:10", 0, False)
 803 MakeHockeyGame((sqlcur, sqlcon), 20151023, "Brampton Beast",
 804                "Adirondack Thunder", "2:2,1:2,1:0,0:1", "6:12,6:16,10:7,0:2", 0, False)
 805 MakeHockeyGame((sqlcur, sqlcon), 20151023, "Kalamazoo Wings",
 806                "Toledo Walleye", "1:2,0:1,1:2", "4:14,8:11,8:15", 0, False)
 807 MakeHockeyGame((sqlcur, sqlcon), 20151023, "Atlanta Gladiators",
 808                "Florida Everblades", "2:1,0:0,2:1", "14:8,8:6,11:9", 0, False)
 809 MakeHockeyGame((sqlcur, sqlcon), 20151023, "Fort Wayne Komets",
 810                "Indy Fuel", "0:0,0:0,3:0", "8:7,11:8,10:6", 0, False)
 811 MakeHockeyGame((sqlcur, sqlcon), 20151023, "Wichita Thunder",
 812                "Missouri Mavericks", "0:0,0:0,0:3", "6:9,12:10,9:13", 0, False)
 813 MakeHockeyGame((sqlcur, sqlcon), 20151023, "Quad City Mallards",
 814                "Tulsa Oilers", "0:0,0:1,0:0", "8:7,5:8,5:5", 0, False)
 815 MakeHockeyGame((sqlcur, sqlcon), 20151023, "Utah Grizzlies",
 816                "Allen Americans", "1:1,0:1,1:2", "9:10,6:5,11:12", 0, False)
 817 MakeHockeyGame((sqlcur, sqlcon), 20151023, "Rapid City Rush",
 818                "Colorado Eagles", "0:0,1:1,2:1", "12:12,12:10,7:4", 0, False)
 819 MakeHockeyGame((sqlcur, sqlcon), 20151023, "Alaska Aces",
 820                "Idaho Steelheads", "0:1,3:0,1:0", "8:13,25:3,10:8", 0, False)
 821
 822 print("Inserting "+leaguename+" Game Data From 10/24/2015.\n")
 823 MakeHockeyGame((sqlcur, sqlcon), 20151024, "Reading Royals",
 824                "Elmira Jackals", "1:2,1:3,0:2", "7:8,12:7,4:6", 0, False)
 825 MakeHockeyGame((sqlcur, sqlcon), 20151024, "Adirondack Thunder",
 826                "Manchester Monarchs", "1:0,1:1,2:1", "10:8,4:14,10:17", 0, False)
 827 MakeHockeyGame((sqlcur, sqlcon), 20151024, "Orlando Solar Bears",
 828                "Norfolk Admirals", "1:0,1:1,4:2", "12:13,8:8,13:20", 0, False)
 829 MakeHockeyGame((sqlcur, sqlcon), 20151024, "Atlanta Gladiators",
 830                "Florida Everblades", "0:1,0:1,1:2", "7:12,9:14,4:7", 0, False)
 831 MakeHockeyGame((sqlcur, sqlcon), 20151024, "South Carolina Stingrays",
 832                "Greenville Swamp Rabbits", "0:0,1:1,1:1,0:1", "11:5,6:8,8:6,1:6", 0, False)
 833 MakeHockeyGame((sqlcur, sqlcon), 20151024, "Fort Wayne Komets",
 834                "Indy Fuel", "1:2,3:2,1:1,1:0", "13:11,17:8,19:8,4:0", 0, False)
 835 MakeHockeyGame((sqlcur, sqlcon), 20151024, "Cincinnati Cyclones",
 836                "Kalamazoo Wings", "0:0,2:1,2:0", "9:8,16:5,9:7", 0, False)
 837 MakeHockeyGame((sqlcur, sqlcon), 20151024, "Wheeling Nailers",
 838                "Brampton Beast", "1:0,3:1,1:0", "6:6,13:8,10:9", 0, False)
 839 MakeHockeyGame((sqlcur, sqlcon), 20151024, "Missouri Mavericks",
 840                "Wichita Thunder", "0:1,2:0,0:0", "9:4,11:3,7:11", 0, False)
 841 MakeHockeyGame((sqlcur, sqlcon), 20151024, "Quad City Mallards",
 842                "Tulsa Oilers", "1:1,2:1,2:1", "10:5,17:9,10:14", 0, False)
 843 MakeHockeyGame((sqlcur, sqlcon), 20151024, "Evansville IceMen",
 844                "Toledo Walleye", "0:1,0:1,1:0", "11:5,9:16,19:6", 0, False)
 845 MakeHockeyGame((sqlcur, sqlcon), 20151024, "Utah Grizzlies",
 846                "Allen Americans", "1:2,2:2,2:1,0:1", "14:16,15:15,14:6,0:1", 0, False)
 847 MakeHockeyGame((sqlcur, sqlcon), 20151024, "Colorado Eagles",
 848                "Rapid City Rush", "0:0,1:1,1:2", "6:5,16:7,6:9", 0, False)
 849 MakeHockeyGame((sqlcur, sqlcon), 20151024, "Alaska Aces",
 850                "Idaho Steelheads", "1:0,2:1,2:3", "11:6,16:16,13:8", 0, False)
 851
 852 print("Inserting "+leaguename+" Game Data From 10/25/2015.\n")
 853 MakeHockeyGame((sqlcur, sqlcon), 20151025, "Brampton Beast",
 854                "Wheeling Nailers", "0:2,2:1,1:1", "7:10,10:17,16:5", 0, False)
 855 MakeHockeyGame((sqlcur, sqlcon), 20151025, "Manchester Monarchs",
 856                "Adirondack Thunder", "1:0,0:2,1:3", "8:6,14:12,17:10", 0, False)
 857 MakeHockeyGame((sqlcur, sqlcon), 20151025, "Greenville Swamp Rabbits",
 858                "Florida Everblades", "0:2,2:0,1:0", "8:7,8:10,9:9", 0, False)
 859 MakeHockeyGame((sqlcur, sqlcon), 20151025, "South Carolina Stingrays",
 860                "Atlanta Gladiators", "0:2,0:0,3:3", "11:9,10:8,14:12", 0, False)
 861 MakeHockeyGame((sqlcur, sqlcon), 20151025, "Quad City Mallards",
 862                "Wichita Thunder", "2:1,1:1,2:0", "11:11,13:8,7:14", 0, False)
 863
 864 print("Inserting "+leaguename+" Game Data From 10/27/2015.\n")
 865 MakeHockeyGame((sqlcur, sqlcon), 20151027, "Kalamazoo Wings",
 866                "Indy Fuel", "1:0,3:1,0:2", "15:20,13:14,6:16", 0, False)
 867 MakeHockeyGame((sqlcur, sqlcon), 20151027, "Missouri Mavericks",
 868                "Quad City Mallards", "0:0,3:1,2:1", "8:8,9:12,9:7", 0, False)
 869
 870 print("Inserting "+leaguename+" Game Data From 10/28/2015.\n")
 871 MakeHockeyGame((sqlcur, sqlcon), 20151028, "Adirondack Thunder",
 872                "Orlando Solar Bears", "1:1,1:1,2:0", "5:10,13:7,10:10", 0, False)
 873 MakeHockeyGame((sqlcur, sqlcon), 20151028, "Reading Royals",
 874                "Elmira Jackals", "3:1,2:2,3:0", "11:3,7:7,9:3", 0, False)
 875 MakeHockeyGame((sqlcur, sqlcon), 20151028, "Florida Everblades",
 876                "South Carolina Stingrays", "1:0,0:3,1:1", "7:7,11:13,11:5", 0, False)
 877 MakeHockeyGame((sqlcur, sqlcon), 20151028, "Colorado Eagles",
 878                "Rapid City Rush", "2:0,1:0,1:0", "8:5,7:6,8:8", 0, False)
 879
 880 print("Inserting "+leaguename+" Game Data From 10/30/2015.\n")
 881 MakeHockeyGame((sqlcur, sqlcon), 20151030, "Kalamazoo Wings",
 882                "Cincinnati Cyclones", "1:0,1:1,1:0", "10:8,13:9,4:17", 0, False)
 883 MakeHockeyGame((sqlcur, sqlcon), 20151030, "Greenville Swamp Rabbits",
 884                "Atlanta Gladiators", "1:1,0:2,1:0", "12:12,10:16,12:16", 0, False)
 885 MakeHockeyGame((sqlcur, sqlcon), 20151030, "Elmira Jackals",
 886                "Orlando Solar Bears", "0:1,1:2,2:0,1:0", "9:11,14:14,18:7,1:1", 0, False)
 887 MakeHockeyGame((sqlcur, sqlcon), 20151030, "Brampton Beast",
 888                "Toledo Walleye", "0:0,1:2,0:2", "13:12,12:11,11:4", 0, False)
 889 MakeHockeyGame((sqlcur, sqlcon), 20151030, "Norfolk Admirals", "Quad City Mallards",
 890                "1:0,1:0,0:2,0:0,1:0", "14:8,14:9,7:18,4:4,1:0", 0, False)
 891 MakeHockeyGame((sqlcur, sqlcon), 20151030, "Florida Everblades",
 892                "South Carolina Stingrays", "0:0,0:0,2:0", "4:7,7:10,6:5", 0, False)
 893 MakeHockeyGame((sqlcur, sqlcon), 20151030, "Indy Fuel",
 894                "Fort Wayne Komets", "2:1,2:1,0:0", "10:10,13:13,5:6", 0, False)
 895 MakeHockeyGame((sqlcur, sqlcon), 20151030, "Wheeling Nailers",
 896                "Adirondack Thunder", "1:2,0:1,0:1", "11:12,10:7,11:6", 0, False)
 897 MakeHockeyGame((sqlcur, sqlcon), 20151030, "Wichita Thunder",
 898                "Colorado Eagles", "3:1,1:0,1:1", "12:7,6:9,5:10", 0, False)
 899 MakeHockeyGame((sqlcur, sqlcon), 20151030, "Tulsa Oilers", "Missouri Mavericks",
 900                "1:0,1:2,1:1,0:0,1:0", "10:7,6:9,8:11,3:5,1:0", 0, False)
 901 MakeHockeyGame((sqlcur, sqlcon), 20151030, "Rapid City Rush",
 902                "Alaska Aces", "0:1,1:2,0:1", "9:16,9:5,9:8", 0, False)
 903 MakeHockeyGame((sqlcur, sqlcon), 20151030, "Idaho Steelheads",
 904                "Utah Grizzlies", "0:1,0:2,1:1", "16:6,15:7,17:2", 0, False)
 905
 906 print("Inserting "+leaguename+" Game Data From 10/31/2015.\n")
 907 MakeHockeyGame((sqlcur, sqlcon), 20151031, "Wichita Thunder",
 908                "Colorado Eagles", "1:1,1:0,0:0", "4:18,7:7,3:10", 0, False)
 909 MakeHockeyGame((sqlcur, sqlcon), 20151031, "Greenville Swamp Rabbits",
 910                "Evansville IceMen", "2:0,0:0,0:3", "17:8,13:18,14:12", 0, False)
 911 MakeHockeyGame((sqlcur, sqlcon), 20151031, "Utah Grizzlies",
 912                "Idaho Steelheads", "0:1,0:2,1:0", "14:14,10:10,11:6", 0, False)
 913 MakeHockeyGame((sqlcur, sqlcon), 20151031, "Rapid City Rush",
 914                "Alaska Aces", "0:0,3:1,2:0", "8:8,14:11,15:14", 0, False)
 915 MakeHockeyGame((sqlcur, sqlcon), 20151031, "Reading Royals",
 916                "Orlando Solar Bears", "0:1,0:2,2:2", "11:9,12:4,13:3", 0, False)
 917 MakeHockeyGame((sqlcur, sqlcon), 20151031, "Elmira Jackals",
 918                "Manchester Monarchs", "0:1,0:2,2:1", "8:17,15:12,17:5", 0, False)
 919 MakeHockeyGame((sqlcur, sqlcon), 20151031, "Fort Wayne Komets",
 920                "Cincinnati Cyclones", "1:3,0:2,0:0", "14:9,12:7,11:4", 0, False)
 921 MakeHockeyGame((sqlcur, sqlcon), 20151031, "Wheeling Nailers",
 922                "Quad City Mallards", "2:0,0:1,0:0", "12:6,15:10,11:8", 0, False)
 923 MakeHockeyGame((sqlcur, sqlcon), 20151031, "Allen Americans",
 924                "Missouri Mavericks", "0:0,1:0,1:1", "8:6,11:10,9:7", 0, False)
 925
 926 print("Inserting "+leaguename+" Game Data From 11/1/2015.\n")
 927 MakeHockeyGame((sqlcur, sqlcon), 20151101, "Brampton Beast",
 928                "Toledo Walleye", "0:1,2:1,3:0", "8:9,8:9,15:7", 0, False)
 929 MakeHockeyGame((sqlcur, sqlcon), 20151101, "Greenville Swamp Rabbits",
 930                "Florida Everblades", "0:2,0:3,0:2", "12:13,10:10,9:10", 0, False)
 931 MakeHockeyGame((sqlcur, sqlcon), 20151101, "South Carolina Stingrays",
 932                "Evansville IceMen", "2:0,1:1,2:1", "8:4,11:8,8:13", 0, False)
 933
 934 print("Inserting "+leaguename+" Game Data From 11/2/2015.\n")
 935 MakeHockeyGame((sqlcur, sqlcon), 20151102, "Utah Grizzlies",
 936                "Idaho Steelheads", "1:0,0:0,0:2", "17:9,19:12,12:6", 0, False)
 937
 938 print("Inserting "+leaguename+" Game Data From 11/3/2015.\n")
 939 MakeHockeyGame((sqlcur, sqlcon), 20151103, "South Carolina Stingrays",
 940                "Florida Everblades", "0:0,1:0,1:0", "5:11,10:5,10:5", 0, False)
 941 MakeHockeyGame((sqlcur, sqlcon), 20151103, "Tulsa Oilers",
 942                "Allen Americans", "2:0,1:1,0:0", "10:3,5:7,5:7", 0, False)
 943
 944 print("Inserting "+leaguename+" Game Data From 11/4/2015.\n")
 945 MakeHockeyGame((sqlcur, sqlcon), 20151104, "Evansville IceMen",
 946                "Indy Fuel", "0:1,0:1,0:1", "5:7,10:8,7:7", 0, False)
 947 MakeHockeyGame((sqlcur, sqlcon), 20151104, "Kalamazoo Wings",
 948                "Adirondack Thunder", "1:0,0:0,1:2,0:1", "11:10,9:12,7:8,0:2", 0, False)
 949 MakeHockeyGame((sqlcur, sqlcon), 20151104, "Quad City Mallards",
 950                "Missouri Mavericks", "2:1,0:2,1:0,0:1", "10:9,9:15,11:10,0:2", 0, False)
 951 MakeHockeyGame((sqlcur, sqlcon), 20151104, "Cincinnati Cyclones",
 952                "Toledo Walleye", "0:0,0:1,1:0,0:0,0:1", "10:7,6:10,11:10,4:4,0:1", 0, False)
 953 MakeHockeyGame((sqlcur, sqlcon), 20151104, "Idaho Steelheads",
 954                "Atlanta Gladiators", "2:3,2:0,0:2", "12:10,11:11,11:6", 0, False)
 955 MakeHockeyGame((sqlcur, sqlcon), 20151104, "Alaska Aces",
 956                "Utah Grizzlies", "1:2,1:1,0:1", "10:15,5:7,15:9", 0, False)
 957
 958 print("Inserting "+leaguename+" Game Data From 11/6/2015.\n")
 959 MakeHockeyGame((sqlcur, sqlcon), 20151106, "South Carolina Stingrays",
 960                "Elmira Jackals", "0:1,0:1,0:0", "11:7,8:7,13:10", 0, False)
 961 MakeHockeyGame((sqlcur, sqlcon), 20151106, "Brampton Beast",
 962                "Manchester Monarchs", "1:2,1:0,2:0", "8:11,19:9,5:11", 0, False)
 963 MakeHockeyGame((sqlcur, sqlcon), 20151106, "Norfolk Admirals",
 964                "Greenville Swamp Rabbits", "2:0,0:2,2:0", "12:11,9:9,12:5", 0, False)
 965 MakeHockeyGame((sqlcur, sqlcon), 20151106, "Cincinnati Cyclones",
 966                "Adirondack Thunder", "2:1,0:0,2:1", "12:11,9:11,10:11", 0, False)
 967 MakeHockeyGame((sqlcur, sqlcon), 20151106, "Wheeling Nailers",
 968                "Kalamazoo Wings", "1:1,1:1,1:2", "12:8,17:11,8:8", 0, False)
 969 MakeHockeyGame((sqlcur, sqlcon), 20151106, "Fort Wayne Komets",
 970                "Toledo Walleye", "1:0,1:0,2:1", "12:5,14:10,7:14", 0, False)
 971 MakeHockeyGame((sqlcur, sqlcon), 20151106, "Quad City Mallards",
 972                "Wichita Thunder", "2:2,0:0,2:0", "8:5,4:14,12:4", 0, False)
 973 MakeHockeyGame((sqlcur, sqlcon), 20151106, "Evansville IceMen",
 974                "Indy Fuel", "1:2,2:0,1:0", "9:13,12:13,6:5", 0, False)
 975 MakeHockeyGame((sqlcur, sqlcon), 20151106, "Colorado Eagles",
 976                "Tulsa Oilers", "1:1,0:0,2:0", "16:2,10:5,14:5", 0, False)
 977 MakeHockeyGame((sqlcur, sqlcon), 20151106, "Rapid City Rush",
 978                "Allen Americans", "0:1,1:1,0:2", "8:9,8:8,9:10", 0, False)
 979 MakeHockeyGame((sqlcur, sqlcon), 20151106, "Idaho Steelheads",
 980                "Atlanta Gladiators", "2:2,1:1,1:1,0:1", "10:17,5:7,13:5,3:1", 0, False)
 981 MakeHockeyGame((sqlcur, sqlcon), 20151106, "Alaska Aces",
 982                "Utah Grizzlies", "0:0,0:1,1:3", "5:9,15:13,8:8", 0, False)
 983
 984 print("Inserting "+leaguename+" Game Data From 11/7/2015.\n")
 985 MakeHockeyGame((sqlcur, sqlcon), 20151107, "Orlando Solar Bears",
 986                "Florida Everblades", "1:2,1:1,0:0", "9:14,9:11,10:11", 0, False)
 987 MakeHockeyGame((sqlcur, sqlcon), 20151107, "Reading Royals",
 988                "Greenville Swamp Rabbits", "1:0,4:1,0:0", "11:12,13:10,5:9", 0, False)
 989 MakeHockeyGame((sqlcur, sqlcon), 20151107, "South Carolina Stingrays",
 990                "Elmira Jackals", "2:0,1:1,1:0", "10:3,16:13,7:5", 0, False)
 991 MakeHockeyGame((sqlcur, sqlcon), 20151107, "Brampton Beast",
 992                "Manchester Monarchs", "0:2,1:1,0:2", "7:19,7:9,10:4", 0, False)
 993 MakeHockeyGame((sqlcur, sqlcon), 20151107, "Toledo Walleye",
 994                "Adirondack Thunder", "0:1,0:0,0:0", "8:5,15:7,8:4", 0, False)
 995 MakeHockeyGame((sqlcur, sqlcon), 20151107, "Norfolk Admirals",
 996                "Wheeling Nailers", "3:2,1:0,2:0", "13:12,9:14,9:12", 0, False)
 997 MakeHockeyGame((sqlcur, sqlcon), 20151107, "Fort Wayne Komets",
 998                "Kalamazoo Wings", "2:1,1:2,1:3", "15:12,17:8,18:7", 0, False)
 999 MakeHockeyGame((sqlcur, sqlcon), 20151107, "Indy Fuel",
1000                "Quad City Mallards", "2:0,2:2,1:0", "8:9,12:4,8:12", 0, False)
1001 MakeHockeyGame((sqlcur, sqlcon), 20151107, "Cincinnati Cyclones",
1002                "Evansville IceMen", "0:0,0:0,2:1", "10:10,11:9,6:7", 0, False)
1003 MakeHockeyGame((sqlcur, sqlcon), 20151107, "Missouri Mavericks",
1004                "Wichita Thunder", "1:0,0:0,0:0", "4:6,10:13,6:6", 0, False)
1005 MakeHockeyGame((sqlcur, sqlcon), 20151107, "Colorado Eagles",
1006                "Tulsa Oilers", "1:0,0:1,1:0", "11:5,10:7,11:9", 0, False)
1007 MakeHockeyGame((sqlcur, sqlcon), 20151107, "Rapid City Rush",
1008                "Allen Americans", "0:2,2:2,0:3", "6:20,14:11,3:18", 0, False)
1009 MakeHockeyGame((sqlcur, sqlcon), 20151107, "Idaho Steelheads",
1010                "Atlanta Gladiators", "0:1,0:1,1:1", "5:10,16:5,11:6", 0, False)
1011 MakeHockeyGame((sqlcur, sqlcon), 20151107, "Alaska Aces",
1012                "Utah Grizzlies", "1:0,1:0,0:3", "11:13,17:10,8:10", 0, False)
1013
1014 print("Inserting "+leaguename+" Game Data From 11/8/2015.\n")
1015 MakeHockeyGame((sqlcur, sqlcon), 20151108, "Brampton Beast",
1016                "Manchester Monarchs", "2:1,0:0,2:1", "12:10,16:11,12:8", 0, False)
1017 MakeHockeyGame((sqlcur, sqlcon), 20151108, "South Carolina Stingrays",
1018                "Norfolk Admirals", "1:0,2:0,0:1", "17:6,15:6,2:6", 0, False)
1019 MakeHockeyGame((sqlcur, sqlcon), 20151108, "Kalamazoo Wings",
1020                "Fort Wayne Komets", "0:2,0:1,2:2", "10:10,6:8,18:13", 0, False)
1021 MakeHockeyGame((sqlcur, sqlcon), 20151108, "Reading Royals",
1022                "Greenville Swamp Rabbits", "2:0,0:0,3:0", "14:9,7:6,7:15", 0, False)
1023 MakeHockeyGame((sqlcur, sqlcon), 20151108, "Orlando Solar Bears",
1024                "Florida Everblades", "0:2,1:1,0:0", "16:19,15:9,11:4", 0, False)
1025 MakeHockeyGame((sqlcur, sqlcon), 20151108, "Wichita Thunder",
1026                "Missouri Mavericks", "0:1,1:1,0:0", "6:12,9:21,8:13", 0, False)
1027
1028 print("Inserting "+leaguename+" Game Data From 11/10/2015.\n")
1029 MakeHockeyGame((sqlcur, sqlcon), 20151110, "Wheeling Nailers",
1030                "Cincinnati Cyclones", "1:2,1:1,5:2", "10:10,18:7,12:9", 0, False)
1031 MakeHockeyGame((sqlcur, sqlcon), 20151110, "Kalamazoo Wings",
1032                "Manchester Monarchs", "2:3,0:3,1:1", "7:14,4:7,13:8", 0, False)
1033 MakeHockeyGame((sqlcur, sqlcon), 20151110, "Atlanta Gladiators",
1034                "Florida Everblades", "0:3,1:2,1:3", "6:14,11:9,7:6", 0, False)
1035 MakeHockeyGame((sqlcur, sqlcon), 20151110, "Norfolk Admirals",
1036                "Elmira Jackals", "1:1,0:1,2:2", "19:11,9:14,4:19", 0, False)
1037 MakeHockeyGame((sqlcur, sqlcon), 20151110, "Allen Americans",
1038                "Wichita Thunder", "1:1,2:0,2:1", "9:9,12:5,11:9", 0, False)
1039
1040 print("Inserting "+leaguename+" Game Data From 11/11/2015.\n")
1041 MakeHockeyGame((sqlcur, sqlcon), 20151111, "Reading Royals",
1042                "Wheeling Nailers", "1:1,1:0,0:0", "10:7,10:4,4:10", 0, False)
1043 MakeHockeyGame((sqlcur, sqlcon), 20151111, "Quad City Mallards",
1044                "Alaska Aces", "2:1,2:2,3:1", "12:10,12:14,10:9", 0, False)
1045 MakeHockeyGame((sqlcur, sqlcon), 20151111, "Cincinnati Cyclones",
1046                "Fort Wayne Komets", "2:0,1:0,0:1", "10:16,10:7,10:12", 0, False)
1047 MakeHockeyGame((sqlcur, sqlcon), 20151111, "Wichita Thunder", "Tulsa Oilers",
1048                "0:1,1:0,0:0,0:0,1:0", "6:12,12:9,10:10,3:0,1:0", 0, False)
1049 MakeHockeyGame((sqlcur, sqlcon), 20151111, "Utah Grizzlies",
1050                "Colorado Eagles", "1:1,1:1,2:0", "15:10,14:11,11:8", 0, False)
1051
1052 print("Inserting "+leaguename+" Game Data From 11/12/2015.\n")
1053 MakeHockeyGame((sqlcur, sqlcon), 20151112, "Greenville Swamp Rabbits",
1054                "Atlanta Gladiators", "2:0,1:1,3:2", "14:9,9:12,11:8", 0, False)
1055 MakeHockeyGame((sqlcur, sqlcon), 20151112, "Orlando Solar Bears",
1056                "Idaho Steelheads", "0:1,2:0,3:3", "12:13,11:11,7:10", 0, False)
1057
1058 print("Inserting "+leaguename+" Game Data From 11/13/2015.\n")
1059 MakeHockeyGame((sqlcur, sqlcon), 20151113, "Kalamazoo Wings",
1060                "Evansville IceMen", "0:0,2:0,2:2", "7:14,13:9,10:12", 0, False)
1061 MakeHockeyGame((sqlcur, sqlcon), 20151113, "Manchester Monarchs",
1062                "Toledo Walleye", "2:1,0:2,3:1", "9:11,18:11,13:10", 0, False)
1063 MakeHockeyGame((sqlcur, sqlcon), 20151113, "Elmira Jackals",
1064                "Norfolk Admirals", "0:2,0:0,1:2", "9:8,13:3,15:6", 0, False)
1065 MakeHockeyGame((sqlcur, sqlcon), 20151113, "South Carolina Stingrays",
1066                "Orlando Solar Bears", "1:0,0:0,0:1,0:0,1:0", "9:4,7:8,13:9,5:1,1:0", 0, False)
1067 MakeHockeyGame((sqlcur, sqlcon), 20151113, "Florida Everblades",
1068                "Idaho Steelheads", "0:2,3:1,0:0,1:0", "6:11,9:6,14:4,2:1", 0, False)
1069 MakeHockeyGame((sqlcur, sqlcon), 20151113, "Indy Fuel",
1070                "Alaska Aces", "1:2,2:0,0:0", "10:12,12:13,4:12", 0, False)
1071 MakeHockeyGame((sqlcur, sqlcon), 20151113, "Cincinnati Cyclones",
1072                "Quad City Mallards", "2:0,0:0,1:1", "12:8,10:11,6:5", 0, False)
1073 MakeHockeyGame((sqlcur, sqlcon), 20151113, "Wheeling Nailers",
1074                "Reading Royals", "3:1,2:0,1:0", "12:8,12:11,14:9", 0, False)
1075 MakeHockeyGame((sqlcur, sqlcon), 20151113, "Atlanta Gladiators",
1076                "Adirondack Thunder", "1:2,0:1,0:1", "5:10,13:2,5:6", 0, False)
1077 MakeHockeyGame((sqlcur, sqlcon), 20151113, "Wichita Thunder",
1078                "Missouri Mavericks", "1:5,0:1,1:1", "5:21,5:11,10:6", 0, False)
1079 MakeHockeyGame((sqlcur, sqlcon), 20151113, "Tulsa Oilers",
1080                "Allen Americans", "0:1,1:1,1:1", "7:9,16:9,7:3", 0, False)
1081 MakeHockeyGame((sqlcur, sqlcon), 20151113, "Utah Grizzlies",
1082                "Rapid City Rush", "1:1,3:0,0:3,1:0", "16:3,11:9,11:9,2:0", 0, False)
1083
1084 print("Inserting "+leaguename+" Game Data From 11/14/2015.\n")
1085 MakeHockeyGame((sqlcur, sqlcon), 20151114, "Kalamazoo Wings",
1086                "Cincinnati Cyclones", "1:0,0:0,0:1,1:0", "7:13,5:14,13:11,1:0", 0, False)
1087 MakeHockeyGame((sqlcur, sqlcon), 20151114, "Reading Royals",
1088                "Norfolk Admirals", "0:0,1:2,2:0", "20:8,9:8,17:9", 0, False)
1089 MakeHockeyGame((sqlcur, sqlcon), 20151114, "Manchester Monarchs",
1090                "Toledo Walleye", "2:2,0:3,0:1", "13:12,13:17,12:12", 0, False)
1091 MakeHockeyGame((sqlcur, sqlcon), 20151114, "Greenville Swamp Rabbits",
1092                "Adirondack Thunder", "1:1,0:0,2:1", "10:10,8:7,6:6", 0, False)
1093 MakeHockeyGame((sqlcur, sqlcon), 20151114, "Florida Everblades",
1094                "Idaho Steelheads", "0:0,2:0,1:0", "12:6,9:4,12:11", 0, False)
1095 MakeHockeyGame((sqlcur, sqlcon), 20151114, "Elmira Jackals",
1096                "Brampton Beast", "0:0,1:2,0:2", "9:10,8:8,5:12", 0, False)
1097 MakeHockeyGame((sqlcur, sqlcon), 20151114, "South Carolina Stingrays",
1098                "Orlando Solar Bears", "1:0,0:1,0:0,0:0,0:1", "6:7,12:8,6:6,6:2,0:1", 0, False)
1099 MakeHockeyGame((sqlcur, sqlcon), 20151114, "Indy Fuel", "Alaska Aces",
1100                "1:1,1:0,0:1,0:0,1:0", "11:5,14:10,4:10,4:4,1:0", 0, False)
1101 MakeHockeyGame((sqlcur, sqlcon), 20151114, "Wheeling Nailers",
1102                "Evansville IceMen", "0:1,0:0,1:0,0:1", "10:8,9:7,10:8,3:3", 0, False)
1103 MakeHockeyGame((sqlcur, sqlcon), 20151114, "Wichita Thunder",
1104                "Missouri Mavericks", "1:0,1:1,0:1,0:0,0:1", "6:10,5:9,9:6,1:3,0:1", 0, False)
1105 MakeHockeyGame((sqlcur, sqlcon), 20151114, "Allen Americans",
1106                "Colorado Eagles", "0:1,0:3,1:4", "10:15,4:15,16:12", 0, False)
1107 MakeHockeyGame((sqlcur, sqlcon), 20151114, "Utah Grizzlies",
1108                "Rapid City Rush", "0:1,0:0,0:1", "6:9,8:2,22:5", 0, False)
1109
1110 print("Inserting "+leaguename+" Game Data From 11/15/2015.\n")
1111 MakeHockeyGame((sqlcur, sqlcon), 20151115, "Brampton Beast",
1112                "Kalamazoo Wings", "2:0,2:2,2:1", "13:4,15:7,10:10", 0, False)
1113 MakeHockeyGame((sqlcur, sqlcon), 20151115, "Atlanta Gladiators",
1114                "Greenville Swamp Rabbits", "0:0,3:0,1:1", "19:6,18:6,11:18", 0, False)
1115 MakeHockeyGame((sqlcur, sqlcon), 20151115, "Manchester Monarchs",
1116                "Toledo Walleye", "1:2,2:0,0:1,0:0,1:0", "13:8,13:10,6:6,3:0,1:0", 0, False)
1117 MakeHockeyGame((sqlcur, sqlcon), 20151115, "Wheeling Nailers",
1118                "Evansville IceMen", "1:0,2:2,1:0", "17:9,14:10,9:4", 0, False)
1119 MakeHockeyGame((sqlcur, sqlcon), 20151115, "Reading Royals",
1120                "Norfolk Admirals", "0:1,2:1,2:0", "11:16,15:4,9:3", 0, False)
1121 MakeHockeyGame((sqlcur, sqlcon), 20151115, "Allen Americans",
1122                "Colorado Eagles", "0:2,2:0,2:1", "6:12,10:7,12:9", 0, False)
1123 MakeHockeyGame((sqlcur, sqlcon), 20151115, "Quad City Mallards",
1124                "Fort Wayne Komets", "0:1,1:0,1:0", "10:14,16:9,10:5", 0, False)
1125
1126 print("Inserting "+leaguename+" Game Data From 11/17/2015.\n")
1127 MakeHockeyGame((sqlcur, sqlcon), 20151117, "Cincinnati Cyclones",
1128                "Alaska Aces", "1:0,1:0,1:1", "10:9,10:9,6:13", 0, False)
1129 MakeHockeyGame((sqlcur, sqlcon), 20151117, "Greenville Swamp Rabbits",
1130                "Orlando Solar Bears", "1:4,3:0,1:1,0:1", "13:11,20:6,14:11,2:1", 0, False)
1131 MakeHockeyGame((sqlcur, sqlcon), 20151117, "Missouri Mavericks",
1132                "Allen Americans", "1:1,1:0,2:0", "16:8,13:3,13:7", 0, False)
1133
1134 print("Inserting "+leaguename+" Game Data From 11/18/2015.\n")
1135 MakeHockeyGame((sqlcur, sqlcon), 20151118, "Adirondack Thunder",
1136                "Norfolk Admirals", "2:1,1:1,0:0", "15:11,14:8,9:6", 0, False)
1137 MakeHockeyGame((sqlcur, sqlcon), 20151118, "Manchester Monarchs",
1138                "Elmira Jackals", "0:1,1:1,0:0", "7:5,22:9,18:5", 0, False)
1139 MakeHockeyGame((sqlcur, sqlcon), 20151118, "Evansville IceMen",
1140                "Alaska Aces", "0:1,0:4,2:1", "12:8,11:16,17:3", 0, False)
1141 MakeHockeyGame((sqlcur, sqlcon), 20151118, "Florida Everblades",
1142                "Wheeling Nailers", "2:3,1:3,2:0", "11:10,11:10,14:5", 0, False)
1143 MakeHockeyGame((sqlcur, sqlcon), 20151118, "Rapid City Rush", "Utah Grizzlies",
1144                "1:1,0:0,1:1,0:0,0:1", "11:13,8:6,5:9,4:2,0:1", 0, False)
1145 MakeHockeyGame((sqlcur, sqlcon), 20151118, "Colorado Eagles",
1146                "Idaho Steelheads", "0:0,0:0,1:1,0:1", "8:3,7:6,14:4,1:1", 0, False)
1147
1148 print("Inserting "+leaguename+" Game Data From 11/19/2015.\n")
1149 MakeHockeyGame((sqlcur, sqlcon), 20151119, "Toledo Walleye", "Kalamazoo Wings",
1150                "2:1,0:0,0:1,0:0,0:1", "10:5,7:4,10:15,4:6,0:1", 0, False)
1151
1152 print("Inserting "+leaguename+" Game Data From 11/20/2015.\n")
1153 MakeHockeyGame((sqlcur, sqlcon), 20151120, "Reading Royals",
1154                "Elmira Jackals", "2:3,1:2,1:0", "10:8,8:9,6:6", 0, False)
1155 MakeHockeyGame((sqlcur, sqlcon), 20151120, "Manchester Monarchs",
1156                "Norfolk Admirals", "0:0,0:0,2:1", "11:21,18:7,17:15", 0, False)
1157 MakeHockeyGame((sqlcur, sqlcon), 20151120, "Greenville Swamp Rabbits",
1158                "South Carolina Stingrays", "0:0,3:0,0:2", "5:14,13:4,7:15", 0, False)
1159 MakeHockeyGame((sqlcur, sqlcon), 20151120, "Brampton Beast",
1160                "Toledo Walleye", "1:0,0:1,1:2", "9:8,7:9,11:7", 0, False)
1161 MakeHockeyGame((sqlcur, sqlcon), 20151120, "Florida Everblades",
1162                "Wheeling Nailers", "2:3,0:1,1:1", "24:7,8:9,19:8", 0, False)
1163 MakeHockeyGame((sqlcur, sqlcon), 20151120, "Cincinnati Cyclones",
1164                "Indy Fuel", "1:0,0:1,0:1", "10:6,6:13,12:7", 0, False)
1165 MakeHockeyGame((sqlcur, sqlcon), 20151120, "Fort Wayne Komets",
1166                "Kalamazoo Wings", "2:1,1:0,0:0", "12:9,13:9,12:9", 0, False)
1167 MakeHockeyGame((sqlcur, sqlcon), 20151120, "Wichita Thunder",
1168                "Allen Americans", "0:1,0:1,0:1", "21:7,7:14,16:13", 0, False)
1169 MakeHockeyGame((sqlcur, sqlcon), 20151120, "Tulsa Oilers",
1170                "Missouri Mavericks", "1:1,0:2,3:1,0:1", "9:9,7:7,8:6,2:2", 0, False)
1171 MakeHockeyGame((sqlcur, sqlcon), 20151120, "Quad City Mallards",
1172                "Alaska Aces", "1:1,0:1,3:0", "5:10,13:13,14:5", 0, False)
1173 MakeHockeyGame((sqlcur, sqlcon), 20151120, "Evansville IceMen",
1174                "Orlando Solar Bears", "1:2,3:1,0:3", "11:12,12:9,11:10", 0, False)
1175 MakeHockeyGame((sqlcur, sqlcon), 20151120, "Colorado Eagles",
1176                "Idaho Steelheads", "2:2,1:1,1:1,1:0", "10:8,14:10,13:3,1:0", 0, False)
1177 MakeHockeyGame((sqlcur, sqlcon), 20151120, "Rapid City Rush",
1178                "Utah Grizzlies", "2:1,2:0,1:0", "9:7,12:9,6:10", 0, False)
1179
1180 print("Inserting "+leaguename+" Game Data From 11/21/2015.\n")
1181 MakeHockeyGame((sqlcur, sqlcon), 20151121, "Manchester Monarchs",
1182                "Norfolk Admirals", "1:0,2:1,2:0", "8:6,13:9,14:7", 0, False)
1183 MakeHockeyGame((sqlcur, sqlcon), 20151121, "Florida Everblades",
1184                "Wheeling Nailers", "0:1,2:1,3:0", "16:6,9:12,18:7", 0, False)
1185 MakeHockeyGame((sqlcur, sqlcon), 20151121, "Elmira Jackals",
1186                "Reading Royals", "0:1,4:0,1:3", "7:8,13:12,8:15", 0, False)
1187 MakeHockeyGame((sqlcur, sqlcon), 20151121, "Atlanta Gladiators",
1188                "South Carolina Stingrays", "0:2,0:0,0:1", "11:14,13:8,15:5", 0, False)
1189 MakeHockeyGame((sqlcur, sqlcon), 20151121, "Toledo Walleye",
1190                "Fort Wayne Komets", "3:2,2:1,1:1", "12:10,10:16,5:14", 0, False)
1191 MakeHockeyGame((sqlcur, sqlcon), 20151121, "Indy Fuel",
1192                "Quad City Mallards", "0:0,2:1,1:1", "6:12,6:9,10:11", 0, False)
1193 MakeHockeyGame((sqlcur, sqlcon), 20151121, "Cincinnati Cyclones",
1194                "Orlando Solar Bears", "1:0,1:1,1:2,0:0,1:0", "6:6,8:9,8:8,2:4,1:0", 0, False)
1195 MakeHockeyGame((sqlcur, sqlcon), 20151121, "Wichita Thunder",
1196                "Missouri Mavericks", "2:3,0:1,0:1", "6:13,6:24,14:6", 0, False)
1197 MakeHockeyGame((sqlcur, sqlcon), 20151121, "Evansville IceMen",
1198                "Kalamazoo Wings", "0:1,2:0,1:1", "14:14,15:15,11:14", 0, False)
1199 MakeHockeyGame((sqlcur, sqlcon), 20151121, "Allen Americans",
1200                "Tulsa Oilers", "0:3,1:2,0:1", "5:14,11:14,4:4", 0, False)
1201 MakeHockeyGame((sqlcur, sqlcon), 20151121, "Colorado Eagles",
1202                "Idaho Steelheads", "1:0,1:0,0:0", "7:6,4:8,8:8", 0, False)
1203 MakeHockeyGame((sqlcur, sqlcon), 20151121, "Rapid City Rush",
1204                "Utah Grizzlies", "1:1,0:0,2:2,1:0", "6:9,8:4,7:13,2:1", 0, False)
1205
1206 print("Inserting "+leaguename+" Game Data From 11/22/2015.\n")
1207 MakeHockeyGame((sqlcur, sqlcon), 20151122, "Brampton Beast",
1208                "Fort Wayne Komets", "0:0,0:0,2:0", "8:7,9:9,12:12", 0, False)
1209 MakeHockeyGame((sqlcur, sqlcon), 20151122, "Manchester Monarchs",
1210                "Norfolk Admirals", "2:0,0:1,2:1", "15:6,13:15,13:8", 0, False)
1211 MakeHockeyGame((sqlcur, sqlcon), 20151122, "Tulsa Oilers",
1212                "Allen Americans", "0:1,1:2,2:1", "6:8,4:13,11:3", 0, False)
1213 MakeHockeyGame((sqlcur, sqlcon), 20151122, "Quad City Mallards",
1214                "Indy Fuel", "1:1,1:0,0:0", "5:12,15:18,12:11", 0, False)
1215
1216 print("Inserting "+leaguename+" Game Data From 11/23/2015.\n")
1217 MakeHockeyGame((sqlcur, sqlcon), 20151123, "Greenville Swamp Rabbits",
1218                "Atlanta Gladiators", "1:1,0:2,2:1", "9:11,8:16,13:8", 0, False)
1219
1220 print("Inserting "+leaguename+" Game Data From 11/24/2015.\n")
1221 MakeHockeyGame((sqlcur, sqlcon), 20151124, "Orlando Solar Bears",
1222                "South Carolina Stingrays", "0:0,2:3,1:3", "10:16,9:17,8:7", 0, False)
1223 MakeHockeyGame((sqlcur, sqlcon), 20151124, "Atlanta Gladiators",
1224                "Manchester Monarchs", "2:0,0:1,1:1", "15:4,4:9,5:16", 0, False)
1225
1226 print("Inserting "+leaguename+" Game Data From 11/25/2015.\n")
1227 MakeHockeyGame((sqlcur, sqlcon), 20151125, "Adirondack Thunder",
1228                "Elmira Jackals", "2:1,0:0,0:0", "6:16,13:10,6:7", 0, False)
1229 MakeHockeyGame((sqlcur, sqlcon), 20151125, "Wheeling Nailers",
1230                "Reading Royals", "0:0,1:0,0:0", "12:6,11:8,2:14", 0, False)
1231 MakeHockeyGame((sqlcur, sqlcon), 20151125, "Norfolk Admirals",
1232                "Greenville Swamp Rabbits", "0:0,0:3,0:3", "11:9,8:12,7:10", 0, False)
1233 MakeHockeyGame((sqlcur, sqlcon), 20151125, "Cincinnati Cyclones",
1234                "Fort Wayne Komets", "1:1,0:0,1:1,0:1", "10:8,6:8,12:7,1:4", 0, False)
1235 MakeHockeyGame((sqlcur, sqlcon), 20151125, "Wichita Thunder",
1236                "Indy Fuel", "1:0,2:0,2:1", "14:7,16:11,8:8", 0, False)
1237 MakeHockeyGame((sqlcur, sqlcon), 20151125, "Missouri Mavericks",
1238                "Quad City Mallards", "1:1,1:0,2:0", "9:10,9:8,5:8", 0, False)
1239 MakeHockeyGame((sqlcur, sqlcon), 20151125, "Rapid City Rush",
1240                "Idaho Steelheads", "1:1,3:0,0:0", "7:13,9:14,1:19", 0, False)
1241 MakeHockeyGame((sqlcur, sqlcon), 20151125, "Colorado Eagles",
1242                "Florida Everblades", "0:0,0:1,0:2", "10:11,7:10,13:10", 0, False)
1243
1244 print("Inserting "+leaguename+" Game Data From 11/26/2015.\n")
1245 MakeHockeyGame((sqlcur, sqlcon), 20151126, "Atlanta Gladiators",
1246                "Manchester Monarchs", "1:1,0:1,1:1", "9:16,6:11,6:7", 0, False)
1247 MakeHockeyGame((sqlcur, sqlcon), 20151126, "Fort Wayne Komets",
1248                "Cincinnati Cyclones", "1:1,0:1,0:3", "12:5,11:7,11:9", 0, False)
1249
1250 print("Inserting "+leaguename+" Game Data From 11/27/2015.\n")
1251 MakeHockeyGame((sqlcur, sqlcon), 20151127, "Atlanta Gladiators", "Orlando Solar Bears",
1252                "1:1,2:0,0:2,0:0,1:0", "12:11,13:12,9:13,2:2,1:0", 0, False)
1253 MakeHockeyGame((sqlcur, sqlcon), 20151127, "Reading Royals",
1254                "Greenville Swamp Rabbits", "2:2,0:2,1:2", "6:13,5:9,9:7", 0, False)
1255 MakeHockeyGame((sqlcur, sqlcon), 20151127, "Toledo Walleye",
1256                "Brampton Beast", "0:0,2:1,2:0", "10:8,12:10,10:7", 0, False)
1257 MakeHockeyGame((sqlcur, sqlcon), 20151127, "Norfolk Admirals", "Manchester Monarchs",
1258                "1:1,1:3,3:1,0:0,0:1", "10:13,10:17,15:9,2:2,0:1", 0, False)
1259 MakeHockeyGame((sqlcur, sqlcon), 20151127, "Tulsa Oilers",
1260                "Wichita Thunder", "1:0,0:0,1:0", "7:3,7:16,10:5", 0, False)
1261 MakeHockeyGame((sqlcur, sqlcon), 20151127, "Missouri Mavericks",
1262                "Indy Fuel", "1:1,2:0,1:1", "12:9,15:10,9:8", 0, False)
1263 MakeHockeyGame((sqlcur, sqlcon), 20151127, "Quad City Mallards",
1264                "Kalamazoo Wings", "2:1,1:0,0:0", "11:10,8:12,2:13", 0, False)
1265 MakeHockeyGame((sqlcur, sqlcon), 20151127, "Utah Grizzlies",
1266                "Allen Americans", "4:1,2:1,1:1", "18:7,12:14,10:15", 0, False)
1267 MakeHockeyGame((sqlcur, sqlcon), 20151127, "Colorado Eagles",
1268                "Florida Everblades", "0:0,0:1,0:1", "8:11,6:12,7:11", 0, False)
1269 MakeHockeyGame((sqlcur, sqlcon), 20151127, "Rapid City Rush",
1270                "Idaho Steelheads", "1:2,0:0,0:1", "5:14,7:9,2:11", 0, False)
1271 MakeHockeyGame((sqlcur, sqlcon), 20151127, "Alaska Aces",
1272                "Evansville IceMen", "1:0,1:4,0:0", "11:4,15:10,14:7", 0, False)
1273
1274 print("Inserting "+leaguename+" Game Data From 11/28/2015.\n")
1275 MakeHockeyGame((sqlcur, sqlcon), 20151128, "Reading Royals", "Greenville Swamp Rabbits",
1276                "1:1,1:2,1:0,0:0,0:1", "9:9,16:6,18:7,1:4,0:1", 0, False)
1277 MakeHockeyGame((sqlcur, sqlcon), 20151128, "Orlando Solar Bears",
1278                "South Carolina Stingrays", "0:1,1:1,0:0", "15:9,9:13,9:12", 0, False)
1279 MakeHockeyGame((sqlcur, sqlcon), 20151128, "Elmira Jackals", "Adirondack Thunder",
1280                "1:2,3:1,0:1,0:0,1:0", "14:12,15:18,4:17,4:1,1:0", 0, False)
1281 MakeHockeyGame((sqlcur, sqlcon), 20151128, "Norfolk Admirals",
1282                "Manchester Monarchs", "0:0,2:2,1:2", "8:12,4:18,11:9", 0, False)
1283 MakeHockeyGame((sqlcur, sqlcon), 20151128, "Fort Wayne Komets",
1284                "Toledo Walleye", "0:0,0:0,0:0,1:0", "13:3,8:9,7:3,3:1", 0, False)
1285 MakeHockeyGame((sqlcur, sqlcon), 20151128, "Wheeling Nailers",
1286                "Brampton Beast", "2:2,1:3,0:1", "11:12,14:10,9:12", 0, False)
1287 MakeHockeyGame((sqlcur, sqlcon), 20151128, "Wichita Thunder",
1288                "Tulsa Oilers", "2:1,0:1,0:2", "9:10,5:8,8:9", 0, False)
1289 MakeHockeyGame((sqlcur, sqlcon), 20151128, "Missouri Mavericks",
1290                "Indy Fuel", "1:2,2:0,1:0", "7:8,11:8,5:7", 0, False)
1291 MakeHockeyGame((sqlcur, sqlcon), 20151128, "Quad City Mallards",
1292                "Cincinnati Cyclones", "1:0,1:0,0:1", "11:7,10:10,8:14", 0, False)
1293 MakeHockeyGame((sqlcur, sqlcon), 20151128, "Utah Grizzlies",
1294                "Allen Americans", "0:0,2:2,2:0", "10:9,9:14,20:5", 0, False)
1295 MakeHockeyGame((sqlcur, sqlcon), 20151128, "Colorado Eagles",
1296                "Florida Everblades", "1:0,2:0,2:1", "8:13,9:10,5:10", 0, False)
1297 MakeHockeyGame((sqlcur, sqlcon), 20151128, "Rapid City Rush",
1298                "Idaho Steelheads", "1:0,1:0,0:1", "7:8,8:15,4:11", 0, False)
1299 MakeHockeyGame((sqlcur, sqlcon), 20151128, "Alaska Aces",
1300                "Evansville IceMen", "1:0,0:0,3:1", "17:7,15:13,14:7", 0, False)
1301
1302 print("Inserting "+leaguename+" Game Data From 11/29/2015.\n")
1303 MakeHockeyGame((sqlcur, sqlcon), 20151129, "Brampton Beast",
1304                "Elmira Jackals", "0:2,1:1,1:2", "10:6,11:5,13:11", 0, False)
1305 MakeHockeyGame((sqlcur, sqlcon), 20151129, "Adirondack Thunder",
1306                "Greenville Swamp Rabbits", "1:0,0:0,1:0", "8:9,5:13,8:10", 0, False)
1307 MakeHockeyGame((sqlcur, sqlcon), 20151129, "Kalamazoo Wings", "Toledo Walleye",
1308                "0:0,3:1,0:2,0:0,0:1", "8:9,9:15,5:23,2:6,0:1", 0, False)
1309 MakeHockeyGame((sqlcur, sqlcon), 20151129, "Reading Royals",
1310                "Wheeling Nailers", "0:1,3:0,0:1", "12:13,20:10,7:21", 0, False)
1311 MakeHockeyGame((sqlcur, sqlcon), 20151129, "Tulsa Oilers",
1312                "Missouri Mavericks", "0:1,1:0,0:1", "2:10,15:12,8:9", 0, False)
1313 MakeHockeyGame((sqlcur, sqlcon), 20151129, "Quad City Mallards",
1314                "Indy Fuel", "0:1,0:0,2:1,1:0", "7:10,10:6,14:8,2:2", 0, False)
1315 MakeHockeyGame((sqlcur, sqlcon), 20151129, "Alaska Aces",
1316                "Evansville IceMen", "1:1,0:3,2:1", "14:6,9:15,21:5", 0, False)
1317
1318 print("Inserting "+leaguename+" Game Data From 11/30/2015.\n")
1319 MakeHockeyGame((sqlcur, sqlcon), 20151130, "Orlando Solar Bears",
1320                "South Carolina Stingrays", "0:2,0:0,0:1", "5:13,6:5,11:9", 0, False)
1321
1322 print("Inserting "+leaguename+" Game Data From 12/1/2015.\n")
1323 MakeHockeyGame((sqlcur, sqlcon), 20151201, "Cincinnati Cyclones",
1324                "Quad City Mallards", "0:0,0:1,1:0,0:0,0:1", "8:6,7:9,13:7,0:1,0:1", 0, False)
1325
1326 print("Inserting "+leaguename+" Game Data From 12/2/2015.\n")
1327 MakeHockeyGame((sqlcur, sqlcon), 20151202, "Elmira Jackals",
1328                "Kalamazoo Wings", "1:1,2:0,1:0", "12:9,15:6,7:11", 0, False)
1329 MakeHockeyGame((sqlcur, sqlcon), 20151202, "Evansville IceMen",
1330                "Missouri Mavericks", "0:3,0:0,0:0", "3:9,5:6,10:11", 0, False)
1331 MakeHockeyGame((sqlcur, sqlcon), 20151202, "Norfolk Admirals",
1332                "South Carolina Stingrays", "0:0,0:1,3:0", "3:10,6:12,9:6", 0, False)
1333 MakeHockeyGame((sqlcur, sqlcon), 20151202, "Tulsa Oilers",
1334                "Rapid City Rush", "1:1,0:0,1:3", "6:8,11:7,11:6", 0, False)
1335 MakeHockeyGame((sqlcur, sqlcon), 20151202, "Idaho Steelheads",
1336                "Florida Everblades", "0:1,1:2,0:1", "5:18,14:7,14:9", 0, False)
1337 MakeHockeyGame((sqlcur, sqlcon), 20151202, "Alaska Aces",
1338                "Colorado Eagles", "0:1,0:0,1:0,0:1", "10:10,16:7,9:6,5:2", 0, False)
1339
1340 print("Inserting "+leaguename+" Game Data From 12/3/2015.\n")
1341 MakeHockeyGame((sqlcur, sqlcon), 20151203, "Greenville Swamp Rabbits",
1342                "Cincinnati Cyclones", "1:0,2:0,1:3", "10:10,10:8,7:10", 0, False)
1343 MakeHockeyGame((sqlcur, sqlcon), 20151203, "Indy Fuel",
1344                "Toledo Walleye", "1:0,0:1,1:3", "5:9,4:7,10:12", 0, False)
1345 MakeHockeyGame((sqlcur, sqlcon), 20151203, "Brampton Beast",
1346                "Adirondack Thunder", "0:1,0:3,0:0", "13:9,8:14,8:5", 0, False)
1347 MakeHockeyGame((sqlcur, sqlcon), 20151203, "Tulsa Oilers",
1348                "Utah Grizzlies", "4:0,1:1,0:0", "13:9,10:10,5:7", 0, False)
1349
1350 print("Inserting "+leaguename+" Game Data From 12/4/2015.\n")
1351 MakeHockeyGame((sqlcur, sqlcon), 20151204, "Adirondack Thunder",
1352                "Brampton Beast", "0:2,2:0,3:0", "7:19,15:5,9:17", 0, False)
1353 MakeHockeyGame((sqlcur, sqlcon), 20151204, "Manchester Monarchs",
1354                "Reading Royals", "0:0,2:1,1:1", "10:4,13:7,5:11", 0, False)
1355 MakeHockeyGame((sqlcur, sqlcon), 20151204, "Greenville Swamp Rabbits",
1356                "Cincinnati Cyclones", "4:2,1:2,1:2,0:1", "16:9,12:17,16:6,0:4", 0, False)
1357 MakeHockeyGame((sqlcur, sqlcon), 20151204, "Elmira Jackals",
1358                "Kalamazoo Wings", "1:0,0:1,1:2", "12:8,20:9,17:8", 0, False)
1359 MakeHockeyGame((sqlcur, sqlcon), 20151204, "Indy Fuel",
1360                "Toledo Walleye", "1:2,1:1,0:2", "11:6,7:8,13:10", 0, False)
1361 MakeHockeyGame((sqlcur, sqlcon), 20151204, "Wheeling Nailers",
1362                "South Carolina Stingrays", "1:1,1:0,1:1", "7:14,10:12,8:14", 0, False)
1363 MakeHockeyGame((sqlcur, sqlcon), 20151204, "Allen Americans",
1364                "Rapid City Rush", "2:0,0:1,1:0", "5:10,15:8,6:11", 0, False)
1365 MakeHockeyGame((sqlcur, sqlcon), 20151204, "Evansville IceMen",
1366                "Fort Wayne Komets", "1:1,1:3,3:3", "16:9,6:5,10:7", 0, False)
1367 MakeHockeyGame((sqlcur, sqlcon), 20151204, "Idaho Steelheads",
1368                "Florida Everblades", "1:0,3:1,1:0", "11:8,9:5,7:11", 0, False)
1369 MakeHockeyGame((sqlcur, sqlcon), 20151204, "Alaska Aces",
1370                "Colorado Eagles", "2:0,1:1,3:3", "15:11,7:14,12:11", 0, False)
1371
1372 print("Inserting "+leaguename+" Game Data From 12/5/2015.\n")
1373 MakeHockeyGame((sqlcur, sqlcon), 20151205, "Manchester Monarchs",
1374                "Reading Royals", "0:1,0:1,0:1", "11:8,6:16,13:6", 0, False)
1375 MakeHockeyGame((sqlcur, sqlcon), 20151205, "Greenville Swamp Rabbits",
1376                "Norfolk Admirals", "0:2,0:0,0:1", "6:10,13:13,11:9", 0, False)
1377 MakeHockeyGame((sqlcur, sqlcon), 20151205, "Orlando Solar Bears",
1378                "Atlanta Gladiators", "0:0,2:0,2:0", "7:9,13:8,7:11", 0, False)
1379 MakeHockeyGame((sqlcur, sqlcon), 20151205, "Elmira Jackals",
1380                "Kalamazoo Wings", "0:0,2:0,1:1", "10:10,18:4,9:9", 0, False)
1381 MakeHockeyGame((sqlcur, sqlcon), 20151205, "Wheeling Nailers",
1382                "South Carolina Stingrays", "0:3,0:2,1:1", "6:18,10:10,8:13", 0, False)
1383 MakeHockeyGame((sqlcur, sqlcon), 20151205, "Allen Americans",
1384                "Utah Grizzlies", "4:1,1:1,2:1", "9:18,4:10,5:16", 0, False)
1385 MakeHockeyGame((sqlcur, sqlcon), 20151205, "Missouri Mavericks",
1386                "Wichita Thunder", "2:1,3:1,0:0", "7:8,11:5,7:9", 0, False)
1387 MakeHockeyGame((sqlcur, sqlcon), 20151205, "Idaho Steelheads",
1388                "Florida Everblades", "0:2,1:0,0:1", "11:10,12:3,11:7", 0, False)
1389 MakeHockeyGame((sqlcur, sqlcon), 20151205, "Alaska Aces",
1390                "Colorado Eagles", "0:2,3:0,1:1", "7:3,7:12,8:7", 0, False)
1391
1392 print("Inserting "+leaguename+" Game Data From 12/6/2015.\n")
1393 MakeHockeyGame((sqlcur, sqlcon), 20151206, "Brampton Beast",
1394                "Kalamazoo Wings", "0:0,0:0,3:0", "9:4,8:12,16:8", 0, False)
1395 MakeHockeyGame((sqlcur, sqlcon), 20151206, "Manchester Monarchs",
1396                "Reading Royals", "0:1,2:1,2:0", "7:8,7:15,11:9", 0, False)
1397 MakeHockeyGame((sqlcur, sqlcon), 20151206, "Orlando Solar Bears",
1398                "Atlanta Gladiators", "1:1,0:0,2:3", "10:18,10:5,13:13", 0, False)
1399 MakeHockeyGame((sqlcur, sqlcon), 20151206, "Indy Fuel",
1400                "South Carolina Stingrays", "0:1,1:0,0:2", "10:10,9:5,6:8", 0, False)
1401 MakeHockeyGame((sqlcur, sqlcon), 20151206, "Wheeling Nailers", "Elmira Jackals",
1402                "0:2,2:0,0:0,0:0,0:1", "13:7,15:8,13:7,3:2,0:1", 0, False)
1403 MakeHockeyGame((sqlcur, sqlcon), 20151206, "Evansville IceMen",
1404                "Quad City Mallards", "1:1,3:1,1:3,0:1", "12:8,19:12,12:12,1:3", 0, False)
1405
1406 print("Inserting "+leaguename+" Game Data From 12/9/2015.\n")
1407 MakeHockeyGame((sqlcur, sqlcon), 20151209, "Brampton Beast",
1408                "Manchester Monarchs", "1:0,1:1,1:3", "7:7,11:9,6:10", 0, False)
1409 MakeHockeyGame((sqlcur, sqlcon), 20151209, "Elmira Jackals",
1410                "Norfolk Admirals", "1:0,2:1,1:2", "10:18,10:21,13:15", 0, False)
1411 MakeHockeyGame((sqlcur, sqlcon), 20151209, "Toledo Walleye",
1412                "Evansville IceMen", "1:0,1:1,0:2", "11:7,9:13,11:15", 0, False)
1413 MakeHockeyGame((sqlcur, sqlcon), 20151209, "Florida Everblades",
1414                "Reading Royals", "0:0,0:2,2:0,0:0,1:0", "11:4,9:11,11:8,3:5,1:0", 0, False)
1415 MakeHockeyGame((sqlcur, sqlcon), 20151209, "Allen Americans",
1416                "Idaho Steelheads", "2:0,0:0,2:0", "8:9,9:8,10:12", 0, False)
1417 MakeHockeyGame((sqlcur, sqlcon), 20151209, "Utah Grizzlies",
1418                "Alaska Aces", "0:0,1:0,4:0", "7:9,13:7,14:10", 0, False)
1419 MakeHockeyGame((sqlcur, sqlcon), 20151209, "Colorado Eagles",
1420                "Wichita Thunder", "1:0,1:0,0:1", "15:7,8:8,10:7", 0, False)
1421
1422 print("Inserting "+leaguename+" Game Data From 12/8/2015.\n")
1423 MakeHockeyGame((sqlcur, sqlcon), 20151208, "Rapid City Rush",
1424                "Wichita Thunder", "1:1,4:0,2:1", "9:5,10:10,6:11", 0, False)
1425
1426 print("Inserting "+leaguename+" Game Data From 12/10/2015.\n")
1427 MakeHockeyGame((sqlcur, sqlcon), 20151210, "Greenville Swamp Rabbits",
1428                "Orlando Solar Bears", "2:0,1:0,3:2", "10:12,15:10,9:10", 0, False)
1429 MakeHockeyGame((sqlcur, sqlcon), 20151210, "Indy Fuel",
1430                "Wheeling Nailers", "1:1,0:0,0:1", "14:8,9:12,8:11", 0, False)
1431 MakeHockeyGame((sqlcur, sqlcon), 20151210, "Tulsa Oilers",
1432                "Idaho Steelheads", "0:0,3:0,1:2", "5:7,16:10,7:10", 0, False)
1433
1434 print("Inserting "+leaguename+" Game Data From 12/11/2015.\n")
1435 MakeHockeyGame((sqlcur, sqlcon), 20151211, "Kalamazoo Wings",
1436                "Brampton Beast", "3:0,0:0,1:0", "16:13,8:6,12:15", 0, False)
1437 MakeHockeyGame((sqlcur, sqlcon), 20151211, "Adirondack Thunder",
1438                "Norfolk Admirals", "0:0,1:2,0:4", "11:5,7:10,11:10", 0, False)
1439 MakeHockeyGame((sqlcur, sqlcon), 20151211, "Greenville Swamp Rabbits",
1440                "Orlando Solar Bears", "0:1,1:0,1:1,0:1", "9:9,11:8,8:16,2:4", 0, False)
1441 MakeHockeyGame((sqlcur, sqlcon), 20151211, "Elmira Jackals", "Manchester Monarchs",
1442                "1:1,0:0,0:0,0:0,1:0", "10:13,10:18,12:12,5:2,1:0", 0, False)
1443 MakeHockeyGame((sqlcur, sqlcon), 20151211, "Toledo Walleye", "Wheeling Nailers",
1444                "0:0,1:0,0:1,0:0,1:0", "13:9,14:8,5:13,5:4,1:0", 0, False)
1445 MakeHockeyGame((sqlcur, sqlcon), 20151211, "Florida Everblades",
1446                "Reading Royals", "2:0,0:0,0:2,1:0", "14:8,10:7,5:8,1:0", 0, False)
1447 MakeHockeyGame((sqlcur, sqlcon), 20151211, "Atlanta Gladiators",
1448                "South Carolina Stingrays", "1:1,2:1,0:0", "6:16,9:10,6:5", 0, False)
1449 MakeHockeyGame((sqlcur, sqlcon), 20151211, "Fort Wayne Komets",
1450                "Indy Fuel", "1:1,1:1,0:0,0:1", "9:10,9:11,12:8,0:2", 0, False)
1451 MakeHockeyGame((sqlcur, sqlcon), 20151211, "Tulsa Oilers",
1452                "Idaho Steelheads", "1:1,1:1,0:2", "12:16,5:14,8:8", 0, False)
1453 MakeHockeyGame((sqlcur, sqlcon), 20151211, "Evansville IceMen",
1454                "Cincinnati Cyclones", "2:0,4:2,1:1", "12:9,13:11,14:9", 0, False)
1455 MakeHockeyGame((sqlcur, sqlcon), 20151211, "Utah Grizzlies",
1456                "Alaska Aces", "2:0,0:1,1:1", "10:9,8:9,8:12", 0, False)
1457 MakeHockeyGame((sqlcur, sqlcon), 20151211, "Colorado Eagles",
1458                "Wichita Thunder", "0:1,3:0,0:1", "9:9,13:11,4:12", 0, False)
1459 MakeHockeyGame((sqlcur, sqlcon), 20151211, "Rapid City Rush",
1460                "Quad City Mallards", "1:1,2:1,2:0", "7:13,8:9,7:9", 0, False)
1461
1462 print("Inserting "+leaguename+" Game Data From 12/12/2015.\n")
1463 MakeHockeyGame((sqlcur, sqlcon), 20151212, "Kalamazoo Wings",
1464                "Brampton Beast", "3:0,0:1,0:0", "11:11,5:11,5:16", 0, False)
1465 MakeHockeyGame((sqlcur, sqlcon), 20151212, "Adirondack Thunder",
1466                "Manchester Monarchs", "1:0,1:1,1:2,0:1", "11:14,15:14,6:9,0:3", 0, False)
1467 MakeHockeyGame((sqlcur, sqlcon), 20151212, "Florida Everblades",
1468                "Reading Royals", "0:2,1:0,0:0", "5:10,10:16,15:4", 0, False)
1469 MakeHockeyGame((sqlcur, sqlcon), 20151212, "Elmira Jackals",
1470                "Norfolk Admirals", "1:0,1:0,2:0", "9:6,6:12,8:28", 0, False)
1471 MakeHockeyGame((sqlcur, sqlcon), 20151212, "Atlanta Gladiators",
1472                "Orlando Solar Bears", "1:1,0:0,0:0,1:0", "13:9,12:5,11:6,3:0", 0, False)
1473 MakeHockeyGame((sqlcur, sqlcon), 20151212, "South Carolina Stingrays",
1474                "Greenville Swamp Rabbits", "3:0,1:1,1:0", "15:13,6:10,11:8", 0, False)
1475 MakeHockeyGame((sqlcur, sqlcon), 20151212, "Indy Fuel",
1476                "Fort Wayne Komets", "1:2,0:0,1:1", "7:19,14:8,12:4", 0, False)
1477 MakeHockeyGame((sqlcur, sqlcon), 20151212, "Cincinnati Cyclones",
1478                "Evansville IceMen", "2:1,2:2,2:1", "9:6,13:9,6:10", 0, False)
1479 MakeHockeyGame((sqlcur, sqlcon), 20151212, "Wheeling Nailers",
1480                "Toledo Walleye", "1:1,4:1,1:0", "11:7,14:7,11:9", 0, False)
1481 MakeHockeyGame((sqlcur, sqlcon), 20151212, "Utah Grizzlies",
1482                "Alaska Aces", "2:1,0:1,2:0", "9:15,13:5,9:15", 0, False)
1483 MakeHockeyGame((sqlcur, sqlcon), 20151212, "Colorado Eagles",
1484                "Wichita Thunder", "1:0,3:0,0:0", "16:8,12:6,6:6", 0, False)
1485 MakeHockeyGame((sqlcur, sqlcon), 20151212, "Rapid City Rush",
1486                "Quad City Mallards", "1:0,0:0,0:2", "7:14,10:10,3:13", 0, False)
1487
1488 print("Inserting "+leaguename+" Game Data From 12/13/2015.\n")
1489 MakeHockeyGame((sqlcur, sqlcon), 20151213, "Brampton Beast",
1490                "Norfolk Admirals", "3:1,0:3,2:1,0:1", "12:6,10:12,13:17,0:1", 0, False)
1491 MakeHockeyGame((sqlcur, sqlcon), 20151213, "Manchester Monarchs",
1492                "Adirondack Thunder", "0:0,0:0,0:2", "9:8,14:10,7:16", 0, False)
1493 MakeHockeyGame((sqlcur, sqlcon), 20151213, "South Carolina Stingrays",
1494                "Atlanta Gladiators", "1:1,1:1,1:0", "13:9,13:10,8:8", 0, False)
1495 MakeHockeyGame((sqlcur, sqlcon), 20151213, "Fort Wayne Komets",
1496                "Evansville IceMen", "2:1,1:2,1:3", "12:8,11:6,10:9", 0, False)
1497 MakeHockeyGame((sqlcur, sqlcon), 20151213, "Allen Americans",
1498                "Idaho Steelheads", "0:1,1:1,1:0,0:1", "1:14,8:9,8:5,1:2", 0, False)
1499 MakeHockeyGame((sqlcur, sqlcon), 20151213, "Tulsa Oilers",
1500                "Missouri Mavericks", "1:2,2:0,1:1", "14:7,19:7,8:10", 0, False)
1501
1502 print("Inserting "+leaguename+" Game Data From 12/16/2015.\n")
1503 MakeHockeyGame((sqlcur, sqlcon), 20151216, "Toledo Walleye",
1504                "Indy Fuel", "1:1,2:0,2:0", "12:12,9:7,5:11", 0, False)
1505 MakeHockeyGame((sqlcur, sqlcon), 20151216, "Adirondack Thunder",
1506                "Elmira Jackals", "3:3,0:1,1:2", "6:7,20:5,12:4", 0, False)
1507 MakeHockeyGame((sqlcur, sqlcon), 20151216, "Evansville IceMen",
1508                "Atlanta Gladiators", "2:1,2:2,1:2,0:1", "7:5,13:14,10:17,2:1", 0, False)
1509 MakeHockeyGame((sqlcur, sqlcon), 20151216, "Norfolk Admirals",
1510                "Reading Royals", "1:2,2:1,0:3", "7:9,17:8,3:20", 0, False)
1511 MakeHockeyGame((sqlcur, sqlcon), 20151216, "Florida Everblades",
1512                "Orlando Solar Bears", "0:0,2:1,1:1", "14:13,19:6,6:10", 0, False)
1513 MakeHockeyGame((sqlcur, sqlcon), 20151216, "Colorado Eagles",
1514                "Allen Americans", "0:0,3:0,1:1", "11:4,10:13,4:11", 0, False)
1515 MakeHockeyGame((sqlcur, sqlcon), 20151216, "Idaho Steelheads",
1516                "Utah Grizzlies", "1:4,4:0,3:1", "7:6,20:7,9:9", 0, False)
1517
1518 print("Inserting "+leaguename+" Game Data From 12/17/2015.\n")
1519 MakeHockeyGame((sqlcur, sqlcon), 20151217, "Kalamazoo Wings",
1520                "Manchester Monarchs", "1:0,0:0,0:1,0:1", "8:12,7:15,10:7,1:2", 0, False)
1521 MakeHockeyGame((sqlcur, sqlcon), 20151217, "Brampton Beast", "Toledo Walleye",
1522                "1:1,2:1,0:1,0:0,0:1", "11:10,8:8,12:10,3:2,0:1", 0, False)
1523
1524 print("Inserting "+leaguename+" Game Data From 12/18/2015.\n")
1525 MakeHockeyGame((sqlcur, sqlcon), 20151218, "Kalamazoo Wings",
1526                "Atlanta Gladiators", "1:1,0:1,0:1", "8:13,4:12,8:6", 0, False)
1527 MakeHockeyGame((sqlcur, sqlcon), 20151218, "Reading Royals",
1528                "Elmira Jackals", "1:1,0:2,1:2", "11:10,8:7,15:6", 0, False)
1529 MakeHockeyGame((sqlcur, sqlcon), 20151218, "South Carolina Stingrays",
1530                "Florida Everblades", "0:1,0:0,1:0,0:1", "7:13,14:7,8:6,3:1", 0, False)
1531 MakeHockeyGame((sqlcur, sqlcon), 20151218, "Norfolk Admirals",
1532                "Adirondack Thunder", "1:2,1:1,1:2", "10:14,14:9,7:10", 0, False)
1533 MakeHockeyGame((sqlcur, sqlcon), 20151218, "Fort Wayne Komets",
1534                "Manchester Monarchs", "0:1,1:3,2:1", "7:8,7:13,11:10", 0, False)
1535 MakeHockeyGame((sqlcur, sqlcon), 20151218, "Tulsa Oilers",
1536                "Wichita Thunder", "0:1,0:1,2:0,0:1", "7:10,6:8,10:5,0:1", 0, False)
1537 MakeHockeyGame((sqlcur, sqlcon), 20151218, "Missouri Mavericks",
1538                "Cincinnati Cyclones", "3:0,1:2,1:0", "16:7,6:11,4:9", 0, False)
1539 MakeHockeyGame((sqlcur, sqlcon), 20151218, "Quad City Mallards",
1540                "Wheeling Nailers", "0:0,0:2,1:2", "11:10,13:17,16:12", 0, False)
1541 MakeHockeyGame((sqlcur, sqlcon), 20151218, "Evansville IceMen",
1542                "Indy Fuel", "0:1,0:0,2:0", "7:13,6:6,9:10", 0, False)
1543 MakeHockeyGame((sqlcur, sqlcon), 20151218, "Utah Grizzlies",
1544                "Colorado Eagles", "0:0,3:0,1:0", "13:3,11:11,9:7", 0, False)
1545 MakeHockeyGame((sqlcur, sqlcon), 20151218, "Idaho Steelheads",
1546                "Allen Americans", "1:1,1:1,4:1", "5:15,9:11,10:10", 0, False)
1547 MakeHockeyGame((sqlcur, sqlcon), 20151218, "Alaska Aces",
1548                "Rapid City Rush", "0:0,2:2,3:0", "15:4,12:9,18:8", 0, False)
1549
1550 print("Inserting "+leaguename+" Game Data From 12/19/2015.\n")
1551 MakeHockeyGame((sqlcur, sqlcon), 20151219, "Kalamazoo Wings",
1552                "Atlanta Gladiators", "0:2,3:1,0:2", "5:6,12:3,8:14", 0, False)
1553 MakeHockeyGame((sqlcur, sqlcon), 20151219, "Reading Royals",
1554                "Elmira Jackals", "1:0,0:0,1:0", "14:10,13:10,9:13", 0, False)
1555 MakeHockeyGame((sqlcur, sqlcon), 20151219, "Greenville Swamp Rabbits",
1556                "Orlando Solar Bears", "2:0,0:1,4:0", "11:5,8:14,9:8", 0, False)
1557 MakeHockeyGame((sqlcur, sqlcon), 20151219, "South Carolina Stingrays",
1558                "Florida Everblades", "0:1,0:0,1:3", "9:7,9:7,9:6", 0, False)
1559 MakeHockeyGame((sqlcur, sqlcon), 20151219, "Toledo Walleye",
1560                "Manchester Monarchs", "0:0,2:0,0:0", "5:5,14:2,4:8", 0, False)
1561 MakeHockeyGame((sqlcur, sqlcon), 20151219, "Norfolk Admirals",
1562                "Adirondack Thunder", "2:1,0:0,0:0", "14:13,9:7,5:16", 0, False)
1563 MakeHockeyGame((sqlcur, sqlcon), 20151219, "Fort Wayne Komets",
1564                "Brampton Beast", "2:0,3:1,0:0", "9:7,13:10,9:11", 0, False)
1565 MakeHockeyGame((sqlcur, sqlcon), 20151219, "Tulsa Oilers", "Wichita Thunder",
1566                "1:1,0:0,1:1,0:0,1:0", "10:7,7:7,8:7,4:1,1:0", 0, False)
1567 MakeHockeyGame((sqlcur, sqlcon), 20151219, "Missouri Mavericks",
1568                "Cincinnati Cyclones", "1:0,2:0,0:2", "15:4,11:9,8:18", 0, False)
1569 MakeHockeyGame((sqlcur, sqlcon), 20151219, "Quad City Mallards",
1570                "Wheeling Nailers", "2:1,1:2,2:0", "7:16,12:11,12:15", 0, False)
1571 MakeHockeyGame((sqlcur, sqlcon), 20151219, "Evansville IceMen",
1572                "Indy Fuel", "0:1,1:1,0:1", "14:14,16:13,15:5", 0, False)
1573 MakeHockeyGame((sqlcur, sqlcon), 20151219, "Utah Grizzlies",
1574                "Colorado Eagles", "3:2,1:0,2:1", "11:9,10:9,7:8", 0, False)
1575 MakeHockeyGame((sqlcur, sqlcon), 20151219, "Idaho Steelheads",
1576                "Allen Americans", "0:2,2:0,0:0,0:0,0:1", "9:4,14:4,9:4,1:2,0:1", 0, False)
1577 MakeHockeyGame((sqlcur, sqlcon), 20151219, "Alaska Aces",
1578                "Rapid City Rush", "4:1,0:0,0:0", "15:5,8:10,8:9", 0, False)
1579
1580 print("Inserting "+leaguename+" Game Data From 12/20/2015.\n")
1581 MakeHockeyGame((sqlcur, sqlcon), 20151220, "Greenville Swamp Rabbits",
1582                "Orlando Solar Bears", "0:0,3:3,4:1", "10:17,10:14,10:13", 0, False)
1583 MakeHockeyGame((sqlcur, sqlcon), 20151220, "Indy Fuel",
1584                "Toledo Walleye", "0:1,3:2,0:1", "17:10,11:6,8:8", 0, False)
1585 MakeHockeyGame((sqlcur, sqlcon), 20151220, "Missouri Mavericks",
1586                "Quad City Mallards", "1:1,1:1,2:0", "16:7,10:10,14:13", 0, False)
1587 MakeHockeyGame((sqlcur, sqlcon), 20151220, "Wichita Thunder",
1588                "Cincinnati Cyclones", "0:2,1:2,0:2", "5:10,6:11,5:14", 0, False)
1589 MakeHockeyGame((sqlcur, sqlcon), 20151220, "Alaska Aces",
1590                "Rapid City Rush", "0:0,1:2,1:1", "11:8,13:6,18:2", 0, False)
1591
1592 print("Inserting "+leaguename+" Game Data From 12/21/2015.\n")
1593 MakeHockeyGame((sqlcur, sqlcon), 20151221, "Fort Wayne Komets",
1594                "Atlanta Gladiators", "1:0,1:0,2:0", "11:11,11:5,11:5", 0, False)
1595 MakeHockeyGame((sqlcur, sqlcon), 20151221, "Allen Americans",
1596                "Tulsa Oilers", "1:0,0:1,0:2", "8:10,6:5,6:11", 0, False)
1597
1598 print("Inserting "+leaguename+" Game Data From 12/26/2015.\n")
1599 MakeHockeyGame((sqlcur, sqlcon), 20151226, "Adirondack Thunder",
1600                "Manchester Monarchs", "3:0,1:0,2:1", "9:3,10:14,12:11", 0, False)
1601 MakeHockeyGame((sqlcur, sqlcon), 20151226, "Elmira Jackals",
1602                "Reading Royals", "0:1,0:0,0:3", "10:7,18:8,17:10", 0, False)
1603 MakeHockeyGame((sqlcur, sqlcon), 20151226, "Atlanta Gladiators",
1604                "Greenville Swamp Rabbits", "0:0,1:2,1:0,0:1", "9:7,12:14,12:7,3:6", 0, False)
1605 MakeHockeyGame((sqlcur, sqlcon), 20151226, "South Carolina Stingrays",
1606                "Norfolk Admirals", "2:0,1:2,2:0", "10:5,15:5,9:9", 0, False)
1607 MakeHockeyGame((sqlcur, sqlcon), 20151226, "Toledo Walleye",
1608                "Wheeling Nailers", "1:0,1:0,2:1", "9:8,11:15,10:12", 0, False)
1609 MakeHockeyGame((sqlcur, sqlcon), 20151226, "Fort Wayne Komets",
1610                "Kalamazoo Wings", "2:1,0:1,3:0", "17:6,7:8,18:9", 0, False)
1611 MakeHockeyGame((sqlcur, sqlcon), 20151226, "Wichita Thunder", "Tulsa Oilers",
1612                "0:1,1:0,0:0,0:0,0:1", "11:13,15:9,9:9,3:1,0:1", 0, False)
1613 MakeHockeyGame((sqlcur, sqlcon), 20151226, "Allen Americans",
1614                "Missouri Mavericks", "1:1,0:1,0:1", "15:8,9:9,9:6", 0, False)
1615 MakeHockeyGame((sqlcur, sqlcon), 20151226, "Quad City Mallards",
1616                "Indy Fuel", "1:1,0:0,0:3", "9:17,6:13,6:12", 0, False)
1617 MakeHockeyGame((sqlcur, sqlcon), 20151226, "Evansville IceMen",
1618                "Cincinnati Cyclones", "0:1,2:1,2:0", "16:6,14:8,21:5", 0, False)
1619 MakeHockeyGame((sqlcur, sqlcon), 20151226, "Colorado Eagles",
1620                "Rapid City Rush", "0:1,2:1,1:1,1:0", "12:5,15:7,6:9,2:0", 0, False)
1621 MakeHockeyGame((sqlcur, sqlcon), 20151226, "Idaho Steelheads",
1622                "Utah Grizzlies", "1:0,2:2,2:0", "11:11,8:9,5:7", 0, False)
1623
1624 print("Inserting "+leaguename+" Game Data From 12/27/2015.\n")
1625 MakeHockeyGame((sqlcur, sqlcon), 20151227, "Brampton Beast",
1626                "Reading Royals", "0:1,1:2,4:2,1:0", "10:5,10:10,19:5,1:0", 0, False)
1627 MakeHockeyGame((sqlcur, sqlcon), 20151227, "Manchester Monarchs",
1628                "Adirondack Thunder", "1:0,1:0,0:0", "10:13,11:13,5:18", 0, False)
1629 MakeHockeyGame((sqlcur, sqlcon), 20151227, "Greenville Swamp Rabbits",
1630                "Atlanta Gladiators", "1:1,1:0,0:1,0:1", "9:8,8:18,7:15,3:4", 0, False)
1631 MakeHockeyGame((sqlcur, sqlcon), 20151227, "Indy Fuel",
1632                "Quad City Mallards", "2:1,0:0,0:0", "6:7,7:10,7:11", 0, False)
1633 MakeHockeyGame((sqlcur, sqlcon), 20151227, "South Carolina Stingrays",
1634                "Norfolk Admirals", "1:0,0:0,2:0", "8:4,8:11,9:10", 0, False)
1635 MakeHockeyGame((sqlcur, sqlcon), 20151227, "Wheeling Nailers",
1636                "Kalamazoo Wings", "0:1,1:5,3:1", "13:11,14:11,12:3", 0, False)
1637 MakeHockeyGame((sqlcur, sqlcon), 20151227, "Orlando Solar Bears",
1638                "Florida Everblades", "2:1,1:3,0:0", "8:12,12:15,9:5", 0, False)
1639 MakeHockeyGame((sqlcur, sqlcon), 20151227, "Rapid City Rush",
1640                "Colorado Eagles", "0:0,0:1,0:2", "6:7,6:9,14:12", 0, False)
1641 MakeHockeyGame((sqlcur, sqlcon), 20151227, "Wichita Thunder",
1642                "Allen Americans", "0:1,1:1,1:0,0:1", "10:11,14:7,7:14,3:2", 0, False)
1643
1644 print("Inserting "+leaguename+" Game Data From 12/28/2015.\n")
1645 MakeHockeyGame((sqlcur, sqlcon), 20151228, "Brampton Beast",
1646                "Reading Royals", "0:1,2:1,0:0,0:1", "8:4,12:4,4:7,4:2", 0, False)
1647 MakeHockeyGame((sqlcur, sqlcon), 20151228, "Utah Grizzlies",
1648                "Idaho Steelheads", "0:0,1:2,0:2", "10:9,8:14,7:5", 0, False)
1649
1650 print("Inserting "+leaguename+" Game Data From 12/29/2015.\n")
1651 MakeHockeyGame((sqlcur, sqlcon), 20151229, "Adirondack Thunder",
1652                "Greenville Swamp Rabbits", "1:1,0:0,0:2", "14:7,8:7,12:7", 0, False)
1653 MakeHockeyGame((sqlcur, sqlcon), 20151229, "Orlando Solar Bears",
1654                "South Carolina Stingrays", "1:3,2:0,0:2", "7:14,13:16,4:12", 0, False)
1655 MakeHockeyGame((sqlcur, sqlcon), 20151229, "Atlanta Gladiators",
1656                "Norfolk Admirals", "0:0,1:0,3:0", "7:11,8:11,12:13", 0, False)
1657 MakeHockeyGame((sqlcur, sqlcon), 20151229, "Fort Wayne Komets",
1658                "Brampton Beast", "1:1,1:2,1:0,0:1", "12:7,7:15,20:5,3:2", 0, False)
1659 MakeHockeyGame((sqlcur, sqlcon), 20151229, "Cincinnati Cyclones",
1660                "Indy Fuel", "1:2,0:1,0:2", "9:11,8:9,6:5", 0, False)
1661
1662 print("Inserting "+leaguename+" Game Data From 12/30/2015.\n")
1663 MakeHockeyGame((sqlcur, sqlcon), 20151230, "Atlanta Gladiators",
1664                "Norfolk Admirals", "2:2,1:1,0:0,1:0", "15:15,6:14,8:8,3:0", 0, False)
1665 MakeHockeyGame((sqlcur, sqlcon), 20151230, "Quad City Mallards",
1666                "Evansville IceMen", "1:1,1:2,0:0", "10:15,18:15,8:11", 0, False)
1667 MakeHockeyGame((sqlcur, sqlcon), 20151230, "Toledo Walleye",
1668                "Elmira Jackals", "0:0,1:1,0:1", "11:13,14:9,10:8", 0, False)
1669 MakeHockeyGame((sqlcur, sqlcon), 20151230, "Wichita Thunder",
1670                "Allen Americans", "1:1,1:1,1:2", "11:10,17:7,11:15", 0, False)
1671 MakeHockeyGame((sqlcur, sqlcon), 20151230, "Idaho Steelheads",
1672                "Colorado Eagles", "2:1,3:2,1:0", "10:7,13:11,4:13", 0, False)
1673
1674 print("Inserting "+leaguename+" Game Data From 12/31/2015.\n")
1675 MakeHockeyGame((sqlcur, sqlcon), 20151231, "Adirondack Thunder",
1676                "Reading Royals", "1:0,0:1,0:0,0:0,1:0", "15:14,9:6,7:5,9:2,1:0", 0, False)
1677 MakeHockeyGame((sqlcur, sqlcon), 20151231, "Kalamazoo Wings",
1678                "Elmira Jackals", "3:2,1:1,1:0", "11:13,17:14,9:8", 0, False)
1679 MakeHockeyGame((sqlcur, sqlcon), 20151231, "Cincinnati Cyclones",
1680                "Toledo Walleye", "0:0,1:0,3:0", "7:7,6:9,10:2", 0, False)
1681 MakeHockeyGame((sqlcur, sqlcon), 20151231, "Wheeling Nailers",
1682                "Brampton Beast", "1:1,0:2,2:0,0:1", "9:10,11:12,13:3,1:1", 0, False)
1683 MakeHockeyGame((sqlcur, sqlcon), 20151231, "Manchester Monarchs",
1684                "Greenville Swamp Rabbits", "0:0,1:0,1:2,1:0", "9:3,11:9,6:13,4:0", 0, False)
1685 MakeHockeyGame((sqlcur, sqlcon), 20151231, "Fort Wayne Komets",
1686                "Indy Fuel", "2:0,5:0,0:0", "8:12,16:12,9:13", 0, False)
1687 MakeHockeyGame((sqlcur, sqlcon), 20151231, "Missouri Mavericks",
1688                "Wichita Thunder", "3:1,3:0,1:0", "9:6,17:4,9:5", 0, False)
1689 MakeHockeyGame((sqlcur, sqlcon), 20151231, "Evansville IceMen",
1690                "Quad City Mallards", "0:2,3:2,1:2", "14:12,12:10,10:7", 0, False)
1691 MakeHockeyGame((sqlcur, sqlcon), 20151231, "Rapid City Rush",
1692                "Tulsa Oilers", "0:1,0:1,1:0", "8:9,8:9,10:6", 0, False)
1693 MakeHockeyGame((sqlcur, sqlcon), 20151231, "Alaska Aces",
1694                "Utah Grizzlies", "0:2,2:1,1:3", "18:7,11:10,11:10", 0, False)
1695
1696 print("Inserting "+leaguename+" Game Data From 1/1/2016.\n")
1697 MakeHockeyGame((sqlcur, sqlcon), 20160101, "Missouri Mavericks",
1698                "Allen Americans", "1:0,3:1,0:0", "13:6,5:13,13:14", 0, False)
1699 MakeHockeyGame((sqlcur, sqlcon), 20160101, "Florida Everblades",
1700                "Orlando Solar Bears", "1:1,0:2,2:2", "10:8,7:11,8:8", 0, False)
1701 MakeHockeyGame((sqlcur, sqlcon), 20160101, "Indy Fuel",
1702                "Fort Wayne Komets", "0:0,1:1,0:1", "10:7,11:13,12:8", 0, False)
1703 MakeHockeyGame((sqlcur, sqlcon), 20160101, "Idaho Steelheads",
1704                "Colorado Eagles", "0:2,1:0,0:1", "6:7,8:7,15:1", 0, False)
1705 MakeHockeyGame((sqlcur, sqlcon), 20160101, "Alaska Aces",
1706                "Utah Grizzlies", "0:0,1:1,0:1", "10:12,9:13,10:5", 0, False)
1707
1708 print("Inserting "+leaguename+" Game Data From 1/2/2016.\n")
1709 MakeHockeyGame((sqlcur, sqlcon), 20160102, "Manchester Monarchs",
1710                "Greenville Swamp Rabbits", "0:1,0:1,2:0,0:0,0:1", "8:11,13:20,17:5,6:2,0:1", 0, False)
1711 MakeHockeyGame((sqlcur, sqlcon), 20160102, "Kalamazoo Wings",
1712                "Elmira Jackals", "0:2,2:3,2:0", "6:10,9:14,15:4", 0, False)
1713 MakeHockeyGame((sqlcur, sqlcon), 20160102, "Reading Royals",
1714                "Adirondack Thunder", "0:0,3:0,2:0", "10:6,11:8,10:8", 0, False)
1715 MakeHockeyGame((sqlcur, sqlcon), 20160102, "Orlando Solar Bears",
1716                "Florida Everblades", "1:0,0:0,2:1", "12:12,12:8,9:13", 0, False)
1717 MakeHockeyGame((sqlcur, sqlcon), 20160102, "South Carolina Stingrays",
1718                "Cincinnati Cyclones", "1:0,0:0,3:1", "12:6,9:14,15:9", 0, False)
1719 MakeHockeyGame((sqlcur, sqlcon), 20160102, "Toledo Walleye",
1720                "Fort Wayne Komets", "1:0,0:2,0:0", "16:7,6:12,10:10", 0, False)
1721 MakeHockeyGame((sqlcur, sqlcon), 20160102, "Norfolk Admirals",
1722                "Atlanta Gladiators", "0:0,2:2,1:0", "8:10,9:15,10:10", 0, False)
1723 MakeHockeyGame((sqlcur, sqlcon), 20160102, "Indy Fuel",
1724                "Wichita Thunder", "1:1,0:1,0:0", "9:9,9:11,5:6", 0, False)
1725 MakeHockeyGame((sqlcur, sqlcon), 20160102, "Wheeling Nailers",
1726                "Brampton Beast", "1:0,2:0,2:1", "10:9,11:10,12:8", 0, False)
1727 MakeHockeyGame((sqlcur, sqlcon), 20160102, "Quad City Mallards",
1728                "Allen Americans", "0:1,1:1,0:2", "8:6,6:18,5:10", 0, False)
1729 MakeHockeyGame((sqlcur, sqlcon), 20160102, "Evansville IceMen",
1730                "Missouri Mavericks", "2:1,1:0,0:2,0:1", "8:14,11:5,9:10,2:3", 0, False)
1731 MakeHockeyGame((sqlcur, sqlcon), 20160102, "Rapid City Rush",
1732                "Tulsa Oilers", "2:1,0:1,2:1", "13:11,7:8,11:8", 0, False)
1733 MakeHockeyGame((sqlcur, sqlcon), 20160102, "Idaho Steelheads",
1734                "Colorado Eagles", "1:0,0:0,0:0", "12:10,7:10,5:8", 0, False)
1735 MakeHockeyGame((sqlcur, sqlcon), 20160102, "Alaska Aces",
1736                "Utah Grizzlies", "1:1,2:0,0:1", "16:8,14:9,8:15", 0, False)
1737
1738 print("Inserting "+leaguename+" Game Data From 1/3/2016.\n")
1739 MakeHockeyGame((sqlcur, sqlcon), 20160103, "Manchester Monarchs",
1740                "Greenville Swamp Rabbits", "0:0,1:0,1:2,0:0,0:1", "14:7,12:12,8:12,2:3,0:1", 0, False)
1741 MakeHockeyGame((sqlcur, sqlcon), 20160103, "South Carolina Stingrays",
1742                "Cincinnati Cyclones", "0:1,1:1,1:2", "19:6,12:13,14:9", 0, False)
1743 MakeHockeyGame((sqlcur, sqlcon), 20160103, "Reading Royals",
1744                "Adirondack Thunder", "0:2,0:0,2:1", "9:5,14:9,11:8", 0, False)
1745 MakeHockeyGame((sqlcur, sqlcon), 20160103, "Wheeling Nailers",
1746                "Norfolk Admirals", "2:1,1:4,0:0", "12:9,7:21,7:8", 0, False)
1747 MakeHockeyGame((sqlcur, sqlcon), 20160103, "Toledo Walleye",
1748                "Elmira Jackals", "1:0,3:0,0:1", "13:4,13:7,11:9", 0, False)
1749 MakeHockeyGame((sqlcur, sqlcon), 20160103, "Orlando Solar Bears",
1750                "Florida Everblades", "1:1,0:0,0:3", "7:12,4:7,8:6", 0, False)
1751 MakeHockeyGame((sqlcur, sqlcon), 20160103, "Evansville IceMen",
1752                "Wichita Thunder", "0:1,1:1,1:0,0:0,0:1", "3:9,7:5,12:8,1:3,0:1", 0, False)
1753
1754 print("Inserting "+leaguename+" Game Data From 1/6/2016.\n")
1755 MakeHockeyGame((sqlcur, sqlcon), 20160106, "Adirondack Thunder",
1756                "Manchester Monarchs", "1:0,2:0,2:2", "15:12,12:7,8:8", 0, False)
1757 MakeHockeyGame((sqlcur, sqlcon), 20160106, "Atlanta Gladiators",
1758                "Cincinnati Cyclones", "2:0,3:1,0:1", "7:8,18:15,8:14", 0, False)
1759 MakeHockeyGame((sqlcur, sqlcon), 20160106, "Norfolk Admirals",
1760                "Orlando Solar Bears", "0:3,2:1,0:0", "18:11,14:12,9:5", 0, False)
1761 MakeHockeyGame((sqlcur, sqlcon), 20160106, "Utah Grizzlies",
1762                "Rapid City Rush", "0:1,0:0,1:2", "14:13,14:3,14:12", 0, False)
1763
1764 print("Inserting "+leaguename+" Game Data From 1/5/2016.\n")
1765 MakeHockeyGame((sqlcur, sqlcon), 20160105, "Tulsa Oilers", "Missouri Mavericks",
1766                "0:2,3:1,0:0,0:0,0:1", "5:13,20:6,7:4,0:2,0:1", 0, False)
1767
1768 print("Inserting "+leaguename+" Game Data From 1/7/2016.\n")
1769 MakeHockeyGame((sqlcur, sqlcon), 20160107, "Greenville Swamp Rabbits",
1770                "Florida Everblades", "0:1,0:0,1:1", "6:13,7:15,9:13", 0, False)
1771
1772 print("Inserting "+leaguename+" Game Data From 1/8/2016.\n")
1773 MakeHockeyGame((sqlcur, sqlcon), 20160108, "Reading Royals",
1774                "Toledo Walleye", "0:1,0:1,1:1", "14:6,21:4,14:5", 0, False)
1775 MakeHockeyGame((sqlcur, sqlcon), 20160108, "Kalamazoo Wings",
1776                "Brampton Beast", "1:1,1:1,1:1,1:0", "4:13,6:17,8:7,2:3", 0, False)
1777 MakeHockeyGame((sqlcur, sqlcon), 20160108, "Adirondack Thunder",
1778                "South Carolina Stingrays", "0:3,1:2,0:0", "13:10,8:7,10:1", 0, False)
1779 MakeHockeyGame((sqlcur, sqlcon), 20160108, "Greenville Swamp Rabbits",
1780                "Florida Everblades", "1:1,1:1,0:0,0:1", "10:7,15:10,13:5,2:3", 0, False)
1781 MakeHockeyGame((sqlcur, sqlcon), 20160108, "Elmira Jackals",
1782                "Manchester Monarchs", "1:3,0:2,0:1", "12:17,11:15,13:17", 0, False)
1783 MakeHockeyGame((sqlcur, sqlcon), 20160108, "Norfolk Admirals",
1784                "Cincinnati Cyclones", "0:1,1:0,2:0", "8:7,12:9,11:8", 0, False)
1785 MakeHockeyGame((sqlcur, sqlcon), 20160108, "Indy Fuel",
1786                "Evansville IceMen", "0:1,2:1,1:0", "12:6,13:8,11:16", 0, False)
1787 MakeHockeyGame((sqlcur, sqlcon), 20160108, "Wheeling Nailers",
1788                "Orlando Solar Bears", "2:0,0:2,0:3", "13:5,7:11,7:8", 0, False)
1789 MakeHockeyGame((sqlcur, sqlcon), 20160108, "Atlanta Gladiators",
1790                "Alaska Aces", "2:0,0:2,0:0,0:0,1:0", "9:3,12:9,5:7,2:4,1:0", 0, False)
1791 MakeHockeyGame((sqlcur, sqlcon), 20160108, "Allen Americans",
1792                "Colorado Eagles", "0:1,0:0,0:0", "11:11,6:15,15:4", 0, False)
1793 MakeHockeyGame((sqlcur, sqlcon), 20160108, "Wichita Thunder", "Tulsa Oilers",
1794                "0:1,1:0,0:0,0:0,0:1", "3:12,10:9,8:11,4:0,0:1", 0, False)
1795 MakeHockeyGame((sqlcur, sqlcon), 20160108, "Quad City Mallards",
1796                "Fort Wayne Komets", "1:2,2:2,1:3", "3:14,11:15,16:10", 0, False)
1797 MakeHockeyGame((sqlcur, sqlcon), 20160108, "Utah Grizzlies",
1798                "Idaho Steelheads", "0:1,0:0,0:0", "9:12,8:5,20:6", 0, False)
1799 MakeHockeyGame((sqlcur, sqlcon), 20160108, "Rapid City Rush",
1800                "Missouri Mavericks", "1:0,0:0,0:1,1:0", "6:8,14:9,11:10,1:0", 0, False)
1801
1802 print("Inserting "+leaguename+" Game Data From 1/9/2016.\n")
1803 MakeHockeyGame((sqlcur, sqlcon), 20160109, "Reading Royals",
1804                "Toledo Walleye", "1:0,1:3,0:1", "8:8,12:11,11:6", 0, False)
1805 MakeHockeyGame((sqlcur, sqlcon), 20160109, "Adirondack Thunder",
1806                "South Carolina Stingrays", "0:1,3:0,1:1", "9:7,20:7,8:10", 0, False)
1807 MakeHockeyGame((sqlcur, sqlcon), 20160109, "Greenville Swamp Rabbits",
1808                "Florida Everblades", "0:0,1:0,0:1,0:0,1:0", "12:14,13:11,2:9,2:3,1:0", 0, False)
1809 MakeHockeyGame((sqlcur, sqlcon), 20160109, "Elmira Jackals",
1810                "Manchester Monarchs", "0:1,0:0,1:3", "12:14,14:12,17:17", 0, False)
1811 MakeHockeyGame((sqlcur, sqlcon), 20160109, "Brampton Beast", "Kalamazoo Wings",
1812                "0:1,2:1,0:0,0:0,0:1", "12:6,12:8,6:12,3:1,0:1", 0, False)
1813 MakeHockeyGame((sqlcur, sqlcon), 20160109, "Norfolk Admirals",
1814                "Cincinnati Cyclones", "0:1,1:0,1:1,1:0", "7:17,16:7,12:11,2:3", 0, False)
1815 MakeHockeyGame((sqlcur, sqlcon), 20160109, "Indy Fuel",
1816                "Evansville IceMen", "1:0,1:0,1:0", "9:11,8:16,9:5", 0, False)
1817 MakeHockeyGame((sqlcur, sqlcon), 20160109, "Wheeling Nailers",
1818                "Orlando Solar Bears", "1:2,1:0,1:4", "9:6,12:5,10:9", 0, False)
1819 MakeHockeyGame((sqlcur, sqlcon), 20160109, "Tulsa Oilers",
1820                "Wichita Thunder", "1:1,3:1,2:2", "19:5,16:13,10:16", 0, False)
1821 MakeHockeyGame((sqlcur, sqlcon), 20160109, "Utah Grizzlies",
1822                "Idaho Steelheads", "1:0,1:0,1:1", "7:4,10:10,8:13", 0, False)
1823 MakeHockeyGame((sqlcur, sqlcon), 20160109, "Rapid City Rush",
1824                "Missouri Mavericks", "0:3,0:0,1:0", "8:14,9:10,11:7", 0, False)
1825
1826 print("Inserting "+leaguename+" Game Data From 1/10/2016.\n")
1827 MakeHockeyGame((sqlcur, sqlcon), 20160110, "Brampton Beast",
1828                "Kalamazoo Wings", "1:0,3:2,3:1", "11:11,14:9,11:15", 0, False)
1829 MakeHockeyGame((sqlcur, sqlcon), 20160110, "Atlanta Gladiators",
1830                "Alaska Aces", "0:1,0:0,1:1", "12:11,8:18,13:10", 0, False)
1831 MakeHockeyGame((sqlcur, sqlcon), 20160110, "Reading Royals",
1832                "South Carolina Stingrays", "0:0,2:0,1:1", "8:4,11:14,8:20", 0, False)
1833 MakeHockeyGame((sqlcur, sqlcon), 20160110, "Wheeling Nailers",
1834                "Indy Fuel", "1:1,1:1,0:1", "11:4,13:14,17:9", 0, False)
1835 MakeHockeyGame((sqlcur, sqlcon), 20160110, "Allen Americans",
1836                "Colorado Eagles", "1:1,3:0,1:1", "10:6,9:9,11:15", 0, False)
1837 MakeHockeyGame((sqlcur, sqlcon), 20160110, "Quad City Mallards",
1838                "Fort Wayne Komets", "0:0,1:0,1:0", "9:7,10:12,4:23", 0, False)
1839
1840 print("Inserting "+leaguename+" Game Data From 1/12/2016.\n")
1841 MakeHockeyGame((sqlcur, sqlcon), 20160112, "Kalamazoo Wings",
1842                "Orlando Solar Bears", "0:1,2:3,0:2", "9:13,9:17,13:5", 0, False)
1843 MakeHockeyGame((sqlcur, sqlcon), 20160112, "Adirondack Thunder",
1844                "Norfolk Admirals", "1:0,0:0,0:0", "12:15,7:11,11:5", 0, False)
1845 MakeHockeyGame((sqlcur, sqlcon), 20160112, "Atlanta Gladiators",
1846                "Alaska Aces", "2:0,1:1,0:2,1:0", "19:5,11:11,13:8,5:6", 0, False)
1847 MakeHockeyGame((sqlcur, sqlcon), 20160112, "Wichita Thunder",
1848                "Missouri Mavericks", "0:1,1:1,0:2", "13:11,8:6,12:6", 0, False)
1849
1850 print("Inserting "+leaguename+" Game Data From 1/13/2016.\n")
1851 MakeHockeyGame((sqlcur, sqlcon), 20160113, "Evansville IceMen",
1852                "Rapid City Rush", "0:0,3:2,1:0", "11:8,13:10,6:19", 0, False)
1853 MakeHockeyGame((sqlcur, sqlcon), 20160113, "Florida Everblades",
1854                "Brampton Beast", "2:1,1:1,1:0", "7:9,8:17,7:12", 0, False)
1855 MakeHockeyGame((sqlcur, sqlcon), 20160113, "Cincinnati Cyclones",
1856                "Fort Wayne Komets", "0:0,1:3,0:1", "10:9,11:13,10:17", 0, False)
1857 MakeHockeyGame((sqlcur, sqlcon), 20160113, "Utah Grizzlies",
1858                "Tulsa Oilers", "1:1,0:0,4:1", "9:12,10:9,12:8", 0, False)
1859
1860 print("Inserting "+leaguename+" Game Data From 1/14/2016.\n")
1861 MakeHockeyGame((sqlcur, sqlcon), 20160114, "Greenville Swamp Rabbits",
1862                "Alaska Aces", "1:0,0:1,1:2", "8:13,6:16,6:18", 0, False)
1863 MakeHockeyGame((sqlcur, sqlcon), 20160114, "Elmira Jackals",
1864                "Norfolk Admirals", "1:0,0:2,0:2", "10:8,9:20,7:11", 0, False)
1865
1866 print("Inserting "+leaguename+" Game Data From 1/15/2016.\n")
1867 MakeHockeyGame((sqlcur, sqlcon), 20160115, "Elmira Jackals",
1868                "Reading Royals", "0:1,0:1,0:2", "6:9,7:7,11:12", 0, False)
1869 MakeHockeyGame((sqlcur, sqlcon), 20160115, "Toledo Walleye",
1870                "Evansville IceMen", "1:1,3:0,1:0", "10:10,16:8,13:7", 0, False)
1871 MakeHockeyGame((sqlcur, sqlcon), 20160115, "Florida Everblades",
1872                "Brampton Beast", "0:0,3:0,2:1", "12:11,7:10,9:17", 0, False)
1873 MakeHockeyGame((sqlcur, sqlcon), 20160115, "Indy Fuel",
1874                "Rapid City Rush", "0:0,0:3,0:1", "11:8,6:14,9:9", 0, False)
1875 MakeHockeyGame((sqlcur, sqlcon), 20160115, "Atlanta Gladiators",
1876                "South Carolina Stingrays", "1:0,0:1,3:0", "8:10,12:8,12:8", 0, False)
1877 MakeHockeyGame((sqlcur, sqlcon), 20160115, "Fort Wayne Komets",
1878                "Orlando Solar Bears", "2:1,2:1,1:0", "15:11,13:11,11:7", 0, False)
1879 MakeHockeyGame((sqlcur, sqlcon), 20160115, "Quad City Mallards",
1880                "Kalamazoo Wings", "0:0,2:2,0:0,1:0", "13:8,11:18,10:7,7:3", 0, False)
1881 MakeHockeyGame((sqlcur, sqlcon), 20160115, "Utah Grizzlies",
1882                "Wichita Thunder", "3:0,2:2,2:1", "12:6,9:8,10:7", 0, False)
1883 MakeHockeyGame((sqlcur, sqlcon), 20160115, "Colorado Eagles",
1884                "Missouri Mavericks", "1:2,2:2,1:1", "6:4,12:10,16:5", 0, False)
1885 MakeHockeyGame((sqlcur, sqlcon), 20160115, "Idaho Steelheads",
1886                "Tulsa Oilers", "1:1,1:0,0:0", "12:10,11:6,7:12", 0, False)
1887
1888 print("Inserting "+leaguename+" Game Data From 1/16/2016.\n")
1889 MakeHockeyGame((sqlcur, sqlcon), 20160116, "Adirondack Thunder",
1890                "Reading Royals", "1:0,1:0,0:0", "9:8,8:10,7:18", 0, False)
1891 MakeHockeyGame((sqlcur, sqlcon), 20160116, "Manchester Monarchs",
1892                "Norfolk Admirals", "0:2,0:0,2:0,0:1", "9:8,12:11,15:3,3:2", 0, False)
1893 MakeHockeyGame((sqlcur, sqlcon), 20160116, "Florida Everblades",
1894                "Brampton Beast", "0:0,1:1,0:0,1:0", "6:5,11:12,6:13,3:0", 0, False)
1895 MakeHockeyGame((sqlcur, sqlcon), 20160116, "Atlanta Gladiators",
1896                "Greenville Swamp Rabbits", "2:1,1:1,2:1", "9:7,9:12,16:6", 0, False)
1897 MakeHockeyGame((sqlcur, sqlcon), 20160116, "South Carolina Stingrays",
1898                "Alaska Aces", "0:3,3:0,1:1,0:1", "14:8,9:4,14:8,1:2", 0, False)
1899 MakeHockeyGame((sqlcur, sqlcon), 20160116, "Toledo Walleye",
1900                "Wheeling Nailers", "3:1,1:1,0:1", "14:12,13:8,7:8", 0, False)
1901 MakeHockeyGame((sqlcur, sqlcon), 20160116, "Fort Wayne Komets",
1902                "Rapid City Rush", "0:0,0:0,1:0", "8:9,11:5,16:7", 0, False)
1903 MakeHockeyGame((sqlcur, sqlcon), 20160116, "Indy Fuel",
1904                "Orlando Solar Bears", "0:1,0:1,0:0", "11:10,9:10,18:4", 0, False)
1905 MakeHockeyGame((sqlcur, sqlcon), 20160116, "Allen Americans",
1906                "Cincinnati Cyclones", "1:2,2:0,0:0", "3:9,7:11,5:7", 0, False)
1907 MakeHockeyGame((sqlcur, sqlcon), 20160116, "Evansville IceMen",
1908                "Quad City Mallards", "0:1,1:0,0:1", "14:8,12:8,13:15", 0, False)
1909 MakeHockeyGame((sqlcur, sqlcon), 20160116, "Utah Grizzlies",
1910                "Wichita Thunder", "0:1,2:1,0:0,1:0", "11:5,15:12,11:8,1:0", 0, False)
1911 MakeHockeyGame((sqlcur, sqlcon), 20160116, "Colorado Eagles",
1912                "Missouri Mavericks", "1:1,1:1,3:1", "8:12,14:6,10:8", 0, False)
1913 MakeHockeyGame((sqlcur, sqlcon), 20160116, "Idaho Steelheads",
1914                "Tulsa Oilers", "1:1,0:1,1:2", "17:13,14:7,7:12", 0, False)
1915
1916 print("Inserting "+leaguename+" Game Data From 1/17/2016.\n")
1917 MakeHockeyGame((sqlcur, sqlcon), 20160117, "Manchester Monarchs",
1918                "Norfolk Admirals", "1:1,3:2,0:1,0:0,0:1", "15:5,15:10,8:8,2:7,0:1", 0, False)
1919 MakeHockeyGame((sqlcur, sqlcon), 20160117, "Indy Fuel",
1920                "Wheeling Nailers", "1:0,1:1,1:1", "8:8,17:10,11:10", 0, False)
1921 MakeHockeyGame((sqlcur, sqlcon), 20160117, "South Carolina Stingrays",
1922                "Alaska Aces", "0:1,1:2,2:0,0:0,0:1", "8:10,13:14,10:18,2:3,0:1", 0, False)
1923 MakeHockeyGame((sqlcur, sqlcon), 20160117, "Elmira Jackals",
1924                "Adirondack Thunder", "0:1,0:0,0:0", "6:16,12:14,6:7", 0, False)
1925 MakeHockeyGame((sqlcur, sqlcon), 20160117, "Fort Wayne Komets",
1926                "Rapid City Rush", "2:0,0:1,1:0", "14:8,9:11,9:8", 0, False)
1927 MakeHockeyGame((sqlcur, sqlcon), 20160117, "Allen Americans", "Cincinnati Cyclones",
1928                "2:2,1:0,0:1,0:0,0:1", "7:8,9:6,12:11,1:4,0:1", 0, False)
1929 MakeHockeyGame((sqlcur, sqlcon), 20160117, "Quad City Mallards",
1930                "Kalamazoo Wings", "0:4,2:0,0:3", "9:14,12:8,12:11", 0, False)
1931
1932 print("Inserting "+leaguename+" Game Data From 1/18/2016.\n")
1933 MakeHockeyGame((sqlcur, sqlcon), 20160118, "Atlanta Gladiators",
1934                "Greenville Swamp Rabbits", "0:0,0:0,0:1", "8:10,14:8,9:12", 0, False)
1935 MakeHockeyGame((sqlcur, sqlcon), 20160118, "Reading Royals",
1936                "Adirondack Thunder", "0:0,0:2,1:1", "8:9,14:13,22:5", 0, False)
1937 MakeHockeyGame((sqlcur, sqlcon), 20160118, "Elmira Jackals", "Brampton Beast",
1938                "0:1,0:0,1:0,0:0,1:0", "11:7,19:4,9:8,3:0,1:0", 0, False)
1939 MakeHockeyGame((sqlcur, sqlcon), 20160118, "Allen Americans",
1940                "Cincinnati Cyclones", "2:1,1:2,0:0,0:1", "7:8,7:6,5:12,1:5", 0, False)
1941 MakeHockeyGame((sqlcur, sqlcon), 20160118, "Utah Grizzlies",
1942                "Wichita Thunder", "0:1,2:0,0:1,1:0", "13:7,12:7,5:16,6:4", 0, False)
1943
1944 print("Inserting "+leaguename+" Game Data From 1/19/2016.\n")
1945 MakeHockeyGame((sqlcur, sqlcon), 20160119, "Greenville Swamp Rabbits",
1946                "Atlanta Gladiators", "0:2,1:1,1:3", "10:14,11:11,12:12", 0, False)
1947
1948 print("Inserting "+leaguename+" Game Data From 1/22/2016.\n")
1949 MakeHockeyGame((sqlcur, sqlcon), 20160122, "Reading Royals",
1950                "Brampton Beast", "0:0,1:0,0:1,0:1", "13:4,14:9,8:7,1:2", 0, False)
1951 MakeHockeyGame((sqlcur, sqlcon), 20160122, "Adirondack Thunder", "Manchester Monarchs",
1952                "1:1,3:4,1:0,0:0,0:1", "15:11,11:25,15:15,5:2,0:1", 0, False)
1953 MakeHockeyGame((sqlcur, sqlcon), 20160122, "Greenville Swamp Rabbits",
1954                "Evansville IceMen", "1:0,0:3,2:3", "11:10,9:12,16:4", 0, False)
1955 MakeHockeyGame((sqlcur, sqlcon), 20160122, "South Carolina Stingrays",
1956                "Atlanta Gladiators", "2:0,1:0,1:1", "14:5,12:9,4:11", 0, False)
1957 MakeHockeyGame((sqlcur, sqlcon), 20160122, "Toledo Walleye",
1958                "Utah Grizzlies", "1:1,2:1,0:0", "9:9,10:13,7:8", 0, False)
1959 MakeHockeyGame((sqlcur, sqlcon), 20160122, "Norfolk Admirals",
1960                "Elmira Jackals", "1:0,0:2,1:0,1:0", "9:11,8:12,12:4,3:2", 0, False)
1961 MakeHockeyGame((sqlcur, sqlcon), 20160122, "Florida Everblades",
1962                "Orlando Solar Bears", "1:1,1:0,2:0", "9:11,22:4,18:9", 0, False)
1963 MakeHockeyGame((sqlcur, sqlcon), 20160122, "Indy Fuel",
1964                "Quad City Mallards", "2:0,0:1,0:0", "11:11,12:8,14:11", 0, False)
1965 MakeHockeyGame((sqlcur, sqlcon), 20160122, "Cincinnati Cyclones",
1966                "Fort Wayne Komets", "0:1,0:3,1:1", "6:11,4:15,8:7", 0, False)
1967 MakeHockeyGame((sqlcur, sqlcon), 20160122, "Wheeling Nailers",
1968                "Kalamazoo Wings", "0:0,0:1,1:0,1:0", "16:7,5:12,13:9,4:0", 0, False)
1969 MakeHockeyGame((sqlcur, sqlcon), 20160122, "Wichita Thunder",
1970                "Allen Americans", "0:0,3:2,0:1,0:1", "5:14,14:10,15:14,1:3", 0, False)
1971 MakeHockeyGame((sqlcur, sqlcon), 20160122, "Missouri Mavericks",
1972                "Tulsa Oilers", "1:1,0:0,1:0", "5:7,10:10,10:5", 0, False)
1973 MakeHockeyGame((sqlcur, sqlcon), 20160122, "Rapid City Rush",
1974                "Colorado Eagles", "0:1,1:3,0:1", "6:17,6:9,6:6", 0, False)
1975 MakeHockeyGame((sqlcur, sqlcon), 20160122, "Alaska Aces",
1976                "Idaho Steelheads", "0:1,0:0,0:1", "8:6,16:12,10:6", 0, False)
1977
1978 print("Inserting "+leaguename+" Game Data From 1/23/2016.\n")
1979 MakeHockeyGame((sqlcur, sqlcon), 20160123, "Manchester Monarchs",
1980                "Adirondack Thunder", "0:1,1:0,1:0", "9:14,16:11,11:15", 0, False)
1981 MakeHockeyGame((sqlcur, sqlcon), 20160123, "Atlanta Gladiators",
1982                "Evansville IceMen", "0:2,3:0,0:2", "15:8,19:12,3:13", 0, False)
1983 MakeHockeyGame((sqlcur, sqlcon), 20160123, "South Carolina Stingrays",
1984                "Greenville Swamp Rabbits", "1:0,2:3,0:1", "11:13,7:8,8:9", 0, False)
1985 MakeHockeyGame((sqlcur, sqlcon), 20160123, "Toledo Walleye",
1986                "Utah Grizzlies", "0:1,2:1,1:3", "3:9,9:5,12:9", 0, False)
1987 MakeHockeyGame((sqlcur, sqlcon), 20160123, "Norfolk Admirals",
1988                "Elmira Jackals", "0:1,1:1,1:1", "3:12,19:10,24:7", 0, False)
1989 MakeHockeyGame((sqlcur, sqlcon), 20160123, "Indy Fuel",
1990                "Quad City Mallards", "1:0,0:0,2:1", "10:4,5:12,11:12", 0, False)
1991 MakeHockeyGame((sqlcur, sqlcon), 20160123, "Cincinnati Cyclones",
1992                "Fort Wayne Komets", "0:0,4:2,2:2", "11:7,14:11,9:9", 0, False)
1993 MakeHockeyGame((sqlcur, sqlcon), 20160123, "Wheeling Nailers",
1994                "Kalamazoo Wings", "0:1,1:0,0:3", "11:14,10:4,12:13", 0, False)
1995 MakeHockeyGame((sqlcur, sqlcon), 20160123, "Missouri Mavericks",
1996                "Tulsa Oilers", "1:0,1:1,1:5", "8:5,10:15,10:9", 0, False)
1997 MakeHockeyGame((sqlcur, sqlcon), 20160123, "Wichita Thunder",
1998                "Allen Americans", "0:1,1:0,0:2", "8:7,13:10,7:9", 0, False)
1999 MakeHockeyGame((sqlcur, sqlcon), 20160123, "Rapid City Rush",
2000                "Colorado Eagles", "0:2,1:0,1:2", "8:10,6:14,10:11", 0, False)
2001 MakeHockeyGame((sqlcur, sqlcon), 20160123, "Alaska Aces",
2002                "Idaho Steelheads", "0:1,0:2,1:0", "17:11,10:8,11:7", 0, False)
2003
2004 print("Inserting "+leaguename+" Game Data From 1/24/2016.\n")
2005 MakeHockeyGame((sqlcur, sqlcon), 20160124, "Manchester Monarchs",
2006                "Adirondack Thunder", "0:2,1:0,1:0,1:0", "10:11,10:10,14:7,1:3", 0, False)
2007 MakeHockeyGame((sqlcur, sqlcon), 20160124, "Indy Fuel",
2008                "Fort Wayne Komets", "0:1,1:0,2:0", "10:19,13:9,12:7", 0, False)
2009 MakeHockeyGame((sqlcur, sqlcon), 20160124, "Allen Americans",
2010                "Wichita Thunder", "0:1,1:0,4:3", "2:9,12:6,11:11", 0, False)
2011 MakeHockeyGame((sqlcur, sqlcon), 20160124, "Toledo Walleye",
2012                "Utah Grizzlies", "2:0,0:2,3:0", "11:9,8:8,9:3", 0, False)
2013 MakeHockeyGame((sqlcur, sqlcon), 20160124, "Alaska Aces",
2014                "Idaho Steelheads", "2:1,1:0,0:1", "16:10,13:12,9:6", 0, False)
2015
2016 print("Inserting "+leaguename+" Game Data From 1/25/2016.\n")
2017 MakeHockeyGame((sqlcur, sqlcon), 20160125, "Reading Royals",
2018                "Brampton Beast", "0:1,1:1,1:0,0:1", "14:9,9:13,12:10,0:1", 0, False)
2019
2020 print("Inserting "+leaguename+" Game Data From 1/26/2016.\n")
2021 MakeHockeyGame((sqlcur, sqlcon), 20160126, "Missouri Mavericks",
2022                "Evansville IceMen", "1:3,3:1,1:1,1:0", "10:14,9:9,11:6,1:0", 0, False)
2023 MakeHockeyGame((sqlcur, sqlcon), 20160126, "Tulsa Oilers",
2024                "Allen Americans", "1:0,1:0,0:0", "14:10,19:6,10:9", 0, False)
2025
2026 print("Inserting "+leaguename+" Game Data From 1/27/2016.\n")
2027 MakeHockeyGame((sqlcur, sqlcon), 20160127, "Orlando Solar Bears",
2028                "Manchester Monarchs", "0:1,0:1,0:1", "5:16,9:8,11:11", 0, False)
2029 MakeHockeyGame((sqlcur, sqlcon), 20160127, "Elmira Jackals",
2030                "Reading Royals", "1:1,3:4,1:2", "8:17,16:20,15:15", 0, False)
2031 MakeHockeyGame((sqlcur, sqlcon), 20160127, "Cincinnati Cyclones",
2032                "Indy Fuel", "2:0,0:0,1:1", "7:5,10:10,9:10", 0, False)
2033 MakeHockeyGame((sqlcur, sqlcon), 20160127, "Wichita Thunder",
2034                "Evansville IceMen", "3:1,0:1,1:0", "13:9,9:12,3:12", 0, False)
2035 MakeHockeyGame((sqlcur, sqlcon), 20160127, "Colorado Eagles",
2036                "Utah Grizzlies", "2:0,2:1,2:2", "9:7,10:12,6:10", 0, False)
2037 MakeHockeyGame((sqlcur, sqlcon), 20160127, "Idaho Steelheads",
2038                "Rapid City Rush", "1:0,3:2,1:0", "12:8,13:9,11:10", 0, False)
2039
2040 print("Inserting "+leaguename+" Game Data From 1/28/2016.\n")
2041 MakeHockeyGame((sqlcur, sqlcon), 20160128, "Orlando Solar Bears",
2042                "Manchester Monarchs", "0:0,0:3,1:0", "6:7,13:19,21:6", 0, False)
2043
2044 print("Inserting "+leaguename+" Game Data From 1/29/2016.\n")
2045 MakeHockeyGame((sqlcur, sqlcon), 20160129, "Kalamazoo Wings",
2046                "Quad City Mallards", "0:1,5:1,1:3", "10:11,14:9,8:9", 0, False)
2047 MakeHockeyGame((sqlcur, sqlcon), 20160129, "Adirondack Thunder",
2048                "Reading Royals", "0:0,2:0,1:0", "12:10,10:18,6:14", 0, False)
2049 MakeHockeyGame((sqlcur, sqlcon), 20160129, "Orlando Solar Bears",
2050                "Manchester Monarchs", "0:2,3:0,0:1,0:0,0:1", "11:14,11:10,7:7,4:3,0:1", 0, False)
2051 MakeHockeyGame((sqlcur, sqlcon), 20160129, "Elmira Jackals",
2052                "Wheeling Nailers", "0:1,1:1,0:2", "14:7,15:8,14:9", 0, False)
2053 MakeHockeyGame((sqlcur, sqlcon), 20160129, "Toledo Walleye",
2054                "Brampton Beast", "2:0,2:0,0:0", "8:12,13:6,8:10", 0, False)
2055 MakeHockeyGame((sqlcur, sqlcon), 20160129, "Norfolk Admirals",
2056                "South Carolina Stingrays", "4:0,1:1,3:1", "14:6,5:12,9:10", 0, False)
2057 MakeHockeyGame((sqlcur, sqlcon), 20160129, "Florida Everblades",
2058                "Greenville Swamp Rabbits", "0:2,3:0,1:0", "8:11,11:10,8:8", 0, False)
2059 MakeHockeyGame((sqlcur, sqlcon), 20160129, "Indy Fuel",
2060                "Evansville IceMen", "4:0,2:0,1:3", "12:5,15:10,3:14", 0, False)
2061 MakeHockeyGame((sqlcur, sqlcon), 20160129, "Atlanta Gladiators",
2062                "Idaho Steelheads", "0:0,0:2,1:2", "9:9,6:13,16:3", 0, False)
2063 MakeHockeyGame((sqlcur, sqlcon), 20160129, "Fort Wayne Komets",
2064                "Cincinnati Cyclones", "2:0,0:0,2:1", "12:9,9:9,8:8", 0, False)
2065 MakeHockeyGame((sqlcur, sqlcon), 20160129, "Allen Americans",
2066                "Tulsa Oilers", "0:0,4:0,3:1", "16:5,11:9,7:7", 0, False)
2067 MakeHockeyGame((sqlcur, sqlcon), 20160129, "Missouri Mavericks",
2068                "Wichita Thunder", "2:0,0:1,0:0", "8:6,10:8,7:9", 0, False)
2069 MakeHockeyGame((sqlcur, sqlcon), 20160129, "Utah Grizzlies",
2070                "Rapid City Rush", "1:0,3:1,0:0", "17:12,18:11,9:14", 0, False)
2071 MakeHockeyGame((sqlcur, sqlcon), 20160129, "Colorado Eagles",
2072                "Alaska Aces", "1:2,2:0,2:0", "8:12,15:4,8:14", 0, False)
2073
2074 print("Inserting "+leaguename+" Game Data From 1/30/2016.\n")
2075 MakeHockeyGame((sqlcur, sqlcon), 20160130, "Adirondack Thunder",
2076                "Reading Royals", "0:1,1:0,1:2", "10:9,7:11,10:4", 0, False)
2077 MakeHockeyGame((sqlcur, sqlcon), 20160130, "Florida Everblades",
2078                "Greenville Swamp Rabbits", "1:0,0:2,0:0", "12:5,7:7,7:4", 0, False)
2079 MakeHockeyGame((sqlcur, sqlcon), 20160130, "Elmira Jackals", "Wheeling Nailers",
2080                "1:2,2:1,0:0,0:0,1:0", "9:13,13:15,12:11,4:3,1:0", 0, False)
2081 MakeHockeyGame((sqlcur, sqlcon), 20160130, "Atlanta Gladiators",
2082                "Idaho Steelheads", "1:0,0:1,0:0,0:0,0:1", "7:9,6:9,11:7,3:4,0:1", 0, False)
2083 MakeHockeyGame((sqlcur, sqlcon), 20160130, "Norfolk Admirals",
2084                "South Carolina Stingrays", "1:2,0:2,0:2", "15:9,11:12,12:9", 0, False)
2085 MakeHockeyGame((sqlcur, sqlcon), 20160130, "Toledo Walleye",
2086                "Fort Wayne Komets", "0:0,1:1,1:0", "5:7,9:13,12:11", 0, False)
2087 MakeHockeyGame((sqlcur, sqlcon), 20160130, "Indy Fuel",
2088                "Evansville IceMen", "1:0,0:1,2:1", "10:7,7:16,11:14", 0, False)
2089 MakeHockeyGame((sqlcur, sqlcon), 20160130, "Cincinnati Cyclones",
2090                "Quad City Mallards", "0:2,1:0,1:0,1:0", "14:5,14:4,13:3,1:2", 0, False)
2091 MakeHockeyGame((sqlcur, sqlcon), 20160130, "Tulsa Oilers",
2092                "Allen Americans", "1:0,2:0,2:2", "16:9,7:11,9:9", 0, False)
2093 MakeHockeyGame((sqlcur, sqlcon), 20160130, "Missouri Mavericks",
2094                "Wichita Thunder", "2:0,1:1,2:1", "14:9,10:10,5:5", 0, False)
2095 MakeHockeyGame((sqlcur, sqlcon), 20160130, "Utah Grizzlies",
2096                "Rapid City Rush", "3:1,2:2,0:1", "13:6,15:10,4:11", 0, False)
2097 MakeHockeyGame((sqlcur, sqlcon), 20160130, "Colorado Eagles",
2098                "Alaska Aces", "2:0,4:0,1:2", "8:8,15:13,9:11", 0, False)
2099
2100 print("Inserting "+leaguename+" Game Data From 1/31/2016.\n")
2101 MakeHockeyGame((sqlcur, sqlcon), 20160131, "Brampton Beast",
2102                "Wheeling Nailers", "1:0,1:0,0:2,0:1", "9:7,9:9,3:14,0:1", 0, False)
2103 MakeHockeyGame((sqlcur, sqlcon), 20160131, "Atlanta Gladiators",
2104                "Idaho Steelheads", "1:1,1:1,0:3", "13:9,13:14,11:11", 0, False)
2105 MakeHockeyGame((sqlcur, sqlcon), 20160131, "Kalamazoo Wings",
2106                "Fort Wayne Komets", "1:2,1:0,0:4", "6:17,13:5,7:14", 0, False)
2107 MakeHockeyGame((sqlcur, sqlcon), 20160131, "Allen Americans",
2108                "Tulsa Oilers", "2:0,0:1,0:0", "7:1,6:14,6:6", 0, False)
2109 MakeHockeyGame((sqlcur, sqlcon), 20160131, "Toledo Walleye",
2110                "Quad City Mallards", "2:0,0:2,0:0,1:0", "9:11,3:12,7:8,1:0", 0, False)
2111
2112 print("Database Check Return: " +
2113       str(sqlcon.execute("PRAGMA integrity_check(100);").fetchone()[0])+"\n")
2114
2115 sqlcon.close()
2116
2117 print("DONE! All Game Data Inserted.")
2118
2119 print("DONE! "+leaguename+" Database Created.")