def get(self, id):
resp = {'Booking Successful': False}
print 'id:', id
db_mgr = DBManager()
session = db_mgr.get_session()
results = []
try:
qry = session.query(ParkingSpots).filter(
ParkingSpots.id == int(id)).update({'available': False})
session.commit()
qry = session.query(ParkingSpots.available).filter(
ParkingSpots.id == int(id)).all()
print qry
if qry[0][0] == False:
resp['Booking Successful'] = True
resp['Your booking ID'] = id
except Exception as e:
print 'Error:', e
finally:
db_mgr.close_session(session)
return resp
def get(self):
db_mgr = DBManager()
session = db_mgr.get_session()
results = []
try:
data_list = session.query(ParkingSpots)
for data in data_list:
results.append(data.toJSON())
except Exception as e:
print 'Error:', e
finally:
db_mgr.close_session(session)
return results
def get(self, id):
results = {'Cancellation Successful': False}
db_mgr = DBManager()
session = db_mgr.get_session()
try:
qry = session.query(ParkingSpots).filter(
ParkingSpots.id == int(id)).update({'available': True})
session.commit()
qry = session.query(ParkingSpots.available).filter(
ParkingSpots.id == int(id)).all()
print qry
if qry[0][0] == True:
results['Cancellation Successful'] = True
except Exception as e:
print 'Error:', e
finally:
db_mgr.close_session(session)
return results
def get(self, address):
db_mgr = DBManager()
session = db_mgr.get_session()
if len(address.split(',')) < 3:
return '{"Invalid data format"}'
lat, lon, radius = address.split(',')
coords_1 = (lat, lon)
results = []
temp = []
try:
data_list = session.query(ParkingSpots).filter(
ParkingSpots.available == True)
for data in data_list:
temp.append(data.toJSON())
for rec in temp:
print 'rec:', rec
coords_2 = (rec['lat'], rec['lon'])
dist = geopy.distance.vincenty(coords_1, coords_2).meters
print 'dist:', dist
if dist < float(radius):
results.append(rec)
except Exception as e:
print 'Error:', e
finally:
db_mgr.close_session(session)
return results
