Spaces:

Samad14
/

bio-nexus-api

Sleeping

bio-nexus-api / bioai-platform /supabase /migrations /007_add_pathway_enrichment_status.sql

fix: prevent opacity flicker on job results page, add pathway_enrichment migration

3cc87a8 4 months ago

365 Bytes

-- Add pathway_enrichment to the jobs.status CHECK constraint

ALTER TABLE jobs DROP CONSTRAINT IF EXISTS jobs_status_check;

ALTER TABLE jobs ADD CONSTRAINT jobs_status_check
  CHECK (status IN (
    'queued', 'running', 'complete', 'failed',
    'submitted_to_ncbi', 'polling_ncbi', 'parsing',
    'interpreting', 'pathway_enrichment', 'fetching_alphafold'
  ));

	-- Add pathway_enrichment to the jobs.status CHECK constraint

	ALTER TABLE jobs DROP CONSTRAINT IF EXISTS jobs_status_check;

	ALTER TABLE jobs ADD CONSTRAINT jobs_status_check
	CHECK (status IN (
	'queued', 'running', 'complete', 'failed',
	'submitted_to_ncbi', 'polling_ncbi', 'parsing',
	'interpreting', 'pathway_enrichment', 'fetching_alphafold'
	));