creating_columns

creating_columns.py

Creating the columns

Played = fList[0][0]
Team = fList[0][1]
GP = fList[0][2]
W = fList[0][3]
D = fList[0][4]
L = fList[0][5]
F = fList[0][6]
A = fList[0][7]
GD = fList[0][8]
Pts = fList[0][9]

queryCreateTable = """CREATE TABLE FOOTBALL(
                    {} int(2) not null,
                    {} varchar(255) not null,
                    {} int(2) not null,
                    {} int(2) not null,
                    {} int(2) not null,
                    {} int(2) not null,
                    {} int(2) not null,
                    {} int(2) not null,
                    {} int(3) not null,
                    {} int(3) not null
                    )""".format(Played, Team, GP, W, D, L, F, A, GD, Pts)

cursor.execute(queryCreateTable)