auto generate not working for postgres JSONB

[sqlalchemy-bot]

Migrated issue, originally created by Paul van der Linden

When I auto generate a migration for a model with a jsonb field i get the following error:

    sa.Column('data', postgresql.JSONB(astext_type=Text()), nullable=True),
NameError: name 'Text' is not defined

This is with version alembic 0.8.10 and sqlalchemy 1.1.5, it used to work, and would not add the astext_type=Text() (in version alembic 0.8.9 and sqlalchmey 1.0.15).

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

this is of the same class as #85 and the PR we have at zzzeek/alembic#38 would form the basis for the architecture that allows these various Postgresql "nested" types to render directly.

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

https://gerrit.sqlalchemy.org/316

[sqlalchemy-bot]

Changes by Michael Bayer (@zzzeek):

• set milestone to "fasttrack"

[sqlalchemy-bot]

Changes by Michael Bayer (@zzzeek):

• added labels: autogenerate - rendering

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

Apply subtype repr logic to JSON/JSONB

Fixed bug where Postgresql JSON/JSONB types rendered on SQLAlchemy
1.1 would render the "astext_type" argument which defaults to
the Text() type without the module prefix, similarly to the
issue with ARRAY fixed in 🎫85.

Also modifies the ARRAY approach from 🎫85 to be
regular expression based for safer targeting of the inner
repr() type.

Change-Id: I66d51301f4bf5b747b5e8da26a83cbff075d71b2
Fixes: #411

→ 9fab143

[sqlalchemy-bot]

Changes by Michael Bayer (@zzzeek):

• changed status to closed

[joanna350]

I cannot get this to work. How are these cases 'closed' when there is no apparent solution??? https://gerrit.sqlalchemy.org/313 -> did not give me any lead, some other sites have these threads that are not trackable, if a bug within Alembic, why is the solution not clear for all's view?

[mikeywaites]

Hey @joanna350 sorry you're still having trouble.

So that I can properly replicate the issue could you provide me with a simple test case, version of postgresql you're running, versions of alembic and sqlalchemy and anything else you think would be helpful.