Query

database.sqlite — test_case_execution

SQL

CREATE TABLE "test_case_execution"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "testRunId" varchar(36) NOT NULL,
  "pastExecutionId" integer,
  "executionId" integer,
  "evaluationExecutionId" integer,
  "status" varchar NOT NULL,
  "runAt" datetime(3),
  "completedAt" datetime(3),
  "errorCode" varchar,
  "errorDetails" text,
  "metrics" text,
  "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  "inputs" text,
  "outputs" text,
  "runIndex" INTEGER DEFAULT NULL,
  CONSTRAINT "FK_dfbe194e3ebdfe49a87bc4692ca" FOREIGN KEY ("evaluationExecutionId") REFERENCES "execution_entity" ("id") ON DELETE SET NULL ON UPDATE NO ACTION,
  CONSTRAINT "FK_e48965fac35d0f5b9e7f51d8c44" FOREIGN KEY ("executionId") REFERENCES "execution_entity" ("id") ON DELETE SET NULL ON UPDATE NO ACTION,
  CONSTRAINT "FK_258d954733841d51edd826a562b" FOREIGN KEY ("pastExecutionId") REFERENCES "execution_entity" ("id") ON DELETE SET NULL ON UPDATE NO ACTION,
  CONSTRAINT "FK_8e4b4774db42f1e6dda3452b2af" FOREIGN KEY ("testRunId") REFERENCES "test_run" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
testRunId varchar(36) Rename | Drop
pastExecutionId INTEGER ✓ Rename | Drop
executionId INTEGER ✓ Rename | Drop
evaluationExecutionId INTEGER ✓ Rename | Drop
status varchar Rename | Drop
runAt datetime(3) ✓ Rename | Drop
completedAt datetime(3) ✓ Rename | Drop
errorCode varchar ✓ Rename | Drop
errorDetails TEXT ✓ Rename | Drop
metrics TEXT ✓ Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop
inputs TEXT ✓ Rename | Drop
outputs TEXT ✓ Rename | Drop
runIndex INTEGER ✓ Rename | Drop

Foreign Keys

Column Destination
testRunId test_run.id
pastExecutionId execution_entity.id
executionId execution_entity.id
evaluationExecutionId execution_entity.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_8e4b4774db42f1e6dda3452b2a testRunId SQL 
CREATE INDEX "IDX_8e4b4774db42f1e6dda3452b2a"
ON "test_case_execution" ("testRunId")
Drop
sqlite_autoindex_test_case_execution_1 id ✓ SQL
-- no sql found --
 Drop