code_notebook_sql_cell_migratable_version

Column Type
code_notebook_cell_id VARCHAR
notebook_name TEXT
cell_name TEXT
interpretable_code TEXT
interpretable_code_hash TEXT
is_idempotent
version_timestamp

SQL DDL

CREATE VIEW "code_notebook_sql_cell_migratable_version" AS
    -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts)
    -- All cells that are candidates for migration (including duplicates)
    SELECT c.code_notebook_cell_id,
          c.notebook_name,
          c.cell_name,
          c.interpretable_code,
          c.interpretable_code_hash,
          CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent,
          COALESCE(c.updated_at, c.created_at) version_timestamp
      FROM code_notebook_cell c
    WHERE c.notebook_name = 'ConstructionSqlNotebook'
    ORDER BY c.cell_name