def add_to_db(object): try: db_session.add(object) db_session.flush() return True except sqlalchemy.exc.IntegrityError as err: print "IntegrityError" return False
def confirm(self, token): s = Serializer(current_app.config['SECRET_KEY']) try: data = s.loads(token) print "Token data = %s" % data except: traceback.print_tb(exc_traceback, limit=1, file=sys.stderr) return False if data.get('confirm') != self.id: print "ERROR: data.get confirm != self.id" return False self.confirmed = 1 db_session.merge(self) db_session.commit() db_session.flush() return True
def insert(self, date, hour, direction, address, count, percent): print "%s, %s, %s, %s, %s, %s" % (date, hour, direction, address, count, percent) self.tdstamp = "%s %s:00.00" % (date, hour) self.direction = direction self.address = ip2int(address) self.flows = count self.percentTraffic = percent try: db_session.merge(self) db_session.flush() #db_session.commit() except AttributeError: traceback.print_exc(file=sys.stderr) except: traceback.print_exc(file=sys.stderr) db_session.rollback()
def flush(self): db_session.flush()
def __init__(self): print "initializing the ipblock object" db_session.flush()
def save(self): db_session.add(self) db_session.flush() db_session.commit()
def delete(self): db_session.delete(self) db_session.flush() db_session.commit()
def update(self): db_session.merge(self) db_session.flush() db_session.commit()