| code_notebook_sql_cell_migratable_state |
transition_result |
TEXT |
/console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_state&stats=yes |
[Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_state&stats=yes) |
[code_notebook_sql_cell_migratable_state (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_state&stats=yes) |
/console/content/view/code_notebook_sql_cell_migratable_state.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_state.sql?stats=yes) |
[code_notebook_sql_cell_migratable_state (view) Content](console/content/view/code_notebook_sql_cell_migratable_state.sql?stats=yes) |
CREATE VIEW "code_notebook_sql_cell_migratable_state" AS
-- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts)
-- All cells that are candidates for migration (latest only)
SELECT
c.*, -- All columns from the code_notebook_sql_cell_migratable view
s.from_state, -- The state the cell transitioned from
s.to_state, -- The state the cell transitioned to
s.transition_reason, -- The reason for the state transition
s.transition_result, -- The result of the state transition
s.transitioned_at -- The timestamp of the state transition
FROM
code_notebook_sql_cell_migratable c
JOIN
code_notebook_state s
ON c.code_notebook_cell_id = s.code_notebook_cell_id
ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_state |
transitioned_at |
TIMESTAMPTZ |
/console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_state&stats=yes |
[Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_state&stats=yes) |
[code_notebook_sql_cell_migratable_state (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_state&stats=yes) |
/console/content/view/code_notebook_sql_cell_migratable_state.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_state.sql?stats=yes) |
[code_notebook_sql_cell_migratable_state (view) Content](console/content/view/code_notebook_sql_cell_migratable_state.sql?stats=yes) |
CREATE VIEW "code_notebook_sql_cell_migratable_state" AS
-- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts)
-- All cells that are candidates for migration (latest only)
SELECT
c.*, -- All columns from the code_notebook_sql_cell_migratable view
s.from_state, -- The state the cell transitioned from
s.to_state, -- The state the cell transitioned to
s.transition_reason, -- The reason for the state transition
s.transition_result, -- The result of the state transition
s.transitioned_at -- The timestamp of the state transition
FROM
code_notebook_sql_cell_migratable c
JOIN
code_notebook_state s
ON c.code_notebook_cell_id = s.code_notebook_cell_id
ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed |
code_notebook_cell_id |
VARCHAR |
/console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes |
[Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS
-- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts)
-- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table)
SELECT c.*
FROM code_notebook_sql_cell_migratable c
LEFT JOIN code_notebook_state s
ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED'
WHERE s.code_notebook_cell_id IS NULL
ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed |
notebook_kernel_id |
VARCHAR |
/console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes |
[Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS
-- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts)
-- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table)
SELECT c.*
FROM code_notebook_sql_cell_migratable c
LEFT JOIN code_notebook_state s
ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED'
WHERE s.code_notebook_cell_id IS NULL
ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed |
notebook_name |
TEXT |
/console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes |
[Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS
-- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts)
-- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table)
SELECT c.*
FROM code_notebook_sql_cell_migratable c
LEFT JOIN code_notebook_state s
ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED'
WHERE s.code_notebook_cell_id IS NULL
ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed |
cell_name |
TEXT |
/console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes |
[Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS
-- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts)
-- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table)
SELECT c.*
FROM code_notebook_sql_cell_migratable c
LEFT JOIN code_notebook_state s
ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED'
WHERE s.code_notebook_cell_id IS NULL
ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed |
interpretable_code |
TEXT |
/console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes |
[Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS
-- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts)
-- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table)
SELECT c.*
FROM code_notebook_sql_cell_migratable c
LEFT JOIN code_notebook_state s
ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED'
WHERE s.code_notebook_cell_id IS NULL
ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed |
interpretable_code_hash |
TEXT |
/console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes |
[Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS
-- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts)
-- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table)
SELECT c.*
FROM code_notebook_sql_cell_migratable c
LEFT JOIN code_notebook_state s
ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED'
WHERE s.code_notebook_cell_id IS NULL
ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed |
description |
TEXT |
/console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes |
[Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS
-- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts)
-- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table)
SELECT c.*
FROM code_notebook_sql_cell_migratable c
LEFT JOIN code_notebook_state s
ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED'
WHERE s.code_notebook_cell_id IS NULL
ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed |
cell_governance |
TEXT |
/console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes |
[Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS
-- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts)
-- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table)
SELECT c.*
FROM code_notebook_sql_cell_migratable c
LEFT JOIN code_notebook_state s
ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED'
WHERE s.code_notebook_cell_id IS NULL
ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed |
arguments |
TEXT |
/console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes |
[Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS
-- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts)
-- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table)
SELECT c.*
FROM code_notebook_sql_cell_migratable c
LEFT JOIN code_notebook_state s
ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED'
WHERE s.code_notebook_cell_id IS NULL
ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed |
activity_log |
TEXT |
/console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes |
[Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS
-- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts)
-- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table)
SELECT c.*
FROM code_notebook_sql_cell_migratable c
LEFT JOIN code_notebook_state s
ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED'
WHERE s.code_notebook_cell_id IS NULL
ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed |
version_timestamp |
|
/console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes |
[Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS
-- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts)
-- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table)
SELECT c.*
FROM code_notebook_sql_cell_migratable c
LEFT JOIN code_notebook_state s
ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED'
WHERE s.code_notebook_cell_id IS NULL
ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed |
is_idempotent |
|
/console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes |
[Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) |
/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
[code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) |
CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS
-- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts)
-- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table)
SELECT c.*
FROM code_notebook_sql_cell_migratable c
LEFT JOIN code_notebook_state s
ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED'
WHERE s.code_notebook_cell_id IS NULL
ORDER BY c.cell_name |
| code_notebook_migration_sql |
migration_sql |
|
/console/info-schema/view.sql?name=code_notebook_migration_sql&stats=yes |
[Content](console/info-schema/view.sql?name=code_notebook_migration_sql&stats=yes) |
[code_notebook_migration_sql (view) Schema](console/info-schema/view.sql?name=code_notebook_migration_sql&stats=yes) |
/console/content/view/code_notebook_migration_sql.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/code_notebook_migration_sql.sql?stats=yes) |
[code_notebook_migration_sql (view) Content](console/content/view/code_notebook_migration_sql.sql?stats=yes) |
CREATE VIEW "code_notebook_migration_sql" AS
-- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts)
-- Creates a dynamic migration script by concatenating all interpretable_code for cells that should be migrated.
-- Excludes cells with names containing '_once_' if they have already been executed.
-- Includes comments before each block and special comments for excluded cells.
-- Wraps everything in a single transaction
SELECT
'BEGIN TRANSACTION;
'||
'CREATE TEMP TABLE IF NOT EXISTS "session_state_ephemeral" (
"key" TEXT PRIMARY KEY NOT NULL,
"value" TEXT NOT NULL
);
' ||
GROUP_CONCAT(
CASE
-- Case 1: Non-idempotent and already executed
WHEN c.is_idempotent = FALSE AND s.code_notebook_cell_id IS NOT NULL THEN
'-- ' || c.notebook_name || '.' || c.cell_name || ' not included because it is non-idempotent and was already executed on ' || s.transitioned_at || '
'
-- Case 2: Idempotent and not yet executed, idempotent and being reapplied, or non-idempotent and being run for the first time
ELSE
'-- ' || c.notebook_name || '.' || c.cell_name || '
' ||
CASE
-- First execution (non-idempotent or idempotent)
WHEN s.code_notebook_cell_id IS NULL THEN
'-- Executing for the first time.
'
-- Reapplying execution (idempotent)
ELSE
'-- Reapplying execution. Last executed on ' || s.transitioned_at || '
'
END ||
c.interpretable_code || '
' ||
'INSERT INTO code_notebook_state (code_notebook_state_id, code_notebook_cell_id, from_state, to_state, transition_reason, created_at) ' ||
'VALUES (' ||
'''' || c.code_notebook_cell_id || '__' || strftime('%Y%m%d%H%M%S', 'now') || '''' || ', ' ||
'''' || c.code_notebook_cell_id || '''' || ', ' ||
'''MIGRATION_CANDIDATE''' || ', ' ||
'''EXECUTED''' || ', ' ||
CASE
WHEN s.code_notebook_cell_id IS NULL THEN '''Migration'''
ELSE '''Reapplication'''
END || ', ' ||
'CURRENT_TIMESTAMP' || ')' || '
' ||
'ON CONFLICT(code_notebook_cell_id, from_state, to_state) DO UPDATE SET updated_at = CURRENT_TIMESTAMP, ' ||
'transition_reason = ''Reapplied ' || datetime('now', 'localtime') || ''';' || '
'
END,
'
'
) || '
COMMIT;' AS migration_sql
FROM
code_notebook_sql_cell_migratable c
LEFT JOIN
code_notebook_state s
ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED'
ORDER BY
c.cell_name |
| plm_graph |
graph_name |
VARCHAR |
/console/info-schema/view.sql?name=plm_graph&stats=yes |
[Content](console/info-schema/view.sql?name=plm_graph&stats=yes) |
[plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) |
/console/content/view/plm_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) |
[plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) |
CREATE VIEW "plm_graph" AS
SELECT
ure.graph_name,
ure.nature,
ur.uniform_resource_id,
ur.uri,
ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id,
ur_ingest_plm.issue_id,
ur_ingest_plm.ur_ingest_session_plm_acct_project_id as project_id,
ur_ingest_plm.title,
ur_ingest_plm.body
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_plm_acct_project_issue ur_ingest_plm ON ure.node_id = ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id
WHERE
ure.graph_name = 'plm' |
| plm_graph |
nature |
TEXT |
/console/info-schema/view.sql?name=plm_graph&stats=yes |
[Content](console/info-schema/view.sql?name=plm_graph&stats=yes) |
[plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) |
/console/content/view/plm_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) |
[plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) |
CREATE VIEW "plm_graph" AS
SELECT
ure.graph_name,
ure.nature,
ur.uniform_resource_id,
ur.uri,
ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id,
ur_ingest_plm.issue_id,
ur_ingest_plm.ur_ingest_session_plm_acct_project_id as project_id,
ur_ingest_plm.title,
ur_ingest_plm.body
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_plm_acct_project_issue ur_ingest_plm ON ure.node_id = ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id
WHERE
ure.graph_name = 'plm' |
| plm_graph |
uniform_resource_id |
VARCHAR |
/console/info-schema/view.sql?name=plm_graph&stats=yes |
[Content](console/info-schema/view.sql?name=plm_graph&stats=yes) |
[plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) |
/console/content/view/plm_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) |
[plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) |
CREATE VIEW "plm_graph" AS
SELECT
ure.graph_name,
ure.nature,
ur.uniform_resource_id,
ur.uri,
ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id,
ur_ingest_plm.issue_id,
ur_ingest_plm.ur_ingest_session_plm_acct_project_id as project_id,
ur_ingest_plm.title,
ur_ingest_plm.body
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_plm_acct_project_issue ur_ingest_plm ON ure.node_id = ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id
WHERE
ure.graph_name = 'plm' |
| plm_graph |
uri |
TEXT |
/console/info-schema/view.sql?name=plm_graph&stats=yes |
[Content](console/info-schema/view.sql?name=plm_graph&stats=yes) |
[plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) |
/console/content/view/plm_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) |
[plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) |
CREATE VIEW "plm_graph" AS
SELECT
ure.graph_name,
ure.nature,
ur.uniform_resource_id,
ur.uri,
ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id,
ur_ingest_plm.issue_id,
ur_ingest_plm.ur_ingest_session_plm_acct_project_id as project_id,
ur_ingest_plm.title,
ur_ingest_plm.body
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_plm_acct_project_issue ur_ingest_plm ON ure.node_id = ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id
WHERE
ure.graph_name = 'plm' |
| plm_graph |
ur_ingest_session_plm_acct_project_issue_id |
VARCHAR |
/console/info-schema/view.sql?name=plm_graph&stats=yes |
[Content](console/info-schema/view.sql?name=plm_graph&stats=yes) |
[plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) |
/console/content/view/plm_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) |
[plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) |
CREATE VIEW "plm_graph" AS
SELECT
ure.graph_name,
ure.nature,
ur.uniform_resource_id,
ur.uri,
ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id,
ur_ingest_plm.issue_id,
ur_ingest_plm.ur_ingest_session_plm_acct_project_id as project_id,
ur_ingest_plm.title,
ur_ingest_plm.body
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_plm_acct_project_issue ur_ingest_plm ON ure.node_id = ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id
WHERE
ure.graph_name = 'plm' |
| plm_graph |
issue_id |
TEXT |
/console/info-schema/view.sql?name=plm_graph&stats=yes |
[Content](console/info-schema/view.sql?name=plm_graph&stats=yes) |
[plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) |
/console/content/view/plm_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) |
[plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) |
CREATE VIEW "plm_graph" AS
SELECT
ure.graph_name,
ure.nature,
ur.uniform_resource_id,
ur.uri,
ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id,
ur_ingest_plm.issue_id,
ur_ingest_plm.ur_ingest_session_plm_acct_project_id as project_id,
ur_ingest_plm.title,
ur_ingest_plm.body
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_plm_acct_project_issue ur_ingest_plm ON ure.node_id = ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id
WHERE
ure.graph_name = 'plm' |
| plm_graph |
project_id |
VARCHAR |
/console/info-schema/view.sql?name=plm_graph&stats=yes |
[Content](console/info-schema/view.sql?name=plm_graph&stats=yes) |
[plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) |
/console/content/view/plm_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) |
[plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) |
CREATE VIEW "plm_graph" AS
SELECT
ure.graph_name,
ure.nature,
ur.uniform_resource_id,
ur.uri,
ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id,
ur_ingest_plm.issue_id,
ur_ingest_plm.ur_ingest_session_plm_acct_project_id as project_id,
ur_ingest_plm.title,
ur_ingest_plm.body
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_plm_acct_project_issue ur_ingest_plm ON ure.node_id = ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id
WHERE
ure.graph_name = 'plm' |
| plm_graph |
title |
TEXT |
/console/info-schema/view.sql?name=plm_graph&stats=yes |
[Content](console/info-schema/view.sql?name=plm_graph&stats=yes) |
[plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) |
/console/content/view/plm_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) |
[plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) |
CREATE VIEW "plm_graph" AS
SELECT
ure.graph_name,
ure.nature,
ur.uniform_resource_id,
ur.uri,
ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id,
ur_ingest_plm.issue_id,
ur_ingest_plm.ur_ingest_session_plm_acct_project_id as project_id,
ur_ingest_plm.title,
ur_ingest_plm.body
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_plm_acct_project_issue ur_ingest_plm ON ure.node_id = ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id
WHERE
ure.graph_name = 'plm' |
| plm_graph |
body |
TEXT |
/console/info-schema/view.sql?name=plm_graph&stats=yes |
[Content](console/info-schema/view.sql?name=plm_graph&stats=yes) |
[plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) |
/console/content/view/plm_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) |
[plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) |
CREATE VIEW "plm_graph" AS
SELECT
ure.graph_name,
ure.nature,
ur.uniform_resource_id,
ur.uri,
ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id,
ur_ingest_plm.issue_id,
ur_ingest_plm.ur_ingest_session_plm_acct_project_id as project_id,
ur_ingest_plm.title,
ur_ingest_plm.body
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_plm_acct_project_issue ur_ingest_plm ON ure.node_id = ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id
WHERE
ure.graph_name = 'plm' |
| imap_graph |
graph_name |
VARCHAR |
/console/info-schema/view.sql?name=imap_graph&stats=yes |
[Content](console/info-schema/view.sql?name=imap_graph&stats=yes) |
[imap_graph (view) Schema](console/info-schema/view.sql?name=imap_graph&stats=yes) |
/console/content/view/imap_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/imap_graph.sql?stats=yes) |
[imap_graph (view) Content](console/content/view/imap_graph.sql?stats=yes) |
CREATE VIEW "imap_graph" AS
SELECT
ure.graph_name,
ur.uniform_resource_id,
ur.nature,
ur.uri,
ur.content,
ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id,
ur_ingest_imap.ingest_imap_acct_folder_id,
ur_ingest_imap.message_id
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_imap_acct_folder_message ur_ingest_imap ON ure.node_id = ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id
WHERE
ure.graph_name = 'imap' |
| imap_graph |
uniform_resource_id |
VARCHAR |
/console/info-schema/view.sql?name=imap_graph&stats=yes |
[Content](console/info-schema/view.sql?name=imap_graph&stats=yes) |
[imap_graph (view) Schema](console/info-schema/view.sql?name=imap_graph&stats=yes) |
/console/content/view/imap_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/imap_graph.sql?stats=yes) |
[imap_graph (view) Content](console/content/view/imap_graph.sql?stats=yes) |
CREATE VIEW "imap_graph" AS
SELECT
ure.graph_name,
ur.uniform_resource_id,
ur.nature,
ur.uri,
ur.content,
ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id,
ur_ingest_imap.ingest_imap_acct_folder_id,
ur_ingest_imap.message_id
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_imap_acct_folder_message ur_ingest_imap ON ure.node_id = ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id
WHERE
ure.graph_name = 'imap' |
| imap_graph |
nature |
TEXT |
/console/info-schema/view.sql?name=imap_graph&stats=yes |
[Content](console/info-schema/view.sql?name=imap_graph&stats=yes) |
[imap_graph (view) Schema](console/info-schema/view.sql?name=imap_graph&stats=yes) |
/console/content/view/imap_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/imap_graph.sql?stats=yes) |
[imap_graph (view) Content](console/content/view/imap_graph.sql?stats=yes) |
CREATE VIEW "imap_graph" AS
SELECT
ure.graph_name,
ur.uniform_resource_id,
ur.nature,
ur.uri,
ur.content,
ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id,
ur_ingest_imap.ingest_imap_acct_folder_id,
ur_ingest_imap.message_id
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_imap_acct_folder_message ur_ingest_imap ON ure.node_id = ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id
WHERE
ure.graph_name = 'imap' |
| imap_graph |
uri |
TEXT |
/console/info-schema/view.sql?name=imap_graph&stats=yes |
[Content](console/info-schema/view.sql?name=imap_graph&stats=yes) |
[imap_graph (view) Schema](console/info-schema/view.sql?name=imap_graph&stats=yes) |
/console/content/view/imap_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/imap_graph.sql?stats=yes) |
[imap_graph (view) Content](console/content/view/imap_graph.sql?stats=yes) |
CREATE VIEW "imap_graph" AS
SELECT
ure.graph_name,
ur.uniform_resource_id,
ur.nature,
ur.uri,
ur.content,
ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id,
ur_ingest_imap.ingest_imap_acct_folder_id,
ur_ingest_imap.message_id
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_imap_acct_folder_message ur_ingest_imap ON ure.node_id = ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id
WHERE
ure.graph_name = 'imap' |
| imap_graph |
content |
BLOB |
/console/info-schema/view.sql?name=imap_graph&stats=yes |
[Content](console/info-schema/view.sql?name=imap_graph&stats=yes) |
[imap_graph (view) Schema](console/info-schema/view.sql?name=imap_graph&stats=yes) |
/console/content/view/imap_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/imap_graph.sql?stats=yes) |
[imap_graph (view) Content](console/content/view/imap_graph.sql?stats=yes) |
CREATE VIEW "imap_graph" AS
SELECT
ure.graph_name,
ur.uniform_resource_id,
ur.nature,
ur.uri,
ur.content,
ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id,
ur_ingest_imap.ingest_imap_acct_folder_id,
ur_ingest_imap.message_id
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_imap_acct_folder_message ur_ingest_imap ON ure.node_id = ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id
WHERE
ure.graph_name = 'imap' |
| imap_graph |
ur_ingest_session_imap_acct_folder_message_id |
VARCHAR |
/console/info-schema/view.sql?name=imap_graph&stats=yes |
[Content](console/info-schema/view.sql?name=imap_graph&stats=yes) |
[imap_graph (view) Schema](console/info-schema/view.sql?name=imap_graph&stats=yes) |
/console/content/view/imap_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/imap_graph.sql?stats=yes) |
[imap_graph (view) Content](console/content/view/imap_graph.sql?stats=yes) |
CREATE VIEW "imap_graph" AS
SELECT
ure.graph_name,
ur.uniform_resource_id,
ur.nature,
ur.uri,
ur.content,
ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id,
ur_ingest_imap.ingest_imap_acct_folder_id,
ur_ingest_imap.message_id
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_imap_acct_folder_message ur_ingest_imap ON ure.node_id = ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id
WHERE
ure.graph_name = 'imap' |
| imap_graph |
ingest_imap_acct_folder_id |
VARCHAR |
/console/info-schema/view.sql?name=imap_graph&stats=yes |
[Content](console/info-schema/view.sql?name=imap_graph&stats=yes) |
[imap_graph (view) Schema](console/info-schema/view.sql?name=imap_graph&stats=yes) |
/console/content/view/imap_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/imap_graph.sql?stats=yes) |
[imap_graph (view) Content](console/content/view/imap_graph.sql?stats=yes) |
CREATE VIEW "imap_graph" AS
SELECT
ure.graph_name,
ur.uniform_resource_id,
ur.nature,
ur.uri,
ur.content,
ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id,
ur_ingest_imap.ingest_imap_acct_folder_id,
ur_ingest_imap.message_id
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_imap_acct_folder_message ur_ingest_imap ON ure.node_id = ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id
WHERE
ure.graph_name = 'imap' |
| imap_graph |
message_id |
TEXT |
/console/info-schema/view.sql?name=imap_graph&stats=yes |
[Content](console/info-schema/view.sql?name=imap_graph&stats=yes) |
[imap_graph (view) Schema](console/info-schema/view.sql?name=imap_graph&stats=yes) |
/console/content/view/imap_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/imap_graph.sql?stats=yes) |
[imap_graph (view) Content](console/content/view/imap_graph.sql?stats=yes) |
CREATE VIEW "imap_graph" AS
SELECT
ure.graph_name,
ur.uniform_resource_id,
ur.nature,
ur.uri,
ur.content,
ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id,
ur_ingest_imap.ingest_imap_acct_folder_id,
ur_ingest_imap.message_id
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_imap_acct_folder_message ur_ingest_imap ON ure.node_id = ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id
WHERE
ure.graph_name = 'imap' |
| filesystem_graph |
graph_name |
VARCHAR |
/console/info-schema/view.sql?name=filesystem_graph&stats=yes |
[Content](console/info-schema/view.sql?name=filesystem_graph&stats=yes) |
[filesystem_graph (view) Schema](console/info-schema/view.sql?name=filesystem_graph&stats=yes) |
/console/content/view/filesystem_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/filesystem_graph.sql?stats=yes) |
[filesystem_graph (view) Content](console/content/view/filesystem_graph.sql?stats=yes) |
CREATE VIEW "filesystem_graph" AS
SELECT
ure.graph_name,
ur.uniform_resource_id,
ur.nature,
ur.uri,
ur_ingest_fs_path.ur_ingest_session_fs_path_id,
ur_ingest_fs_path.root_path
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_fs_path ur_ingest_fs_path ON ure.node_id = ur_ingest_fs_path.ur_ingest_session_fs_path_id
WHERE
ure.graph_name = 'filesystem' |
| filesystem_graph |
uniform_resource_id |
VARCHAR |
/console/info-schema/view.sql?name=filesystem_graph&stats=yes |
[Content](console/info-schema/view.sql?name=filesystem_graph&stats=yes) |
[filesystem_graph (view) Schema](console/info-schema/view.sql?name=filesystem_graph&stats=yes) |
/console/content/view/filesystem_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/filesystem_graph.sql?stats=yes) |
[filesystem_graph (view) Content](console/content/view/filesystem_graph.sql?stats=yes) |
CREATE VIEW "filesystem_graph" AS
SELECT
ure.graph_name,
ur.uniform_resource_id,
ur.nature,
ur.uri,
ur_ingest_fs_path.ur_ingest_session_fs_path_id,
ur_ingest_fs_path.root_path
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_fs_path ur_ingest_fs_path ON ure.node_id = ur_ingest_fs_path.ur_ingest_session_fs_path_id
WHERE
ure.graph_name = 'filesystem' |
| filesystem_graph |
nature |
TEXT |
/console/info-schema/view.sql?name=filesystem_graph&stats=yes |
[Content](console/info-schema/view.sql?name=filesystem_graph&stats=yes) |
[filesystem_graph (view) Schema](console/info-schema/view.sql?name=filesystem_graph&stats=yes) |
/console/content/view/filesystem_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/filesystem_graph.sql?stats=yes) |
[filesystem_graph (view) Content](console/content/view/filesystem_graph.sql?stats=yes) |
CREATE VIEW "filesystem_graph" AS
SELECT
ure.graph_name,
ur.uniform_resource_id,
ur.nature,
ur.uri,
ur_ingest_fs_path.ur_ingest_session_fs_path_id,
ur_ingest_fs_path.root_path
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_fs_path ur_ingest_fs_path ON ure.node_id = ur_ingest_fs_path.ur_ingest_session_fs_path_id
WHERE
ure.graph_name = 'filesystem' |
| filesystem_graph |
uri |
TEXT |
/console/info-schema/view.sql?name=filesystem_graph&stats=yes |
[Content](console/info-schema/view.sql?name=filesystem_graph&stats=yes) |
[filesystem_graph (view) Schema](console/info-schema/view.sql?name=filesystem_graph&stats=yes) |
/console/content/view/filesystem_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/filesystem_graph.sql?stats=yes) |
[filesystem_graph (view) Content](console/content/view/filesystem_graph.sql?stats=yes) |
CREATE VIEW "filesystem_graph" AS
SELECT
ure.graph_name,
ur.uniform_resource_id,
ur.nature,
ur.uri,
ur_ingest_fs_path.ur_ingest_session_fs_path_id,
ur_ingest_fs_path.root_path
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_fs_path ur_ingest_fs_path ON ure.node_id = ur_ingest_fs_path.ur_ingest_session_fs_path_id
WHERE
ure.graph_name = 'filesystem' |
| filesystem_graph |
ur_ingest_session_fs_path_id |
VARCHAR |
/console/info-schema/view.sql?name=filesystem_graph&stats=yes |
[Content](console/info-schema/view.sql?name=filesystem_graph&stats=yes) |
[filesystem_graph (view) Schema](console/info-schema/view.sql?name=filesystem_graph&stats=yes) |
/console/content/view/filesystem_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/filesystem_graph.sql?stats=yes) |
[filesystem_graph (view) Content](console/content/view/filesystem_graph.sql?stats=yes) |
CREATE VIEW "filesystem_graph" AS
SELECT
ure.graph_name,
ur.uniform_resource_id,
ur.nature,
ur.uri,
ur_ingest_fs_path.ur_ingest_session_fs_path_id,
ur_ingest_fs_path.root_path
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_fs_path ur_ingest_fs_path ON ure.node_id = ur_ingest_fs_path.ur_ingest_session_fs_path_id
WHERE
ure.graph_name = 'filesystem' |
| filesystem_graph |
root_path |
TEXT |
/console/info-schema/view.sql?name=filesystem_graph&stats=yes |
[Content](console/info-schema/view.sql?name=filesystem_graph&stats=yes) |
[filesystem_graph (view) Schema](console/info-schema/view.sql?name=filesystem_graph&stats=yes) |
/console/content/view/filesystem_graph.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/filesystem_graph.sql?stats=yes) |
[filesystem_graph (view) Content](console/content/view/filesystem_graph.sql?stats=yes) |
CREATE VIEW "filesystem_graph" AS
SELECT
ure.graph_name,
ur.uniform_resource_id,
ur.nature,
ur.uri,
ur_ingest_fs_path.ur_ingest_session_fs_path_id,
ur_ingest_fs_path.root_path
FROM
uniform_resource_edge ure
JOIN
uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
JOIN
ur_ingest_session_fs_path ur_ingest_fs_path ON ure.node_id = ur_ingest_fs_path.ur_ingest_session_fs_path_id
WHERE
ure.graph_name = 'filesystem' |
| threat_model |
id |
|
/console/info-schema/view.sql?name=threat_model&stats=yes |
[Content](console/info-schema/view.sql?name=threat_model&stats=yes) |
[threat_model (view) Schema](console/info-schema/view.sql?name=threat_model&stats=yes) |
/console/content/view/threat_model.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/threat_model.sql?stats=yes) |
[threat_model (view) Content](console/content/view/threat_model.sql?stats=yes) |
CREATE VIEW threat_model AS
WITH json_data AS (
SELECT
json_extract(threats.value, '$."a:Value"."b:Id"') AS "id",
json_extract(threats.value, '$."a:Value"."b:ChangedBy"') AS "changed_by",
json_extract(threats.value, '$."a:Value"."b:ModifiedAt"') AS "last_modified",
json_extract(threats.value, '$."a:Value"."b:State"') AS "state",
json_each.value AS kv_value
FROM
uniform_resource_transform,
json_each(json_extract(content, '$.ThreatModel.ThreatInstances."a:KeyValueOfstringThreatpc_P0_PhOB"')) AS threats,
json_each(json_extract(threats.value, '$."a:Value"."b:Properties"."a:KeyValueOfstringstring"'))
)
SELECT
id,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Title' THEN json_extract(kv_value, '$."a:Value"') END) AS "title",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatCategory' THEN json_extract(kv_value, '$."a:Value"') END) AS "category",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatShortDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "short_description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'InteractionString' THEN json_extract(kv_value, '$."a:Value"') END) AS "interaction",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Priority' THEN json_extract(kv_value, '$."a:Value"') END) AS "priority",
state,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'StateInformation' THEN json_extract(kv_value, '$."a:Value"') END) AS "justification",
"changed_by",
"last_modified"
FROM
json_data
GROUP BY
id, "changed_by", "last_modified", state |
| threat_model |
title |
|
/console/info-schema/view.sql?name=threat_model&stats=yes |
[Content](console/info-schema/view.sql?name=threat_model&stats=yes) |
[threat_model (view) Schema](console/info-schema/view.sql?name=threat_model&stats=yes) |
/console/content/view/threat_model.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/threat_model.sql?stats=yes) |
[threat_model (view) Content](console/content/view/threat_model.sql?stats=yes) |
CREATE VIEW threat_model AS
WITH json_data AS (
SELECT
json_extract(threats.value, '$."a:Value"."b:Id"') AS "id",
json_extract(threats.value, '$."a:Value"."b:ChangedBy"') AS "changed_by",
json_extract(threats.value, '$."a:Value"."b:ModifiedAt"') AS "last_modified",
json_extract(threats.value, '$."a:Value"."b:State"') AS "state",
json_each.value AS kv_value
FROM
uniform_resource_transform,
json_each(json_extract(content, '$.ThreatModel.ThreatInstances."a:KeyValueOfstringThreatpc_P0_PhOB"')) AS threats,
json_each(json_extract(threats.value, '$."a:Value"."b:Properties"."a:KeyValueOfstringstring"'))
)
SELECT
id,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Title' THEN json_extract(kv_value, '$."a:Value"') END) AS "title",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatCategory' THEN json_extract(kv_value, '$."a:Value"') END) AS "category",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatShortDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "short_description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'InteractionString' THEN json_extract(kv_value, '$."a:Value"') END) AS "interaction",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Priority' THEN json_extract(kv_value, '$."a:Value"') END) AS "priority",
state,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'StateInformation' THEN json_extract(kv_value, '$."a:Value"') END) AS "justification",
"changed_by",
"last_modified"
FROM
json_data
GROUP BY
id, "changed_by", "last_modified", state |
| threat_model |
category |
|
/console/info-schema/view.sql?name=threat_model&stats=yes |
[Content](console/info-schema/view.sql?name=threat_model&stats=yes) |
[threat_model (view) Schema](console/info-schema/view.sql?name=threat_model&stats=yes) |
/console/content/view/threat_model.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/threat_model.sql?stats=yes) |
[threat_model (view) Content](console/content/view/threat_model.sql?stats=yes) |
CREATE VIEW threat_model AS
WITH json_data AS (
SELECT
json_extract(threats.value, '$."a:Value"."b:Id"') AS "id",
json_extract(threats.value, '$."a:Value"."b:ChangedBy"') AS "changed_by",
json_extract(threats.value, '$."a:Value"."b:ModifiedAt"') AS "last_modified",
json_extract(threats.value, '$."a:Value"."b:State"') AS "state",
json_each.value AS kv_value
FROM
uniform_resource_transform,
json_each(json_extract(content, '$.ThreatModel.ThreatInstances."a:KeyValueOfstringThreatpc_P0_PhOB"')) AS threats,
json_each(json_extract(threats.value, '$."a:Value"."b:Properties"."a:KeyValueOfstringstring"'))
)
SELECT
id,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Title' THEN json_extract(kv_value, '$."a:Value"') END) AS "title",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatCategory' THEN json_extract(kv_value, '$."a:Value"') END) AS "category",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatShortDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "short_description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'InteractionString' THEN json_extract(kv_value, '$."a:Value"') END) AS "interaction",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Priority' THEN json_extract(kv_value, '$."a:Value"') END) AS "priority",
state,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'StateInformation' THEN json_extract(kv_value, '$."a:Value"') END) AS "justification",
"changed_by",
"last_modified"
FROM
json_data
GROUP BY
id, "changed_by", "last_modified", state |
| threat_model |
short_description |
|
/console/info-schema/view.sql?name=threat_model&stats=yes |
[Content](console/info-schema/view.sql?name=threat_model&stats=yes) |
[threat_model (view) Schema](console/info-schema/view.sql?name=threat_model&stats=yes) |
/console/content/view/threat_model.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/threat_model.sql?stats=yes) |
[threat_model (view) Content](console/content/view/threat_model.sql?stats=yes) |
CREATE VIEW threat_model AS
WITH json_data AS (
SELECT
json_extract(threats.value, '$."a:Value"."b:Id"') AS "id",
json_extract(threats.value, '$."a:Value"."b:ChangedBy"') AS "changed_by",
json_extract(threats.value, '$."a:Value"."b:ModifiedAt"') AS "last_modified",
json_extract(threats.value, '$."a:Value"."b:State"') AS "state",
json_each.value AS kv_value
FROM
uniform_resource_transform,
json_each(json_extract(content, '$.ThreatModel.ThreatInstances."a:KeyValueOfstringThreatpc_P0_PhOB"')) AS threats,
json_each(json_extract(threats.value, '$."a:Value"."b:Properties"."a:KeyValueOfstringstring"'))
)
SELECT
id,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Title' THEN json_extract(kv_value, '$."a:Value"') END) AS "title",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatCategory' THEN json_extract(kv_value, '$."a:Value"') END) AS "category",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatShortDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "short_description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'InteractionString' THEN json_extract(kv_value, '$."a:Value"') END) AS "interaction",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Priority' THEN json_extract(kv_value, '$."a:Value"') END) AS "priority",
state,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'StateInformation' THEN json_extract(kv_value, '$."a:Value"') END) AS "justification",
"changed_by",
"last_modified"
FROM
json_data
GROUP BY
id, "changed_by", "last_modified", state |
| threat_model |
description |
|
/console/info-schema/view.sql?name=threat_model&stats=yes |
[Content](console/info-schema/view.sql?name=threat_model&stats=yes) |
[threat_model (view) Schema](console/info-schema/view.sql?name=threat_model&stats=yes) |
/console/content/view/threat_model.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/threat_model.sql?stats=yes) |
[threat_model (view) Content](console/content/view/threat_model.sql?stats=yes) |
CREATE VIEW threat_model AS
WITH json_data AS (
SELECT
json_extract(threats.value, '$."a:Value"."b:Id"') AS "id",
json_extract(threats.value, '$."a:Value"."b:ChangedBy"') AS "changed_by",
json_extract(threats.value, '$."a:Value"."b:ModifiedAt"') AS "last_modified",
json_extract(threats.value, '$."a:Value"."b:State"') AS "state",
json_each.value AS kv_value
FROM
uniform_resource_transform,
json_each(json_extract(content, '$.ThreatModel.ThreatInstances."a:KeyValueOfstringThreatpc_P0_PhOB"')) AS threats,
json_each(json_extract(threats.value, '$."a:Value"."b:Properties"."a:KeyValueOfstringstring"'))
)
SELECT
id,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Title' THEN json_extract(kv_value, '$."a:Value"') END) AS "title",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatCategory' THEN json_extract(kv_value, '$."a:Value"') END) AS "category",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatShortDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "short_description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'InteractionString' THEN json_extract(kv_value, '$."a:Value"') END) AS "interaction",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Priority' THEN json_extract(kv_value, '$."a:Value"') END) AS "priority",
state,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'StateInformation' THEN json_extract(kv_value, '$."a:Value"') END) AS "justification",
"changed_by",
"last_modified"
FROM
json_data
GROUP BY
id, "changed_by", "last_modified", state |
| threat_model |
interaction |
|
/console/info-schema/view.sql?name=threat_model&stats=yes |
[Content](console/info-schema/view.sql?name=threat_model&stats=yes) |
[threat_model (view) Schema](console/info-schema/view.sql?name=threat_model&stats=yes) |
/console/content/view/threat_model.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/threat_model.sql?stats=yes) |
[threat_model (view) Content](console/content/view/threat_model.sql?stats=yes) |
CREATE VIEW threat_model AS
WITH json_data AS (
SELECT
json_extract(threats.value, '$."a:Value"."b:Id"') AS "id",
json_extract(threats.value, '$."a:Value"."b:ChangedBy"') AS "changed_by",
json_extract(threats.value, '$."a:Value"."b:ModifiedAt"') AS "last_modified",
json_extract(threats.value, '$."a:Value"."b:State"') AS "state",
json_each.value AS kv_value
FROM
uniform_resource_transform,
json_each(json_extract(content, '$.ThreatModel.ThreatInstances."a:KeyValueOfstringThreatpc_P0_PhOB"')) AS threats,
json_each(json_extract(threats.value, '$."a:Value"."b:Properties"."a:KeyValueOfstringstring"'))
)
SELECT
id,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Title' THEN json_extract(kv_value, '$."a:Value"') END) AS "title",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatCategory' THEN json_extract(kv_value, '$."a:Value"') END) AS "category",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatShortDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "short_description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'InteractionString' THEN json_extract(kv_value, '$."a:Value"') END) AS "interaction",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Priority' THEN json_extract(kv_value, '$."a:Value"') END) AS "priority",
state,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'StateInformation' THEN json_extract(kv_value, '$."a:Value"') END) AS "justification",
"changed_by",
"last_modified"
FROM
json_data
GROUP BY
id, "changed_by", "last_modified", state |
| threat_model |
priority |
|
/console/info-schema/view.sql?name=threat_model&stats=yes |
[Content](console/info-schema/view.sql?name=threat_model&stats=yes) |
[threat_model (view) Schema](console/info-schema/view.sql?name=threat_model&stats=yes) |
/console/content/view/threat_model.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/threat_model.sql?stats=yes) |
[threat_model (view) Content](console/content/view/threat_model.sql?stats=yes) |
CREATE VIEW threat_model AS
WITH json_data AS (
SELECT
json_extract(threats.value, '$."a:Value"."b:Id"') AS "id",
json_extract(threats.value, '$."a:Value"."b:ChangedBy"') AS "changed_by",
json_extract(threats.value, '$."a:Value"."b:ModifiedAt"') AS "last_modified",
json_extract(threats.value, '$."a:Value"."b:State"') AS "state",
json_each.value AS kv_value
FROM
uniform_resource_transform,
json_each(json_extract(content, '$.ThreatModel.ThreatInstances."a:KeyValueOfstringThreatpc_P0_PhOB"')) AS threats,
json_each(json_extract(threats.value, '$."a:Value"."b:Properties"."a:KeyValueOfstringstring"'))
)
SELECT
id,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Title' THEN json_extract(kv_value, '$."a:Value"') END) AS "title",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatCategory' THEN json_extract(kv_value, '$."a:Value"') END) AS "category",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatShortDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "short_description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'InteractionString' THEN json_extract(kv_value, '$."a:Value"') END) AS "interaction",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Priority' THEN json_extract(kv_value, '$."a:Value"') END) AS "priority",
state,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'StateInformation' THEN json_extract(kv_value, '$."a:Value"') END) AS "justification",
"changed_by",
"last_modified"
FROM
json_data
GROUP BY
id, "changed_by", "last_modified", state |
| threat_model |
state |
|
/console/info-schema/view.sql?name=threat_model&stats=yes |
[Content](console/info-schema/view.sql?name=threat_model&stats=yes) |
[threat_model (view) Schema](console/info-schema/view.sql?name=threat_model&stats=yes) |
/console/content/view/threat_model.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/threat_model.sql?stats=yes) |
[threat_model (view) Content](console/content/view/threat_model.sql?stats=yes) |
CREATE VIEW threat_model AS
WITH json_data AS (
SELECT
json_extract(threats.value, '$."a:Value"."b:Id"') AS "id",
json_extract(threats.value, '$."a:Value"."b:ChangedBy"') AS "changed_by",
json_extract(threats.value, '$."a:Value"."b:ModifiedAt"') AS "last_modified",
json_extract(threats.value, '$."a:Value"."b:State"') AS "state",
json_each.value AS kv_value
FROM
uniform_resource_transform,
json_each(json_extract(content, '$.ThreatModel.ThreatInstances."a:KeyValueOfstringThreatpc_P0_PhOB"')) AS threats,
json_each(json_extract(threats.value, '$."a:Value"."b:Properties"."a:KeyValueOfstringstring"'))
)
SELECT
id,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Title' THEN json_extract(kv_value, '$."a:Value"') END) AS "title",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatCategory' THEN json_extract(kv_value, '$."a:Value"') END) AS "category",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatShortDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "short_description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'InteractionString' THEN json_extract(kv_value, '$."a:Value"') END) AS "interaction",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Priority' THEN json_extract(kv_value, '$."a:Value"') END) AS "priority",
state,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'StateInformation' THEN json_extract(kv_value, '$."a:Value"') END) AS "justification",
"changed_by",
"last_modified"
FROM
json_data
GROUP BY
id, "changed_by", "last_modified", state |
| threat_model |
justification |
|
/console/info-schema/view.sql?name=threat_model&stats=yes |
[Content](console/info-schema/view.sql?name=threat_model&stats=yes) |
[threat_model (view) Schema](console/info-schema/view.sql?name=threat_model&stats=yes) |
/console/content/view/threat_model.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/threat_model.sql?stats=yes) |
[threat_model (view) Content](console/content/view/threat_model.sql?stats=yes) |
CREATE VIEW threat_model AS
WITH json_data AS (
SELECT
json_extract(threats.value, '$."a:Value"."b:Id"') AS "id",
json_extract(threats.value, '$."a:Value"."b:ChangedBy"') AS "changed_by",
json_extract(threats.value, '$."a:Value"."b:ModifiedAt"') AS "last_modified",
json_extract(threats.value, '$."a:Value"."b:State"') AS "state",
json_each.value AS kv_value
FROM
uniform_resource_transform,
json_each(json_extract(content, '$.ThreatModel.ThreatInstances."a:KeyValueOfstringThreatpc_P0_PhOB"')) AS threats,
json_each(json_extract(threats.value, '$."a:Value"."b:Properties"."a:KeyValueOfstringstring"'))
)
SELECT
id,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Title' THEN json_extract(kv_value, '$."a:Value"') END) AS "title",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatCategory' THEN json_extract(kv_value, '$."a:Value"') END) AS "category",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatShortDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "short_description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'InteractionString' THEN json_extract(kv_value, '$."a:Value"') END) AS "interaction",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Priority' THEN json_extract(kv_value, '$."a:Value"') END) AS "priority",
state,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'StateInformation' THEN json_extract(kv_value, '$."a:Value"') END) AS "justification",
"changed_by",
"last_modified"
FROM
json_data
GROUP BY
id, "changed_by", "last_modified", state |
| threat_model |
changed_by |
|
/console/info-schema/view.sql?name=threat_model&stats=yes |
[Content](console/info-schema/view.sql?name=threat_model&stats=yes) |
[threat_model (view) Schema](console/info-schema/view.sql?name=threat_model&stats=yes) |
/console/content/view/threat_model.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/threat_model.sql?stats=yes) |
[threat_model (view) Content](console/content/view/threat_model.sql?stats=yes) |
CREATE VIEW threat_model AS
WITH json_data AS (
SELECT
json_extract(threats.value, '$."a:Value"."b:Id"') AS "id",
json_extract(threats.value, '$."a:Value"."b:ChangedBy"') AS "changed_by",
json_extract(threats.value, '$."a:Value"."b:ModifiedAt"') AS "last_modified",
json_extract(threats.value, '$."a:Value"."b:State"') AS "state",
json_each.value AS kv_value
FROM
uniform_resource_transform,
json_each(json_extract(content, '$.ThreatModel.ThreatInstances."a:KeyValueOfstringThreatpc_P0_PhOB"')) AS threats,
json_each(json_extract(threats.value, '$."a:Value"."b:Properties"."a:KeyValueOfstringstring"'))
)
SELECT
id,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Title' THEN json_extract(kv_value, '$."a:Value"') END) AS "title",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatCategory' THEN json_extract(kv_value, '$."a:Value"') END) AS "category",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatShortDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "short_description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'InteractionString' THEN json_extract(kv_value, '$."a:Value"') END) AS "interaction",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Priority' THEN json_extract(kv_value, '$."a:Value"') END) AS "priority",
state,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'StateInformation' THEN json_extract(kv_value, '$."a:Value"') END) AS "justification",
"changed_by",
"last_modified"
FROM
json_data
GROUP BY
id, "changed_by", "last_modified", state |
| threat_model |
last_modified |
|
/console/info-schema/view.sql?name=threat_model&stats=yes |
[Content](console/info-schema/view.sql?name=threat_model&stats=yes) |
[threat_model (view) Schema](console/info-schema/view.sql?name=threat_model&stats=yes) |
/console/content/view/threat_model.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/threat_model.sql?stats=yes) |
[threat_model (view) Content](console/content/view/threat_model.sql?stats=yes) |
CREATE VIEW threat_model AS
WITH json_data AS (
SELECT
json_extract(threats.value, '$."a:Value"."b:Id"') AS "id",
json_extract(threats.value, '$."a:Value"."b:ChangedBy"') AS "changed_by",
json_extract(threats.value, '$."a:Value"."b:ModifiedAt"') AS "last_modified",
json_extract(threats.value, '$."a:Value"."b:State"') AS "state",
json_each.value AS kv_value
FROM
uniform_resource_transform,
json_each(json_extract(content, '$.ThreatModel.ThreatInstances."a:KeyValueOfstringThreatpc_P0_PhOB"')) AS threats,
json_each(json_extract(threats.value, '$."a:Value"."b:Properties"."a:KeyValueOfstringstring"'))
)
SELECT
id,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Title' THEN json_extract(kv_value, '$."a:Value"') END) AS "title",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatCategory' THEN json_extract(kv_value, '$."a:Value"') END) AS "category",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatShortDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "short_description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'UserThreatDescription' THEN json_extract(kv_value, '$."a:Value"') END) AS "description",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'InteractionString' THEN json_extract(kv_value, '$."a:Value"') END) AS "interaction",
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'Priority' THEN json_extract(kv_value, '$."a:Value"') END) AS "priority",
state,
MAX(CASE WHEN json_extract(kv_value, '$."a:Key"') = 'StateInformation' THEN json_extract(kv_value, '$."a:Value"') END) AS "justification",
"changed_by",
"last_modified"
FROM
json_data
GROUP BY
id, "changed_by", "last_modified", state |
| web_application |
Title |
|
/console/info-schema/view.sql?name=web_application&stats=yes |
[Content](console/info-schema/view.sql?name=web_application&stats=yes) |
[web_application (view) Schema](console/info-schema/view.sql?name=web_application&stats=yes) |
/console/content/view/web_application.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/web_application.sql?stats=yes) |
[web_application (view) Content](console/content/view/web_application.sql?stats=yes) |
CREATE VIEW web_application AS
SELECT DISTINCT
json_extract(border.value, '$."a:Value".Properties."a:anyType"[1]."b:Value"."#text"') AS Title
FROM
uniform_resource_transform,
json_each(
CASE
WHEN json_type(json_extract(content, '$.ThreatModel.DrawingSurfaceList.DrawingSurfaceModel')) = 'array'
THEN json_extract(content, '$.ThreatModel.DrawingSurfaceList.DrawingSurfaceModel')
ELSE json_array(json_extract(content, '$.ThreatModel.DrawingSurfaceList.DrawingSurfaceModel'))
END
) AS drawing_surface,
json_each(
json_extract(drawing_surface.value, '$.Borders."a:KeyValueOfguidanyType"')
) AS border
WHERE json_extract(border.value, '$."a:Value"."@i:type"') = 'StencilEllipse'
AND json_extract(border.value, '$."a:Value".Properties."a:anyType"[0]."b:DisplayName"') = 'Web Application' |