sqlalchemy.dialects.postgresql.hstore

module documentation

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 _​HStore​Array​Function Undocumented
Class _​HStore​Defined​Function Undocumented
Class _​HStore​Delete​Function Undocumented
Class _​HStore​Keys​Function Undocumented
Class _​HStore​Matrix​Function Undocumented
Class _​HStore​Slice​Function Undocumented
Class _​HStore​Vals​Function 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 =

Undocumented

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

Undocumented

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

Undocumented

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

Undocumented

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

Undocumented

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

Undocumented

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

Undocumented

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

Undocumented

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

Undocumented

def _parse_error(hstore_str, pos):
format an unmarshalling error.
def _parse_hstore(hstore_str):

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):
Serialize a dictionary into an hstore literal. Keys and values must both be strings (except None for values).