""" This file is auto-generated by res/schema/embed.py - DO NOT MODIFY THIS FILE MANUALLY """

CURRENT_SCHEMA = """BEGIN;

PRAGMA user_version = 4;

CREATE TABLE IF NOT EXISTS execution (
  id            INTEGER PRIMARY KEY NOT NULL,
  context       VARCHAR(36)         NOT NULL UNIQUE,
  stamp         TIMESTAMP           NOT NULL DEFAULT CURRENT_TIMESTAMP,
  configuration TEXT                         DEFAULT NULL,
  kind          VARCHAR(256)                 DEFAULT NULL
);

CREATE TABLE IF NOT EXISTS host (
  id       INTEGER PRIMARY KEY NOT NULL,
  context  VARCHAR(36)         NOT NULL REFERENCES execution (context),
  hostname VARCHAR(255)        NOT NULL,
  UNIQUE (context, hostname)
);

CREATE TABLE IF NOT EXISTS message_data (
  hash VARCHAR(64) PRIMARY KEY NOT NULL,
  data TEXT
);

CREATE TABLE IF NOT EXISTS data_source (
  id      INTEGER PRIMARY KEY NOT NULL,
  context VARCHAR(36)         NOT NULL REFERENCES execution (context),
  host_id INTEGER             NOT NULL REFERENCES host (id),
  actor   VARCHAR(1024)       NOT NULL DEFAULT '',
  phase   VARCHAR(1024)       NOT NULL DEFAULT '',
  UNIQUE (context, host_id, actor, phase)
);


CREATE TABLE IF NOT EXISTS message (
  id                INTEGER PRIMARY KEY NOT NULL,
  context           VARCHAR(36)         NOT NULL REFERENCES execution (context),
  stamp             TIMESTAMP           NOT NULL DEFAULT CURRENT_TIMESTAMP,
  topic             VARCHAR(1024)       NOT NULL,
  type              VARCHAR(1024)       NOT NULL,
  data_source_id    INTEGER             NOT NULL REFERENCES data_source (id),
  message_data_hash VARCHAR(64)         NOT NULL REFERENCES message_data (hash)
);

CREATE TABLE IF NOT EXISTS metadata (
  hash              VARCHAR(64) PRIMARY KEY NOT NULL,
  metadata          TEXT
);

CREATE TABLE IF NOT EXISTS actor_config (
  id                INTEGER PRIMARY KEY NOT NULL,
  context           VARCHAR(36)         NOT NULL REFERENCES execution (context),
  actor_config_hash VARCHAR(64)         NOT NULL REFERENCES actor_config_data (hash)
);

CREATE TABLE IF NOT EXISTS actor_config_data (
  hash    VARCHAR(64) PRIMARY KEY NOT NULL,
  config  TEXT
);

CREATE TABLE IF NOT EXISTS entity (
  id                INTEGER PRIMARY KEY NOT NULL,
  context           VARCHAR(36)         NOT NULL REFERENCES execution (context),
  kind              VARCHAR(256)        NOT NULL DEFAULT '',
  name              VARCHAR(1024)       NOT NULL DEFAULT '',
  metadata_hash     VARCHAR(64)         NOT NULL REFERENCES metadata (hash),
  UNIQUE (context, kind, name)
);

CREATE TABLE IF NOT EXISTS dialog (
  id                INTEGER PRIMARY KEY NOT NULL,
  context           VARCHAR(36)         NOT NULL REFERENCES execution (context),
  scope             VARCHAR(1024)       NOT NULL DEFAULT '',
  data              TEXT                         DEFAULT NULL,
  data_source_id    INTEGER             NOT NULL REFERENCES data_source (id)
);


CREATE TABLE IF NOT EXISTS audit (
  id             INTEGER PRIMARY KEY NOT NULL,
  event          VARCHAR(256)        NOT NULL REFERENCES execution (context),
  stamp          TIMESTAMP           NOT NULL DEFAULT CURRENT_TIMESTAMP,
  context        VARCHAR(36)         NOT NULL,
  data_source_id INTEGER             NOT NULL REFERENCES data_source (id),

  message_id     INTEGER                      DEFAULT NULL REFERENCES message (id),
  data           TEXT                         DEFAULT NULL
);

CREATE VIEW IF NOT EXISTS messages_data AS
  SELECT
    message.id        AS id,
    message.context   AS context,
    message.stamp     AS stamp,
    message.topic     AS topic,
    message.type      AS type,
    data_source.actor AS actor,
    data_source.phase AS phase,
    msg_data.hash     AS message_hash,
    msg_data.data     AS message_data,
    host.hostname     AS hostname
  FROM
    message
  JOIN
    data_source              ON data_source.id            = message.data_source_id,
    message_data AS msg_data ON message.message_data_hash = msg_data.hash,
    host                     ON host.id                   = data_source.host_id
;

COMMIT;
"""
"""Current schema of the leapp database"""

