Spaces:
Sleeping
Sleeping
File size: 1,826 Bytes
96a886b f19b08d 96a886b bb750d6 96a886b bb750d6 96a886b bb750d6 4efee17 bb750d6 f19b08d 96a886b f19b08d bb750d6 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 | 'use strict';
/* v8 ignore next 3 */
if (require.main === module) {
const { loadEnv } = require('../load-env');
loadEnv();
}
const { getWrappedDb } = require('../database');
function migrate() {
console.log('[Migrate] Start migrating...');
try {
const db = getWrappedDb();
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)
);
`);
console.log('[Migrate] Migration complete.');
} catch (error) {
console.error('[Migrate] Migration failed:', error.message);
throw error;
}
}
/* v8 ignore next 3 */
if (require.main === module) {
migrate();
}
module.exports = { migrate };
|