github.com/christoph-karpowicz/db_mediator@v0.0.0-20210207102849-61a28a1071d8/config/synch/example.yaml (about)

     1  name: example
     2  
     3  nodes:
     4      - 
     5          name        : dvdrental_films
     6          database    : dvdrental
     7          table       : film
     8          key         : film_id
     9      -
    10          name        : msamp_films
    11          database    : msamp
    12          table       : Sakila_films
    13          key         : _id
    14  
    15  map:
    16      - 'dvdrental_films.film_id TO msamp_films.ext_id'
    17      - 'dvdrental_films.title TO msamp_films.Title'
    18      - 'dvdrental_films.description TO msamp_films.Description'
    19      - 'dvdrental_films.rental_duration TO msamp_films."Rental Duration"'
    20      - 'dvdrental_films.length TO msamp_films.Length'
    21      - 'dvdrental_films.replacement_cost TO msamp_films."Replacement Cost"'
    22      - '   dvdrental_films.rating TO msamp_films.Rating '
    23      - 'dvdrental_films.special_features TO msamp_films."Special Features"'
    24  
    25  link:
    26      # - '[dvdrental_films.title WHERE film_id <= 3] TO [msamp_films.Title]'
    27      - '[dvdrental_films.title WHERE film_id > 30 AND film_id <= 50] TO [msamp_films.Title]'
    28  
    29  match:
    30      method: ids
    31      args: 
    32          - 'dvdrental_films.film_id'
    33          - 'msamp_films.ext_id'
    34  
    35  do: 
    36      - 'UPDATE'
    37      # - 'INSERT'