def register(args):
profile_pic = base64photo(args['Photo'])
my_cursor = db.cursor()
my_cursor.execute("SELECT AadharNo from User WHERE AadharNo = '" +
str(args['AadharNo']) + "'")
row_cursor = my_cursor.fetchall()
if len(row_cursor) > 0:
return {
'Status':
0,
'Message':
'Account already exist for this aadhaar no :' +
str(args['AadharNo'])
}
else:
if len(str(args['Phoneno'])) == 10 and len(str(
args['AadharNo'])) == 12:
current_time = datetime.datetime.now()
sql = "INSERT INTO User (Name,Phoneno,AadharNo,Latitude,Longitude,ProfilePic,OnDate) VALUES " \
"(%s,%s,%s,%s,%s,%s,%s)"
val = (args['Name'], args['Phoneno'], args['AadharNo'],
args['Latitude'], args['Longitude'], profile_pic,
current_time)
my_cursor.execute(sql, val)
db.commit()
user_id = my_cursor.lastrowid
db.close()
return {
'Message': 'Registered Successfully',
'UserID': user_id,
'Status': 1
}
else:
return {'Message': 'Please enter valid data', 'Status': 0}
def location_update(args):
my_cursor = db.cursor()
current_time = datetime.datetime.now()
sql = "INSERT INTO Location (UserID,Latitude,Longitude,OnDate) VALUES (%s,%s,%s,%s)"
val = (args['userid'], args['latitude'], args['longitude'], current_time)
my_cursor.execute(sql, val)
db.commit()
return {'Message': 'Success', 'Status': 1}
def __init__(self, start_position, capacity=10, game_id=None):
self._id = None
self.status = VehicleStatus.WAITING
self.position = start_position
self.capacity = capacity
if game_id != None:
query = "INSERT INTO vehicle SET capacity = \"{}\", game_id = \"{}\";".format(
capacity, game_id)
cursor.execute(query)
db.commit()
self._id = cursor.lastrowid
def _save_event(self, event_type, order=None, vehicle=None):
query = """
INSERT INTO adenoa.event SET
event.game_id = {},
event.time = {},
event.type = \"{}\",
event.order = {},
event.vehicle = {}
""".format(self._id, self.clock.time, event_type, order._id,
vehicle._id)
cursor.execute(query)
db.commit()
def save_in_database(self):
if self.game_id != None:
query = """
INSERT INTO adenoa.order SET
status = \"{}\",
departures = 1,
arrivals = 1,
game_id = {},
created_at = {};
""".format(str(self.status), self.game_id, self.created_at)
cursor.execute(query)
db.commit()
self._id = cursor.lastrowid
def insert_order(self, new_order):
"""
Add new ride to the order.
"""
self.begin.extend(new_order.begin)
self.destinations.extend(new_order.destinations)
if len(self.begin) >= 25:
self.full == True
if self.game_id:
query = """
UPDATE adenoa.order SET
departures = {},
arrivals = {},
full = {}
WHERE id = {};
""".format(len(self.begin), len(self.destinations), int(self.full),
self._id)
cursor.execute(query)
db.commit()
def _save_in_database(self):
cities = ", ".join([str(c) for c in self.plan.cities])
query = "INSERT INTO game SET cities = \"{}\";".format(cities)
cursor.execute(query)
db.commit()
self._id = cursor.lastrowid