DBManager 0.1.1

Make Database Managing easier!

DBManager.py

A library for Database Management that makes our development easier.

Compatibility

This module supports connections with MySQL, PostgreSQL, SQL Server and SQLite3.

Features

The module manage almost everything by itself, this means Opening/Closing connections, cursors and managing of Commits.
Some of its features are:

• execute(sql): Executes either an SQL sentence or a .sql file. It also can return values from a SELECT.
• select(table, columns, condition, order): This method will return a list of selected values or just a value if ResultSet turns out to be just one.
• insert(table, values): Inserts values into a table by the folowwing syntax: insert("test", id=12, name="LeCuay", money=32.12).
• update(table, condition, sets): Updates rows by the following syntax: update("test", "name like '%Cuai%'", name="LeCuay", id=1, money=122.53).
• create_table(table, values): Creates a table with the params in values by the following syntax: create_table("test", id="INTEGER PRIMARY KEY", name="VARCHAR(255)".
• create_database(dbname): Manage the creation of a Database and its Isolation levels.
• callproc(name, params): Calls a stored procedure from the Database.

To-do List

• Add compatibility with OracleDB.
• Add compatibility with MongoDB.
• Add more specific features for each Connection.