[sqlalchemy] SA (4.0) mssql table creation problems. No Python Errors?

2007-10-19 Thread Eddie
Hi guys. Thanks for all the help on my previous topic (MS Access querying). I have another new-userish question about mssql. I wrote some working code the other day(meaning connection was set up correctly I hope?), and it doesn't work anymore today. I tried retracing my steps, but I can't seem

[sqlalchemy] Complex objects using sqlalchemy

2007-10-19 Thread mhearne808[insert-at-sign-here]gmail[insert-dot-here]com
Does anyone have any examples of using more complex classes with sqlalchemy? I'd like to have a user interface for my objects that hides as much of the complexity of sqlalchemy as possible. Using the users/addresses example from the sqlalchemy website (http://

[sqlalchemy] Re: vote for Python - PLEASE!

2007-10-19 Thread Monty Taylor
Daniel Haus wrote: Looks like you're frighteningly successful. You're right, python could use much more love, but look at this! Obviously the poll is not representative anymore, is it... Yeah - a little skewed there. On the other hand, the poll wasn't exactly very scientific in the first

[sqlalchemy] Re: SA (4.0) mssql table creation problems. No Python Errors?

2007-10-19 Thread Eddie
sounds like something is crashing inside the DBAPI driver. try taking whatever SQL output is printed and trying it manually. Doesn't even make it that far. I shortened the program even more to this and have the same problem: from sqlalchemy import * connectionString = 'mssql://sa:[EMAIL

[sqlalchemy] Re: SA (4.0) mssql table creation problems. No Python Errors?

2007-10-19 Thread Michael Bayer
On Oct 19, 2007, at 8:23 PM, Eddie wrote: 2007-10-19 16:26:45,437 INFO sqlalchemy.engine.base.Engine.0x..d0 {} 2007-10-19 16:26:45,437 INFO sqlalchemy.engine.base.Engine.0x..d0 COMMIT the end (--END--) yeah this is something configurational with your DBAPI. anything wrong on the

[sqlalchemy] Re: Complex objects using sqlalchemy

2007-10-19 Thread Michael Bayer
On Oct 19, 2007, at 6:01 PM, mhearne808[[insert-at-sign-here]]gmail [[insert-dot-here]]com wrote: Does anyone have any examples of using more complex classes with sqlalchemy? I'd like to have a user interface for my objects that hides as much of the complexity of sqlalchemy as possible.

[sqlalchemy] Re: SA (4.0) mssql table creation problems. No Python Errors?

2007-10-19 Thread Michael Bayer
On Oct 19, 2007, at 5:52 PM, Eddie wrote: Hi guys. Thanks for all the help on my previous topic (MS Access querying). I have another new-userish question about mssql. I wrote some working code the other day(meaning connection was set up correctly I hope?), and it doesn't work anymore

[sqlalchemy] Re: Update statement with join for Mysql

2007-10-19 Thread Michael Bayer
On Oct 18, 2007, at 9:23 AM, Karl Pflästerer wrote: Hi, am I wrong, or is it at the moment not possible to write an update statement for Mysql which includes multiple tables like that: import sqlalchemy.sql as sql query = sql.text(UPDATE shows AS s INNER JOIN show_artendef

[sqlalchemy] Re: Connecting to a Microsoft Access Database

2007-10-19 Thread Paul Johnston
Hi, access:///VMCPDB.mdb Three slashes! The hostname is empty. And you want the full path to the .mdb file. Paul On 10/18/07, Eddie [EMAIL PROTECTED] wrote: Latest Version still gives me problems still in the same engine = create_engine('access://VMCPDB') line. Debug looks like the

[sqlalchemy] Re: Reflecting Tables does not work with SQLite

2007-10-19 Thread Markus Gritsch
On 10/18/07, Michael Bayer [EMAIL PROTECTED] wrote: sqlite doesnt have DECIMAL or TINYINT types defined. sqlite3 instead as a somewhat bizarre way of indicating types, where you can use any string you want to indicate a type and it uses search expressions on the string to determine its

[sqlalchemy] Re: vote for Python - PLEASE!

2007-10-19 Thread Daniel Haus
Looks like you're frighteningly successful. You're right, python could use much more love, but look at this! Obviously the poll is not representative anymore, is it... --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups