MRPg99fs

1def createTable():
2    createTable = """ 
3        DROP TABLE IF EXISTS Websites; 
4        CREATE TABLE Websites(WebsiteId int IDENTITY(1,1) PRIMARY KEY,
5        GlobalRankId int NOT NULL, TldRank int NOT NULL,
6        Domain nvarchar(150) NOT NULL,
7        TLD nvarchar(150) NOT NULL,
8        RefSubNets int NOT NULL, Reflps int NOT NULL,
9        IDN_Domain nvarchar(150) NOT NULL, IDN_TLD nvarchar(150) NOT NULL,
10        PrevGlobalRank int NOT NULL, PrevTldRank int NOT NULL, PrevRefSubnets int NOT NULL, PrevRefIps int NOT NULL);
11        """
12    cnxn = pyodbc.connect(
13        'DRIVER=' + DRIVER + ';SERVER=' + SERVER + ';DATABASE=' + DATABASE + ';UID=' + USERNAME + ';PWD=' + PASSWORD)
14
15    cursor = cnxn.cursor()
16    result = cursor.execute(createTable)
17    cursor.commit()