def update(self, o):
idx = o['idx']
rec = o['rec']
db = Database()
db.query('ippool_update_valid', id=rec['id'], valid=rec['valid'])
db.close()
self.data[idx] = rec
self.RowChanged(idx)
def load_data(self):
db = Database()
r = db.query('ippool_count')[0]
c = r.c if r.c is not None else 0
s = r.s if r.s is not None else 0
f = r.f if r.f is not None else 0
self.led_total.set_value(c)
self.led_succ.set_value(s)
self.led_fail.set_value(f)
def records(self):
db = Database()
rows = db.query('ippool_all')
rows = rows.as_dict()
if len(rows) == 0:
return []
delt = rows[len(rows) - 1]['speed'] - rows[0]['speed']
rows = [[
d['country'], d['ip'], d['port'], d['city'],
100 - int(100 * (d['speed'] / delt)), d['conn_type']
] for d in rows]
return rows
def update_record(self, rec):
ip = rec[1]
port = rec[2]
valid = rec[4]
db = Database()
rows = db.query('ippool_update_valid', ip=ip, port=port, valid=valid)
def get_all_record(self):
db = Database()
rows = db.query('ippool_all')
rows = rows.as_dict()
rows = [ [i, d['ip'], d['port'], d['conn_type'], d['valid'] ] for i, d in enumerate(rows)]
return rows
def instance(cls):
db = Database()
rows = db.query('ippool_all')
rows = rows.as_dict()
db.close()
return TestGridModel(rows)