Metadata-Version: 2.0
Name: bqspec
Version: 0.2.2
Summary: SQL testing tool for Google BigQuery
Home-page: https://github.com/orisano/bqspec
Author: Nao YONASHIRO
Author-email: owan.orisano@gmail.com
License: MIT
Description-Content-Type: UNKNOWN
Platform: UNKNOWN
Classifier: Development Status :: 2 - Pre-Alpha
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3.6
Classifier: Programming Language :: Python :: Implementation :: CPython
Classifier: Topic :: Software Development :: Libraries
Classifier: Topic :: Software Development :: Libraries :: Python Modules
Classifier: Topic :: Utilities
Requires-Dist: six
Requires-Dist: typing
Requires-Dist: ruamel.yaml
Requires-Dist: embexpr
Requires-Dist: google-cloud-bigquery
Requires-Dist: click
Requires-Dist: tqdm

BQSpec
===================================
| SQL testing tool for Google BigQuery.
| this library is pre-alpha. not recommended to production use.
| (under construction now)

Getting Started
--------
.. code:: bash

    pip install bqspec

.. code:: bash

    gcloud auth application-default login

How to Use
--------
spec.yaml

.. code:: yaml

    # test target SQL filepath
    query_path: ./sample.sql
    # any BigQuery query parameters (optional). more details: https://cloud.google.com/bigquery/docs/parameterized-queries
    params:
        - type: DATE
          name: date
          value: 2017-11-30
    # known columns (optional).
    columns:
        - id
        - a
        - b
        - c
        - total
    # conditions which all rows must met (optional).
    invariants:
        - total >= 0  # write python expression
        - a + b == c
    # any test cases
    cases:
        - where:
          - id == 1
          expected:
          - total == 15
          - a == 2
          - b == 3
          - c == 5

.. code:: bash

    bqspec -f spec.yaml

or

.. code:: bash

    bqspec -d .


License
--------
MIT


