apiVersion: api/v1
kind: Case
name: lightning_import_csv_from_minio_with_cfg
features: [ lightning ]
summary: lightning import csv from minio with config
steps: |
    1. /tidb-lightning -c config.yaml
    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,"transfer-to-config":true}
    -   type: STRING
        name: drop_databases
        default: test
---
apiVersion: api/v1
kind: Case
name: lightning_import_sql_from_minio_with_cfg
features: [ lightning ]
summary: lightning import sql from minio with cfg
steps: |
    1. /tidb-lightning -c config.yaml
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,"transfer-to-config":true}
    -   type: STRING
        name: drop_databases
        default: test
---
apiVersion: api/v1
kind: Case
name: lightning_import_parquet_from_minio_with_cfg
features: [ lightning ]
summary: lightning import parquet from minio with cfg
steps: |
    1. /tidb-lightning -c config.yaml
    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,"transfer-to-config":true}
    -   type: STRING
        name: drop_databases
        default: import
---
apiVersion: api/v1
kind: Case
name: lightning_import_csv_from_minio_with_cfg_tidb_backend
features: [ lightning ]
summary: lightning import csv from minio with cfg
steps: |
    1. /tidb-lightning -c config.yaml
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,"transfer-to-config":true}
    -   type: STRING
        name: drop_databases
        default: test
---
apiVersion: api/v1
kind: Case
name: lightning_import_sql_from_minio_with_cfg_tidb_backend
features: [ lightning ]
summary: lightning import sql from minio with cfg tidb backend
steps: |
    1. /tidb-lightning -c config.yaml
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,"transfer-to-config":true}
    -   type: STRING
        name: drop_databases
        default: test
---
apiVersion: api/v1
kind: Case
name: lightning_import_parquet_from_minio_with_cfg_tidb_backend
features: [ lightning ]
summary: lightning import parquet from minio with cfg tidb backend
steps: |
    1. /tidb-lightning -c config.yaml
    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,"transfer-to-config":true}
    -   type: STRING
        name: drop_databases
        default: import