sqlalchemy.dialects.postgresql.hstore

module documentation
(source)

Undocumented

Class HSTORE Represent the PostgreSQL HSTORE type.
Class hstore Construct an hstore value within a SQL expression using the PostgreSQL ``hstore()`` function.
Constant CONTAINED_BY Undocumented
Constant CONTAINS Undocumented
Constant GETITEM Undocumented
Constant HAS_ALL Undocumented
Constant HAS_ANY Undocumented
Constant HAS_KEY Undocumented
Constant HSTORE_DELIMITER_RE Undocumented
Constant HSTORE_PAIR_RE Undocumented
Variable idx_precedence Undocumented
Class _HStoreArrayFunction Undocumented
Class _HStoreDefinedFunction Undocumented
Class _HStoreDeleteFunction Undocumented
Class _HStoreKeysFunction Undocumented
Class _HStoreMatrixFunction Undocumented
Class _HStoreSliceFunction Undocumented
Class _HStoreValsFunction Undocumented
Function _parse_error format an unmarshalling error.
Function _parse_hstore Parse an hstore from its literal string representation.
Function _serialize_hstore Serialize a dictionary into an hstore literal. Keys and values must both be strings (except None for values).
CONTAINED_BY = (source)

Undocumented

Value
operators.custom_op('<@',
                    precedence=idx_precedence,
                    natural_self_precedent=True,
                    eager_grouping=True)
CONTAINS = (source)

Undocumented

Value
operators.custom_op('@>',
                    precedence=idx_precedence,
                    natural_self_precedent=True,
                    eager_grouping=True)
GETITEM = (source)

Undocumented

Value
operators.custom_op('->',
                    precedence=idx_precedence,
                    natural_self_precedent=True,
                    eager_grouping=True)
HAS_ALL = (source)

Undocumented

Value
operators.custom_op('?&',
                    precedence=idx_precedence,
                    natural_self_precedent=True,
                    eager_grouping=True)
HAS_ANY = (source)

Undocumented

Value
operators.custom_op('?|',
                    precedence=idx_precedence,
                    natural_self_precedent=True,
                    eager_grouping=True)
HAS_KEY = (source)

Undocumented

Value
operators.custom_op('?',
                    precedence=idx_precedence,
                    natural_self_precedent=True,
                    eager_grouping=True)
HSTORE_DELIMITER_RE = (source)

Undocumented

Value
re.compile('''
[ ]* , [ ]*
''',
           re.VERBOSE)
HSTORE_PAIR_RE = (source)

Undocumented

Value
re.compile('''
(
  "(?P<key> (\\\\ . | [^"])* )"       # Quoted key
)
[ ]* => [ ]*    # Pair operator, optional adjoining whitespace
(
    (?P<value_null> NULL )          # NULL value
...
idx_precedence = (source)

Undocumented

def _parse_error(hstore_str, pos): (source)

format an unmarshalling error.

def _parse_hstore(hstore_str): (source)

Parse an hstore from its literal string representation. Attempts to approximate PG's hstore input parsing rules as closely as possible. Although currently this is not strictly necessary, since the current implementation of hstore's output syntax is stricter than what it accepts as input, the documentation makes no guarantees that will always be the case.

def _serialize_hstore(val): (source)

Serialize a dictionary into an hstore literal. Keys and values must both be strings (except None for values).