apiVersion: api/v1
kind: Case
name: dumpling_from_mysql_to_local_csv
features: [ dumpling ]
summary: dumpling from mysql to local csv files
steps: |
    1. Copy files from minio to local
    2. Import to mysql by loader
    3. Dumpling from mysql to local csv files
expectedResult:
    1. Dumpling successfully
priority: P1
supportedVersions: [ ">=3.0" ]
tags: [ "dumpling", "acceptance" ]
designer: lixia02@pingcap.com
automation: AUTOMATED
active: true
framework:
    generic:
        command: [ "/dump_from_mysql" ]
        workingDir: "/"
        env: null
        image: hub.pingcap.net/chengyou/dump-from-mysql
        imagePullPolicy: "Always"
parameters:
    -   type: RESOURCE
        name: mysql
        default: mysql
    -   type: RESOURCE
        name: dumpling
        default: dumpling
    -   type: RESOURCE
        name: loader
        default: loader
    -   type: STRING
        name: mc_copy_opts
        default: |
            {"src":"qa-minio/tpcc/10-warehouses-sql","dst":"/tmp/loader-local","timeout":"10m"}
    -   type: STRING
        name: loader_opts
        default: |
            {"data-dir":"/tmp/loader-local/10-warehouses-sql","threads":16,"timeout":"10m","sql-mode":"ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"}
    -   type: STRING
        name: dumpling_opts
        default: |
            {"output":"/tmp/dumpling-output","filetype":"csv","filesize":"256M","rows":200,"threads":20,"timeout":"10m"}
    -   type: STRING
        name: drop_databases
        default: test
---
apiVersion: api/v1
kind: Case
name: dumpling_from_mysql_to_local_sql
features: [ dumpling ]
summary: dumpling from mysql to local sql files
steps: |
    1. Copy files from minio to local
    2. Import to mysql by loader
    3. Dumpling from mysql to local sql files
expectedResult:
    1. Dumpling successfully
priority: P1
supportedVersions: [ ">=3.0" ]
tags: [ "dumpling", "acceptance" ]
designer: lixia02@pingcap.com
automation: AUTOMATED
active: true
framework:
    generic:
        command: [ "/dump_from_mysql" ]
        workingDir: "/"
        env: null
        image: hub.pingcap.net/chengyou/dump-from-mysql
        imagePullPolicy: "Always"
parameters:
    -   type: RESOURCE
        name: mysql
        default: mysql
    -   type: RESOURCE
        name: dumpling
        default: dumpling
    -   type: RESOURCE
        name: loader
        default: loader
    -   type: STRING
        name: mc_copy_opts
        default: |
            {"src":"qa-minio/tpcc/10-warehouses-sql","dst":"/tmp/loader-local","timeout":"10m"}
    -   type: STRING
        name: loader_opts
        default: |
            {"data-dir":"/tmp/loader-local/10-warehouses-sql","threads":16,"timeout":"10m","sql-mode":"ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"}
    -   type: STRING
        name: dumpling_opts
        default: |
            {"output":"/tmp/dumpling-output","filetype":"sql","filesize":"256M","rows":200,"threads":20,"timeout":"10m"}
    -   type: STRING
        name: drop_databases
        default: test