server/src/seeder.ts

import { getDB } from "./db.js";
import bcrypt from "bcrypt";
import { generateId, verifyRequestOrigin } from "lucia";


import dotenv from "dotenv";
dotenv.config();

var db = getDB();

const users = [
    {
        username: "user1",
        password: await bcrypt.hash("123", 10),
    },
    {
        username: "user2",
        password: await bcrypt.hash("123", 10),
    },
    {
        username: "user3",
        password: await bcrypt.hash("123", 10),
    },
];



function seedUsers() {

    const stmt = db.prepare("INSERT INTO users(id,name,password) VALUES(?,?,?)");

    users.forEach(user => {
        stmt.run(user.username, user.username, user.password);
    })

}

function seedMessages() {

    const stmt = db.prepare(`INSERT INTO messages(id,content,type,sender_id,receiver_id) VALUES(?,?,?,?,?)`);

    for (var i = 0; i < users.length; i++) {
        for (var j = 0; j < users.length; j++) {
            if(i==j) continue;
            var message_id = generateId(5);
            var content = "hi";
            var type = "text";
            var sender_id = users[i].username;
            var receiver_id = users[j].username;
            
            stmt.run(
                message_id,
                content,
                type,
                sender_id,
                receiver_id,
            );

        }    


    }
}


db.prepare("delete from users").run();
db.prepare("delete from messages").run();
seedUsers()
seedMessages()