Database Tools Python scripts - Top 4 Download

Database Tools Python script downloads

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

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

Create an ODBC data source

 With the help of the ctypes module, this script creates the required ODBC data sources when you install database applications that use ODBC. Requirements: · ctypes ...
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

Create table statements for MS Access tables

This script parses the output of MS Access's documenter report and generates sql create table statements for the tables in the report. ...
Python

Parse and create fixed size binary data

Python's struct library is too low-level for direct usage. This script having only 40 lines shows how it can be turned into more developer-friendly tool. ...
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

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

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

Run SQLite connections in isolated threads

This script lets databaseconnections live in their own thread and queues are used to communicate with them. ...
Python

Adding SQLite sign function

This script adds a user defined Sign function to SQLite using PySQLite. Requirements: · PySQLite ...
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

GUID Script

This script is a globally unique identifier that combines ip, time, and random bits. Since the time is listed first, you can sort records by guid. You can also extract the time and ip if needed. GUIDs make wonderful database keys. They require no access to the database (to get the ...
Python

Simple ZODB viewer in wxPython

This is a very simple script that allows you to examine a ZODB database. Start the script and you can see what is in your ZODB file as well as the overall structure. ...
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