Database Queries

Create val
app.get("/db/create", async (c) => {
  await sqlite.execute(`create table if not exists installations (
  uuid varchar(255) PRIMARY KEY not null,
  active boolean not null default 0,
  spotify_connected boolean not null default 0,
  name varchar(255) null,
  first_name varchar(255) null,
  last_name varchar(255) null,
  email varchar(255) null,
  locale varchar(255) null,
  time_zone_iana varchar(255) null,
  plugin_setting_id INTEGER null,
  trmnl_access_token varchar(255) null,
  preferences text not null,
  uninstalled_at datetime null,
  created_at datetime not null default CURRENT_TIMESTAMP,
  updated_at datetime not null default CURRENT_TIMESTAMP
)`);

  await sqlite.execute(`create table if not exists tokens (
  uuid varchar(255) PRIMARY KEY not null,
  access_token varchar(255) not null,
  expires_at integer not null,
  refresh_token varchar(255) not null,
  FOREIGN KEY (uuid) REFERENCES installations (uuid)
)`);

  return c.text("ok");
});