apiVersion: api/v1
kind: Case
name: lightning_import_csv_from_minio_with_cli
features: [ lightning ]
summary: lightning import csv from minio with cli
steps: |
    1. /tidb-lightning -d "s3://tpcc/10-warehouses-csv?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true" -pd-urls "$target_pd" -tidb-host $target_tidb_host -tidb-port $target_tidb_port -tidb-user $target_tidb_user -backend local -sorted-kv-dir /tmp/sorted-kv-dir
    2. check crc32 checksum
expectedResult:
    1. Import successfully
category: FUNCTIONALITY
priority: P1
supportedVersions: [ ">=4.0" ]
tags: [ "lightning", "acceptance" ]
designer: lixia02@pingcap.com
automation: AUTOMATED
active: true
framework:
    generic:
        command: [ "/basic" ]
        workingDir: "/"
        env: null
        image: hub.pingcap.net/chengyou/lightning-basic-test
        imagePullPolicy: "Always"
parameters:
    -   type: RESOURCE
        name: target
        default: target
    -   type: RESOURCE
        name: lightning
        default: lightning
    -   type: STRING
        name: import_basic_opts
        default: |
            {"data-dir":"s3://tpcc/10-warehouses-csv?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true","backend":"local","sorted-kv-dir":"/tmp/sorted-kv-dir","config":"[mydumper.csv]\nheader=false","timeout":"10m","crc32-checksum":4164883055}
    -   type: STRING
        name: drop_databases
        default: test
---
apiVersion: api/v1
kind: Case
name: lightning_import_sql_from_minio_with_cli
features: [ lightning ]
summary: lightning import sql from minio with cli
steps: |
    1. /tidb-lightning -d "s3://tpcc/10-warehouses-sql?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true" -pd-urls "$target_pd" -tidb-host $target_tidb_host -tidb-port $target_tidb_port -tidb-user $target_tidb_user -backend local -sorted-kv-dir /tmp/sorted-kv-dir
expectedResult:
    1. Import successfully
category: FUNCTIONALITY
priority: P1
supportedVersions: [ ">=4.0" ]
tags: [ "lightning", "acceptance" ]
designer: lixia02@pingcap.com
automation: AUTOMATED
active: true
framework:
    generic:
        command: [ "/basic" ]
        workingDir: "/"
        env: null
        image: hub.pingcap.net/chengyou/lightning-basic-test
        imagePullPolicy: "Always"
parameters:
    -   type: RESOURCE
        name: target
        default: target
    -   type: RESOURCE
        name: lightning
        default: lightning
    -   type: STRING
        name: import_basic_opts
        default: |
            {"data-dir":"s3://tpcc/10-warehouses-sql?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true","backend":"local","sorted-kv-dir":"/tmp/sorted-kv-dir","config":"","timeout":"10m","crc32-checksum":4164883055}
    -   type: STRING
        name: drop_databases
        default: test
---
apiVersion: api/v1
kind: Case
name: lightning_import_parquet_from_minio_with_cli
features: [ lightning ]
summary: lightning import parquet from minio with cli
steps: |
    1. /tidb-lightning -d "s3://nfs/fubin/parquet?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true" -pd-urls "$target_pd" -tidb-host $target_tidb_host -tidb-port $target_tidb_port -tidb-user $target_tidb_user -backend local -sorted-kv-dir /tmp/sorted-kv-dir
    2. Check crc32
expectedResult:
    1. Import successfully
category: FUNCTIONALITY
priority: P1
supportedVersions: [ ">=4.0" ]
tags: [ "lightning", "acceptance" ]
designer: lixia02@pingcap.com
automation: AUTOMATED
active: true
framework:
    generic:
        command: [ "/basic" ]
        workingDir: "/"
        env: null
        image: hub.pingcap.net/chengyou/lightning-basic-test
        imagePullPolicy: "Always"
parameters:
    -   type: RESOURCE
        name: target
        default: target
    -   type: RESOURCE
        name: lightning
        default: lightning
    -   type: STRING
        name: import_basic_opts
        default: |
            {"data-dir":"s3://nfs/fubin/parquet?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true","backend":"local","sorted-kv-dir":"/tmp/sorted-kv-dir","config":"","timeout":"10m","crc32-checksum":1440344869}
    -   type: STRING
        name: drop_databases
        default: import
---
apiVersion: api/v1
kind: Case
name: lightning_import_csv_from_minio_with_cli_tidb_backend
features: [ lightning ]
summary: lightning import csv from minio with cli
steps: |
    1. /tidb-lightning -d "s3://tpcc/10-warehouses-csv?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true" -pd-urls "$target_pd" -tidb-host $target_tidb_host -tidb-port $target_tidb_port -tidb-user $target_tidb_user -backend local -sorted-kv-dir /tmp/sorted-kv-dir
expectedResult:
    1. Import successfully
category: FUNCTIONALITY
priority: P1
supportedVersions: [ ">=4.0" ]
tags: [ "lightning", "acceptance" ]
designer: lixia02@pingcap.com
automation: AUTOMATED
active: true
framework:
    generic:
        command: [ "/basic" ]
        workingDir: "/"
        env: null
        image: hub.pingcap.net/chengyou/lightning-basic-test
        imagePullPolicy: "Always"
