Skip to content

Self-hosted personal gallery application with online photo management and albums, supporting Live/Motion Photos, EXIF parsing, geolocation recognition, and an explore map.

1.3 KB
Raw Blame
import assert from 'node:assert/strict'
import { readFileSync } from 'node:fs'
import test from 'node:test'
import Database from 'better-sqlite3'

test('Local account seeding synchronizes regenerated credentials without replacing the account', () => {
  const source = readFileSync('scripts/setup-cloud-local.mjs', 'utf8')
  const sql = source.match(/`(INSERT INTO platform_accounts[^`]+)`/)?.[1]
  assert.ok(sql)
  const db = new Database(':memory:')
  try {
    db.exec(`
      CREATE TABLE platform_users(id INTEGER PRIMARY KEY, email TEXT UNIQUE);
      CREATE TABLE platform_accounts(
        id INTEGER PRIMARY KEY, account_id TEXT, provider_id TEXT,
        user_id INTEGER, password TEXT, created_at INTEGER, updated_at INTEGER,
        UNIQUE(provider_id, account_id)
      );
      INSERT INTO platform_users VALUES(1, '[email protected]');
    `)
    const seed = db.prepare(sql)
    seed.run('original-hash', 10, 10, '[email protected]')
    seed.run('regenerated-hash', 20, 20, '[email protected]')
    assert.deepEqual(db.prepare('SELECT * FROM platform_accounts').all(), [
      {
        id: 1,
        account_id: '1',
        provider_id: 'credential',
        user_id: 1,
        password: 'regenerated-hash',
        created_at: 10,
        updated_at: 20,
      },
    ])
  } finally {
    db.close()
  }
})