Re: [sqlalchemy] Alembic and postgresql multiple schema question

I've spent a long time evaluating this use case and there are a lot of ways to do it, but ultimately you are saying each schema is identical, and originally, you just wanted to set "search_path" to each schema, which is probably how this should be done if each schema is independent of each other an

Re: [sqlalchemy] Quering NUMBER as Decimal from Oracle problem

On Fri, Aug 31, 2018 at 5:54 AM, Андрей В. wrote: > Hello, > > I'm use SQLAlchemy for work with existing Oracle DB(Python 3.5.4, SQLAlchemy > 1.2.11, cx_Oracle 6.1, Oacle Client 11g1). > I reflecting tables and views(including materialized views) for quering > data. > > Example: > Tere is MV exist

Re: [sqlalchemy] Alembic and postgresql multiple schema question

from __future__ import with_statement from alembic import context from sqlalchemy import engine_from_config, pool from logging.config import fileConfig # this is the Alembic Config object, which provides # access to the values within the .ini file in use. config = context.config # Interpret the

[sqlalchemy] Quering NUMBER as Decimal from Oracle problem

Hello, I'm use SQLAlchemy for work with existing Oracle DB(Python 3.5.4, SQLAlchemy 1.2.11, cx_Oracle 6.1, Oacle Client 11g1). I reflecting tables and views(including materialized views) for quering data. Example: Tere is MV exists in DB create materialized view test_mv_table refresh force