Sha256: a808c4e75bf0cde34691e96ccfe7e906c5f48d3175024765da60f9432b61f6ee

Contents?: true

Size: 855 Bytes

Versions: 7

Compression:

Stored size: 855 Bytes

Contents

class AddTimeoutToPromiseView < ActiveRecord::Migration[4.2]
  def up
    execute <<~SQL
       DROP VIEW IF EXISTS marty_vw_promises;
       CREATE OR REPLACE VIEW marty_vw_promises
       AS
       SELECT
       id,
       title,
       user_id,
       cformat,
       parent_id,
       job_id,
       status,
       start_dt,
       end_dt,
       priority,
       timeout
       FROM marty_promises;

       GRANT SELECT ON marty_vw_promises TO public;
    SQL
  end

  def down
    execute <<~SQL
       DROP VIEW IF EXISTS marty_vw_promises;
       CREATE OR REPLACE VIEW marty_vw_promises
       AS
       SELECT
       id,
       title,
       user_id,
       cformat,
       parent_id,
       job_id,
       status,
       start_dt,
       end_dt
       FROM marty_promises;

       GRANT SELECT ON marty_vw_promises TO public;
    SQL
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version Path
marty-14.3.0 db/migrate/524_add_timeout_to_promise_view.rb
marty-14.0.0 db/migrate/524_add_timeout_to_promise_view.rb
marty-13.0.2 db/migrate/524_add_timeout_to_promise_view.rb
marty-11.0.0 db/migrate/524_add_timeout_to_promise_view.rb
marty-10.0.3 db/migrate/524_add_timeout_to_promise_view.rb
marty-10.0.2 db/migrate/524_add_timeout_to_promise_view.rb
marty-10.0.0 db/migrate/524_add_timeout_to_promise_view.rb