parameters:
    -   type: RESOURCE
        name: target
        default: target
    -   type: RESOURCE
        name: lightning
        default: lightning
    -   type: STRING
        name: import_basic_opts
        default: |
            {"data-dir":"s3://tpcc/10-warehouses-csv?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true","backend":"tidb","sorted-kv-dir":"/tmp/sorted-kv-dir","config":"[mydumper.csv]\nheader=false","timeout":"10m","crc32-checksum":4164883055}
    -   type: STRING
        name: drop_databases
        default: test
---
apiVersion: api/v1
kind: Case
name: lightning_import_sql_from_minio_with_cli_tidb_backend
features: [ lightning ]
summary: lightning import sql from minio with cli tidb backend
steps: |
    1. /tidb-lightning -d "s3://tpcc/10-warehouses-sql?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true" -pd-urls "$target_pd" -tidb-host $target_tidb_host -tidb-port $target_tidb_port -tidb-user $target_tidb_user -backend local -sorted-kv-dir /tmp/sorted-kv-dir
expectedResult:
    1. Import successfully
category: FUNCTIONALITY
priority: P1
supportedVersions: [ ">=4.0" ]
tags: [ "lightning", "acceptance" ]
designer: lixia02@pingcap.com
automation: AUTOMATED
active: true
framework:
    generic:
        command: [ "/basic" ]
        workingDir: "/"
        env: null
        image: hub.pingcap.net/chengyou/lightning-basic-test
        imagePullPolicy: "Always"
parameters:
    -   type: RESOURCE
        name: target
        default: target
    -   type: RESOURCE
        name: lightning
        default: lightning
    -   type: STRING
        name: import_basic_opts
        default: |
            {"data-dir":"s3://tpcc/10-warehouses-sql?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true","backend":"tidb","sorted-kv-dir":"/tmp/sorted-kv-dir","config":"","timeout":"10m","crc32-checksum":4164883055}
    -   type: STRING
        name: drop_databases
        default: test
---
apiVersion: api/v1
kind: Case
name: lightning_import_parquet_from_minio_with_cli_tidb_backend
features: [ lightning ]
summary: lightning import parquet from minio with cli tidb backend
steps: |
    1. /tidb-lightning -d "s3://nfs/fubin/parquet?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true" -pd-urls "$target_pd" -tidb-host $target_tidb_host -tidb-port $target_tidb_port -tidb-user $target_tidb_user -backend local -sorted-kv-dir /tmp/sorted-kv-dir
    2. Check crc32 checksum
expectedResult:
    1. Import successfully
category: FUNCTIONALITY
priority: P1
supportedVersions: [ ">=4.0" ]
tags: [ "lightning", "acceptance" ]
designer: lixia02@pingcap.com
automation: AUTOMATED
active: true
framework:
    generic:
        command: [ "/basic" ]
        workingDir: "/"
        env: null
        image: hub.pingcap.net/chengyou/lightning-basic-test
        imagePullPolicy: "Always"
parameters:
    -   type: RESOURCE
        name: target
        default: target
    -   type: RESOURCE
        name: lightning
        default: lightning
    -   type: STRING
        name: import_basic_opts
        default: |
            {"data-dir":"s3://nfs/fubin/parquet?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true","backend":"tidb","sorted-kv-dir":"/tmp/sorted-kv-dir","config":"","timeout":"10m","crc32-checksum":1440344869}
    -   type: STRING
        name: drop_databases
        default: import
---
apiVersion: api/v1
kind: Case
name: dumpling_from_tidb_to_local_sql_files
features: [ dumpling ]
summary: dumpling from tidb to local sql files
steps: |
    1. Dump data from TiDB to local SQL files
expectedResult:
    1. Dump successfully
category: FUNCTIONALITY
priority: P1
supportedVersions: [ ">=4.0" ]
tags: [ "dumpling", "acceptance" ]
designer: lixia02@pingcap.com
automation: AUTOMATED
active: true
framework:
    generic:
        command: [ "/basic" ]
        workingDir: "/"
        env: null
        image: hub.pingcap.net/chengyou/dumpling-basic-test
        imagePullPolicy: "Always"
parameters:
    -   type: RESOURCE
        name: target
        default: target
    -   type: RESOURCE
        name: dumpling
        default: dumpling
    -   type: STRING
        name: dumpling_opts
        default: |
            {"output":"/export_data_sql","filetype":"sql","filesize":"256M","rows":10000,"threads":10,"timeout":"10m"}
---
apiVersion: api/v1
kind: Case
name: dumpling_from_tidb_to_local_csv_files
features: [ dumpling ]
summary: dumpling from tidb to local csv files
steps: |
    1. Dump data from TiDB to local csv files
expectedResult:
    1. Dump successfully
category: FUNCTIONALITY
priority: P1
supportedVersions: [ ">=4.0" ]
tags: [ "dumpling", "acceptance" ]
designer: lixia02@pingcap.com
automation: AUTOMATED
active: true
framework:
    generic:
        command: [ "/basic" ]
        workingDir: "/"
        env: null
        image: hub.pingcap.net/chengyou/dumpling-basic-test
        imagePullPolicy: "Always"
parameters:
    -   type: RESOURCE
        name: target
        default: target
    -   type: RESOURCE
        name: dumpling
        default: dumpling
    -   type: STRING
        name: dumpling_opts
        default: |
            {"output":"/export_data_csv","filetype":"csv","filesize":"256M","rows":10000,"threads":10,"timeout":"10m"}