Skip to main content

The PLIB.DBTOOLS package provides an easier to use interface to DB-API compliant databases.

Note: PLIB.DBTOOLS works with Python 2.7. If you are using Python 3, see the PLIB3.DBTOOLS package, available at https://pypi.org/project/plib3.dbtools.

The setup.py script for PLIB.DBTOOLS uses the setuputils helper module, which helps to automate away much of the boilerplate in Python setup scripts. This module is available as a separate release at https://pypi.org/project/setuputils.

The PLIB.DBTOOLS Package

The following classes and functions are available in the plib.dbtools namespace:

  • The DBInterface class provides a simple API for working with databases. It assumes that the underlying database engine conforms to the Python DB API. This class itself does not know about any particular database engine; a customized class should be derived from it for each particular engine.

  • The MySQLDBInterface class customizes DBInterface to work with a MySQL database. It uses the MySQLdb third-party Python package. This class is in the plib.dbtools.mysql sub-package.

  • The SQLite3DBInterface class customizes DBInterface to work with an SQLite version 3 database. It uses the sqlite3 module that comes with Python as its database engine. This class is in the plib.dbtools.sqlite sub-package.

  • The get_db_interface function is a convenience function that returns an instance of the appropriate DBInterface subclass for the database type passed to it.

  • The get_db_interface_class and get_db_interface_args functions factor out key portions of get_db_interface so that they can be used separately if desired. For example, some databases might require subclassing the interface class further, or customizing the interface arguments.

Installation

To install PLIB.DBTOOLS, you can simply run:

$ python setup.py install

at a shell prompt from the directory into which you unzipped the source tarball (the same directory that this README file is in). This will install PLIB and then run each of the post-install scripts in the scripts directory.

Release files for plib.dbtools 1.0.5

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for plib.dbtools 1.0.5
File Size Uploaded
plib.dbtools-1.0.5.tar.gz 23.7 kB Details

Release files / plib.dbtools-1.0.5.tar.gz

Download URL plib.dbtools-1.0.5.tar.gz
Size 23.7 kB
Tags Source
SHA-256 checksum
How to use checksums
d0ea0902de9ef794332ba0d79c6cd7c00b32f4c0d34b2eb5a47535a6fca459c1
BLAKE2b-256 checksum
How to use checksums
5696b150761814ffc3c394b38abebea32d385853427ce0a64e45da6ea39bd9de
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via python-requests/2.9.1

Release history Release notifications | RSS feed

This release

1.0.5 This release

1 release file

1.0.4

1 release file

1.0.3

1 release file

1.0.2

1 release file

1.0.1

1 release file

1.0

1 release file

0.9.20

1 release file

0.9.19

1 release file

0.9.18

1 release file

0.9.17

1 release file

0.9.16

1 release file

0.9.15

1 release file

0.9.14

1 release file

0.9.13

1 release file

0.9.12

1 release file

0.9.11

1 release file

0.9.10

1 release file

0.9.9

1 release file

0.9.8

1 release file

0.9.7

1 release file

0.9.6

1 release file

0.9.5

1 release file

0.9.4

1 release file

0.9.3

1 release file

0.9.2

1 release file

0.9.1

1 release file

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page