Re: extending enum type natively in postgres using alembic

Mike, thank you very much for so fast and detailed response! чт, 31 окт. 2019 г. в 17:45, Mike Bayer : > > > On Thu, Oct 31, 2019, at 8:45 AM, Alexander wrote: > > Dear colleagues, > > I would like to extend enum type in postgres using alembic and currently i >

extending enum type natively in postgres using alembic

tgres supports adding new values to enum natively (added queries below), is it possible to perform such request in alembic? ALTER TYPE enum_type ADD VALUE 'new_value'; -- appends to list ALTER TYPE enum_type ADD VALUE 'new_value' BEFORE 'old_value'; ALTER TYPE enum_ty

Re: I need to create cube field. Is it possible using sqlalchemy / alembic?

', CUBE)) > > docs: > https://docs.sqlalchemy.org/en/latest/core/custom_types.html?highlight=userdefinedtype#creating-new-types > > > > > On Thu, Nov 1, 2018 at 1:47 AM Alexander Vasin > wrote: > > > > I need to create cube field. Is it possible using sqlalc

I need to create cube field. Is it possible using sqlalchemy / alembic?

I need to create cube field. Is it possible using sqlalchemy / alembic? -- You received this message because you are subscribed to the Google Groups "sqlalchemy-alembic" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy-alembic+unsubscr...@goog

Re: Integrate PyHive and Alembic

The dialect subclassed the SQLCompiler but not the DDLCompiler. Putting the visit_* statements in a DDLCompiler subclass worked! Thanks! Now to override the UPDATE and DELETE statements since Hive doesn't support those... Will give it a whirl before asking more questions. Thanks, Alexande

Re: Integrate PyHive and Alembic

a visit_primary_key_constraint() method to my dialect which simply returns '' but this is having no effect. And I am a bit lost in finding which method I should override to ensure I never append a 'NOT NULL' string to the end of a column specification. Any recommendations? Thanks

Re: Integrate PyHive and Alembic

valid HiveQL keywords. I assume somewhere in the HiveImpl class I could override the contents of this statement, but I couldn't figure out where/how to do that. Thanks, Alexander On Friday, February 10, 2017 at 9:45:38 AM UTC-5, mike bayer wrote: > > > > On 02/10/2017 07:41 AM,

Integrate PyHive and Alembic

e to execute raw SQL against a Hive instance (no ORM implementation needed) and I was hoping to use Alembic to manage the minimum upgrade/downgrade functionality. Are there any simple edits I can make to the Alembic source code to allow me to achieve this goal? Thanks, Alexander -- You r

Generating migrations as SQL scripts should not infer connection status

> > A major capability of Alembic is to generate migrations as SQL scripts, > instead of running them against the database - this is also referred to as > *offline > mode*. - http://alembic.readthedocs.org/en/latest/offline.html I apologize if this seems pedantic, but I can't seem to understa