SQLObject - Connect to established DB with non-int 'id' field

[Sean DiZazzo]

Hi all,

I am just beginning with TurboGears and have run into a problem with
SQLObject.

I'm trying to connect to an established mysql DB, and use TurboGears
to display results from the DB only. The problem is that the DB
already has an 'id' field that is a string as opposed to an int.
SQLObject complains because it wants to use the id field for it's own
purposes.

How can I use TurboGears to get data out of this DB?

Thanks in advance.

~Sean

 

[Diez B. Roggisch]

Hi all,

I am just beginning with TurboGears and have run into a problem with
SQLObject.

I'm trying to connect to an established mysql DB, and use TurboGears
to display results from the DB only. The problem is that the DB
already has an 'id' field that is a string as opposed to an int.
SQLObject complains because it wants to use the id field for it's own
purposes.

How can I use TurboGears to get data out of this DB?

http://sqlobject.org/FAQ.html#non-integer-ids

While I personally prefer SQLObject over SQLAlchemy, the latter has
better legacy-database-support. Maybe a switch would be the better solution.

Diez

 

[Sean DiZazzo]

http://sqlobject.org/FAQ.html#non-integer-ids

While I personally prefer SQLObject over SQLAlchemy, the latter has
better legacy-database-support. Maybe a switch would be the better solution.

Diez

doh...I swear I looked there! This time I see it. Thanks.

~Sean

 

[Pradeep Jindal]

Hi all,

I am just beginning with TurboGears and have run into a problem with
SQLObject.

I'm trying to connect to an established mysql DB, and use TurboGears
to display results from the DB only. The problem is that the DB
already has an 'id' field that is a string as opposed to an int.
SQLObject complains because it wants to use the id field for it's own
purposes.

How can I use TurboGears to get data out of this DB?

Thanks in advance.

~Sean

I know I am not exactly answering your question, but its much better to use
sqlalchemy when you already have the databases setup. And especially when you
can not make any changes to existing database schemas.

- Pradeep