Scripts Index
Related Topics
Popular Trends
Trending Topics
Python Database Tools  

List comprehensions for database request

download download home home   report broken
important script information
company name:
code.activestate.com
license: Free
minimum requirements: Python
functional limitations:
List comprehensions for database request description


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.



Relates:
Database - Query - Database Requests - Database Query - Database Script - Requests
Similar scripts
DBF reader and writer (Popularity: ) : In this script the reader iterates over records in Dbase or Xbase files and the writer creates dbf files from Python sequences.
OraSchemadoc (Popularity: ) : OraSchemadoc provides "JavaDoc" style detailed documentation for all objects in schema covering Oracle specific features. Result of execution of oraschemadoc is set of static html files.Features:- data about all tables, including columns- table constraints(check, unique and referential)- indexes, including functional ...
MS SQL Server Database Mover (Popularity: ) : This script automates the movement of databases from one Microsoft SQL Server to another. It is designed to detach, copy, and reattach database files with a single call. It could be used to move databases with a minimum of downtime. ...
Create table statements for MS Access tables (Popularity: ) : This script parses the output of MS Access's documenter report and generates sql create table statements for the tables in the report.
Python Hyperschema (Popularity: ) : Python Hyperschema is an open source public domain project that creates very useful HTML hypermaps from SQL database schema, which consists of two small PL/SQL files and one Python (or C) source code file. The thus generated HTML pages have ...
SICKnotes (Popularity: ) : SICKnotes which is a short form for site inventory, configuration and knowledge is a web tool which is based on the permissions that assists with inventory, system changes, contact info, and knowledge for anything from a small startup to a ...
MS SQL Server log monitor (Popularity: ) : 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 ...
Dump a database file to a pickle (Popularity: ) : This script converts the database file given on the command line to a pickle representation.The default is hash. If a pickle file is named it is opened for write access (deleting any existing data). If no pickle file is named, ...
Book Database (Popularity: ) : Book Database script allows you to learn programming database applications.
Read tabular data from Excel spreadsheets (Popularity: ) : Sometimes you get an Excel spreadsheet (say, from the marketing departement) and you want to read tabular data from it (i.e. a line with column headers and lines of data). There are many ways to do this (including ODBC mxODBC), ...
User reviews

Write a review:
1 2 3 4 5 6 7 8 9 10
1=poor 10=excellent
Write review*
Your name*
Email*
  (Comments are moderated, and will not appear on this site until the editor has approved them)
 
Similar Software
Navicat for SQLite (Linux) - the best GUI database administration tool (Popularity: ) : Navicat for SQLite is a powerful and comprehensive GUI provides a complete set of functions for database management and administration. It offers tools for data editing, SQL query and data modeling and support for all SQLite object types. A new ...
Navicat for SQLite (Mac OS X) - the best GUI database administration tool (Popularity: ) : Navicat for SQLite is a powerful and comprehensive GUI provides a complete set of functions for database management and administration. It offers tools for data editing, SQL query and data modeling and support for all SQLite object types. A new ...
List Of All US Cities, States and Zip Codes Database Software (Popularity: ) : This software offers a solution to users who want to search and save lists of cities, states and zip codes in the United States. The user can enter part of a city name, state or zip code to search or ...
EMail List Organizer Deluxe (Popularity: ) : Email List Organizer Deluxe for Windows: easy-to-use database management software that helps you to organize and manage your mailing lists. Database management features will help you to remove duplicates, verify email addresses, change small letters to capital letters, create multiple ...
Navicat for SQLite Linux (Popularity: ) : Navicat for SQLite is a powerful and comprehensive GUI provides a complete set of functions for database management and administration. It offers tools for data editing, SQL query and data modeling and support for all SQLite object types. A new ...
Navicat for SQLite (Mac OS X) (Popularity: ) : Navicat for SQLite is a powerful and comprehensive GUI provides a complete set of functions for database management and administration. It offers tools for data editing, SQL query and data modeling and support for all SQLite object types. A new ...
Navicat for MySQL (Mac OS X) - superb database tool for MySQL and MariaDB (Popularity: ) : Navicat for MySQL are able to connect to MySQL and MariaDB databases simultaneously within a single application. It works with MySQL database servers from version 3.21 or above and MariaDB 5.1 or higher. It is also compatible with Drizzle, OurDelta, ...
Navicat for PostgreSQL(Mac OS X) - the best GUI database administration tool (Popularity: ) : Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database administration. User can create and execute queries and functions with a powerful SQL Editor, and manage the data with versatile data editing tools. Navicat for PostgreSQL connects user to ...
Navicat for SQLite (Windows) - the best GUI database administration tool (Popularity: ) : Navicat for SQLite is a powerful and comprehensive GUI provides a complete set of functions for database management and administration. It offers tools for data editing, SQL query and data modeling and support for all SQLite object types. A new ...
VWdatalist (Popularity: ) : VWdatalist is designed to display a ‘pick list’ from a database table and automatically return the identification of the text chosen. Features:- Can display drop-down list direct from a database recordset- Simple property ‘value’ to refer to item selected- Control ...
ad


Rate me
supported os
All
stats
downloads 2
version 1.0
size in Kb
popularity   
719/376435
user rating 5/10
New Scripts
Popular Scripts
Latest Reviews