Skip to main content

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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

basicsql-0.1.5.tar.gz (6.9 kB view hashes)

Uploaded source

Built Distribution

basicsql-0.1.5-py3-none-any.whl (6.9 kB view hashes)

Uploaded py3

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page