Python sqlalchemy.dialects.postgresql.HSTORE Examples

The following are 7 code examples of sqlalchemy.dialects.postgresql.HSTORE(). You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may also want to check out all available functions/classes of the module sqlalchemy.dialects.postgresql , or try the search function .
Example #1
Source File: test_postgresql.py    From alembic with MIT License 6 votes vote down vote up 
def test_postgresql_hstore_subtypes(self):
        eq_ignore_whitespace(
            autogenerate.render._repr_type(HSTORE(), self.autogen_context),
            "postgresql.HSTORE(text_type=sa.Text())",
        )

        eq_ignore_whitespace(
            autogenerate.render._repr_type(
                HSTORE(text_type=String()), self.autogen_context
            ),
            "postgresql.HSTORE(text_type=sa.String())",
        )

        eq_ignore_whitespace(
            autogenerate.render._repr_type(
                HSTORE(text_type=BYTEA()), self.autogen_context
            ),
            "postgresql.HSTORE(text_type=postgresql.BYTEA())",
        )

        assert (
            "from sqlalchemy.dialects import postgresql"
            in self.autogen_context.imports
        )
Example #2
Source File: test_converter.py    From graphene-sqlalchemy with MIT License 5 votes vote down vote up 
def test_should_postgresql_hstore_convert():
    assert get_field(postgresql.HSTORE()).type == graphene.JSONString
Example #3
Source File: test_types.py    From sqlalchemy with MIT License 5 votes vote down vote up 
def test_hstore(self):
        self.test_hashable_flag(
            postgresql.HSTORE(),
            [{"a": "1", "b": "2", "c": "3"}, {"d": "4", "e": "5", "f": "6"}],
        )
Example #4
Source File: test_types.py    From sqlalchemy with MIT License 5 votes vote down vote up 
def setup(self):
        metadata = MetaData()
        self.test_table = Table(
            "test_table",
            metadata,
            Column("id", Integer, primary_key=True),
            Column("hash", HSTORE),
        )
        self.hashcol = self.test_table.c.hash
Example #5
Source File: test_types.py    From sqlalchemy with MIT License 5 votes vote down vote up 
def test_ret_type_text(self):
        col = column("x", HSTORE())

        is_(col["foo"].type.__class__, Text)
Example #6
Source File: test_types.py    From sqlalchemy with MIT License 5 votes vote down vote up 
def test_ret_type_custom(self):
        class MyType(types.UserDefinedType):
            pass

        col = column("x", HSTORE(text_type=MyType))

        is_(col["foo"].type.__class__, MyType)
Example #7
Source File: test_types.py    From sqlalchemy with MIT License 5 votes vote down vote up 
def define_tables(cls, metadata):
        Table(
            "data_table",
            metadata,
            Column("id", Integer, primary_key=True),
            Column("name", String(30), nullable=False),
            Column("data", HSTORE),
        )