File size: 4,171 Bytes
96a886b
 
45c48e9
96a886b
1f0f638
96a886b
 
 
7f0d072
1f0f638
4efee17
96a886b
4efee17
7f0d072
4efee17
45c48e9
4efee17
 
 
 
 
45c48e9
4efee17
7f0d072
 
4efee17
 
 
 
96a886b
 
 
 
4efee17
7f0d072
96a886b
4efee17
 
 
 
 
 
 
 
 
96a886b
4efee17
 
 
 
 
 
96a886b
4efee17
96a886b
4efee17
 
 
 
 
 
96a886b
4efee17
96a886b
4efee17
 
 
 
 
 
96a886b
4efee17
96a886b
4efee17
 
 
 
 
 
96a886b
4efee17
96a886b
4efee17
 
 
 
 
 
96a886b
4efee17
96a886b
7f0d072
 
4efee17
7f0d072
 
4efee17
 
96a886b
7f0d072
96a886b
45c48e9
96a886b
7f0d072
 
96a886b
4efee17
96a886b
 
 
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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
'use strict';

/* v8 ignore next 3 */
if (require.main === module) {
  const { loadEnv } = require('../config/load-env');
  loadEnv();
}

/* v8 ignore start */
const { getWrappedDb } = require('.');
const { migrate } = require('./migrate');

const BASE = process.env.SEED_API_BASE_URL || 'https://jsonplaceholder.typicode.com';
/* v8 ignore stop */

/* v8 ignore start */
async function fetchJSON(url) {
  const res = await fetch(url);
  if (!res.ok) throw new Error(`HTTP ${res.status}`);
  return res.json();
}
/* v8 ignore stop */

/* v8 ignore start */
async function seed({ database = getWrappedDb(), fetch: fetchFn = fetchJSON, runMigrate = true, skipTransaction = false } = {}) {
  if (runMigrate) migrate();
  const db = database;
  const row = db.prepare('SELECT COUNT(*) as rowCount FROM users').get();
  if (row.rowCount > 0) {
    console.log('[DB] Already seeded, skipping.');
    return;
  }

  const t0 = Date.now();
  if (!skipTransaction) db.exec('BEGIN');

  try {
    console.log('  [fetch] GET /users');
    const t1 = Date.now();
    const users = await fetchFn(`${BASE}/users`);
    const insertUser = db.prepare(`INSERT INTO users (id,name,username,email,phone,website,address,company) VALUES (?,?,?,?,?,?,?,?)`);
    for (const user of users) {
      insertUser.run(user.id, user.name, user.username, user.email, user.phone, user.website, JSON.stringify(user.address), JSON.stringify(user.company));
    }
    console.log(`  [done] users: ${users.length} rows in ${Date.now() - t1}ms`);

    console.log('  [fetch] GET /posts');
    const t2 = Date.now();
    const posts = await fetchFn(`${BASE}/posts`);
    const insertPost = db.prepare(`INSERT INTO posts (id,userId,title,body) VALUES (?,?,?,?)`);
    for (const post of posts) {
      insertPost.run(post.id, post.userId, post.title, post.body);
    }
    console.log(`  [done] posts: ${posts.length} rows in ${Date.now() - t2}ms`);

    console.log('  [fetch] GET /comments');
    const t3 = Date.now();
    const comments = await fetchFn(`${BASE}/comments`);
    const insertComment = db.prepare(`INSERT INTO comments (id,postId,name,email,body) VALUES (?,?,?,?,?)`);
    for (const comment of comments) {
      insertComment.run(comment.id, comment.postId, comment.name, comment.email, comment.body);
    }
    console.log(`  [done] comments: ${comments.length} rows in ${Date.now() - t3}ms`);

    console.log('  [fetch] GET /albums');
    const t4 = Date.now();
    const albums = await fetchFn(`${BASE}/albums`);
    const insertAlbum = db.prepare(`INSERT INTO albums (id,userId,title) VALUES (?,?,?)`);
    for (const album of albums) {
      insertAlbum.run(album.id, album.userId, album.title);
    }
    console.log(`  [done] albums: ${albums.length} rows in ${Date.now() - t4}ms`);

    console.log('  [fetch] GET /photos');
    const t5 = Date.now();
    const photos = await fetchFn(`${BASE}/photos`);
    const insertPhoto = db.prepare(`INSERT INTO photos (id,albumId,title,url,thumbnailUrl) VALUES (?,?,?,?,?)`);
    for (const photo of photos) {
      insertPhoto.run(photo.id, photo.albumId, photo.title, photo.url, photo.thumbnailUrl);
    }
    console.log(`  [done] photos: ${photos.length} rows in ${Date.now() - t5}ms`);

    console.log('  [fetch] GET /todos');
    const t6 = Date.now();
    const todos = await fetchFn(`${BASE}/todos`);
    const insertTodo = db.prepare(`INSERT INTO todos (id,userId,title,completed) VALUES (?,?,?,?)`);
    for (const todo of todos) {
      insertTodo.run(todo.id, todo.userId, todo.title, todo.completed ? 1 : 0);
    }
    console.log(`  [done] todos: ${todos.length} rows in ${Date.now() - t6}ms`);

    if (!skipTransaction) db.exec('COMMIT');
    console.log(`[Seed] Seeding done in ${Date.now() - t0}ms`);
  } catch (error) {
    if (!skipTransaction) db.exec('ROLLBACK');
    console.error('[Seed] Seeding failed:', error.message);
    throw error;
  }
}
/* v8 ignore stop */

/* v8 ignore next 5 */
if (require.main === module) {
  seed({ runMigrate: false }).then(() => process.exit(0)).catch((error) => {
    console.error('[Seed] Seeding failed:', error.message);
    process.exit(1);
  });
}

module.exports = { seed };