List comprehensions for database request

Category: Python - Database Tools

Python has list comprehensions to select items in an iterable if a certain condition is true ; this is very similar to database requests. This script wraps a table of a DB-API compliant database in a class that implements the iteration protocol, so that you can use the for ... in ... if ... syntax. Date: 21 January, 2012


Database Requests - Database Query - Database Script - Database - Requests - Query

Homepage: http://code.activestate.com/

Developer: code.activestate.com

License: Freeware

Operating System: All

Add a Comment

all are required fields

     
What do you think of this resource?

Select Your Rate:

Votes:0

 

Related Scripts Download

This script is a wrapper around DBAPI-compliant databases to support iteration and generator expression syntax for requests, instead of SQL.

developer Developer: code.activestate.com
license License: Freeware
operating systems Operating System: All


Python has list comprehensions to select items in an iterable if a certain condition is true ; this is very similar to database requests.

developer Developer: code.activestate.com
license License: Freeware
operating systems Operating System: Windows, Linux, Mac OS, BSD, Solaris


This script is a wrapper around DBAPI-compliant databases to support iteration and generator expression syntax for requests, instead of SQL.

developer Developer: code.activestate.com
license License: Freeware
operating systems Operating System: Windows, Linux, Mac OS, BSD, Solaris


GEQUEL is a GTK-based frontend for a MySQL database.

developer Developer: ta.twi.tudelft.nl
license License: Freeware
operating systems Operating System: All


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

developer Developer: code.activestate.com
license License: Freeware
operating systems Operating System: All


SPIDERS (SQL PHP/PERL Integrated DEvelopment Reporting System) is a PHP web front end on apache used to run perl script reports on SQL databases.

developer Developer: SourceForge.net
license License: Freeware
operating systems Operating System: All


This script runs parameterized map, filter, reduce, and extract functions on a database structured as a list of tuples.

developer Developer: code.activestate.com
license License: Freeware
operating systems Operating System: All


CrocoPat manipulates relations of any arity, including graphs (which are binary relations).

developer Developer: mtc.epfl.ch
license License: Freeware
operating systems Operating System: All


This script is a wrapper around DBAPI-compliant databases to support iteration and generator expression syntax for requests, instead of SQL.

developer Developer: code.activestate.com
license License: Freeware
operating systems Operating System: All