[SQLObject] Using existing databases in read-only mode

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

Hallo,

I'm trying to clean up a project and use SQLObject as DB-wrapper. The
tables are filled and I only want to use SO in read-only mode.

Now I have a probably very stupid question: How do I instantiate a new
SQLObject given an id.

I'm trying something like this, which feels natural, but doesn't work:

from SQLObject import *

SQLProductFields = [Col('id'), Col('description'), Col('format'),
	Col('artist'), Col('category'), Col('title'), Col('price'),
	Col('label')]

class Normal(SQLObject):
	_columns = SQLProductFields
	_connection = DBConnection.MySQLConnection(host='localhost', db='fbar', 
		user='foo', passwd='')

entry=45
n = Normal(entry)   # error here!

Traceback (most recent call last):
  File "SQLText.py", line 9, in ?
    n = Normal(45)
  File "/usr/lib/python2.2/site-packages/SQLObject/SQLObject.py", line 419, in __new__
    val._init(id, connection)
  File "/usr/lib/python2.2/site-packages/SQLObject/SQLObject.py", line 428, in _init
    self.id = id
  File "<string>", line 1, in <lambda>
  File "/usr/lib/python2.2/site-packages/SQLObject/SQLObject.py", line 456, in _SO_setValue
    self._SO_writeLock.acquire()
AttributeError: 'Normal' object has no attribute '_SO_writeLock'

I'm probably doing something totally wrong, but I don't get, what...
I'm using SO from half an hour ago.
Ciao
-- 
 Frank Barknecht                               _ ______footils.org__