[sqlalchemy] Re: Oracle timestamp and postgres datetime compatibility

2009-12-03 Thread Nicola Lacquaniti
I tried the same thing, but I obtain an 'ORA-01843: not a valid month' message from the backend. This is my model: class BaseObject(Base, Dictionaryable): __tablename__ = 'baseobj' id = Column(Integer, Sequence((__tablename__+'id_seq')[-30:]), autoincrement=True,

[sqlalchemy] how to change a database

2009-12-03 Thread Peter
Hi Lets suppose I created an engine on database 'foo' and I want to create a database 'bar' and then do my work on 'bar'. What is the recommended way to do this ? connection.execute('CREATE DATABASE IF NOT EXISTS bar') connection.execute('USE bar') The former command succeeds with a warning (

[sqlalchemy] FlushError: instance is in unsaved, pending instance...

2009-12-03 Thread Alessandro Dentella
Hi, I'm stuck with the code below raise FlushError complaining: Traceback (most recent call last): File stdin, line 49, in module File /misc/src/sqlalchemy/sqlalchemy/lib/sqlalchemy/orm/session.py, line 673, in commit self.transaction.commit() File

[sqlalchemy] dealing with multiple databases when using declarative

2009-12-03 Thread Victor Olex
By database we refer to a separate instance (could be on another server) of equvalent database i.e. production and development environments. Using sqlalchemy.ext.declarative, what would be a correct pattern to enable one model to connect to two equivalent databases? Consider: --- model.py ---

Re: [sqlalchemy] how to change a database

2009-12-03 Thread chaouche yacine
Why not create a different engine for that database ? --- On Thu, 12/3/09, Peter vm...@mycircuit.org wrote: From: Peter vm...@mycircuit.org Subject: [sqlalchemy] how to change a database To: sqlalchemy@googlegroups.com Date: Thursday, December 3, 2009, 4:37 AM Hi Lets suppose I created

[sqlalchemy] Requirement for Oracle Apps Consultants in Saudi Arabia

2009-12-03 Thread Imran
Connexion Technologies is a Business Consulting, IT Solutions and Services company with operations in UAE, Qatar, Bahrain, KSA India. We are looking for Oracle Apps Consultants for our client in Saudi Arabia Job Description: Broad Functions: •Functional lead in the department to handle

Re: [sqlalchemy] Re: Oracle timestamp and postgres datetime compatibility

2009-12-03 Thread Michael Bayer
On Dec 3, 2009, at 6:12 AM, Nicola Lacquaniti wrote: I tried the same thing, but I obtain an 'ORA-01843: not a valid month' message from the backend. can you try 0.6 trunk please, and ensure you're on the latest version of cx_oracle as well. Oracle test coverage is not at 100% in 0.5 but is

Re: [sqlalchemy] FlushError: instance is in unsaved, pending instance...

2009-12-03 Thread Michael Bayer
On Dec 3, 2009, at 1:23 PM, Alessandro Dentella wrote: Hi, I'm stuck with the code below raise FlushError complaining: Traceback (most recent call last): File stdin, line 49, in module File /misc/src/sqlalchemy/sqlalchemy/lib/sqlalchemy/orm/session.py, line 673, in commit

Re: [sqlalchemy] dealing with multiple databases when using declarative

2009-12-03 Thread Michael Bayer
On Dec 3, 2009, at 2:39 PM, Victor Olex wrote: By database we refer to a separate instance (could be on another server) of equvalent database i.e. production and development environments. Using sqlalchemy.ext.declarative, what would be a correct pattern to enable one model to connect to