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.11.1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3c705a8df17ed18eb4c4d35bf4b6d64a2ed0a28c549119f2540900eee5856fc8 |
|
MD5 | b05b172180294d51848a342637514cde |
|
BLAKE2b-256 | ac1d7b8e6a8ea51ab9e8da37f9eb1f0a4e2648c02c712f3ecc64dde2f33d8c96 |
Close
Hashes for pyplatform_database-2020.11.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0a13b7e240efa7f0197430267ae1c6764f3041ca922c837c8b2f6f544c73f62f |
|
MD5 | e7eae6f4e76d63b7b0a9728b8792d96c |
|
BLAKE2b-256 | 094ae63cba69777dbfd7b825f98614f5cb0f20abd619c040e18d0d4bed894f98 |