Skip to content

Instantly share code, notes, and snippets.

@JosephMaxwell
Created April 18, 2018 14:09
Show Gist options
  • Save JosephMaxwell/cc3f1ba3f3636810ec1a3a689aeaed18 to your computer and use it in GitHub Desktop.
Save JosephMaxwell/cc3f1ba3f3636810ec1a3a689aeaed18 to your computer and use it in GitHub Desktop.
config.yaml
configuration:
compress-output: true
pipelines:
default:
- name: global-commands
actions:
- name: m2-clear-customers
sort: 50
- name: m2-clear-orders
sort: 60
- name: m2-clear-quotes
sort: 70
- name: m2-clear-reports
sort: 80
- name: m2-clear-common
sort: 90
- name: m2-clear-swiftotter
sort: 100
environments:
staging:
sort: 100
transformations:
core_config_data:
- "UPDATE {{table_name}} SET value = 'http://dev.swiftotter.com/' WHERE path LIKE 'web/%secure/base_url' AND scope_id = 0;"
local-init:
sort: 200
transformations:
admin_user:
- "DELETE FROM {{table_name}};"
- "ALTER TABLE {{table_name}} AUTO_INCREMENT = 1;"
- "INSERT INTO {{table_name}} (firstname, lastname, email, username, password) VALUES ('SwiftOtter', 'Studios', 'me@swiftotter.com', 'local_admin', CONCAT(SHA2('xxxxxxxxlocal_admin', 256), ':xxxxxxxx:1'));"
authorization_role:
- "INSERT INTO {{table_name}} (parent_id, tree_level, sort_order, role_type, user_id, user_type, role_name) VALUES ('1','2','0','U','1','2','local_admin');"
core_config_data:
- "UPDATE {{table_name}} SET value = 'https://lc.swiftotter.dev/' WHERE path LIKE 'web/%secure/base_url' AND scope_id = 0;"
local:
sort: 300
ignored_tables:
- setup_module
- customer_address_entity
- customer_address_entity_datetime
- customer_address_entity_decimal
- customer_address_entity_int
- customer_address_entity_text
- customer_address_entity_varchar
- customer_entity
- customer_entity_datetime
- customer_entity_decimal
- customer_entity_int
- customer_entity_text
- customer_entity_varchar
- sales_creditmemo
- sales_credimemo_comment
- sales_creditmemo_grid
- sales_creditmemo_item
- sales_invoice
- sales_invoice_comment
- sales_invoice_grid
- sales_invoice_item
- sales_order
- sales_order_address
- sales_order_grid
- sales_order_item
- sales_order_payment
- sales_order_status_history
- sales_shipment
- sales_shipment_comment
- sales_shipment_grid
- sales_shipment_item
- sales_shipment_track
- sales_invoiced_aggregated
- sales_invoiced_aggregated_order
- sales_payment_transaction
- sales_order_aggregated_created
- sales_order_tax
- sales_order_tax_item
- sales_quote
- sales_quote_address
- sales_quote_address_item
- sales_quote_item
- sales_quote_item_option
- sales_quote_payment
- sales_quote_shipping_rate
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment