Qovery / Replibyte

Seed your development database with real data ⚡️
https://www.replibyte.com
GNU General Public License v3.0
4.16k stars 128 forks source link

Subset a dump #252

Open kr-sanjeev-singh opened 1 year ago

kr-sanjeev-singh commented 1 year ago

If I try to dump create a dump using a subset

The associated data is not coming.

My conf.yaml file

source:
    connection_uri: postgres://root:root@localhost:5432/Dev-Research # you can use $DATABASE_URL
    transformers:
        - database: public
          table: users
          columns:
              - name: id
                transformer_name: transient
              - name: '"fullName"'
                transformer_name: first-name
    database_subset: # optional - downscale database while keeping it consistent
        database: public
        table: addresses
        strategy_name: random
        strategy_options:
            percent: 100
        passthrough_tables:
            - users
datastore:
    local_disk:
        dir: /data/replibyte
destination:
    connection_uri: postgres://root:root@localhost:5432/d4 # you can use $DATABASE_URL

can anyone please help me on this?

evoxmusic commented 1 year ago

Hi @singhaniasahil, what’s the issue you’re facing?

FYI: I see you have the strategy_options.percent to 100 which means that you’ll keep the full size of the reference table. I don’t know if it’s on purpose, but just in case :)