Database Tools Python scripts - Top 4 Download

Database Tools Python script downloads

Adding SQLite sign function

This script adds a user defined Sign function to SQLite using PySQLite. Requirements: · PySQLite ...
Python

ADO primary key and table creation

This script creates an Access 2000 table and adds a primary key to it. ...
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

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

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

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

Dee Module

Dee Module implements a truly relational database language using Python. ...
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

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

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

Expressions Generator for database requests

This script is a wrapper around DBAPI-compliant databases to support iteration and generator expression syntax for requests, instead of SQL. ...
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

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

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

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

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

mx ODBC example

Mx.odbc is cross platform and very fast. It could be used to go through a few hundred thousand rows of an access database in seconds where pure ADO would take 30 min (or 3 min if you use the ADO type library). This script is a simple example of how to talk to ...
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

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