Generic database wrapper
Python
Switch branches/tags
Nothing to show
Clone or download

README

Spartacus is a database wrapper for the most widely used RDBMS Python drivers.

Currently, Spartacus supports:

* SQLite

    pip install Spartacus

* Memory (in-memory SQLite)

    pip install Spartacus

* PostgreSQL

    pip install Spartacus[postgresql]

* MySQL

    pip install Spartacus[mysql]

* MariaDB

    pip install Spartacus[mariadb]

* Firebird

    pip install Spartacus[firebird]

* Oracle

    # make sure you have Oracle Database or Instant Client installed and configured
    pip install Spartacus[oracle]

* MS SQL

    sudo apt install freetds-bin freetds-dev
    pip install Spartacus[mssql]

* IBM DB2

    pip install Spartacus[ibmdb2]

* All supported RDBMS:

    pip install Spartacus[complete]

Instantiate this way:

SQLite

    v_database = Spartacus.Database.SQLite('../employees.db')

Memory

    v_database = Spartacus.Database.Memory()

PostgreSQL

    v_database = Spartacus.Database.PostgreSQL('127.0.0.1', '5432', 'employees', 'william', 'password')

MySQL

    v_database = Spartacus.Database.MySQL('127.0.0.1', '3306', 'employees', 'root', 'password')

MariaDB

    v_database = Spartacus.Database.MariaDB('127.0.0.1', '3306', 'employees', 'root', 'password')

Firebird

    v_database = Spartacus.Database.Firebird('127.0.0.1', '3050', '/path/to/employees.fdb', 'sysdba', 'masterkey')

Oracle

    v_database = Spartacus.Database.Oracle('127.0.0.1', '1521', 'XE', 'employees', 'password')

Microsoft SQL Server

    v_database = Spartacus.Database.MSSQL('127.0.0.1', '1433', 'employees', 'sa', 'password')

IBM DB2

    v_database = Spartacus.Database.IBMDB2('127.0.0.1', '50000', 'employes', 'db2inst1', 'password')