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

[Oleg B. <ph...@ph...>]

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.

> 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'

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.