Function resolveOwnerMember

packages/core/src/query/contact-queries.ts:70–90

(db: DatabaseAdapter)

}

export function resolveOwnerMember(db: DatabaseAdapter): ContactMemberRef | null {
  const meta = db.prepare('SELECT owner_id FROM meta LIMIT 1').get() as { owner_id: string | null } | undefined
  if (!isValidContactPlatformId(meta?.owner_id)) return null
  const aliasesSelect = hasColumn(db, 'member', 'aliases') ? 'aliases' : 'NULL as aliases'

  const row = db
    .prepare(
      `SELECT
        id,
        platform_id as platformId,
        COALESCE(group_nickname, account_name, platform_id) as name,
        ${aliasesSelect},
        avatar
      FROM member m
      WHERE platform_id = ? AND ${nonSystemContactMemberCondition(db, 'm')}
      LIMIT 1`
    )
    .get(meta.owner_id) as ContactMemberRow | undefined

  return row ? mapContactMemberRow(row) : null
}

export function getNonSystemMembersForContacts(db: DatabaseAdapter): ContactMemberRef[] {
  const aliasesSelect = hasColumn(db, 'member', 'aliases') ? 'aliases' : 'NULL as aliases'