Пример #1
0
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
Пример #2
0
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
Пример #3
0
    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
Пример #4
0
    def delete(self):
 		from ex.database import getSession
		sess = getSession()
		try:

			sess.delete(self)
			sess.commit()
		except:
			sess.rollback()
			raise

		return self
Пример #5
0
    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
Пример #6
0
    def update(self):
		from ex.database import getSession
		sess = getSession()
		# sess.begin(subtransactions=True)
		sess.commit()
Пример #7
0
    def queryObject(self):
		from ex.database import getSession
		return getSession().query(self.__class__)