sqlobject-discuss

[SQLObject] Name of 'id' field

[Frank B. <fb...@fo...>]

Hi,

this mail is to test the new list, but also to ask a real question:

I want to use SQLObject with a sql-table that already has a column called
"id", which is not autoincrement. Now I could use SQLObject in read-only
mode, which is okay, since I don't want to write currently. But in
gerneral, I would like it if the id-table's name was configurable, like
  
  __id__ = 'SO_id'

In my special case, the data including "id" is regularly imported from
another db (Filemaker on MacOS-9) via CSV into mysql ("import file").
Updates should overwrite rows that are identified by "id".

ciao
-- 
Frank Barknecht

Re: [SQLObject] Name of 'id' field

[Ian B. <ia...@co...>]

New feature in CVS: add an attribute _idName that gives the id column's
name, like:

class MyTable(SQLObject):
    _idName = "SO_id"

On Fri, 2003-02-28 at 06:37, Frank Barknecht wrote:
> Hi,
> 
> this mail is to test the new list, but also to ask a real question:
> 
> I want to use SQLObject with a sql-table that already has a column called
> "id", which is not autoincrement. Now I could use SQLObject in read-only
> mode, which is okay, since I don't want to write currently. But in
> gerneral, I would like it if the id-table's name was configurable, like
>   
>   __id__ = 'SO_id'
> 
> In my special case, the data including "id" is regularly imported from
> another db (Filemaker on MacOS-9) via CSV into mysql ("import file").
> Updates should overwrite rows that are identified by "id".
> 
> ciao