const path = require('path')
const db_location = path.join(__dirname, 'gdurl.sqlite')
const db = require('better-sqlite3')(db_location)

db.pragma('journal_mode = WAL')

create_table_copied()
function create_table_copied () {
  const [exists] = db.prepare('PRAGMA table_info(copied)').all()
  if (exists) return
  const create_table = `CREATE TABLE "copied" (
  "taskid"  INTEGER,
  "fileid"  TEXT
)`
  db.prepare(create_table).run()
  const create_index = `CREATE INDEX "copied_taskid" ON "copied" ("taskid");`
  db.prepare(create_index).run()
}

create_table_bookmark()
function create_table_bookmark () {
  const [exists] = db.prepare('PRAGMA table_info(bookmark)').all()
  if (exists) return
  const create_table = `CREATE TABLE "bookmark" (
  "alias"  TEXT,
  "target"  TEXT
);`
  db.prepare(create_table).run()
  const create_index = `CREATE UNIQUE INDEX "bookmark_alias" ON "bookmark" (
  "alias"
);`
  db.prepare(create_index).run()
}

create_table_hash()
function create_table_hash () {
  const [exists] = db.prepare('PRAGMA table_info(hash)').all()
  if (exists) return
  const create_table = `CREATE TABLE "hash" (
  "md5" TEXT NOT NULL,
  "gid" TEXT NOT NULL UNIQUE,
  "status"  TEXT NOT NULL DEFAULT 'normal'
);`
  db.prepare(create_table).run()
  const create_index = 'CREATE INDEX "hash_md5" ON "hash" ("md5");'
  db.prepare(create_index).run()
  const create_index2 = 'CREATE INDEX "hash_gid" ON "hash" ("gid");'
  db.prepare(create_index2).run()
}

module.exports = { db }