Database Tools Python scripts - Top 4 Download

Database Tools Python script downloads

Sql2diagram sxd

It can be used in reverse-engineering ERD (Entity-Relationship Diagrams) to create UML-style table structure diagrams.The program outputs OpenOffice.org Draw (.sxd) files, so the results are editable.The program can also output a machine readable textual explanation of the diagram it is writing. ...
Python

neo my2pg

neo_my2pg is a Python script for migration from mysql to postgresql. Don't need dump because it use the dbapi 2.0 during the migration.The script is compatible with all major web browsers and is very easy to install and use. ...
Python

Pybliographer

Pybliographer is a tool for managing bibliographic databases. You can either use its graphical interface (based on Gnome) which provides powerful editing capabilities, a nice hierarchical search mechanism, direct insertion of references into LyX and Kile, direct queries on Medline, and more. Or you can directly access its internal python classes ...
Python

PythonReports

PythonReports is a toolkit aimed to build database reports in Python programs. The toolkit includes report template designer, report builder and several printout renderers for GUI and graphic file output. Report builder applies a template to a sequence of uniform data objects and produces a printout structure that can be saved ...
Python

DirectoryStorage

DirectoryStorage is a Storage for ZODB, the object database used by Zope. It uses ordinary files and directories to store revisions of ZODB objects; one file per revision per object. Features: - very simple file format; one file per revision per object. Your data is not locked away inside an unfamiliar, ...
Python

Dee Module

Dee Module implements a truly relational database language using Python. ...
Python

Dynamic Generation of image labels

In the Web domain, sometimes it is necessary to dynamically create images containg just text. This script uses PIL to do just that, and it can be integrated to Zope/Plone through External Methods. ...
Python

ADO primary key and table creation

This script creates an Access 2000 table and adds a primary key to it. ...
Python

Using ADO to list field definitions for tables

This script demonstrates the use of ADO to get database table definitions. A PostgreSQL create code is generated. ...
Python

Using the MySQLdb interface

Using the MySQLdb interface script is a simple example showing how to use the MySQLdb interface to function with your MySQL database. ...
Python

Resultset

Resultset allows you to accessdatabase results by field name. It wraps each result row in a ResultRow class which allows you to retrieve results via a dictionary interface (by column name). The regular list interface (by column number) is also provided. ...
Python

MySQL and accessing database results by field

MySQL and accessing database results by field script allows you to access database records returned by a query using the field name. ...
Python

Printing of Database Cursor Contents

One of the problems of dealing with databases is presenting the result of a query when you may not know much about the data. This script uses the cursor's description attribute to try and provide appropriate headings, and optionally examines each output row to ensure column widths are adequate. ...
Python

Using Berkeley DB Database

Berkeley DB is an open source database. Its most important advantages are its simplicity to use and its performance. This is an introductory example, that shows how to create a database, add new elements in it (as Key/Value pairs) and finally how to print all content of the database. The example ...
Python

Another way to use fields for databases

Another way to use fields for databases script is a lightweight method to access the field names from a database. ...
Python

Classmethods for Object Relational Mappings

This script shows one use for class methods, i.e. to map Relational tables and rows to objects in python. class methods come in handy when you want all objects in a class to share one method, in this case to retrieve rows from a table. ...
Python

Metakit for safe reading and writing

Metakit is a reliable/lightweight/fast database library that python can use. Metakit has an extend mode that enables many simultaneous readers and one writer w/out needing a database server to synchronize things. ...
Python

Single parameters style for DB API modules

This script allows you to code SQL queries the same way independent on paramstyle of used DB module. ...
Python

Efficient database trees

Sometimes it can be hard to work out a way of efficiently representing a tree in the database. Combining modified preorder tree traversal with a parent child model allows most common queries to be represented in a single sql query. This example uses MySQLdb, but can easy be changed to use ...
Python

Modifying pickles without instantiating objects

This code loads arbitrary pickles. It just loads their data into totally inert objects which you can then traverse and do what you like to. It's pretty similar to processing a DOM tree. ...
Python