import json
import psycopg2
conn = psycopg2.connect(user='postgres', password='postgres', port=5433)
cur = conn.cursor()

#from pprint import pprint

#with open('info.json') as data_file:
#    data = json.load(data_file)
#pprint(data)

with open('info.json', 'r') as file:
    data = json.load(file)
#   for x in range(30600,len(data)):
    for x in range(0,10):
        fav = (data[x]["fav"])
        wps = (data[x]["wps"])
        lon = (data[x]["lon"])
        time = (data[x]["time"])
        essid = (data[x]["essid"])
        range = (data[x]["range"])
        bssid = (data[x]["bssid"])
        nowifi = (data[x]["nowifi"])
        key = (data[x]["key"])
        hidden = (data[x]["hidden"])
        lat = (data[x]["lat"])
        sec = (data[x]["sec"])
        comment = (data[x]["comment"])
        len = (len(data))
        print(x)
        cur.execute('insert into "3wifi"(id, lat, lon, "time", "ESSID", "BSSID", range, sec, comment, key, hidden, fav, nowifi) values(x, lat, lon, time, essid, bssid, range, sec, comment, key, hidden, fav, nowifi)')
        conn.commit()


file.close()