This is a small package intended to help with basic operations such as select, insert, update, and upsert as well as executing raw SQL queries for different database types.
Project description
Basic SQL
This is a small package intended to help with basic operations such as select, insert, update, and upsert as well as executing raw SQL queries for different database types.
Additional requirements
The package is using SQLAlchemy and depending on what database you want to connect to the installation of additional packages is required. Below are the instructions for the databases that are currently supported:
PostgreSQL
pip install psycopg2
MySQL
pip install pymysql
SQL Server (MSSQL)
pip install pyodbc
On Linux first follow the Microsoft instructions to install the required drivers.
Oracle
pip install cx_Oracle
On Linux first follow the Oracle instructions to install the required drivers.
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
