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.

Source Distribution

DBManager-0.1.1.tar.gz (6.3 kB view hashes)

Uploaded Source

Built Distribution

DBManager-0.1.1-py3-none-any.whl (7.0 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page