Metadata-Version: 2.1
Name: SqlDataApi
Version: 0.1.1
Summary: Python library for Sql Data Api
Home-page: https://github.com/FalconSoft/sql-data-api-client-Python
Author: FalconSoft Ltd
Author-email: ppaska@falconsoft-ltd.com
License: UNKNOWN
Platform: UNKNOWN
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Requires-Python: >=3.6
Description-Content-Type: text/markdown

# sql-data-api-client-Python
SQL Data Api client for Python

### Usage
```py
    """Sql Data Api"""
    SqlDataApi.set_api_url("https://localhost:44302")
    SqlDataApi.set_authentication("12121212-token-21121212")

    # query data
    result = SqlDataApi("SQL-Shared").run_query_to_array("test1.Sample100",
        filter="country = @country",
        filter_params={"country": "UK"}
    )
    print(result)

    # save data
    status = SqlDataApi("SQL-Shared").save_array("test1.Sample100", result)
    print(status)

    # execute stored procedure
    sp_res = SqlDataApi("northwind-db-connection").execute_sp_to_array("northwind.NorthwindEmployeesSummary", {'startDate': "2019-01-01", 'endDate': "2020-05-14"})
    print(sp_res)

```

### License

MIT - FalconSoft Ltd

