Nodejs-JSON-API-Server / src /db /migrate.js
dangkhoa2016's picture
feat: fetch seed data from JSONPlaceholder API
4efee17
Raw History Blame
1.71 kB
'use strict';
if (require.main === module) {
const { loadEnv } = require('../load-env');
loadEnv();
}
const { getDb } = require('../database');
function migrate() {
const db = getDb();
db.exec(`
CREATE TABLE IF NOT EXISTS users (
id INTEGER PRIMARY KEY,
name TEXT,
username TEXT UNIQUE,
email TEXT,
phone TEXT,
website TEXT,
address TEXT,
company TEXT
);
CREATE TABLE IF NOT EXISTS posts (
id INTEGER PRIMARY KEY,
userId INTEGER,
title TEXT,
body TEXT,
FOREIGN KEY(userId) REFERENCES users(id)
);
CREATE TABLE IF NOT EXISTS comments (
id INTEGER PRIMARY KEY,
postId INTEGER,
name TEXT,
email TEXT,
body TEXT,
FOREIGN KEY(postId) REFERENCES posts(id)
);
CREATE TABLE IF NOT EXISTS albums (
id INTEGER PRIMARY KEY,
userId INTEGER,
title TEXT,
FOREIGN KEY(userId) REFERENCES users(id)
);
CREATE TABLE IF NOT EXISTS photos (
id INTEGER PRIMARY KEY,
albumId INTEGER,
title TEXT,
url TEXT,
thumbnailUrl TEXT,
FOREIGN KEY(albumId) REFERENCES albums(id)
);
CREATE TABLE IF NOT EXISTS todos (
id INTEGER PRIMARY KEY,
userId INTEGER,
title TEXT,
completed INTEGER DEFAULT 0,
FOREIGN KEY(userId) REFERENCES users(id)
);
`);
}
if (require.main === module) {
try {
migrate();
console.log('[DB] Migration complete.');
} catch (error) {
console.error('[DB] Migration failed:', error.message);
process.exit(1);
}
}
module.exports = { migrate };