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.8.1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2ed0793fa33fdc2dd67698d34080ed1dee2da3534bc2897548e30468e6c8be47 |
|
MD5 | 6f49a0a2901f37ac6ad8f8d2fdcd042b |
|
BLAKE2b-256 | f42cfbd61d7dfd7f65968b15ac09d1b0c81b8bc1853fad316e80d5971183ca71 |
Close
Hashes for pyplatform_database-2020.8.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7f2f96db4bb55ee19f5cd898165388c59b25fd1c4668ca6cb45d491ed3718689 |
|
MD5 | 332e9d2802f95535d8136303abafb651 |
|
BLAKE2b-256 | b15b9e81beb6eb37c574a7cf3178b974b2bd44f21603f7656d78fadcde2ff8c3 |