lemon.external.gadfly.semantics

Package lemon :: Package external :: Package gadfly :: Module semantics

[show private | hide private]

Module lemon.external.gadfly.semantics

SQL semantics

:Author: Aaron Watters
:Maintainers: http://gadfly.sf.net/
:Copyright: Aaron Robert Watters, 1994
:Id: $Id: semantics.py,v 1.1 2003/08/12 09:17:12 thejimmyg Exp $:

Classes
`Average`
`BetweenPredicate`	e1 BETWEEN e2 AND e3...
`BoundAddition`	promised addition.
`BoundAttribute`	bound attribute: initialize with relname=None if implicit.
`BoundDivision`	promised division.
`BoundExpression`	superclass for all bound expressions.
`BoundMinus`
`BoundMultiplication`	promised multiplication.
`BoundSubtraction`	promised subtraction.
`BoundTuple`
`BTand_pred`
`BTnot_pred`
`BTor_pred`
`BTPredicate`	superclass for bound tuple predicates.
`Constant`
`Count`
`DescExpr`	special wrapper used only for order by descending...
`descOb`	special wrapper only used for sorting in descending order should only be compared with other descOb instances.
`Except`
`ExistsPred`	EXISTS subquery.
`HashJoiner`
`InLits`	expr IN literals, support dynamic bindings.
`InPredicate`	Quantified equal any predicate...
`Intersect`
`LessEqPred`
`LessPred`
`Maximum`
`Median`
`Minimum`
`NontrivialEqPred`	equation of nontrivial expressions.
`NumberedColumn`	order by column number...
`OrderExpr`	order by expression.
`Parse_Context`	contextual information for parsing p.param() returns a new sequence number for external parameter.
`QuantEQ`	Quantified equal any predicate...
`QuantGE`	Quantified greater equal any predicate...
`QuantGT`	Quantified greater than any predicate...
`QuantLE`	Quantified less equal any predicate...
`QuantLT`	Quantified less than any predicate...
`QuantNE`	Quantified not equal any predicate...
`Selector`	For implementing, eg the SQL SELECT statement.
`SimpleColumn`	a simple column name for application to a list of tuples...
`SimpleRecursive`	Simple Recursive structure, only requires initargs...
`SubQueryExpression`	sub query expression (subq), must eval to single column, single value...
`Sum`
`TupleCollector`	Translate a sequence of assignments to simple tuples.
`Union`	union clause.

Function Summary
	`aggregate(assignments, exprlist)` aggregates are a assignments with special...
	`dump_single_column(assigns, att)` dump single column assignment...
	`dynamic_binding(ndynamic, dynamic)` create bindings from dynamic tuple for ndynamic parameters...
	`NamedSort(name, ord)`
	`no_ints_nulls(list)` in place remove all ints, Nones from a list (for null handling)...
	`order_tuples(order_list, tuples)`
	`orderbind_sequence(order_list, order)`
	`PositionedSort(num, ord)`
	`relbind_sequence(order_list, dict, db)`

Variable Summary
`str`	`SELECT_TEMPLATE` = `'SELECT %s %s\nFROM %s\nWHERE %s\nGROU...`

Function Details

aggregate(assignments, exprlist)

aggregates are a assignments with special
attribute None > list of subtuple

dump_single_column(assigns, att)

dump single column assignment

dynamic_binding(ndynamic, dynamic)

create bindings from dynamic tuple for ndynamic parameters
if a tuple is given create one
if a list is given create many

no_ints_nulls(list)

in place remove all ints, Nones from a list (for null handling)

Variable Details

SELECT_TEMPLATE

Type:: str
Value:: '''SELECT %s %s FROM %s WHERE %s GROUP BY %s HAVING %s %s ORDER BY %s %s '''

Generated by Epydoc 2.0 on Mon Nov 10 15:08:18 2003

http://epydoc.sf.net