caais.db - Database utilities and custom aggregates

class caais.db.GroupConcat(*args, **kwargs)

Bases: Aggregate

Aggregate multiple values be concatenating them into one string using a separator character. Similar to the join() function in Python.

function = 'GROUP_CONCAT'

template = '%(function)s(%(expressions)s%(separator)s)'

class caais.db.DefaultConcat(*args, **kwargs)

Bases: GroupConcat

Aggregate values by concatenating them into one string using the MULTI_VALUE_SEPARATOR character as a separator.

class caais.db.CharFieldOrDefault(*args, **kwargs)

Bases: Case

Return char field, or default_str if field is NULL or empty.