Re: [SQLObject] very newbie: how to start with SQLObject ?

[Stef M. <ste...@gm...>]

Oleg Broytmann wrote:
> On Tue, Feb 03, 2009 at 06:14:24PM +0100, Stef Mientki wrote:
>   
>>>   Well, we use sqlite:///path/to/data.base syntax with ':' replaced by
>>> '|': sqlite:///C|program/data.db. This is how we do it:
>>>       
>> This is absolutely weird
>>     
>
>    Not at all. This is how web-browsers used to support file://-URLs on
> w32.
>   
That must be a long time ago,
for decades I use "file:///D:/...."
>   
>> There seems to have been more problems with table names and columns names,
>> but the above states clear that underscores are allowed.
>> The error complains about invalid column names,
>> so apparently it has read the table information,
>> and the table names are so simple 'Field1', 'Field2' , etc
>>
>> Or I'm doing something completely wrong,
>> or I do things different from other users ( e.g. starting with already
>> existing database),
>> or no-one has really tested SQLObject with sqlite3.
>> Any other possibilities ?  ;-)
>>     
>
>    Or trying to use SQLObject with a database that SQLObject fails to
> handle. SQLObject has some requirements, most notable - there have to be
> a primary key in the table, of type INT or CHAR, with the name 'id'; if
> it's not named 'id' you have to provide an explicit name:
>
> class MyTable(SQLObject):
>    class sqlmeta:
>       idName = 'my_id'
>
>   
That explains.
thanks Oleg,

cheers,
Stef