dangkhoa2016's picture
feat: seed environment settings and extract SETTING_DEFS
7f0d072
Raw History Blame
4.17 kB
'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 };