[sqlalchemy] Re: Please add some __len__ methods

2007-10-23 Thread klaus
Seems like I am learning more python on this list than I ever wanted... On 22 Okt., 15:37, Michael Bayer [EMAIL PROTECTED] wrote: On Oct 22, 2007, at 6:32 AM, klaus wrote: Hi all, I wonder why some classes/objects implement part of a list interface - but without a __len__ method.

[sqlalchemy] loading of table attributes into orm object

2007-10-23 Thread Brendan Arnold
hi there, i'm trying to construct a query using the or_ function as follows, or_(model.Sample.name == '') Traceback (most recent call last): File console, line 1, in ? AttributeError: type object 'Sample' has no attribute 'name' however when i instantiate an unrelated instance this now

[sqlalchemy] turbogears, sqlalchemy and utf8

2007-10-23 Thread Lukasz Szybalski
Hello, I came across this errors when I was working with unicode mysql database. My record would not get displayed and I would get: UnicodeDecodeError: 'utf8' codec can't decode byte 0xbf in position 261: unexpected code byte I was referred to

[sqlalchemy] Re: turbogears, sqlalchemy and utf8

2007-10-23 Thread Marco Mariani
Lukasz Szybalski wrote: dev.cfg has sqlalchemy.dburi=mysql://user:[EMAIL PROTECTED]:3306/dbname sqlalchemy.convert_unicode = True --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

[sqlalchemy] Re: turbogears, sqlalchemy and utf8

2007-10-23 Thread Lukasz Szybalski
On 10/23/07, Marco Mariani [EMAIL PROTECTED] wrote: Lukasz Szybalski wrote: dev.cfg has sqlalchemy.dburi=mysql://user:[EMAIL PROTECTED]:3306/dbname I did this in dev.cfg : sqlalchemy.convert_unicode = True sqlalchemy.dburi=mysql://user:[EMAIL PROTECTED]:3306/dbname now I get a

[sqlalchemy] Re: multiple inserts of sqlalchemy instances?

2007-10-23 Thread Lukasz Szybalski
On 10/22/07, Barry Hart [EMAIL PROTECTED] wrote: I've written code similar to this with no problems. Are you using assign_mapper? If so, the save() call is unnecessary. Do you get this error on the first object or on some subsequent object? Barry - Original Message From:

[sqlalchemy] Re: multiple inserts of sqlalchemy instances?

2007-10-23 Thread Michael Bayer
On Oct 23, 2007, at 10:16 AM, Lukasz Szybalski wrote: I am having an issue with a second new.flush() Does this require multiple sessions for each save? I can't find any documentation on multiple inserts with assign_mapper. Lucas Your best bet is to use version 0.4 and to not use any

[sqlalchemy] Re: loading of table attributes into orm object

2007-10-23 Thread Michael Bayer
On Oct 23, 2007, at 7:18 AM, Brendan Arnold wrote: hi there, i'm trying to construct a query using the or_ function as follows, or_(model.Sample.name == '') Traceback (most recent call last): File console, line 1, in ? AttributeError: type object 'Sample' has no attribute 'name'

[sqlalchemy] Re: turbogears, sqlalchemy and utf8

2007-10-23 Thread jason kirtland
Lukasz Szybalski wrote: On 10/23/07, Marco Mariani [EMAIL PROTECTED] wrote: Lukasz Szybalski wrote: dev.cfg has sqlalchemy.dburi=mysql://user:[EMAIL PROTECTED]:3306/dbname I did this in dev.cfg : sqlalchemy.convert_unicode = True sqlalchemy.dburi=mysql://user:[EMAIL

[sqlalchemy] Re: multiple inserts of sqlalchemy instances?

2007-10-23 Thread Lukasz Szybalski
On 10/23/07, Michael Bayer [EMAIL PROTECTED] wrote: On Oct 23, 2007, at 10:16 AM, Lukasz Szybalski wrote: I am having an issue with a second new.flush() Does this require multiple sessions for each save? I can't find any documentation on multiple inserts with assign_mapper. Lucas

[sqlalchemy] business object backend

2007-10-23 Thread jean-marc pouchoulon
hello all, We are using business object , a decisionnal layer upon our databases. I can connect to BO backend with odbc and execute sql order. is SQLAlchemy is able to connect to an ODBC driver other than MSSQL driver? I try also with mysql odbc driver unsuccessfully. thanks for your

[sqlalchemy] case inconsistency in reflected column names between mac and windows

2007-10-23 Thread Travis Kriplean
Hello, We're running into a problem with case in the reflected column names between mac and windows both using sqlalchemy 0.4.0. For example, in our mysql database, we have a table with columns named END_YEAR and DESCRIPTION. On a windows box: print table.c ['table.END_YEAR',

[sqlalchemy] Re: loading of table attributes into orm object

