WriteOnlyColumn

class dbbase.column_types.WriteOnlyColumn(*args, **kwargs)[source]

Bases: sqlalchemy.sql.schema.Column

This class creates a subclassed column that identifies it as write only.

The use case for it derives from the need to screen out columns such as passwords from user tables.

Methods

all_()

Produce a _expression.all_() clause against the parent object.

any_()

Produce a _expression.any_() clause against the parent object.

append_foreign_key(fk)

argument_for(dialect_name, argument_name, …)

Add a new kind of dialect-specific keyword argument for this class.

asc()

Produce a _expression.asc() clause against the parent object.

between(cleft, cright[, symmetric])

Produce a _expression.between() clause against the parent object, given the lower and upper range.

bool_op(opstring[, precedence])

Return a custom boolean operator.

cast(type_)

Produce a type cast, i.e.

collate(collation)

Produce a _expression.collate() clause against the parent object, given the collation string.

compare(other[, use_proxies, equivalents])

Compare this ColumnElement to another.

compile(default[, bind, dialect])

Compile this SQL expression.

concat(other)

Implement the ‘concat’ operator.

contains(other, **kwargs)

Implement the ‘contains’ operator.

copy(**kw)

Create a copy of this Column, uninitialized.

desc()

Produce a _expression.desc() clause against the parent object.

distinct()

Produce a _expression.distinct() clause against the parent object.

endswith(other, **kwargs)

Implement the ‘endswith’ operator.

get_children([schema_visitor])

used to allow SchemaVisitor access

ilike(other[, escape])

Implement the ilike operator, e.g.

in_(other)

Implement the in operator.

is_(other)

Implement the IS operator.

is_distinct_from(other)

Implement the IS DISTINCT FROM operator.

isnot(other)

Implement the IS NOT operator.

isnot_distinct_from(other)

Implement the IS NOT DISTINCT FROM operator.

label(name)

Produce a column label, i.e.

like(other[, escape])

Implement the like operator.

match(other, **kwargs)

Implements a database-specific ‘match’ operator.

notilike(other[, escape])

implement the NOT ILIKE operator.

notin_(other)

implement the NOT IN operator.

notlike(other[, escape])

implement the NOT LIKE operator.

nullsfirst()

Produce a _expression.nullsfirst() clause against the parent object.

nullslast()

Produce a _expression.nullslast() clause against the parent object.

op(opstring[, precedence, is_comparison, …])

Produce a generic operator function.

operate(op, *other, **kwargs)

Operate on an argument.

params(*optionaldict, **kwargs)

references(column)

Return True if this Column references the given column via foreign key.

reverse_operate(op, other, **kwargs)

Reverse operate on an argument.

self_group([against])

Apply a ‘grouping’ to this _expression.ClauseElement.

shares_lineage(othercolumn)

Return True if the given _expression.ColumnElement has a common ancestor to this _expression.ColumnElement.

startswith(other, **kwargs)

Implement the startswith operator.

unique_params(*optionaldict, **kwargs)

Attributes

anon_label

Provides a constant ‘anonymous label’ for this ColumnElement.

base_columns

bind

comparator

default

description

dialect_kwargs

A collection of keyword arguments specified as dialect-specific options to this construct.

dialect_options

A collection of keyword arguments specified as dialect-specific options to this construct.

dispatch

expression

Return a column expression.

foreign_keys

info

is_clause_element

is_selectable

key

kwargs

A synonym for DialectKWArgs.dialect_kwargs.

onupdate

primary_key

proxy_set

quote

Return the value of the quote flag passed to this schema object, for those schema items which have a name field.

server_default

server_onupdate

supports_execution

table

timetuple

type