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