• Home
  • Line#
  • Scopes#
  • Navigate#
  • Raw
  • Download
1UP_SQL = """
2ALTER TABLE host_queue_entries ADD COLUMN started_on datetime NULL;
3ALTER TABLE jobs ADD COLUMN max_runtime_hrs integer NOT NULL;
4-- conservative value for existing jobs, to make sure they don't get
5-- unexpectedly timed out.
6UPDATE jobs SET max_runtime_hrs = timeout;
7"""
8
9DOWN_SQL = """
10ALTER TABLE jobs DROP COLUMN max_runtime_hrs;
11ALTER TABLE host_queue_entries DROP COLUMN started_on;
12"""
13