pyre.db.Measure

Module Contents

class pyre.db.Measure.Measure

Bases: pyre.records.measure

The base class for table field descriptors

class measure

The base class of the local mixins.

Its purpose is to trap value coercion and skip it for the special values {NULL} and {DEFAULT} that show up as {literals} instances

coerce(self, value, **kwds)

class bool

Bases: pyre.db.Measure.measure

Mixin for booleans

decl = BOOLEAN

sql(self, value)

SQL rendering of {value}

class date(default=None, **kwds)

Bases: pyre.db.Measure.measure

Mixin for dates

decl = DATE

sql(self, value)

SQL rendering of {value}

class decimal(precision, scale, **kwds)

Bases: pyre.db.Measure.measure

Mixin for fixed point numbers

sql(self, value)

SQL rendering of {value}

class float

Bases: pyre.db.Measure.measure

Mixin for floating point numbers

decl = DOUBLE PRECISION

sql(self, value)

SQL rendering of my value

class int

Bases: pyre.db.Measure.measure

Mixin for integers

decl = INTEGER

sql(self, value)

SQL rendering of my value

class str(maxlen=None, **kwds)

Bases: pyre.db.Measure.measure

Mixin for strings

sql(self, value)

SQL rendering of my value

class time(default=None, timezone=False, **kwds)

Bases: pyre.db.Measure.measure

Mixin for timestamps

sql(self, value)

SQL rendering of {value}

_primary

_unique

_notNull

_foreign

setDefault(self, value)

Set a new default value

primary(self)

Mark a field as a primary key

unique(self)

Mark a field as containing values that are unique across the table rows

notNull(self)

Mark a field as not accepting a NULL value

references(self, **kwds)

Mark a field as a foreign key

decldefault(self)

Invoked by the SQL mill to create the declaration of the default value