deckforge/scripts/seed.ts at main · indianic/deckforge

History

70 lines (56 loc) · 1.96 KB

Raw

/**

* Seed script — creates the first workspace and admin user.

* Run once after first migration:

* DATABASE_URL=... npx tsx scripts/seed.ts

import postgres from 'postgres';

import { drizzle } from 'drizzle-orm/postgres-js';

import * as schema from '../lib/db/schema/index';

import { seedLayouts } from './seed/layouts';

const connectionString = process.env.DATABASE_URL;

if (!connectionString) {

console.error('DATABASE_URL is required');

process.exit(1);

}

const client = postgres(connectionString);

const db = drizzle(client, { schema });

async function seed() {

console.log('Seeding database...');

// Check if workspace already exists

const existing = await db.query.workspaces.findFirst();

if (existing) {

console.log('Workspace already exists — seeding layouts only.');

await seedLayouts(db as never, existing.id);

await client.end();

return;

}

const [workspace] = await db

.insert(schema.workspaces)

.values({ name: 'My Workspace' })

.returning();

if (!workspace) throw new Error('Failed to create workspace');

const adminEmail = process.env.ADMIN_EMAIL ?? 'admin@deckforge.test';

const adminName = process.env.ADMIN_NAME ?? 'Admin';

const [admin] = await db

.insert(schema.users)

.values({

workspaceId: workspace.id,

name: adminName,

email: adminEmail.toLowerCase(),

role: 'admin',

})

.returning();

if (!admin) throw new Error('Failed to create admin user');

console.log(`Workspace created: "${workspace.name}" (${workspace.id})`);

console.log(`Admin user created: ${admin.email} (${admin.id})`);

console.log('Seeding built-in layouts...');

await seedLayouts(db as never, workspace.id);

console.log('');

console.log(`To log in on production, run:`);

console.log(` DATABASE_URL=... APP_URL=https://yourdomain.com npx tsx scripts/create-magic-link.ts ${admin.email}`);

await client.end();

}

seed().catch((err) => {

console.error(err);

process.exit(1);

});

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Expand file tree

Search code, repositories, users, issues, pull requests...

Uh oh!

FilesExpand file tree

seed.ts

Latest commit

History

seed.ts

File metadata and controls

Expand file tree