def UpdateYuqueEvernoteBookMap(
self, bookmapList: Sequence[SNTypes.SystemConfig.SyncBookMap]):
# 创建session对象:
session = self.DBSession()
# 清空原有的对应关系
session.query(DBOTyping.YuqueEvernoteBookMap).delete()
for bookmap in bookmapList:
res = session.query(ENDBTypes.Notebook) \
.filter(ENDBTypes.Notebook.name == bookmap.evernoteBook).first()
evernoteNoteBookGuid = res.guid
res = session.query(YQDBTypes.YuqueBook) \
.filter(YQDBTypes.YuqueBook.name == bookmap.yuqueBook).first()
yuqueBookNamespace = res.namespace
dbmap = DBOTyping.YuqueEvernoteBookMap(
evernoteNoteBookGuid=evernoteNoteBookGuid,
yuqueBookNamespace=yuqueBookNamespace,
)
session.add(dbmap)
# 提交修改
session.commit()
# 关闭数据库
session.close()
def UpdateEvernotebooks(self, enNotebookList: Sequence[Types.Notebook]):
'''
更新印象笔记的 笔记本
'''
# 创建session对象:
session = self.DBSession()
# 清空表
session.query(ENDBTypes.Notebook).delete()
for enNotebook in enNotebookList:
dbNotebook = ENDBTypes.Notebook(
guid=enNotebook.guid,
name=enNotebook.name,
updateSequenceNum=enNotebook.updateSequenceNum,
defaultNotebook=enNotebook.defaultNotebook,
serviceCreated=enNotebook.serviceCreated,
serviceUpdated=enNotebook.serviceUpdated,
published=enNotebook.published,
stack=enNotebook.stack,
)
session.add(dbNotebook)
# 提交修改
session.commit()
# 关闭数据库
session.close()
def GetEvernoteFirstUnDonloadNoteInfo(self):
'''
获取未下载的数据
'''
session = self.DBSession()
# 查找需要上传的笔记本
res = session.query(DBOTyping.YuqueEvernoteBookMap).all()
if res is None:
session.close()
return None
uploadBookList = []
for r in res:
uploadBookList.append(r.evernoteNoteBookGuid)
res = session.query(ENDBTypes.Note).filter(
and_(ENDBTypes.Note.downloaded == False,
ENDBTypes.Note.active == True,
ENDBTypes.Note.notebookGuid.in_(uploadBookList))).order_by(
ENDBTypes.Note.updateSequenceNum.desc()).first()
if res is None:
session.close()
return None
else:
guid = res.guid
session.close()
return guid
def UpdateYuqueBooks(self, booklist: Sequence[BookSerializer]):
'''
更新印象笔记的 笔记本
'''
# 创建session对象:
session = self.DBSession()
# 清空表
session.query(YQDBTypes.YuqueBook).delete()
for book in booklist:
dbNotebook = YQDBTypes.YuqueBook(
id=book.id,
type=book.type,
slug=book.slug,
name=book.name,
namespace=book.namespace,
user_id=book.user_id,
description=book.description,
creator_id=book.creator_id,
public=book.public,
likes_count=book.likes_count,
watches_count=book.watches_count,
created_at=book.created_at,
updated_at=book.updated_at,
)
session.add(dbNotebook)
# 提交修改
session.commit()
# 关闭数据库
session.close()
return
def GetEvernoteFirstUnUploadNoteInfo(self) -> YQDBTypes.UnUploadNoteInfo:
'''
获取未上传的笔记信息
'''
session = self.DBSession()
results: dict = {}
# 找到印象笔记中所有待上传的笔记本
res = session.query(DBOTyping.YuqueEvernoteBookMap).all()
if res is None:
session.close()
return None
uploadBookList = []
for r in res:
uploadBookList.append(r.evernoteNoteBookGuid)
logging.debug(uploadBookList)
# 找到第一条已经下载的笔记
res = session.query(ENDBTypes.Note) \
.filter(
and_(ENDBTypes.Note.syncToYuque == False,
ENDBTypes.Note.notebookGuid.in_(uploadBookList),
ENDBTypes.Note.downloaded == True,
ENDBTypes.Note.active == True)
).order_by(ENDBTypes.Note.updateSequenceNum.desc()).first()
if res is None:
session.close()
return None
notebookGuid = res.notebookGuid
noteGuid = res.guid
title = res.title
enml = res.enml
html = res.html
markdown = res.markdown
# 找到语雀的笔记本
res = session.query(DBOTyping.YuqueEvernoteBookMap).filter(
DBOTyping.YuqueEvernoteBookMap.evernoteNoteBookGuid ==
notebookGuid).first()
yuqueBookNamespace = res.yuqueBookNamespace
noteInfo = YQDBTypes.UnUploadNoteInfo(
notebookGuid=notebookGuid,
noteGuid=noteGuid,
title=title,
yuqueBookNamespace=yuqueBookNamespace,
enml=enml,
html=html,
markdown=markdown,
)
session.close()
return noteInfo
def SaveEvernoteLocalUSN(self, localUSN: int):
session = self.DBSession()
# 更新USN
session.query(ENDBTypes.SyncState).delete()
syncState = ENDBTypes.SyncState(updateCount=localUSN)
session.add(syncState)
# 提交修改
session.commit()
session.close()
def SetEvernoteUploadState(self, noteGuid: str, state: bool):
'''
标记文件的上传状态
'''
session = self.DBSession()
session.query(ENDBTypes.Note).filter(
ENDBTypes.Note.guid == noteGuid).update({"syncToYuque": state})
session.commit()
session.close()
return
def SetEvernoteDownloadState(self, noteGuid: str, state: bool):
'''
标记文件的下载状态
'''
session = self.DBSession()
session.query(ENDBTypes.Note).filter(
ENDBTypes.Note.guid == noteGuid).update({"downloaded": state})
session.commit()
session.close()
return
def SaveEvernoteContent(self, noteGuid: str, enml: str, html: str,
markdown: str):
'''
标记文件已经上传
'''
session = self.DBSession()
session.query(ENDBTypes.Note) \
.filter(ENDBTypes.Note.guid == noteGuid) \
.update({"enml": enml,
'html': html,
'markdown': markdown})
session.commit()
session.close()
return
def InsertEvernoteData(self, noteList: Sequence[Types.Note]):
if noteList is None:
return
session = self.DBSession()
for note in noteList:
# 如果是有效数据 才记录到数据库中，不然就删除
dbNote = ENDBTypes.Note(
guid=note.guid,
title=note.title,
content=note.content,
# contentHash=note.contentHash,
contentLength=note.contentLength,
created=note.created,
updated=note.updated,
deleted=note.deleted,
active=note.active,
updateSequenceNum=note.updateSequenceNum,
notebookGuid=note.notebookGuid,
# tagGuids=note.tagGuids,
# resources=note.resources,
# attributes=note.attributes,
# tagNames=note.tagNames,
syncToYuque=False,
downloaded=False)
# 删除原有的
session.query(ENDBTypes.Note).filter(
ENDBTypes.Note.guid == note.guid).delete()
# 添加新数据
session.add(dbNote)
# 更新USN
session.query(ENDBTypes.SyncState).delete()
syncState = ENDBTypes.SyncState(updateCount=note.updateSequenceNum)
session.add(syncState)
# 提交修改
session.commit()
session.close()
def mysql_query(self):
"""数据库查询需要转换的数据"""
all_local_file = [] # 分拣两种文件
all_oss_file = []
flag = 'http'
txt = 'url_vrc like "%.pdf%" or url_vrc_two like "%.pdf%" or url_vehicle_license like "%.pdf%" or ' \
'url_voc like "%.pdf%" or url_truck_jqx like "%.pdf%" or url_others_insurance like "%.pdf%"'
_obj = session.query(tk.url_vrc, tk.url_vrc_two,
tk.url_vehicle_license, tk.url_voc,
tk.url_truck_jqx, tk.url_others_insurance,
tk.plate).filter(text(txt)).all()
for item in _obj:
if self.match_name(item.url_vrc):
if flag in item.url_vrc:
all_local_file.append({'url_vrc': item.url_vrc})
else:
all_oss_file.append({'url_vrc': item.url_vrc})
if self.match_name(item.url_vrc_two):
if flag in item.url_vrc_two:
all_local_file.append({'url_vrc_two': item.url_vrc_two})
else:
all_oss_file.append({'url_vrc_two': item.url_vrc_two})
if self.match_name(item.url_vehicle_license):
if flag in item.url_vehicle_license:
all_local_file.append(
{'url_vehicle_license': item.url_vehicle_license})
else:
all_oss_file.append(
{'url_vehicle_license': item.url_vehicle_license})
if self.match_name(item.url_voc):
if flag in item.url_voc:
all_local_file.append({'url_voc': item.url_voc})
else:
all_oss_file.append({'url_voc': item.url_voc})
if self.match_name(item.url_truck_jqx):
if flag in item.url_truck_jqx:
all_local_file.append(
{'url_truck_jqx': item.url_truck_jqx})
else:
all_oss_file.append({'url_truck_jqx': item.url_truck_jqx})
if self.match_name(item.url_others_insurance):
if flag in item.url_others_insurance:
all_local_file.append(
{'url_others_insurance': item.url_others_insurance})
else:
all_oss_file.append(
{'url_others_insurance': item.url_others_insurance})
return all_local_file, all_oss_file
def GetEvernoteLocalUSN(self):
'''
获取本地的最后一次同步数值
'''
session = self.DBSession()
state = session.query(ENDBTypes.SyncState).first()
if state is None:
# 第一次查询 是找不到合适的笔记本的
return 0
logging.debug(state.updateCount)
updateCount = state.updateCount
# session.commit()
session.close()
return updateCount