Python library for Sql Data Api
Project description
sql-data-api-client-Python
SQL Data Api client for Python
Usage
pip install sql_data_api_client
import sql_data_api_client as sql
"""Sql Data Api"""
sql.SqlDataApi.set_api_url("https://localhost:44302")
sql.SqlDataApi.set_authentication("12121212-token-21121212")
# query data
result = sql.SqlDataApi("SQL-Shared").run_query_to_array("test1.Sample100",
filter="country = @country",
filter_params={"country": "UK"}
)
print(result)
# save data
status = sql.SqlDataApi("SQL-Shared").save_array("test1.Sample100", result)
print(status)
# execute stored procedure
sp_res = sql.SqlDataApi("northwind-db-connection").execute_sp_to_array("northwind.NorthwindEmployeesSummary", {'startDate': "2019-01-01", 'endDate': "2020-05-14"})
print(sp_res)
License
A permissive MIT License (c) FalconSoft Ltd.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for sql_data_api_client-0.1.4.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | cb3bd706c4dae1a1111ae5915f8202af7ada3c597ec7d05c0f89b4a1d36d5b08 |
|
MD5 | 405b61aecf6991929a4f67c83ed098d4 |
|
BLAKE2b-256 | a9b9efa45c0264e3c5bbe4fe5e02a3d9a47d5f32b0f3b8b0af030106512b7b14 |
Close
Hashes for sql_data_api_client-0.1.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 14c06c825b18865c740f9c2ce9867e36a08354f2fd94b4cc58c20b118f7d9abd |
|
MD5 | bbd3a1a4c89c39d4c5f3419c0c0f0158 |
|
BLAKE2b-256 | 7ee19d02cd54a2d1bf398936cbc61f55276d90ef03ea7387c1a298f49c133143 |