import requests
from time import sleep
from random import randint
from datetime import datetime
from db_commands import FlightTrackerCluster
from env_variables import QPX_API_KEY, ORIGIN_ONE, DESTINATION_ONE, ORIGIN_TWO, DESTINATION_TWO, DEPARTURE_DATE
from env_variables import QPX_API_KEY_TWO, ORIGIN_THREE, DESTINATION_THREE, ORIGIN_FOUR, DESTINATION_FOUR
# from env_variables import RETURN_DATE
############################################## Set-Up ################################################
days = [
'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday',
'Sunday'
]
myCluster = FlightTrackerCluster()
myCluster.createKeySpace('plane')
myCluster.changeKeySpace('plane')
#Uncomment the first time to create the table
#myCluster.createTable('tickets', ['hour', 'date', 'day', 'carrier', 'origin', 'destination', 'departure_date', 'price'], ['day', 'date', 'origin', 'destination', 'price', 'hour'])
params_one = myCluster.getParams(ORIGIN_ONE, DESTINATION_ONE, DEPARTURE_DATE,
100)
params_two = myCluster.getParams(ORIGIN_TWO, DESTINATION_TWO, DEPARTURE_DATE,
100)
params_three = myCluster.getParams(ORIGIN_THREE, DESTINATION_THREE,
DEPARTURE_DATE, 100)
params_four = myCluster.getParams(ORIGIN_FOUR, DESTINATION_FOUR,
DEPARTURE_DATE, 100)
# params = myCluster.getParams(ORIGIN_ONE, DESTINATION_ONE, DEPARTURE_DATE, RETURN_DATE, 100)
from db_commands import FlightTrackerCluster
myCluster = FlightTrackerCluster()
myCluster.changeKeySpace('plane')
first = raw_input('Are you sure you want to delete the table "tickets"? Type "Y" to confirm: ')
if first == 'Y':
myCluster.deleteTable('tickets')
print "Table has been deleted."
import json
import requests
from time import sleep
from random import randint
from datetime import datetime
from db_commands import FlightTrackerCluster
from env_variables import QPX_API_KEY, ORIGIN_ONE, DESTINATION_ONE, ORIGIN_TWO, DESTINATION_TWO, DEPARTURE_DATE
from env_variables import QPX_API_KEY_TWO, ORIGIN_THREE, DESTINATION_THREE, ORIGIN_FOUR, DESTINATION_FOUR
# from env_variables import RETURN_DATE
############################################## Set-Up ################################################
days = ['Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday']
myCluster = FlightTrackerCluster()
myCluster.createKeySpace('plane')
myCluster.changeKeySpace('plane')
#Uncomment the first time to create the table
#myCluster.createTable('tickets', ['hour', 'date', 'day', 'carrier', 'origin', 'destination', 'departure_date', 'price'], ['day', 'date', 'origin', 'destination', 'price', 'hour'])
params_one = myCluster.getParams(ORIGIN_ONE, DESTINATION_ONE, DEPARTURE_DATE, 100)
params_two = myCluster.getParams(ORIGIN_TWO, DESTINATION_TWO, DEPARTURE_DATE, 100)
params_three = myCluster.getParams(ORIGIN_THREE, DESTINATION_THREE, DEPARTURE_DATE, 100)
params_four = myCluster.getParams(ORIGIN_FOUR, DESTINATION_FOUR, DEPARTURE_DATE, 100)
# params = myCluster.getParams(ORIGIN_ONE, DESTINATION_ONE, DEPARTURE_DATE, RETURN_DATE, 100)
last = None
def writeToCassandra(params, hour, date, day_of_week, origin, destination, departure_date, api_key):
url = 'https://www.googleapis.com/qpxExpress/v1/trips/search?key=' + QPX_API_KEY
from db_commands import FlightTrackerCluster
myCluster = FlightTrackerCluster()
myCluster.changeKeySpace('plane')
first = raw_input(
'Are you sure you want to delete the table "tickets"? Type "Y" to confirm: '
)
if first == 'Y':
myCluster.deleteTable('tickets')
print "Table has been deleted."
