Skip to main content

Make Database Managing easier!

Project description

DBManager.py

PyVersion

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.

Project details


Download files

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

Filename, size & hash SHA256 hash help File type Python version Upload date
DBManager-0.1.3-py3-none-any.whl (7.0 kB) Copy SHA256 hash SHA256 Wheel py3
DBManager-0.1.3.tar.gz (6.3 kB) Copy SHA256 hash SHA256 Source None

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page