A Python library to upload and download data from database systems
Project description
SnowPy
Current release: SnowPy [v0.1.1]
'SnowPy' is a Python package providing a set of user-friendly functions to help upload and download data from database systems such as Microsoft SQL Server, Snowflake, (more to come). 'SnowPy' intially realsed as data tools for the mltoolkit project (https://mltoolkit.github.io/MLToolKit).
Introduction
SnowPy is a Python library to upload and download data from database system
Installation
pip install SnowPy
If the installation failed with dependancy issues, execute the above command with --no-dependencies
pip install SnowPy --no-dependencies
Functions
Usage
import snowpy
Warning: Python Variable, Function or Class names
The Python interpreter has a number of built-in functions. It is possible to overwrite thier definitions when coding without any rasing a warning from the Python interpriter. (https://docs.python.org/3/library/functions.html) Therfore, AVOID THESE NAMES as your variable, function or class names.
abs | all | any | ascii | bin | bool | bytearray | bytes |
callable | chr | classmethod | compile | complex | delattr | dict | dir |
divmod | enumerate | eval | exec | filter | float | format | frozenset |
getattr | globals | hasattr | hash | help | hex | id | input |
int | isinstance | issubclass | iter | len | list | locals | map |
max | memoryview | min | next | object | oct | open | ord |
pow | property | range | repr | reversed | round | set | |
setattr | slice | sorted | staticmethod | str | sum | super | tuple |
type | vars | zip | __import__ |
If you accedently overwrite any of the built-in function (e.g. list), execute the following to bring built-in defition.
del(list)
Functions
|- MSSQL
| |- execute_mssql_query
| |- read_data_mssql
| |- write_data_mssql
|- MySQL
| |- To be integrated...
|- Snowflake
| |- execute_snowflake_sql_query
| |- read_data_snowflake
| |- write_data_snowflake
|- CSV
| |- read_data_csv
| |- write_data_csv
SnowPy Example
# to be posted
Data Loading
# to be posted
License
Copyright 2019 Sumudu Tennakoon
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
Cite as
@misc{SnowPy2019,
author = "Sumudu Tennakoon",
title = "SnowPy: A Python library to upload and download data from database systems",
year = 2019,
publisher = "GitHub",
howpublished = {\url{https://mltoolkit.github.io/SnowPy/}},
version = "0.1.0"
}
SnowPy Project Timeline
Future Release Plan
References
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.