mirror of
https://github.com/saltbo/zpan.git
synced 2026-08-29 00:01:42 +08:00
saltbo
48 lines
1.6 KiB
TypeScript
48 lines
1.6 KiB
TypeScript
import { describe, expect, it } from 'vitest'
|
|
import {
|
|
buildPreviewAdminSeedSql,
|
|
buildWranglerArgs,
|
|
CREDENTIAL_ACCOUNT_ISSUER,
|
|
} from '../../scripts/seed-preview-admin'
|
|
|
|
describe('seed-preview-admin script', () => {
|
|
it('builds idempotent SQL for the preview admin account', () => {
|
|
const sql = buildPreviewAdminSeedSql({
|
|
email: "admin'quoted@zpan.space",
|
|
passwordHash: "hash'quoted",
|
|
userId: "user'quoted",
|
|
accountId: "account'quoted",
|
|
now: 1771771771771,
|
|
})
|
|
|
|
expect(sql).toContain("VALUES ('user''quoted', 'Admin', 'admin''quoted@zpan.space', 1, 'admin', 0, NULL, NULL")
|
|
expect(sql).toContain('ON CONFLICT(email) DO UPDATE SET')
|
|
expect(sql).toContain('banned = 0')
|
|
expect(sql).toContain('ban_reason = NULL')
|
|
expect(sql).toContain('ban_expires = NULL')
|
|
expect(sql).toContain('UPDATE account')
|
|
expect(sql).toContain("SET password = 'hash''quoted'")
|
|
expect(sql).toContain(`issuer = '${CREDENTIAL_ACCOUNT_ISSUER}'`)
|
|
expect(sql).toContain('INSERT INTO account (id, issuer, account_id, provider_id')
|
|
expect(sql).toContain(`SELECT 'account''quoted', '${CREDENTIAL_ACCOUNT_ISSUER}', u.id, 'credential'`)
|
|
expect(sql).toContain('AND NOT EXISTS')
|
|
expect(sql).not.toContain('BEGIN')
|
|
expect(sql).not.toContain('COMMIT')
|
|
})
|
|
|
|
it('targets only the remote staging D1 database', () => {
|
|
expect(buildWranglerArgs('/tmp/seed.sql')).toEqual([
|
|
'exec',
|
|
'wrangler',
|
|
'd1',
|
|
'execute',
|
|
'zpan-db-staging',
|
|
'--remote',
|
|
'--env',
|
|
'staging',
|
|
'--file',
|
|
'/tmp/seed.sql',
|
|
])
|
|
})
|
|
})
|