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 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()
