[sqlalchemy] Oracle Views/DatabaseLink and declarative

2010-02-24 Thread Christian Klinger
Hi, i need some help/advice in defining my classes with the declarative syntax from sqlalchemy. This is the current situation: I have one table in my Database which is a Oracle Database Link. The name of this Database Link is a...@adr. I created a view for this Database Link called

RE: [sqlalchemy] reflecting schema just on a single table

2010-02-24 Thread King Simon-NFHD78
-Original Message- From: sqlalchemy@googlegroups.com [mailto:sqlalch...@googlegroups.com] On Behalf Of Paul Rigor (uci) Sent: 24 February 2010 00:23 To: sqlalchemy Subject: [sqlalchemy] reflecting schema just on a single table Hi, Is there anyway to use a metadata object just

RE: [sqlalchemy] Oracle Views/DatabaseLink and declarative

2010-02-24 Thread King Simon-NFHD78
Christian Klinger wrote: [SNIP] Ok now a second table comes into the game. The name of this table is BTeilnehmer. As you can see this table has a ForeignKey to Unternehmen.mnr. I use a seperate metadata BaseC for it because i want to create this table. Hi, I don't know if the seperate

Re: [sqlalchemy] Re: How to make relation to same table

2010-02-24 Thread flya flya
Yes, this is what I wonder, but my code use orm, declarative_base(), not mapper, I write these code follow the document's example, it can't work too, what's wrong with my code? Base = declarative_base() class Page(Base): __tablename__ = 'pages' id = Column(Integer, primary_key=True)

[sqlalchemy] Re: Joining an Aliased Table Ignored

2010-02-24 Thread Affect
This works great! Thanks, Michael. In a related note, I was wondering why I wasn't able to make this explicit workaround myself. It is because I don't understand the SA abstractions well enough. I hope that your upcoming book helps in this regard (SQLAlchemy: Database Access Using Python). It's

[sqlalchemy] server_version_info

2010-02-24 Thread Gregg Lind
Is there a nice way to get server_version_info from an existing connection or engine? Right now it looks quite buried in (for pg): sqlalchemy.database.postgres.PGDialiect().server_version_info(myconnection). -- You received this message because you are subscribed to the Google Groups

Re: [sqlalchemy] server_version_info

2010-02-24 Thread Michael Trier
Hello, On Feb 24, 2010, at 11:59 AM, Gregg Lind wrote: Is there a nice way to get server_version_info from an existing connection or engine? Right now it looks quite buried in (for pg): sqlalchemy.database.postgres.PGDialiect().server_version_info(myconnection). The dialect contains the

[sqlalchemy] Re: Support for IBM AS/400 database

2010-02-24 Thread st...@mailbag.com
Does anyone have a clue on this error? Is it due to a change in SQLAlchemy between 0.4.0 and 0.5.8? -Jim On Feb 19, 5:02 pm, Jim Steil j...@qlf.com wrote: Here is the traceback I get when following that recipe...   import sqlalchemy   from sqlalchemy import *   import ibm_db_sa.ibm_db_sa

Re: [sqlalchemy] Re: Support for IBM AS/400 database

2010-02-24 Thread Lukasz Szybalski
I would check with ibm_db_sa mailing list. Maybe their example is out of date, or there is a fix for it? Lucas On Wed, Feb 24, 2010 at 1:51 PM, st...@mailbag.com j...@qlf.com wrote: Does anyone have a clue on this error?  Is it due to a change in SQLAlchemy between 0.4.0 and 0.5.8? -Jim

[sqlalchemy] Slow running

2010-02-24 Thread dusans
Hi. I got this simple query thats running very slow: Im working on sqlalchemy 0.6 0.6beta1, sqlite3, python 2.5, windows xp 1. I've addet News.[title] to make it run faster, but its still very very slow == Code (10 seconds) == : Session.query(News.title, KernelResults).\

Re: [sqlalchemy] Re: How to make relation to same table

2010-02-24 Thread Michael Bayer
On Feb 24, 2010, at 6:14 AM, flya flya wrote: Yes, this is what I wonder, but my code use orm, declarative_base(), not mapper, I write these code follow the document's example, it can't work too, what's wrong with my code? Base = declarative_base() class Page(Base): __tablename__ =

Re: [sqlalchemy] Re: Joining an Aliased Table Ignored

2010-02-24 Thread Michael Bayer
On Feb 24, 2010, at 10:21 AM, Affect wrote: This works great! Thanks, Michael. In a related note, I was wondering why I wasn't able to make this explicit workaround myself. It is because I don't understand the SA abstractions well enough. I hope that your upcoming book helps in this

Re: [sqlalchemy] Slow running

2010-02-24 Thread Michael Bayer
On Feb 24, 2010, at 6:15 PM, dusans wrote: Hi. I got this simple query thats running very slow: Im working on sqlalchemy 0.6 0.6beta1, sqlite3, python 2.5, windows xp 1. I've addet News.[title] to make it run faster, but its still very very slow == Code (10 seconds) == :

Re: [sqlalchemy] Re: Support for IBM AS/400 database

2010-02-24 Thread Jim Steil
I went in to the ibm_db_sa code and made a change to make it compatible with 0.5.8. But, now I'm getting another error that I need to run down that is not python-related. I'm missing db2cli.dll on my system and don't know where I'm supposed to get it from. And, reading about it online leads