Re: [sqlalchemy] [alembic] data migration and select expression

2012-11-28 Thread Bruno Binet
is a UnicodeDecodeError which I reported on alembic bug tracker: https://bitbucket.org/zzzeek/alembic/issue/90/special-unicode-chars-causes (this can easily be worked around by asking alembic not to output sql to sys.stdout). On 27 November 2012 16:52, Michael Bayer wrote: > > On Nov 27, 201

[sqlalchemy] [alembic] data migration and select expression

2012-11-27 Thread Bruno Binet
} for valeur in [u'circulaire', u'ovale', u'rectangulaire'']]) def downgrade(): pass ``` But it does not work, I cannot use a `select` expression here. How would you do such data migrations with alembic? Ideally it would work with both online and off

Re: [sqlalchemy] drop index bug?

2012-09-24 Thread Bruno Binet
Thanks! On 24 September 2012 17:19, Michael Bayer wrote: > > On Sep 24, 2012, at 10:24 AM, Bruno Binet wrote: > >> >> Should I report this as a bug somewhere? > > its a bug, ticket 2571 is created and fixed, > http://www.sqlalchemy.org/trac/ticket/2571 >

[sqlalchemy] drop index bug?

2012-09-24 Thread Bruno Binet
.c.name) i.create() i.drop() After looking at the code, it looks like `DDLCompiler.visit_drop_index` does not prefix the index name with the schema. So for my example, the sql produced is "DROP INDEX my_idx" instead of "DROP INDEX app.my_idx". Should I report this as a bug somew