peworkshop/scripts/seed-db.js

const { query } = require('../lib/db');
const bcrypt = require('bcryptjs');

async function seedDb() {
    try {
        const hashedPassword = bcrypt.hashSync('admin', 10);
        await query(
            'INSERT OR IGNORE INTO users (username, password, role) VALUES (?, ?, ?)',
            ['admin', hashedPassword, 'admin']
        );

        console.log('Database seeded successfully.');
    } catch (err) {
        console.error('Error seeding database:', err);
    }
}

seedDb();