Files
qms/scripts/create-admin.js
jason ad499f6782
Build and Push Docker Image / build (push) Successful in 1m12s
Assemble QMS app + SQLite refactor + Unraid single-container deploy
Reconstruct the full app from init-source overlays (base + fix-1..6 +
update-1..3, last-wins) at the repo root, complete the missing pieces so it
builds and runs, and stage the Unraid deployment.

App completion:
- types/index.ts: former Prisma enums as string-literal unions + AppUser
- pages/_app.tsx + styles/globals.css (mount AppProvider/ToastProvider)
- API routes: auth/login, auth/me, users, submissions (+REVIEW_READY notify),
  forms (list/create), notifications
- scripts/create-admin.js: idempotent first-admin bootstrap
- 14 unbuilt nav targets stubbed via ComingSoon placeholder

SQLite refactor (single-container, no external DB):
- schema provider -> sqlite; enums -> String; Json -> String;
  FormField.options String[] -> JSON-encoded String
- lib/forms.ts (de)serialises options at the DB boundary
- drop mode:"insensitive" (unsupported on SQLite)
- enum imports repointed from @prisma/client to @/types

Deploy:
- multi-stage Dockerfile (next build -> prod runner), docker-entrypoint.sh
  (prisma db push -> create-admin -> next start), .dockerignore
- docker-compose.yml: br0 10.2.0.x, /mnt/user/appdata/qms -> /data volume
- README rewritten for the Unraid/Gitea Actions flow; .env scrubbed of the
  live Supabase credential; vercel.json removed

Verified: next build clean (41 routes); live SQLite round-trip of
login/session, form options array, and submission -> REVIEW_READY.

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
2026-06-15 16:58:47 -05:00

33 lines
1.1 KiB
JavaScript

// Creates the first admin from ADMIN_EMAIL / ADMIN_PASSWORD / ADMIN_NAME.
// Idempotent: does nothing if any ADMIN user already exists, so container
// restarts never reset the password. Run via `npm run create-admin`.
const { PrismaClient } = require('@prisma/client')
const bcrypt = require('bcryptjs')
const prisma = new PrismaClient()
async function main() {
const email = (process.env.ADMIN_EMAIL || 'admin@local').trim().toLowerCase()
const password = process.env.ADMIN_PASSWORD || 'changeme'
const name = process.env.ADMIN_NAME || 'Administrator'
const existing = await prisma.user.findFirst({ where: { role: 'ADMIN' } })
if (existing) {
console.log('[create-admin] An admin user already exists — skipping.')
return
}
const password_hash = await bcrypt.hash(password, 12)
await prisma.user.create({
data: { email, name, password: password_hash, role: 'ADMIN', active: true },
})
console.log(`[create-admin] Created admin: ${email}`)
}
main()
.catch(e => {
console.error('[create-admin] failed:', e)
process.exit(1)
})
.finally(() => prisma.$disconnect())