Spaces:
Sleeping
Sleeping
Download src/db/migrate.js from dangkhoa2016/Nodejs-JSON-API-Server: direct link, hf CLI and curl.
- Browser
- Download file 2.08 kB
-
https://huggingface.co/spaces/dangkhoa2016/Nodejs-JSON-API-Server/resolve/bd2e5f835de4d3a6f2ac80e2c030ecd1d1c99062/src/db/migrate.js
- Command line
-
hf download hf://spaces/dangkhoa2016/Nodejs-JSON-API-Server@bd2e5f835de4d3a6f2ac80e2c030ecd1d1c99062/src/db/migrate.js
-
curl -L -o migrate.js https://huggingface.co/spaces/dangkhoa2016/Nodejs-JSON-API-Server/resolve/bd2e5f835de4d3a6f2ac80e2c030ecd1d1c99062/src/db/migrate.js
2.08 kB
| ; | |
| /* 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 }; | |