MIGRATIONS = [
    (0, """BEGIN;

ALTER TABLE message
  RENAME TO message_0;

CREATE TABLE message (
  id                INTEGER PRIMARY KEY NOT NULL,
  context           VARCHAR(36)         NOT NULL REFERENCES execution (context),
  stamp             TIMESTAMP           NOT NULL DEFAULT CURRENT_TIMESTAMP,
  topic             VARCHAR(1024)       NOT NULL,
  type              VARCHAR(1024)       NOT NULL,
  data_source_id    INTEGER             NOT NULL REFERENCES data_source (id),
  message_data_hash VARCHAR(64)         NOT NULL REFERENCES message_data (hash)
);

INSERT INTO message (id, context, stamp, topic, type, data_source_id, message_data_hash)
  SELECT
    id,
    context,
    stamp,
    channel,
    type,
    data_source_id,
    message_data_hash
  FROM message_0;

DROP TABLE message_0;
DROP VIEW messages_data;

CREATE VIEW IF NOT EXISTS messages_data AS
  SELECT
    message.id        AS id,
    message.context   AS context,
    message.stamp     AS stamp,
    message.topic     AS topic,
    message.type      as type,
    data_source.actor as actor,
    data_source.phase as phase,
    msg_data.hash     as message_hash,
    msg_data.data     as message_data,
    host.hostname     as hostname
  FROM
    message
    JOIN
    data_source ON data_source.id = message.data_source_id
    ,
    message_data as msg_data ON message.message_data_hash = msg_data.hash,
  host ON host.id = data_source.host_id;

PRAGMA user_version = 1;

COMMIT;"""),
    (1, """BEGIN;

ALTER TABLE execution
  ADD COLUMN kind VARCHAR(256) DEFAULT NULL;

PRAGMA user_version = 2;

COMMIT;"""),
    (2, """BEGIN;

CREATE TABLE IF NOT EXISTS metadata (
  hash VARCHAR(64) PRIMARY KEY NOT NULL,
  metadata TEXT
);

CREATE TABLE IF NOT EXISTS entity (
  id                INTEGER PRIMARY KEY NOT NULL,
  context           VARCHAR(36)         NOT NULL REFERENCES execution (context),
  kind              VARCHAR(256)        NOT NULL DEFAULT '',
  name              VARCHAR(1024)       NOT NULL DEFAULT '',
  metadata_hash     VARCHAR(64)         NOT NULL REFERENCES metadata (hash),
  UNIQUE (context, kind, name)
);

CREATE TABLE IF NOT EXISTS dialog (
  id                INTEGER PRIMARY KEY NOT NULL,
  context           VARCHAR(36)         NOT NULL REFERENCES execution (context),
  scope             VARCHAR(1024)       NOT NULL DEFAULT '',
  data              TEXT                         DEFAULT NULL,
  data_source_id    INTEGER             NOT NULL REFERENCES data_source (id)
);

PRAGMA user_version = 3;

COMMIT;
"""),
    (3, """BEGIN;

CREATE TABLE IF NOT EXISTS actor_config (
  id                INTEGER PRIMARY KEY NOT NULL,
  context           VARCHAR(36)         NOT NULL REFERENCES execution (context),
  actor_config_hash VARCHAR(64)         NOT NULL REFERENCES actor_config_data (hash)
);

CREATE TABLE IF NOT EXISTS actor_config_data (
  hash    VARCHAR(64) PRIMARY KEY NOT NULL,
  config  TEXT
);

PRAGMA user_version = 4;

COMMIT;
""")
]
"""Migrations for previous versions of the leapp database"""