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)
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)