Pyplatform-database package provides read and write functions for Microsoft SQL database.
Project description
Pyplatform-database package provides read and write functions for Microsoft SQL database.
Installation
pip install pyplatform-database
Authentication and environment variables
Refer to main page for documentation on authentication
Exploring the modules
from pyplatform.database import *
show_me()
Usage
reading from SQL table, default database provided in credential file
from pyplatform.database import *
query = """SELECT * FROM dbo.fact_sample_superstore"""
df = az_to_df(query)
df.head()
writing pandas dataframe to sql table with non default setting
from pyplatform.database import *
# df #TODO create dataframe as source
table_name = 'dbo.fact_sample_superstore'
engine = azure_sql_engine(database='testDB') #changing database only
df_to_azure_sql(df,table_name, engine=engine)
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 pyplatform-database-2020.12.1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 90d35d7d4815d8137fa7ca3a906376df2b51e4c147988bba7b5f7ea25c61aa3c |
|
MD5 | 8e1d9be7c8d8e765865c2fa733a32c90 |
|
BLAKE2b-256 | 48b1661a736806119d8f8ae83d1cb90597bca6f4578fd140da283eccfa455541 |
Close
Hashes for pyplatform_database-2020.12.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5f6d95f2ebe270f11d7a8f9138276b324733b63277cbaaf8cac276ac10f0bae5 |
|
MD5 | cec7bbec5483aa1d930a74763a3a8ef0 |
|
BLAKE2b-256 | 8471d0bc80b8bf2ff5cae94e6237cb39819d2e6e4603a7a114e304079210d854 |