def loadFromID(self, id):
print self.id
result = Query.getOneResult("select * from " + Query.getDBName() + ".COURSES where ID = " + str(id))
if result is None:
return
self.loadFromResult(result)
return self
def loadFromAll(self, username, schedule_name):
SQL = "select * from " + Query.getDBName() + ".SCHEDULES where USERNAME = '******' and SCHEDULE_NAME = '" + schedule_name + "'"
result = Query.getOneResult(SQL)
if result is not None:
self.loadFromResult(result)
self.username = username
self.schedule_name = schedule_name
return self
def loadFromID(self, id):
result = Query.getOneResult("select * from " + Query.getDBName() +".BUILDINGS where ID = '" + id + "'")
if result is None:
return
self.loadFromResult(result)
#floorPlans = []
floors = Floor.getAllForBuilding(id)
for floor in floors:
self.floorPlans.append(floor.floor_map)
return self
def save(self):
if self.in_DB:
#update
SQL = "update " + Query.getDBName() + ".SCHEDULES set USERNAME = '******', SCHEDULE_NAME = '" + self.schedule_name + "'"
Query.execute(SQL)
else:
#insert
SQL = "insert into " + Query.getDBName() + ".SCHEDULES (USERNAME, SCHEDULE_NAME) values('" + self.username + "', '" + self.schedule_name + "')"
Query.execute(SQL)
#get the new ID and save it to the object
SQL = "select * from " + Query.getDBName() + ".SCHEDULES order by ID desc"
result = Query.getOneResult(SQL)
self.id = result[0]
self.in_DB = True
def save(self):
if self.in_DB:
#update
SQL = "update " + Query.getDBName() + ".COORDINATES set BUILDING_ID = '" + self.building_id + "', LATITUDE = '" + self.latitude + "', LONGITUDE = '" + self.longitude + "' where ID = '" + self.id + "'"
Query.execute(SQL)
else:
#insert
SQL = "insert into " + Query.getDBName() + ".COORDINATES (BUILDING_ID, LATITUDE, LONGITUDE) values('" + self.building_id + "', '" + self.latitude + "', '" + self.longitude + "')"
Query.execute(SQL)
#get the new ID and save it to the object
SQL = "select * from " + Query.getDBName() + ".COORDINATES order by ID desc"
result = Query.getOneResult(SQL)
self.id = result[0]
self.in_DB = True
def save(self):
if self.in_DB:
#update
SQL = "update " + Query.getDBName() + ".COURSES set NAME = '" + self.name + "', user_id = " + str(self.user_id) + ", TIME = '" + self.time + "', DAYS = '" + self.days + "', BUILDING_ID = '" + self.building_id + "', ROOM = '" + self.room + "' where ID = " + str(self.id)
Query.execute(SQL)
else:
#insert
SQL = "insert into " + Query.getDBName() + ".COURSES (NAME, user_id, TIME, DAYS, BUILDING_ID, ROOM) values('" + self.name + "', " + str(self.user_id) + ", '" + self.time + "', '" + self.days + "', '" + self.building_id + "', '" + self.room + "')"
Query.execute(SQL)
#get the new ID and save it to the object
SQL = "select * from " + Query.getDBName() + ".COURSES order by ID desc"
result = Query.getOneResult(SQL)
self.id = result[0]
self.in_DB = True
def save(self):
if self.in_DB:
#update
SQL = "update " + Query.getDBName() + ".FLOORS set BUILDING_ID = '" + self.building_id + "', FLOOR_NUMBER = " + str(self.floor_number) + ", FLOOR_MAP = '" + self.floor_map + "' where ID = " + str(self.id)
Query.execute(SQL)
else:
#insert
SQL = "insert into " + Query.getDBName() + ".FLOORS (BUILDING_ID, FLOOR_NUMBER, FLOOR_MAP) values('" + self.building_id + "', " + str(self.floor_number) + ", '" + self.floor_map + "')"
Query.execute(SQL)
#get the new ID and save it to the object
SQL = "select * from " + Query.getDBName() + ".FLOORS order by ID desc"
result = Query.getOneResult(SQL)
self.id = result[0]
self.in_DB = True
def loadFromID(self, id):
result = Query.getOneResult("select * from " + Query.getDBName() + ".SCHEDULES where ID = " + str(id))
if result is None:
return
return self.loadFromResult(result)
def loadFromID(self, username):
result = Query.getOneResult("select * from " + Query.getDBName() + ".USERS where USERNAME = '******'")
if result is None:
return User()
self.loadFromResult(result)
return self
