RfwmDR68

1const path = require('path')
2const sqlite = require('sqlite') // eslint-disable-line func-call-spacing
3
4(async function () { // eslint-disable-line no-unexpected-multiline
5  console.log('Creating database')
6  const db = await sqlite.open(path.join(__dirname, 'database.sqlite3'))
7  console.log('Creating database tables')
8  // setup the necessary tables
9  db.exec(`
10  CREATE TABLE IF NOT EXISTS "playlists" (
11    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
12    "guild" INTEGER,
13    "author" TEXT,
14    "author_id" INTEGER,
15    "name" TEXT,
16    FOREIGN KEY("guild") REFERENCES "playlists"("guild")
17  );
18  CREATE TABLE IF NOT EXISTS "playlist_song"(
19    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
20    "music_playlist_id" INTEGER NOT NULL,
21    "provider" TEXT,
22    "query" TEXT,
23    "title" TEXT,
24    "uri" TEXT,
25    FOREIGN KEY("id") REFERENCES "playlist_song"("music_playlist_id")
26  );`)
27  console.log('Tables created, closing database.')
28  db.close()
29})()