def main(argv): """ """ args = parse_arguments(argv) with open(args.config_file) as config_file: config = json.load(config_file) with sqlite3.connect(config["db-path"]) as conn: for row in select_weather(conn): print(row[0], row[1], row[2] == row[3], "| actual rain:", row[2], "predicted rain:", row[3]) return 0
def main(argv): """ """ args = parse_arguments(argv) with open(args.config_file) as config_file: config = json.load(config_file) observations = get_observations("Birmingham", config["metoffice-API-key"]) # Push to database with sqlite3.connect(config["db-path"]) as conn: for obs in observations: conn.execute("INSERT OR IGNORE INTO observations (datetime, location, vendor, precipitation, temperature) VALUES (?,?,?,?,?)", [obs['datetime'], "birmingham", "metoffice", obs['precipitation?'], obs['temperature']]) return 0