rk_ozon.yaml

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)