sqlobject-discuss

[SQLObject] bug or feature?

[Emanuele O. <oli...@it...>]

Hi,
first of all I'd like to say that SQLObject is a beautiful module
and I'm using it with with very interesting results (with SQLite
on a Linux box).

I tried to run this, to try many-to-many relations:
---
from SQLObject import *

__connection__=SQLiteConnection('bug.sqlite', debug=1)

class A(SQLObject):
    b=RelatedJoin('B')

class B(SQLObject):
    a=RelatedJoin('A')

A.createTable(ifNotExists=True)
B.createTable(ifNotExists=True)

a=A.new()
b=B.new()
---

I got an:
"_sqlite.DatabaseError: near ")": syntax error"
due to this SQL command:
"INSERT INTO a () VALUES ()"

Is it a pysqlite problem or SQLObject problem?

In the following you can find the complete log (debug=1).

Cheers,

						Emanuele

--- log transcript ---
/tmp 143>python bug-many-to-many.py
 1/QueryOne:  SELECT tbl_name FROM sqlite_master WHERE type='table' AND tbl_name = 'a'
 1/COMMIT  :  auto
 1/Query   :  CREATE TABLE a (
    id INTEGER PRIMARY KEY
)
 1/COMMIT  :  auto
 1/QueryOne:  SELECT tbl_name FROM sqlite_master WHERE type='table' AND tbl_name = 'a_b'
 1/COMMIT  :  auto
 1/Query   :  CREATE TABLE a_b (
a_id INT NOT NULL,
b_id INT NOT NULL
)
 1/COMMIT  :  auto
 1/QueryOne:  SELECT tbl_name FROM sqlite_master WHERE type='table' AND tbl_name = 'b'
 1/COMMIT  :  auto
 1/Query   :  CREATE TABLE b (
    id INTEGER PRIMARY KEY
)
 1/COMMIT  :  auto
 1/QueryIns:  INSERT INTO a () VALUES ()
Traceback (most recent call last):
  File "bug-many-to-many.py", line 14, in ?
    a=A.new()
  File "/opt/python2.3/lib/python2.3/site-packages/SQLObject/SQLObject.py", line 883, in new
    inst._SO_finishCreate(id)
  File "/opt/python2.3/lib/python2.3/site-packages/SQLObject/SQLObject.py", line 905, in _SO_finishCreate
    id, names, values)
  File "/opt/python2.3/lib/python2.3/site-packages/SQLObject/DBConnection.py", line 160, in queryInsertID
    return self._runWithConnection(self._queryInsertID, table, idName, id, names, values)
  File "/opt/python2.3/lib/python2.3/site-packages/SQLObject/DBConnection.py", line 72, in _runWithConnection
    val = meth(conn, *args)
  File "/opt/python2.3/lib/python2.3/site-packages/SQLObject/DBConnection.py", line 717, in _queryInsertID
    c.execute(q)
  File "/opt/python2.3/lib/python2.3/site-packages/sqlite/main.py", line 244, in execute
    self.rs = self.con.db.execute(SQL)
_sqlite.DatabaseError: near ")": syntax error
-----------------------------------------------------------------

Re: [SQLObject] bug or feature?

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

On Nov 26, 2003, at 8:09 AM, Emanuele Olivetti wrote:
> Hi,
> first of all I'd like to say that SQLObject is a beautiful module
> and I'm using it with with very interesting results (with SQLite
> on a Linux box).
>
> I tried to run this, to try many-to-many relations:
> ---
> from SQLObject import *
>
> __connection__=SQLiteConnection('bug.sqlite', debug=1)
>
> class A(SQLObject):
>     b=RelatedJoin('B')
>
> class B(SQLObject):
>     a=RelatedJoin('A')
>
> A.createTable(ifNotExists=True)
> B.createTable(ifNotExists=True)
>
> a=A.new()
> b=B.new()
> ---
>
> I got an:
> "_sqlite.DatabaseError: near ")": syntax error"
> due to this SQL command:
> "INSERT INTO a () VALUES ()"
>
> Is it a pysqlite problem or SQLObject problem?

A SQLObject problem I suppose, though it's because you have trivial 
classes.  The only column in your A and B tables is the ID (which 
SQLite generates automatically on insert).  So there's no values to 
insert, and there's no way to express an insert that doesn't insert 
anything (strictly speaking, it inserts an ID, but because it is 
implicit it doesn't show up in the SQL, and so the SQL is invalid).

Add some columns to your classes and you should be okay.  They won't be 
useful until you do that anyway.

--
Ian Bicking | ia...@co... | http://blog.ianbicking.org

Re: [SQLObject] bug or feature?

[Emanuele O. <oli...@it...>]

On Wed, Nov 26, 2003 at 11:37:59AM -0600, Ian Bicking wrote:
> A SQLObject problem I suppose, though it's because you have trivial
> classes.  The only column in your A and B tables is the ID (which
> SQLite generates automatically on insert).  So there's no values to
> insert, and there's no way to express an insert that doesn't insert
> anything (strictly speaking, it inserts an ID, but because it is
> implicit it doesn't show up in the SQL, and so the SQL is invalid).

OK. I'm just jumping in SQLObject in these days so I try to give
feedback as soon as possible.

> Add some columns to your classes and you should be okay.  They won't be 
> useful until you do that anyway.

For sure.

Thanks,

						Emanuele