demo_valid.yml

#
# JBZoo Toolbox - Csv-Blueprint.
#
# This file is part of the JBZoo Toolbox project.
# For the full copyright and license information, please view the LICENSE
# file that was distributed with this source code.
#
# @license    MIT
# @copyright  Copyright (C) JBZoo.com, All rights reserved.
# @see        https://github.com/JBZoo/Csv-Blueprint
#

# This schema is valid because match the CSV file (tests/fixtures/demo.csv) perfectly.

filename_pattern: /(demo|demo_.*|demo-.*)\.csv$/

extra: 123

columns:
  - name: Name
    extra: 123
    rules:
      not_empty: true
      length_min: 4
      length_max: 7
    aggregate_rules:
      is_unique: true

  - name: City
    extra: null
    rules:
      not_empty: true
      is_capitalize: true

  - name: Float
    extra:
      custom_key: "custom_value"
      custom_key_2: "custom_value_2"
    rules:
      not_empty: true
      is_float: true
      num_min: -19366059128
      num_max: 4825.186
    aggregate_rules:
      sum_max: 4692


  - name: Birthday
    extra: [123, 456]
    rules:
      not_empty: true
      date_format: Y-m-d

  - name: Favorite color
    rules:
      not_empty: true
      allow_values: [ red, green, blue ]