读取firefox浏览器历史记录（nim学习系列）

读取firefox浏览器历史记录（nim学习系列）

读取firefox历史记录

读取firefox浏览器历史记录并保存到CSV文件（需要sqlite3_64.dll或者sqlite3_32.dll）。
编译：

nim c -d:release --opt:size --cpu:amd64 firefoxHistory.nim

nim c -d:release --opt:size --cpu:i386 firefoxHistory.nim

源代码

#[
Author: StudyCat
Blog: https://www.cnblogs.com/studycat
Github: https://github.com/StudyCat404/myNimExamples
License: BSD 3-Clause
]#

import db_sqlite
import osproc
import os
import strutils
import streams
import times

let time = cpuTime()
    
proc findDBFiles(): seq[string] =
    var cmdArgs: array[6,string]
    var outp: string
    
    cmdArgs[0] = "/Q"
    cmdArgs[1] = "/C"
    cmdArgs[2] = "dir"
    cmdArgs[3] = r"%appdata%\Mozilla\Firefox\Profiles\places.sqlite"
    cmdArgs[4] = "/S"
    cmdArgs[5] = "/B"
    let shell = os.getEnv("COMSPEC")
    outp = osproc.execProcess(shell, args=cmdArgs, options={poStdErrToStdOut,poUsePath})

    var line = ""
    var strm = newStringStream(outp)
    if not isNil(strm):    
        while strm.readLine(line):
            if line.len() > 0:
                result.add(line)
  
proc firefoxHistory(dbFilePath: string) =
    var record: string
    var f: File
    f = open("firefoxHistory.csv", fmAppend)
    
    if fileExists(dbFilePath):
        let db = open(dbFilePath, "", "", "")
        try:
            for row in db.fastRows(sql"select moz_places.title, moz_places.url, datetime(moz_places.last_visit_date / 1000000, 'unixepoch') from moz_places"):
                record = join(row, ",")
                f.writeLine(record)
        except:
            stderr.writeLine(getCurrentExceptionMsg())
        finally:
            db.close()
    f.close()   

when isMainModule:
    when defined windows:
        for path in findDBFiles():
            echo path
            firefoxHistory(path)  
    
        echo "Time taken: ", cpuTime() - time, "s"