console_information_schema_view (view) Content
| 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' |
| test_execution_log | test_case_id | /console/info-schema/view.sql?name=test_execution_log&stats=yes | [Content](console/info-schema/view.sql?name=test_execution_log&stats=yes) | [test_execution_log (view) Schema](console/info-schema/view.sql?name=test_execution_log&stats=yes) | /console/content/view/test_execution_log.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/test_execution_log.sql?stats=yes) | [test_execution_log (view) Content](console/content/view/test_execution_log.sql?stats=yes) | CREATE VIEW test_execution_log AS SELECT json_extract(content, '$.test_case_fii') AS test_case_id, json_extract(value, '$.step') AS step_number, json_extract(value, '$.stepname') AS step_name, json_extract(value, '$.status') AS step_status, strftime('%d-%m-%Y %H:%M:%S', json_extract(value, '$.start_time')) AS step_start_time, strftime('%d-%m-%Y %H:%M:%S', json_extract(value, '$.end_time')) AS step_end_time FROM uniform_resource, json_each(json_extract(content, '$.steps')) -- Expands the steps array into rows WHERE uri LIKE '%.result.json' | |
| test_execution_log | step_number | /console/info-schema/view.sql?name=test_execution_log&stats=yes | [Content](console/info-schema/view.sql?name=test_execution_log&stats=yes) | [test_execution_log (view) Schema](console/info-schema/view.sql?name=test_execution_log&stats=yes) | /console/content/view/test_execution_log.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/test_execution_log.sql?stats=yes) | [test_execution_log (view) Content](console/content/view/test_execution_log.sql?stats=yes) | CREATE VIEW test_execution_log AS SELECT json_extract(content, '$.test_case_fii') AS test_case_id, json_extract(value, '$.step') AS step_number, json_extract(value, '$.stepname') AS step_name, json_extract(value, '$.status') AS step_status, strftime('%d-%m-%Y %H:%M:%S', json_extract(value, '$.start_time')) AS step_start_time, strftime('%d-%m-%Y %H:%M:%S', json_extract(value, '$.end_time')) AS step_end_time FROM uniform_resource, json_each(json_extract(content, '$.steps')) -- Expands the steps array into rows WHERE uri LIKE '%.result.json' | |
| test_execution_log | step_name | /console/info-schema/view.sql?name=test_execution_log&stats=yes | [Content](console/info-schema/view.sql?name=test_execution_log&stats=yes) | [test_execution_log (view) Schema](console/info-schema/view.sql?name=test_execution_log&stats=yes) | /console/content/view/test_execution_log.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/test_execution_log.sql?stats=yes) | [test_execution_log (view) Content](console/content/view/test_execution_log.sql?stats=yes) | CREATE VIEW test_execution_log AS SELECT json_extract(content, '$.test_case_fii') AS test_case_id, json_extract(value, '$.step') AS step_number, json_extract(value, '$.stepname') AS step_name, json_extract(value, '$.status') AS step_status, strftime('%d-%m-%Y %H:%M:%S', json_extract(value, '$.start_time')) AS step_start_time, strftime('%d-%m-%Y %H:%M:%S', json_extract(value, '$.end_time')) AS step_end_time FROM uniform_resource, json_each(json_extract(content, '$.steps')) -- Expands the steps array into rows WHERE uri LIKE '%.result.json' | |
| test_execution_log | step_status | /console/info-schema/view.sql?name=test_execution_log&stats=yes | [Content](console/info-schema/view.sql?name=test_execution_log&stats=yes) | [test_execution_log (view) Schema](console/info-schema/view.sql?name=test_execution_log&stats=yes) | /console/content/view/test_execution_log.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/test_execution_log.sql?stats=yes) | [test_execution_log (view) Content](console/content/view/test_execution_log.sql?stats=yes) | CREATE VIEW test_execution_log AS SELECT json_extract(content, '$.test_case_fii') AS test_case_id, json_extract(value, '$.step') AS step_number, json_extract(value, '$.stepname') AS step_name, json_extract(value, '$.status') AS step_status, strftime('%d-%m-%Y %H:%M:%S', json_extract(value, '$.start_time')) AS step_start_time, strftime('%d-%m-%Y %H:%M:%S', json_extract(value, '$.end_time')) AS step_end_time FROM uniform_resource, json_each(json_extract(content, '$.steps')) -- Expands the steps array into rows WHERE uri LIKE '%.result.json' | |
| test_execution_log | step_start_time | /console/info-schema/view.sql?name=test_execution_log&stats=yes | [Content](console/info-schema/view.sql?name=test_execution_log&stats=yes) | [test_execution_log (view) Schema](console/info-schema/view.sql?name=test_execution_log&stats=yes) | /console/content/view/test_execution_log.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/test_execution_log.sql?stats=yes) | [test_execution_log (view) Content](console/content/view/test_execution_log.sql?stats=yes) | CREATE VIEW test_execution_log AS SELECT json_extract(content, '$.test_case_fii') AS test_case_id, json_extract(value, '$.step') AS step_number, json_extract(value, '$.stepname') AS step_name, json_extract(value, '$.status') AS step_status, strftime('%d-%m-%Y %H:%M:%S', json_extract(value, '$.start_time')) AS step_start_time, strftime('%d-%m-%Y %H:%M:%S', json_extract(value, '$.end_time')) AS step_end_time FROM uniform_resource, json_each(json_extract(content, '$.steps')) -- Expands the steps array into rows WHERE uri LIKE '%.result.json' | |
| test_execution_log | step_end_time | /console/info-schema/view.sql?name=test_execution_log&stats=yes | [Content](console/info-schema/view.sql?name=test_execution_log&stats=yes) | [test_execution_log (view) Schema](console/info-schema/view.sql?name=test_execution_log&stats=yes) | /console/content/view/test_execution_log.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/test_execution_log.sql?stats=yes) | [test_execution_log (view) Content](console/content/view/test_execution_log.sql?stats=yes) | CREATE VIEW test_execution_log AS SELECT json_extract(content, '$.test_case_fii') AS test_case_id, json_extract(value, '$.step') AS step_number, json_extract(value, '$.stepname') AS step_name, json_extract(value, '$.status') AS step_status, strftime('%d-%m-%Y %H:%M:%S', json_extract(value, '$.start_time')) AS step_start_time, strftime('%d-%m-%Y %H:%M:%S', json_extract(value, '$.end_time')) AS step_end_time FROM uniform_resource, json_each(json_extract(content, '$.steps')) -- Expands the steps array into rows WHERE uri LIKE '%.result.json' | |
| test_cases_run_status | group_name | BLOB | /console/info-schema/view.sql?name=test_cases_run_status&stats=yes | [Content](console/info-schema/view.sql?name=test_cases_run_status&stats=yes) | [test_cases_run_status (view) Schema](console/info-schema/view.sql?name=test_cases_run_status&stats=yes) | /console/content/view/test_cases_run_status.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/test_cases_run_status.sql?stats=yes) | [test_cases_run_status (view) Content](console/content/view/test_cases_run_status.sql?stats=yes) | CREATE VIEW test_cases_run_status AS SELECT g.name AS group_name, g.suite_id, g.id AS group_id, g.created_by, strftime('%d-%m-%Y', g.created_at) AS formatted_test_case_created_at, COUNT(tc.test_case_id) AS test_case_count, COUNT(p.test_case_id) AS success_status_count, (COUNT(tc.test_case_id)-COUNT(p.test_case_id)) AS failed_status_count FROM groups g LEFT JOIN test_cases tc ON g.id = tc.group_id LEFT JOIN test_case_run_results p on p.test_case_id=tc.test_case_id and status='passed' GROUP BY g.name, g.id |
| test_cases_run_status | suite_id | BLOB | /console/info-schema/view.sql?name=test_cases_run_status&stats=yes | [Content](console/info-schema/view.sql?name=test_cases_run_status&stats=yes) | [test_cases_run_status (view) Schema](console/info-schema/view.sql?name=test_cases_run_status&stats=yes) | /console/content/view/test_cases_run_status.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/test_cases_run_status.sql?stats=yes) | [test_cases_run_status (view) Content](console/content/view/test_cases_run_status.sql?stats=yes) | CREATE VIEW test_cases_run_status AS SELECT g.name AS group_name, g.suite_id, g.id AS group_id, g.created_by, strftime('%d-%m-%Y', g.created_at) AS formatted_test_case_created_at, COUNT(tc.test_case_id) AS test_case_count, COUNT(p.test_case_id) AS success_status_count, (COUNT(tc.test_case_id)-COUNT(p.test_case_id)) AS failed_status_count FROM groups g LEFT JOIN test_cases tc ON g.id = tc.group_id LEFT JOIN test_case_run_results p on p.test_case_id=tc.test_case_id and status='passed' GROUP BY g.name, g.id |
| test_cases_run_status | group_id | BLOB | /console/info-schema/view.sql?name=test_cases_run_status&stats=yes | [Content](console/info-schema/view.sql?name=test_cases_run_status&stats=yes) | [test_cases_run_status (view) Schema](console/info-schema/view.sql?name=test_cases_run_status&stats=yes) | /console/content/view/test_cases_run_status.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/test_cases_run_status.sql?stats=yes) | [test_cases_run_status (view) Content](console/content/view/test_cases_run_status.sql?stats=yes) | CREATE VIEW test_cases_run_status AS SELECT g.name AS group_name, g.suite_id, g.id AS group_id, g.created_by, strftime('%d-%m-%Y', g.created_at) AS formatted_test_case_created_at, COUNT(tc.test_case_id) AS test_case_count, COUNT(p.test_case_id) AS success_status_count, (COUNT(tc.test_case_id)-COUNT(p.test_case_id)) AS failed_status_count FROM groups g LEFT JOIN test_cases tc ON g.id = tc.group_id LEFT JOIN test_case_run_results p on p.test_case_id=tc.test_case_id and status='passed' GROUP BY g.name, g.id |
| test_cases_run_status | created_by | BLOB | /console/info-schema/view.sql?name=test_cases_run_status&stats=yes | [Content](console/info-schema/view.sql?name=test_cases_run_status&stats=yes) | [test_cases_run_status (view) Schema](console/info-schema/view.sql?name=test_cases_run_status&stats=yes) | /console/content/view/test_cases_run_status.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/test_cases_run_status.sql?stats=yes) | [test_cases_run_status (view) Content](console/content/view/test_cases_run_status.sql?stats=yes) | CREATE VIEW test_cases_run_status AS SELECT g.name AS group_name, g.suite_id, g.id AS group_id, g.created_by, strftime('%d-%m-%Y', g.created_at) AS formatted_test_case_created_at, COUNT(tc.test_case_id) AS test_case_count, COUNT(p.test_case_id) AS success_status_count, (COUNT(tc.test_case_id)-COUNT(p.test_case_id)) AS failed_status_count FROM groups g LEFT JOIN test_cases tc ON g.id = tc.group_id LEFT JOIN test_case_run_results p on p.test_case_id=tc.test_case_id and status='passed' GROUP BY g.name, g.id |
| test_cases_run_status | formatted_test_case_created_at | /console/info-schema/view.sql?name=test_cases_run_status&stats=yes | [Content](console/info-schema/view.sql?name=test_cases_run_status&stats=yes) | [test_cases_run_status (view) Schema](console/info-schema/view.sql?name=test_cases_run_status&stats=yes) | /console/content/view/test_cases_run_status.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/test_cases_run_status.sql?stats=yes) | [test_cases_run_status (view) Content](console/content/view/test_cases_run_status.sql?stats=yes) | CREATE VIEW test_cases_run_status AS SELECT g.name AS group_name, g.suite_id, g.id AS group_id, g.created_by, strftime('%d-%m-%Y', g.created_at) AS formatted_test_case_created_at, COUNT(tc.test_case_id) AS test_case_count, COUNT(p.test_case_id) AS success_status_count, (COUNT(tc.test_case_id)-COUNT(p.test_case_id)) AS failed_status_count FROM groups g LEFT JOIN test_cases tc ON g.id = tc.group_id LEFT JOIN test_case_run_results p on p.test_case_id=tc.test_case_id and status='passed' GROUP BY g.name, g.id | |
| test_cases_run_status | test_case_count | /console/info-schema/view.sql?name=test_cases_run_status&stats=yes | [Content](console/info-schema/view.sql?name=test_cases_run_status&stats=yes) | [test_cases_run_status (view) Schema](console/info-schema/view.sql?name=test_cases_run_status&stats=yes) | /console/content/view/test_cases_run_status.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/test_cases_run_status.sql?stats=yes) | [test_cases_run_status (view) Content](console/content/view/test_cases_run_status.sql?stats=yes) | CREATE VIEW test_cases_run_status AS SELECT g.name AS group_name, g.suite_id, g.id AS group_id, g.created_by, strftime('%d-%m-%Y', g.created_at) AS formatted_test_case_created_at, COUNT(tc.test_case_id) AS test_case_count, COUNT(p.test_case_id) AS success_status_count, (COUNT(tc.test_case_id)-COUNT(p.test_case_id)) AS failed_status_count FROM groups g LEFT JOIN test_cases tc ON g.id = tc.group_id LEFT JOIN test_case_run_results p on p.test_case_id=tc.test_case_id and status='passed' GROUP BY g.name, g.id |
Error We are sorry, but an error occurred while generating this page. You should contact the site's administrator.
Error in query number 6:
Parsing failed: SQLPage couldn't understand the SQL file. Please check for syntax errors:
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE ' END) || ' ' ||
⬆️
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
Backtrace
sql parser error: Expected: END, found: ' ||
' at Line: 42, Column: 149"console/content/view/console_information_schema_view.auto.sql" contains a syntax error preventing SQLPage from parsing and preparing its SQL statements.You can hide error messages like this one from your users by setting the 'environment' configuration option to 'production'.