On Tue, Nov 6, 2018 at 10:33 PM Paul Becotte wrote:
>
> Hi!
>
> I recently needed to use the select ... into ... construct to build a temp
> table in Redshift. I used the recipe
> https://bitbucket.org/zzzeek/sqlalchemy/wiki/UsageRecipes/SelectInto here to
> get a good idea of how to go about
Hi!
I recently needed to use the select ... into ... construct to build a temp
table in Redshift. I used the
recipe https://bitbucket.org/zzzeek/sqlalchemy/wiki/UsageRecipes/SelectInto
here to get a good idea of how to go about this, and was wondering if I
should contribute the final working
On Tue, Nov 6, 2018 at 6:11 PM 'Van Klaveren, Brian N.' via sqlalchemy
wrote:
>
> Hi,
>
> I want to create a custom type for TINYINT and DOUBLE.
>
> I've defined them as custom types.
>
> I want to use with_variant for them, so that in sqlite they print out as
> TINYINT and DOUBLE.
>
> But I
Hi,
I want to create a custom type for TINYINT and DOUBLE.
I've defined them as custom types.
I want to use with_variant for them, so that in sqlite they print out as
TINYINT and DOUBLE.
But I also want them to use the variants defined for other databases, like
Oracle and Postgres.
The
I should add, please specify which backend you're using and what DDL
sequence you are looking to emit.
On Tue, Nov 6, 2018 at 3:21 PM Mike Bayer wrote:
>
> On Tue, Nov 6, 2018 at 2:54 PM wrote:
> >
> > Hi,
> >
> > I find that `UniqueConstraint` from `sqlachemy` and
> >
On Tue, Nov 6, 2018 at 2:54 PM wrote:
>
> Hi,
>
> I find that `UniqueConstraint` from `sqlachemy` and
> `op.create_unique_constraint` by `alembic`, it cannot handle multiple columns
> that contain null values.
>
> I saw we can solve using SQL commands via some tricky ways like creating
>
I've updated the documentation and in a few hours it should be up at
https://docs.sqlalchemy.org/en/latest/orm/persistence_techniques.html#simple-vertical-partitioning
On Tue, Nov 6, 2018 at 3:04 PM wrote:
>
> Oh, it's perfect for me if I can use bases for bindings.
>
> Thank you
>
> Le mardi 6
Oh, it's perfect for me if I can use bases for bindings.
Thank you
Le mardi 6 novembre 2018 21:27:19 UTC+2, Mike Bayer a écrit :
>
> On Tue, Nov 6, 2018 at 2:20 PM > wrote:
> >
> > I have many classes, so it's seems a better idea to use something like
> that (but I don't know what exactly is
Hi,
I find that `UniqueConstraint` from `sqlachemy` and
`op.create_unique_constraint` by `alembic`, it cannot handle multiple
columns that contain null values.
I saw we can solve using SQL commands via some tricky ways like creating
unique index and coalesce, do we have some ways using
On Tue, Nov 6, 2018 at 2:20 PM wrote:
>
> I have many classes, so it's seems a better idea to use something like that
> (but I don't know what exactly is this registry, and why it's a WeakRef dict)
> :
>
> binding = {cls: engine for cls in Base._decl_class_registry.values()}
see I don't want
I have many classes, so it's seems a better idea to use something like that
(but I don't know what exactly is this registry, and why it's a WeakRef
dict) :
binding = {cls: engine for cls in Base._decl_class_registry.values()}
If not, maybe I can use the second approach, overloading Session,
On Tue, Nov 6, 2018 at 9:41 AM wrote:
>
> Hi,
>
> I'm using a schema with multiple DB, like :
>
> engine1 = create_engine("mysql://localhost/{db}?charset=utf8".format(db=db1))
> engine2 = create_engine("mysql://localhost/{db}?charset=utf8".format(db=db2))
>
> Then I use automap and reflection to
Hi,
I'm using a schema with multiple DB, like :
engine1 = create_engine("mysql://localhost/{db}?charset=utf8".format(db=db1
))
engine2 = create_engine("mysql://localhost/{db}?charset=utf8".format(db=db2
))
Then I use automap and reflection to generate mapping of all classes needed.
Sometime, I
Thanks a lot Mike!
On Wednesday, October 31, 2018 at 7:43:51 PM UTC+1, Mike Bayer wrote:
> here's the issue:
>
>
> https://bitbucket.org/zzzeek/alembic/issues/515/system-true-not-generated-for-column
>
>
14 matches
Mail list logo