Re: [sqlalchemy] Sequence on non primary_key and import data

2012-01-17 Thread Martijn Moeling
This is one of the reasons I'm dropping MySQL, at the end it just generates trouble.. I was hoping to get an easy two platform fix for this, but there just is not. So moving to PG needs to done quickly here. Thing is I want PG to be installed on my Workstation, exactly like on Lion Server….

[sqlalchemy] Re: Elixir: Enum and accented characters (non-ASCII character)

2012-01-17 Thread Pierre Bossé
Thank you Michael for your answers, but This does not work even with the UFT-8 encoding. I changed my program with utf-8: = # -*- coding: utf-8 -*- from elixir import * from sqlalchemy import create_engine class TestEnum(Entity):

[sqlalchemy] Sessions, threads, cherrypy visibility

2012-01-17 Thread John Hufnagle
Didn't see an answer to this in the discussions. I have: 1. slqlchemy 0.7.3, cherrypy and mysql Ver 14.14 Distrib 5.5.18, for osx10.6 2. a cherry py application that initializes the scoped session as: Session = scoped_session(sessionmaker(bind=engine)) 3a. Passes that Session instance into a

Re: [sqlalchemy] Re: Elixir: Enum and accented characters (non-ASCII character)

2012-01-17 Thread Michael Bayer
On Jan 17, 2012, at 7:46 AM, Pierre Bossé wrote: Thank you Michael for your answers, but This does not work even with the UFT-8 encoding. 2012-01-17 07:10:03,405 INFO sqlalchemy.engine.base.Engine CREATE TABLE TEST_ENUM ( id INTEGER NOT NULL, MY_ENUM NVARCHAR2(100),

Re: [sqlalchemy] Sessions, threads, cherrypy visibility

2012-01-17 Thread Michael Bayer
On Jan 17, 2012, at 9:03 AM, John Hufnagle wrote: Didn't see an answer to this in the discussions. I have: 1. slqlchemy 0.7.3, cherrypy and mysql Ver 14.14 Distrib 5.5.18, for osx10.6 2. a cherry py application that initializes the scoped session as: Session =

Re: [sqlalchemy] Re: Elixir: Enum and accented characters (non-ASCII character)

2012-01-17 Thread Michael Bayer
On Jan 17, 2012, at 12:29 PM, Michael Bayer wrote: OK but very significantly, the behavior has changed. SQLAlchemy is now sending in the correct DDL to Oracle.What remains is whether or not it gets to cx_oracle in the best way possible as well as if cx_oracle does the right thing

[sqlalchemy] Re: datetime to utc

2012-01-17 Thread Mason
This is great!! Wasn't aware of this at all. Is the something that does utc part db dependent? I am only familiar with mysql, so if I change to other db in the future, and the convert to utc function is called 'convert_to_tz' instead of 'convert_tz', will this break? I know I can access the

Re: [sqlalchemy] Re: datetime to utc

2012-01-17 Thread Michael Bayer
On Jan 17, 2012, at 1:35 PM, Mason wrote: This is great!! Wasn't aware of this at all. Is the something that does utc part db dependent? I am only familiar with mysql, so if I change to other db in the future, and the convert to utc function is called 'convert_to_tz' instead of

[sqlalchemy] Sessions, transactions and executing individual statements

2012-01-17 Thread David Beitey
After running a number of arbitrary SQL statements upon a sqlalchemy session, I'm finding that when I attempt to commit the transaction, the changes which are in the session, get lost. I'm sure I'm missing something, but not sure what. Essentially, what I have looks like this: import

Re: [sqlalchemy] Sessions, transactions and executing individual statements

2012-01-17 Thread Michael Bayer
On Jan 17, 2012, at 10:16 PM, David Beitey wrote: After running a number of arbitrary SQL statements upon a sqlalchemy session, I'm finding that when I attempt to commit the transaction, the changes which are in the session, get lost. I'm sure I'm missing something, but not sure what.