7bf9e25ede
* feat: track workspace runnables used in flows * track script hash * weird * do it with lock * Revert "feat: add support for | None and Optional in python (#5361)" This reverts commit9736355d5f. * Revert "Revert "feat: add support for | None and Optional in python (#5361)"" This reverts commitbb8f709894. * update openapi * delete old in lock_modules + don't track hub scripts
13 lines
814 B
SQL
13 lines
814 B
SQL
CREATE TABLE flow_workspace_runnables (
|
|
flow_path VARCHAR(255) NOT NULL,
|
|
runnable_path VARCHAR(255) NOT NULL,
|
|
script_hash BIGINT NULL,
|
|
runnable_is_flow BOOLEAN NOT NULL,
|
|
workspace_id VARCHAR(50) NOT NULL,
|
|
FOREIGN KEY (workspace_id, flow_path) REFERENCES flow (workspace_id, path) ON DELETE CASCADE
|
|
);
|
|
|
|
CREATE UNIQUE INDEX flow_workspace_without_hash_unique_idx ON flow_workspace_runnables (flow_path, runnable_path, runnable_is_flow, workspace_id) WHERE script_hash IS NULL;
|
|
CREATE UNIQUE INDEX flow_workspace_with_hash_unique_idx ON flow_workspace_runnables (flow_path, runnable_path, script_hash, runnable_is_flow, workspace_id) WHERE script_hash IS NOT NULL;
|
|
CREATE INDEX flow_workspace_runnable_path_is_flow_idx ON flow_workspace_runnables (runnable_path, runnable_is_flow, workspace_id);
|