Make Database Managing easier!
Project description
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 invalues
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.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
DBManager-0.1.3.tar.gz
(6.3 kB
view hashes)
Built Distribution
Close
Hashes for DBManager-0.1.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 85fcb975d45d8e755ccd192fad773641d90c616ecd53c997c8c4bb08992f7551 |
|
MD5 | 03e03c2d5b79659b3b2d80d8957b8f4c |
|
BLAKE2b-256 | 98f1aff6f7767528445784c40d01f5cec7f6adcb10a78e275e2dbf31cb44354b |