2007-10-23 Thread Brendan Arnold
yes you are right, i was using 0.4beta5, i have upgraded to 0.4.0 and it works as expected. thanks! brendan On 10/23/07, Michael Bayer [EMAIL PROTECTED] wrote: On Oct 23, 2007, at 7:18 AM, Brendan Arnold wrote: hi there, i'm trying to construct a query using the or_ function as

[sqlalchemy] Re: case inconsistency in reflected column names between mac and windows

2007-10-23 Thread Travis Kriplean
It appears that this only occurs on macs running a ppc processor, not an intel processor. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] Re: case inconsistency in reflected column names between mac and windows

2007-10-23 Thread Lukasz Szybalski
On 10/23/07, Travis Kriplean [EMAIL PROTECTED] wrote: It appears that this only occurs on macs running a ppc processor, not an intel processor. I run into the same problem when I transfer mysql data over to Linux. Windows mysql is case insensitive while linux version cares what case it is.

[sqlalchemy] Re: multiple inserts of sqlalchemy instances?

2007-10-23 Thread Wes Duff
I have done something like this. I am using active mapper. I am new to all of this as well, but see if this helps any a = model.Document() a.first_name = kw.get('first_name') a.last_name = kw.get('last_name') b = model.Body() b.body_name = kw.get('body_name') And that is all I was doing of

[sqlalchemy] Re: multiple inserts of sqlalchemy instances?

2007-10-23 Thread Michael Bayer
On Oct 23, 2007, at 1:07 PM, Lukasz Szybalski wrote: So you cannot do multiple writes using extensions assign_mapper, mapper aka python class mapped to sql table? you can do anything with assign_mapper, just that its usage is going to be more confusing since it auto-saves objects, and

[sqlalchemy] ActiveMapper -- Questions - NEED DOCUMENTATION

2007-10-23 Thread Wes Duff
Hello, I was wondering if anyone can tell me how to access a column using active mapper. Or maybe you might know of a good documentational site for ActiveMapper? Here is a table example class Document(ActiveMapper): class mapping: __table__='document' id =

[sqlalchemy] Re: business object backend

2007-10-23 Thread Michael Bayer
we might be supporting mysql and sybase via ODBC at some point, but supporting pyodbc versus the more native drivers such as psycopg2 and mysqldb is a non-trivial task (not sure about the stability of odbc for DB's like oracle, postgres, I doubt one even exists for sqlite or firebird).

[sqlalchemy] Re: ActiveMapper -- Questions - NEED DOCUMENTATION

2007-10-23 Thread Michael Bayer
On Oct 23, 2007, at 4:42 PM, Wes Duff wrote: a = model.Docment.c.title should be that one Would also help if there were some good documentation out there for ActiveMapper. P.S. I cannot change to something else. I must stay with ActiveMapper ActiveMapper is unmaintained. I can't

[sqlalchemy] Re: ActiveMapper -- Questions - NEED DOCUMENTATION

2007-10-23 Thread Wes Duff
I am working for a company right now that has all of thier database items on Active Mapper. I would love to change to something with more documentation. We plan on changing soon, but for right now I have to get this working. Thanks On 10/23/07, Michael Bayer [EMAIL PROTECTED] wrote: On Oct

[sqlalchemy] Re: ActiveMapper -- Questions - NEED DOCUMENTATION

2007-10-23 Thread Wes Duff
Thanks alot for your info. Much appreciated. On 10/23/07, Wes Duff [EMAIL PROTECTED] wrote: I am working for a company right now that has all of thier database items on Active Mapper. I would love to change to something with more documentation. We plan on changing soon, but for right now I

[sqlalchemy] Re: case inconsistency in reflected column names between mac and windows

2007-10-23 Thread jason kirtland
Travis Kriplean wrote: Hello, We're running into a problem with case in the reflected column names between mac and windows both using sqlalchemy 0.4.0. For example, in our mysql database, we have a table with columns named END_YEAR and DESCRIPTION. On a windows box: print table.c

[sqlalchemy] In a many to many relationship how to access some properties of that relationship

2007-10-23 Thread Jason
Greetings, for my model I have this: user_table=Table(users, metadata, Column(id, Integer, primary_key=True), Column(gender, Unicode), Column(age, Integer, ForeignKey(ages.id)), Column(occupation, Integer, ForeignKey(occupations.id)), Column(zipCode,

[sqlalchemy] Re: can't get pool_recycle to prevent gone away errors

2007-10-23 Thread jeffcodefork
Yes! That's it. Thanks so much, Jeff On Oct 23, 1:44 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Oct 23, 2007, at 1:36 PM, jeffcodefork wrote: Hi, I'm running SA 0.4 on 3 instances of cherrypy, each with 10 threads. Each thread creates its own Session object when it initializes,