def update_or_add(cls, ip, port, status):
try:
slave = session.query(SqliteTable).filter(
SqliteTable.ip == ip, SqliteTable.port == port).one()
cls.slave_update(ip, port, status)
except NoResultFound:
cls.slave_add(ip, port, status)
def remove_zombies(cls):
""" remove slave zombies ,this method can be called peroidly,but not frequently,
because it is operating the database
"""
current_time = datetime.now()
valide_period = timedelta(seconds=settings.DETECT_ZOMBIE_FRENQUENCY)
expire = current_time - valide_period
zombie_slaves = session.query(SqliteTable).filter(SqliteTable.update_time < expire).delete()
def remove_zombies(cls):
""" remove slave zombies ,this method can be called peroidly,but not frequently,
because it is operating the database
"""
current_time = datetime.now()
valide_period = timedelta(seconds=settings.DETECT_ZOMBIE_FRENQUENCY)
expire = current_time - valide_period
zombie_slaves = session.query(SqliteTable).filter(
SqliteTable.update_time < expire).delete()
def get_command(cls, ip, port):
cmd = session.query(SqliteTable).filter(
SqliteTable.ip == ip, SqliteTable.port == port).one()
return cmd
def slave_update(cls, ip, port, status):
session.query(SqliteTable).filter(
SqliteTable.ip == ip, SqliteTable.port == port).update(status)
session.commit()
def slave_remove(cls, ip, port):
session.query(SqliteTable).filter(SqliteTable.ip == ip,
SqliteTable.port == port).delete()
session.commit()
def exists(cls, ip, port):
""" check whether the slave exists """
return session.query(exists().where(
and_(SqliteTable.ip == ip, SqliteTable.port == port))).scalar()
def all(cls, offset=0, limit=100):
""" get all the slaves """
all_slaves = session.query(SqliteTable).offset(offset).limit(
limit).all()
return all_slaves
def get_command(cls,ip,port):
cmd = session.query(SqliteTable).filter(SqliteTable.ip==ip,SqliteTable.port==port).one()
return cmd
def update_or_add(cls,ip,port,status):
try:
slave = session.query(SqliteTable).filter(SqliteTable.ip==ip,SqliteTable.port==port).one()
cls.slave_update(ip,port,status)
except NoResultFound:
cls.slave_add(ip,port,status)
def slave_update(cls,ip,port,status):
session.query(SqliteTable).filter(SqliteTable.ip==ip,SqliteTable.port==port).update(status)
session.commit()
def slave_remove(cls,ip,port):
session.query(SqliteTable).filter(SqliteTable.ip==ip,SqliteTable.port==port).delete()
session.commit()
def exists(cls,ip,port):
""" check whether the slave exists """
return session.query(exists().where(and_(SqliteTable.ip == ip,SqliteTable.port==port))).scalar()
def all(cls,offset=0,limit=100):
""" get all the slaves """
all_slaves = session.query(SqliteTable).offset(offset).limit(limit).all()
return all_slaves