File size: 2,081 Bytes
96a886b
 
f19b08d
96a886b
1f0f638
96a886b
 
1f0f638
96a886b
 
bb750d6
 
 
 
 
96a886b
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
7f0d072
 
 
 
 
 
 
 
96a886b
 
7f0d072
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
83
84
85
86
87
88
89
90
91
'use strict';

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

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)
    );

    CREATE TABLE IF NOT EXISTS settings (
      id          INTEGER PRIMARY KEY,
      key         TEXT NOT NULL UNIQUE,
      value       TEXT NOT NULL,
      description TEXT DEFAULT '',
      updated_at  TEXT DEFAULT ''
    );
  `);

    /* v8 ignore next 1 */
    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 };