Skip to content

Instantly share code, notes, and snippets.

@andriimosin
Last active July 7, 2017 17:38
Show Gist options
  • Save andriimosin/7a5124cda868f4b1f09ad4e3878bde80 to your computer and use it in GitHub Desktop.
Save andriimosin/7a5124cda868f4b1f09ad4e3878bde80 to your computer and use it in GitHub Desktop.
UPDATE order_checkers_data SET headcount_check = jsonb_set(headcount_check, '{type}', '"turnoffable"'),
display_online_check = jsonb_set(display_online_check, '{type}', '"turnoffable"'),
never_again_check = jsonb_set(never_again_check, '{type}', '"test"'), confirmed_status_check = jsonb_set(confirmed_status_check, '{type}', '"permanent"'),
feedback_check = jsonb_set(feedback_check, '{type}', '"snoozeable"'),
has_location_check = jsonb_set(has_location_check, '{type}', '"permanent"'),
state_is_not_under_revision_check = jsonb_set(state_is_not_under_revision_check, '{type}', '"permanent"'),
run_time_check = jsonb_set(run_time_check, '{type}', '"snoozeable"'),
email_delivery_check = jsonb_set(email_delivery_check, '{type}', '"snoozeable"');
UPDATE menu_checkers_data SET allergens_check = jsonb_set(allergens_check, '{type}', '"turnoffable"'),
delivery_charge_check = jsonb_set(delivery_charge_check, '{type}', '"snoozeable"'),
entree_count_check = jsonb_set(entree_count_check, '{type}', '"turnoffable"'),
item_feedback_check = jsonb_set(item_feedback_check, '{type}', '"snoozeable"'),
old_items_check = jsonb_set(old_items_check, '{type}', '"snoozeable"'),
vendor_repeat_check = jsonb_set(vendor_repeat_check, '{type}', '"snoozeable"'),
vendor_availability_check = jsonb_set(vendor_availability_check, '{type}', '"snoozeable"'),
tax_charge_check = jsonb_set(tax_charge_check, '{type}', '"snoozeable"');
UPDATE schedule_checkers_data SET extra_order_scheduled_check = jsonb_set(extra_order_scheduled_check, '{type}', '"snoozeable"'),
client_unavailability_check = jsonb_set(client_unavailability_check, '{type}', '"snoozeable"'),
missing_order_check = jsonb_set(missing_order_check, '{type}', '"snoozeable"');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment