Example #1
0
def getDupTable():
    note = Note(NOTEROOT)
    note.readIndex()
    # 导入并规整加载到表格里的数据格式
    df = note.index
    ddf = df.loc[df.duplicated(subset=['title'], keep=False)].copy()  #进行查重
    ddf['title'] = "<a href='load/" + ddf[
        'type'] + "/" + ddf.index + "'>" + ddf[
            'title'] + "</a>"  # 改造title使之超链接化
    ddf['atime'] = ddf['atime'].apply(
        lambda x: x.strftime('%Y-%m-%d'))  # 日期格式化
    ddf['ctime'] = ddf['ctime'].apply(lambda x: x.strftime('%Y-%m-%d'))
    ddf['mtime'] = ddf['mtime'].apply(
        lambda x: x.strftime('%Y-%m-%d %H:%M:%S'))
    #df['att'] = df['att_list']
    ddf = ddf[[
        'type', 'title', 'att_num', 'keywords', 'mtime', 'atime', 'ctime'
    ]]
    ddf.columns = ['Type', '标题', '附', '关键词', 'mtime', 'atime', 'ctime']
    # 忽略path url,同时调整顺序
    dj = ddf.to_json(orient="split")  # orient="split" 可能和后边的json.loads有关!!!
    #print(dj)
    return jsonify(note_dup_list=json.loads(dj)["data"],
                   columns=[{
                       "title": str(col)
                   } for col in json.loads(dj)["columns"]])
Example #2
0
def index():
    note = Note(NOTEROOT)
    note.getUpdateTime()
    session['update_time'] = note.index_update_time
    # 暂存更新时间(以打开笔记本时为准),防止后续读写index导致更新时间有误
    note.readIndex()
    note.doStatistics()
    countinfo = f"所有:{note.index.shape[0]}\
                  草稿:{note.index.loc[note.index['type']=='Draft'].shape[0]}\
                  存档:{note.index.loc[note.index['type']=='Archive'].shape[0]}"

    page = render_template("index.html",
                           title='索引页 - 网页笔记本',
                           note_root=NOTEROOT,
                           note_new_dir=NEWNOTEDIR,
                           note_update_time=session['update_time'],
                           note_count=countinfo)
    return page