def __init__(self, capacity):
self.db_proc = db_proc()
self.lru = LRUCache(capacity)
def __init__(self, capacity):
self.db_proc = db_proc()
self.lru = LRUCache(capacity)
class Ac_Data():
def __init__(self, capacity):
self.db_proc = db_proc()
self.lru = LRUCache(capacity)
#从数据库中读取
def load(self):
datas = self.db_proc.ACComments.load()
#使用map进行多线程读取历史数据
pool = ThreadPool(16)
nodes = pool.map(self.load_data, tuple(datas))
pool.close()
pool.join()
#载入历史数据
for node in nodes:
self.insert(node)
def load_data(self, data):
row = ACcommentsPO()
row.set_cid(int(data[0]))
row.set_content(data[1])
row.set_user_name(data[2])
row.set_layer(int(data[3]))
row.set_acid(int(data[4]))
row.set_delete(int(data[5]))
row.set_siji(int(data[6]))
row.set_check_time(data[7])
return row
def insert(self, data):
if not data:
#有的投稿什么都没有
return
#所有评论，只要不是已经删除的，都先放入lru cache中
if data.get_delete() != 1:
try:
self.lru.set(data.get_cid(), data)
except Exception as e:
#在多线程并发的时候，容易出现头结点被同时操作的情况，先跑跑看，以后再看是不是需要加锁
pass
#再分别放入删除表和司机表中，注意如果一条评论既是司机也被删除，那么删除表中应当有记录
if data.get_delete() == 1\
or data.get_siji() == 1:
try:
insert_data = self.lru.get(data.get_cid())
#代码没用，待删除
insert_data.set_delete(data.get_delete())
insert_data.set_siji(data.get_siji())
self.db_proc.ACComments.insert(insert_data)
except Exception:
#永远不应该走到这里
pass
def save(self):
nodes = self.lru.get_all()
self.db_proc.ACComments.clear()
pool = ThreadPool(16)
nodes = pool.map(self.db_proc.ACComments.save, tuple(nodes))
pool.close()
pool.join()
class Ac_Data():
def __init__(self, capacity):
self.db_proc = db_proc()
self.lru = LRUCache(capacity)
#从数据库中读取
def load(self):
datas = self.db_proc.ACComments.load()
#使用map进行多线程读取历史数据
pool = ThreadPool(16)
nodes = pool.map(self.load_data, tuple(datas))
pool.close()
pool.join()
#载入历史数据
for node in nodes:
self.insert(node)
def load_data(self, data):
row = ACcommentsPO()
row.set_cid(int(data[0]))
row.set_content(data[1])
row.set_user_name(data[2])
row.set_layer(int(data[3]))
row.set_acid(int(data[4]))
row.set_delete(int(data[5]))
row.set_siji(int(data[6]))
row.set_check_time(data[7])
return row
def insert(self, data):
if not data:
#有的投稿什么都没有
return
#所有评论，只要不是已经删除的，都先放入lru cache中
if data.get_delete() != 1:
try:
self.lru.set(data.get_cid(), data)
except Exception as e:
#在多线程并发的时候，容易出现头结点被同时操作的情况，先跑跑看，以后再看是不是需要加锁
pass
#再分别放入删除表和司机表中，注意如果一条评论既是司机也被删除，那么删除表中应当有记录
if data.get_delete() == 1\
or data.get_siji() == 1:
try:
insert_data = self.lru.get(data.get_cid())
#代码没用，待删除
insert_data.set_delete(data.get_delete())
insert_data.set_siji(data.get_siji())
self.db_proc.ACComments.insert(insert_data)
except Exception:
#永远不应该走到这里
pass
def save(self):
nodes = self.lru.get_all()
self.db_proc.ACComments.clear()
pool = ThreadPool(16)
nodes = pool.map(self.db_proc.ACComments.save, tuple(nodes))
pool.close()
pool.join()