Function getLatestContactMessageTs

packages/core/src/query/contact-queries.ts:111–122

(db: DatabaseAdapter)

}

export function getLatestContactMessageTs(db: DatabaseAdapter): number | null {
  const row = db
    .prepare(
      `SELECT MAX(msg.ts) as ts
       FROM message msg
       JOIN member m ON msg.sender_id = m.id
       WHERE ${nonSystemMessageCondition(db, 'msg', 'm')}`
    )
    .get() as { ts: number | null } | undefined

  return row?.ts ?? null
}

export function getPrivateContactFacts(
  db: DatabaseAdapter,