firstRun.js

import * as FileSystem from 'expo-file-system';
import * as Localization from 'expo-localization';
import {db, TRACK_DIR} from './styleConst';


const CREATE_TABLE = `
PRAGMA foreign_keys = ON;
CREATE TABLE IF NOT EXISTS Playlists (
  lst_name TEXT PRIMARY KEY,
);

CREATE TABLE IF NOT EXISTS Tracks (
  track_name TEXT PRIMARY KEY,
);

CREATE TABLE IF NOT EXISTS Linking (
  fk_lst_name TEXT,
  fk_track_name TEXT,
  PRIMARY KEY (fk_lst_name, fk_track_name),
  FOREIGN KEY (fk_lst_name)
    REFERENCES Playlists (lst_name)
    ON DELETE CASCADE,
  FOREIGN KEY (fk_track_name)
    REFERENCES Tracks (track_name)
    ON DELETE CASCADE
);
`

export async function first_run(){
  db.exec([{ sql: 'PRAGMA foreign_keys = ON;', args: [] }], false, () =>
    console.log('Foreign keys turned on')
  );

  db.transaction(tx => {
    tx.executeSql(
      `CREATE TABLE IF NOT EXISTS Playlists (
        lst_name TEXT PRIMARY KEY,
        date TEXT
      );`,
      null,
      (tx1) => console.log('create table success2'),
      (_, error) => console.log(error)
    );
    tx.executeSql(
      `CREATE TABLE IF NOT EXISTS Tracks (
        track_name TEXT PRIMARY KEY,
        date TEXT
      );`,
      null,
      (tx1) => console.log('create table success3'),
      (_, error) => console.log(error)
    );
    tx.executeSql(
      `CREATE TABLE IF NOT EXISTS Linking (
        fk_lst_name TEXT,
        fk_track_name TEXT,
        PRIMARY KEY (fk_lst_name, fk_track_name),
        FOREIGN KEY (fk_lst_name)
          REFERENCES Playlists (lst_name)
          ON DELETE CASCADE,
        FOREIGN KEY (fk_track_name)
          REFERENCES Tracks (track_name)
          ON DELETE CASCADE
      );`,
      null,
      (tx1) => console.log('create table success4'),
      (_, error) => console.log(error)
    );
  });
  console.log(Localization.locale);

  const dir_info = await FileSystem.getInfoAsync(TRACK_DIR);
  if (!dir_info.exists){
    FileSystem.makeDirectoryAsync(TRACK_DIR);
  }
}