[SQLObject] Problem upgrading from SQLite 3.2.1 to 3.3.4

[Mike Orr <sluggoster@gm...>]

I have a TurboGears application using SQLObject, and upgraded from
SQLite 3.2.1 to 3.3.4 to see if it would solve a performance problem
[1].  Instead I get an exception (below) whenever I hit a page that
does any query.  If I downgrade SQLite, the old behavior returns.  I'm
using SQLObject 0.7.1dev_r1613 with TurboGears 0.9a1.  Is there a
version of SQLObject which does better with SQLite 3.3.4?

Page handler: <bound method ChemicalDirectory.default of
<cameosd.controllers.ChemicalDirectory object at 0xb7474d2c>>
Traceback (most recent call last):
  File "/usr/local/lib/python2.4/CherryPy-2.2.0betadev_r980-py2.4.egg/cherr=
ypy/_cphttptools.py",
line 99, in _run
    self.main()
  File "/usr/local/lib/python2.4/CherryPy-2.2.0betadev_r980-py2.4.egg/cherr=
ypy/_cphttptools.py",
line 248, in main
    body =3D page_handler(*virtual_path, **self.params)
  File "<string>", line 3, in default
  File "/usr/local/lib/python2.4/TurboGears-0.9a1-py2.4.egg/turbogears/cont=
rollers.py",
line 210, in expose
    tg_format, html, fragment, *args, **kw)
  File "/usr/local/lib/python2.4/TurboGears-0.9a1-py2.4.egg/turbogears/data=
base.py",
line 193, in run_with_transaction
    retval =3D func(*args, **kw)
  File "/usr/local/lib/python2.4/TurboGears-0.9a1-py2.4.egg/turbogears/cont=
rollers.py",
line 228, in _execute_func
    output =3D errorhandling.try_call(func, *args, **kw)
  File "/usr/local/lib/python2.4/TurboGears-0.9a1-py2.4.egg/turbogears/erro=
rhandling.py",
line 63, in try_call
    output =3D func(self, *args, **kw)
  File "/home/mso/svn/hazweb/Cameo-Search-Demo/cameosd/controllers.py",
line 36, in default
    chem =3D Chemical.get(chem_id)
  File "/usr/local/lib/python2.4/SQLObject-0.7.1dev_r1534-py2.4.egg/sqlobje=
ct/main.py",
line 912, in get
    val._init(id, connection, selectResults)
  File "/usr/local/lib/python2.4/SQLObject-0.7.1dev_r1534-py2.4.egg/sqlobje=
ct/main.py",
line 955, in _init
    selectResults =3D self._connection._SO_selectOne(self, dbNames)
  File "/usr/local/lib/python2.4/SQLObject-0.7.1dev_r1534-py2.4.egg/sqlobje=
ct/dbconnection.py",
line 571, in _SO_selectOne
    return self.queryOne(
  File "/usr/local/lib/python2.4/SQLObject-0.7.1dev_r1534-py2.4.egg/sqlobje=
ct/dbconnection.py",
line 748, in queryOne
    return self._dbConnection._queryOne(self._connection, s)
  File "/usr/local/lib/python2.4/SQLObject-0.7.1dev_r1534-py2.4.egg/sqlobje=
ct/dbconnection.py",
line 339, in _queryOne
    self._executeRetry(conn, c, s)
  File "/usr/local/lib/python2.4/SQLObject-0.7.1dev_r1534-py2.4.egg/sqlobje=
ct/dbconnection.py",
line 295, in _executeRetry
    return cursor.execute(query)
Warning: You can only execute one statement at a time.


[1] The original problem was, a query with a many:many join and a
substring search hangs the SQLObject library and prevents any other
web requests from completing.  I heard the new version of SQLite
solved a multithreading bug so I wanted to see if it would work
better.

--
Mike Orr <sluggoster@...>
(mso@... address is semi-reliable)

Re: [SQLObject] Patch: support for locking rows

[Oleg Broytmann <phd@ma...>]

On Wed, Mar 08, 2006 at 03:06:25PM +0100, David Faure wrote:
> Hmm, the last line shouldn't have been added, since the support for '%s' hasn't been committed.
> 
> --- docs/SQLObject.txt  (revision 1634)
> +++ docs/SQLObject.txt  (working copy)
> @@ -739,7 +739,6 @@ values are:
>     single SQL command, a list of SQL commands, or a dictionary with keys that
>     are dbNames and values that are either single SQL command string or a list
>     of SQL commands. This is usually for ALTER TABLE commands.
> -   ``%s``, if present, is substituted with the name of the table.

   Fixed. Thank you.

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

Re: [SQLObject] Patch to make tableExists work with "db.table" table name

[David Faure <dfaure@kl...>]

On Tuesday 21 February 2006 15:32, David Faure wrote:
> SQLObject currently assumes that a default database was selected for the =
connection.
> However I'm using SQLObject in a C++ application which executes python sc=
ripts,
> and the connection doesn't have a default database selected, on purpose.
>=20
> With the following naming style I can make SQLObject prepend the database=
 name
> before creating a table or running queries in a table:
>=20
> class PrependDBStyle(sqlobject.DefaultStyle):
> 	def pythonClassToDBTable(self, className):
> 		return "sqlobjects." + super(PrependDBStyle, self).pythonClassToDBTable=
(className)
> 	def dbTableToPythonClass(self, table):
> 		if table.startsWith( "sqlobjects." ):
> 			table =3D table[11:]
> 		return super(PrependDBStyle,self).dbTableToPythonClass(table)
>=20
> However the tableExists check is currently implemented with "SHOW TABLES"=
, which
> fails when there is no default database selected. The attached patch uses=
 "DESCRIBE %s"
> instead, which works in both cases ("describe foo" or "describe db.foo")

Can the attached patch be considered for inclusion?
"DESCRIBE [db.]table" works in all cases (with or without a default databas=
e)
whereas
"SHOW TABLES" needs a default database.

=2D-=20
David Faure -- faure@..., dfaure@...
KDE/KOffice developer, Qt consultancy projects
Klar=E4lvdalens Datakonsult AB, Platform-independent software solutions

Re: [SQLObject] Patch: support for locking rows

[David Faure <dfaure@kl...>]

On Sunday 26 February 2006 16:46, Oleg Broytmann wrote:
> On Wed, Feb 22, 2006 at 01:21:58AM +0100, David Faure wrote:
> > +`createSQL`:
> > +   SQL queries run after table creation. createSQL can be a string wit=
h a
> > +   single SQL command, a list of SQL commands, or a dictionary with ke=
ys that
> > +   are dbNames and values that are either single SQL command string or=
 a list
> > +   of SQL commands. This is usually for ALTER TABLE commands.
> > +   ``%s``, if present, is substituted with the name of the table.
>=20
>    Added to the documentation. Thank you!

Hmm, the last line shouldn't have been added, since the support for '%s' ha=
sn't been committed.

=2D-- docs/SQLObject.txt  (revision 1634)
+++ docs/SQLObject.txt  (working copy)
@@ -739,7 +739,6 @@ values are:
    single SQL command, a list of SQL commands, or a dictionary with keys t=
hat
    are dbNames and values that are either single SQL command string or a l=
ist
    of SQL commands. This is usually for ALTER TABLE commands.
=2D   ``%s``, if present, is substituted with the name of the table.


 There is also one instance attribute:

=2D-=20
David Faure -- faure@..., dfaure@...
KDE/KOffice developer, Qt consultancy projects
Klar=E4lvdalens Datakonsult AB, Platform-independent software solutions