def saveWorld(): from ex.database import getSession # savePlayers() # saveUnits() sess = getSession() # .begin(subtransactions=True) try: RVEngine.log("Flushing database.") sess.flush() # sess.commit() RVEngine.log("Flushed") except Exception, e: try: logger.error("Error Rolling back: '" + str(e) + "'") sess.rollback() sess = getSession() # .begin(subtransactions=True) logger.error("Error Reflushing database.") sess.flush() logger.error("Error Recommiting database.") # sess.commit() except Exception, e: logger.error("Aborting: " + str(e)) sess.rollback() raise
def saveMultiple(self, objects=[]): from ex.database import getSession sess = getSession().begin(subtransactions=True) try: sess.add_all(objects) # sess.commit() except: # sess.rollback() sess = getSession().begin(subtransactions=True) try: sess.add_all(objects) # sess.commit() except: sess.rollback() raise return True
def delete(self): from ex.database import getSession sess = getSession() try: sess.delete(self) sess.commit() except: sess.rollback() raise return self
def save(self): from ex.database import getSession sess = getSession() # sess.begin(subtransactions=True) try: sess.add(self) # sess.commit() except: # sess.rollback() sess.begin(subtransactions=True) try: sess.add(self) # sess.commit() except: sess.rollback() raise return True
def update(self): from ex.database import getSession sess = getSession() # sess.begin(subtransactions=True) sess.commit()
def queryObject(self): from ex.database import getSession return getSession().query(self.__class__)