pycsn

Python package supporting cds for table definitions in the first place. The data type is a dict and therefore using csn/json as the primary formatn from which a cds-document can be created.

Use cases:

• Commandline: creating csn-file from csv-file that can be then adjusted
• Use package for creating a csn-file in a python script, e.g.
  1. Create csn from pd.DataFrame with index as primary keys
  2. Add annotations

Commandline

usage: pycsn [-h] [filename] [csn]

Creates csn-file from pandas DataFrame.

positional arguments:
  filename    Data Filename (csv) or folder (delta)
  csn         csn-file (optional)

options:
  -h, --help  show this help message and exit

Table of Contents

• Installation
• License

Installation

pip install pycsn

For testing

Install cds

Install the cds cli tool "cds-dk"

npm add -g @sap/cds-dk

Local Database

Because the final destination of a table is HANA, you should test if the resulting sql-statement (CREATE TABLE) works. sqlite is recommended by SAP CAP.

For MacOs:

brew install sqlite

Testing

pyscn is using a dict a its primary data format.

Example Data

table : store columns : transaction_id: store_id:

License

pycsn is distributed under the terms of the MIT license.