Where

class dbastable.Where(column, op, value)

Bases: object

Where statement generator for SQL queries.

Parameters:

columnstr

The column name.

opstr

The SQL operator. Must be one of: =, !=, >, <, >=, <=, LIKE, IN, NOT IN, IS, IS NOT, BETWEEN, NOT BETWEEN.

valueany

The value to compare with the column. If the operator is IN or NOT IN, the value must be a list of values. If the operator is BETWEEN or NOT BETWEEN, the value must be a list of two values. For all other operators, the value must be a single value.

Attributes Summary

to_sql

Generate a string for the where statement.

Attributes Documentation

to_sql

Generate a string for the where statement.