[sqlalchemy] Re: getting referenced *class* from relation

2009-03-17 Thread Ants Aasma
On Mar 17, 12:17 am, Alessandro Dentella san...@e-den.it wrote: Now I want to get User class starting from Project and 'staff'. Project.__mapper__.get_property('manager')._get_target().class_ seems to do that but the leading underscore in _get_target suggest it's private, so I

[sqlalchemy] Re: getting referenced *class* from relation

2009-03-17 Thread sandro dentella
thanks! *:-) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to

[sqlalchemy] Re: ProgrammingError: (ProgrammingError) Cannot operate on a closed cursor. None None

2009-03-17 Thread Timothy N. Tsvetkov
I have the same problem, I've installed pysqlite (2.5.5) from sources, and after I've removed it everything is ok. I've tried to install the last one because I had a common problem: ProgrammingError?: (ProgrammingError?) You must not use 8-bit bytestrings unless you use a text_factory that can

[sqlalchemy] Re: ProgrammingError: (ProgrammingError) Cannot operate on a closed cursor. None None

2009-03-17 Thread Michael Bayer
Timothy N. Tsvetkov wrote: I have the same problem, I've installed pysqlite (2.5.5) from sources, and after I've removed it everything is ok. I've tried to install the last one because I had a common problem: ProgrammingError?: (ProgrammingError?) You must not use 8-bit bytestrings unless

[sqlalchemy] Re: ProgrammingError: (ProgrammingError) Cannot operate on a closed cursor. None None

2009-03-17 Thread Michael Bayer
OK scratch that, it is in fact fetchone() raising an error on a closed cursor that's the difference, the PRAGMA behavior, to my surprise, was always there. an adjustment to the sqlite dialect is made in r5846 for 0.5 and r5847 for the 0.4 branch. A release for 0.5 should be made before

[sqlalchemy] Python 3 port

2009-03-17 Thread Arc Riley
Hey guys We're looking for a database-agnostic ORM package to build the standard Concordance database classes on. This requires Py3 support. http://concordance-xmpp.org/ Yes, yes, there aren't many DB packages for Py3 yet. This is exactly why we're looking for something that's

[sqlalchemy] Re: Python 3 port

2009-03-17 Thread Michael Bayer
Arc Riley wrote: Yes, yes, there aren't many DB packages for Py3 yet. This is exactly why we're looking for something that's database-agnostic; right now we're limited to sqlite but preferably our classes shouldn't care what database is being used and can just as readily be used with

[sqlalchemy] Re: Python 3 port

2009-03-17 Thread Arc Riley
Grr - you mean trunk *isn't* the head development tree in svn? Frustrating in wasted time in duplicated effort. Can you please post this on the website so others don't make the same mistake? Ok. I can chalk this up to practice and a learning experience. Yes - we're looking to use sqlalchemy in

[sqlalchemy] SQL Syntax Error

2009-03-17 Thread mhearne808[insert-at-sign-here]gmail[insert-dot-here]com
I have a reasonably complex schema that I attempting to manage with SQLAlchemy. I just added some tables in code and tried re-creating the database, and got an error that looks like this: ## sqlalchemy.exc.ProgrammingError: (ProgrammingError) (1064, You have an error in your SQL

[sqlalchemy] Re: Python 3 port

2009-03-17 Thread Michael Bayer
Arc Riley wrote: Grr - you mean trunk *isn't* the head development tree in svn? Frustrating in wasted time in duplicated effort. Can you please post this on the website so others don't make the same mistake? trunk is the head dev tree in SVN, but we like to have trunk always passing all

[sqlalchemy] Re: SQL Syntax Error

2009-03-17 Thread Michael Bayer
the String() type requires a length on MySQL, since MySQL has no length-less VARCHAR construct. mhearne808[insert-at-sign-here]gmail[insert-dot-here]com wrote: I have a reasonably complex schema that I attempting to manage with SQLAlchemy. I just added some tables in code and tried

[sqlalchemy] Re: Python 3 port

2009-03-17 Thread Arc Riley
the site is in need of updating regarding 0.6's existence but usually people come in and chat on the list or IRC before starting major development initiatives, but sorry, we'll add it. Actually I've been asking on IRC for two days re: Py3. Nobody seemed to know anything about this.

[sqlalchemy] Join on a non-normalized model

2009-03-17 Thread Damien
Hello list, I need some advice on setting a one-to-many join in my particular case (non-normalized db model) I have the following situation: - 2 tables with a 1..n join - note: the references table field is not a primary key (I have to work on a non-normalized model, that's life) - I need to

[sqlalchemy] Re: Join on a non-normalized model

2009-03-17 Thread Michael Bayer
I don't see anything wrong with your model and no it shouldn't matter that watersheds.name is not a primary key. expand upon the meaning of not effective here. Damien wrote: Hello list, I need some advice on setting a one-to-many join in my particular case (non-normalized db model)

[sqlalchemy] Limit invalidates query results on view - 0.4.8

2009-03-17 Thread Jonathan Vanasco
I have query on a view that looks like this: query= dbSession.query(_class).filter('entry_status = 2').order_by ( _class.c.entry_authored_on.desc() ).limit(3).offset(0) results= query.all() print query print - - - - - - print results print == == == this always returns no results. however

[sqlalchemy] Re: Limit invalidates query results on view - 0.4.8

2009-03-17 Thread Michael Bayer
try setting echo='debug'. it usually tells all. if any columns in the primary key are NULL, the query won't return an object. If you have partially null primary keys, set allow_null_pks=True on your mapper. On Mar 17, 2009, at 8:08 PM, Jonathan Vanasco wrote: I have query on a