Created
December 21, 2018 14:13
-
-
Save woto/3ba5d837c1f68aee7284c3fb445dcca0 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
default: &default | |
truncate: true | |
sequence: true | |
root: | |
- <<: *default | |
table: schema_migrations | |
sql: SELECT * FROM schema_migrations | |
sequence: false | |
- <<: *default | |
table: users | |
sql: SELECT * FROM users | |
- <<: *default | |
table: user_params | |
sql: SELECT * FROM user_params | |
- <<: *default | |
table: extra_charges_configs | |
sql: SELECT * FROM extra_charges_configs | |
- <<: *default | |
table: extra_comission_configs | |
sql: SELECT * FROM extra_comission_configs | |
- <<: *default | |
table: affiliate_links | |
sql: SELECT * FROM affiliate_links where merchant_id IN (12027) LIMIT 1 | |
- <<: *default | |
table: transitions | |
sql: SELECT * FROM transitions where merchant_id IN (12027) LIMIT 1 | |
- <<: *default | |
table: commodities | |
sql: SELECT * FROM commodities where user_id IN (12027) WHERE article IN ('001', '*') | |
- <<: *default | |
table: orders | |
sql: SELECT * FROM orders where merchant_id IN (12027) | |
- <<: *default | |
table: service_acts | |
sql: SELECT * FROM service_acts | |
- <<: *default | |
table: sales | |
sql: SELECT * FROM sales where merchant_id IN (12027) | |
- <<: *default | |
table: import_jobs | |
sql: SELECT * FROM import_jobs where user_id IN (12027) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment