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.
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
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
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
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
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:
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
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'
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
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
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
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',
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
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
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.
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
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
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 =
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).
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
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
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
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
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,
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,
25 matches
Mail list logo