ingest-texts-db.js

const os = require('os')
const path = require('path')
const keytar = require('/Applications/Texts.app/Contents/Resources/app/node_modules/keytar')
const bs = require('/Applications/Texts.app/Contents/Resources/app/node_modules/better-sqlite3') // https://github.com/signalapp/better-sqlite3

let db
async function getUnlockedDb() {
  if (db) return db

  const key = await keytar.getPassword('com.kishanbagaria.jack', 'etilqs_key')
  const keyBuffer = Buffer.from(key, 'base64')
  const keyHex = keyBuffer.toString('hex')

  db = bs(path.join(os.homedir(), 'Library/Application Support/jack/.index.db'))
  const pragmaKeySql = `PRAGMA key = "x'${keyHex}'";`
  db.exec(pragmaKeySql)

  return db
}

async function findMessagesCount() {
  const db = await getUnlockedDb()

  const count = db.prepare('select count(*) from messages').pluck().get()
  console.log({ count })
}

findMessagesCount()