1wfsN6aJ

1cursor.execute(
2                "CREATE TABLE IF NOT EXISTS temperatureTable(date VARCHAR(30) NOT NULL, time VARCHAR(30) NOT NULL, longitude VARCHAR(30) NOT NULL, latitude VARCHAR(30) NOT NULL, temperature VARCHAR(30) NOT NULL, PRIMARY KEY (date, longitude, latitude))")
3            lineToBeStored = 0
4            for lat in numpy.nditer(latitude):
5                for lon in numpy.nditer(longitude):
6                    cursor.execute(
7                        "INSERT INTO temperatureTable VALUES('%s', '%s', '%s', '%s', '%s')" % (
8                            today, dateTime, lat, lon, temperatureData[lineToBeStored]))`>