File size: 1,464 Bytes
c13f601
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
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()