Database Tools scripts - Top 4 Download

Database Tools script downloads

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

Python DAO interface class

Python DAO interface class is a simple base class that can be used to quickly get connected to any database that has DAO interface.  It really is just a Python wrapper around the DAO COM object. ...
Python

Mapping arbitrary objects to a PostgreSQL database

Mapping arbitrary objects to a PostgreSQL database script allows you to introduce arbitrary objects into a PostgreSQL database. ...
Python

Pivot Crosstab Denormalization of Normalized List

This script shows you a function that creates a cross-tab or pivot table from a normalised input table. You can use this function to 'denormalize' a table of normalized records. ...
Python

DBF reader and writer

In this script the reader iterates over records in Dbase or Xbase files and the writer creates dbf files from Python sequences. ...
Python

MS SQL Server log monitor

MS SQL Server log monitor is a script that gathers errors, warnings, and failures from Micrsoft SQL Servers and SQL Server Agents. It creates a single HTML file from multiple server logs.It could be used as a quick daily check to determine if particular servers require administrator intervention.You can authenticate using either native ...
Python