def updateStation(station):
(conn, cur) = dbutil.connect()
cur.execute(
''' UPDATE station set updated = %s where station = %s ''', (datetime.now(), station))
conn.commit()
dbutil.disconnect(conn)
def dbInsert(d, table):
(conn, cur) = dbutil.connect()
stmt = convertDictToInsert(d, table)
cur.execute(stmt, d.values())
conn.commit()
dbutil.disconnect(conn)
def updateStationState(station, state):
(conn, cur) = dbutil.connect()
cur.execute(
''' UPDATE station set state = %s where station = %s ''', (state, station))
conn.commit()
dbutil.disconnect(conn)
def updateStation(station):
(conn, cur) = dbutil.connect()
cur.execute(''' UPDATE station set updated = %s where station = %s ''',
(datetime.now(), station))
conn.commit()
dbutil.disconnect(conn)
def updateStationState(station, state):
(conn, cur) = dbutil.connect()
cur.execute(''' UPDATE station set state = %s where station = %s ''',
(state, station))
conn.commit()
dbutil.disconnect(conn)
def dbInsert(d, table):
(conn, cur) = dbutil.connect()
stmt = convertDictToInsert(d, table)
cur.execute(stmt, d.values())
conn.commit()
dbutil.disconnect(conn)
for state in states:
url = '''http://data.fcc.gov/mediabureau/v01/tv/facility/search/%s.json''' % (
state)
req = urllib2.Request(url=url)
f = urllib2.urlopen(req)
page = json.loads(f.read())
facilities = [
sl['facilityList'] if sl['searchType'] == 'State' else None
for sl in page['results']['searchList']
]
facilities = [fac for fac in facilities if fac is not None][0]
for facility in facilities:
stations.append(facility['callSign'])
stations.sort(reverse=False)
(conn, cur) = dbutil.connect()
for station in stations:
print station
cur.execute(''' INSERT INTO station values (%s, %s) ''',
(station, datetime.now()))
conn.commit()
dbutil.disconnect(conn)
states = [s.abbr for s in us.states.STATES]
stations = []
for state in states:
url = '''http://data.fcc.gov/mediabureau/v01/tv/facility/search/%s.json''' % (
state)
req = urllib2.Request(url=url)
f = urllib2.urlopen(req)
page = json.loads(f.read())
facilities = [sl['facilityList'] if sl['searchType'] ==
'State' else None for sl in page['results']['searchList']]
facilities = [fac for fac in facilities if fac is not None][0]
for facility in facilities:
stations.append(facility['callSign'])
stations.sort(reverse=False)
(conn, cur) = dbutil.connect()
for station in stations:
print station
cur.execute(
''' INSERT INTO station values (%s, %s) ''', (station, datetime.now()))
conn.commit()
dbutil.disconnect(conn)
