Sorry my fault
self._execute = lambda a: self._cursor.execute(a[:-1])
not
self._execute = lambda *a: self._cursor.execute(a[:-1])
On Feb 27, 10:06 am, DenesL <denes1...@yahoo.ca> wrote:
> Ok, more tests.
>
> If I change sql.py around line 790
> # self._execute = lambda *a, **b: self._cursor.execute(*a,
> **b)
> self._execute = lambda *a: self._cursor.execute(a[:-1])
>
> I get
> Traceback (most recent call last):
> File "C:\web2py\trunk\gluon\restricted.py", line 98, in restricted
> exec ccode in environment
> File "C:/web2py/trunk/applications/test/models/db.py", line 7, in
> <module>
> SQLField('name','string') )
> File "C:\web2py\trunk\gluon\sql.py", line 860, in define_table
> raise e
> TypeError: The first argument to execute must be a string or unicode
> query.
>
> sql.log
> timestamp: 2009-02-27T10:43:25.656000
> CREATE TABLE person(
> id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY NOT NULL,
> name VARCHAR(32)
> );
>
> Note the ending ';'
>
> Now I revert the change in sql.py around line 790
> self._execute = lambda *a, **b: self._cursor.execute(*a,
> **b)
> # self._execute = lambda *a: self._cursor.execute(a[:-1])
>
> and I add
> if self._db._dbname == 'db2': other=''
> after
> other = ';'
> around line 1115
>
> then the creation runs fine as per the sql.log
> timestamp: 2009-02-27T11:01:12.875000
> CREATE TABLE person(
> id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY NOT NULL,
> name VARCHAR(32)
> )
> success!
> timestamp: 2009-02-27T11:01:15.984000
> CREATE TABLE dog(
> id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY NOT NULL,
> name VARCHAR(32),
> owner INT, FOREIGN KEY (owner) REFERENCES person(id) ON DELETE
> CASCADE
> )
> success!
>
> but inserting a new person fails:
> Traceback (most recent call last):
> File "C:\web2py\trunk\gluon\restricted.py", line 98, in restricted
> exec ccode in environment
> File "C:/web2py/trunk/applications/test/controllers/appadmin.py",
> line 271, in <module>
> File "C:\web2py\trunk\gluon\globals.py", line 75, in <lambda>
> self._caller = lambda f: f()
> File "C:/web2py/trunk/applications/test/controllers/appadmin.py",
> line 103, in insert
> if form.accepts(request.vars, session):
> File "C:\web2py\trunk\gluon\sqlhtml.py", line 561, in accepts
> self.vars.id = self.table.insert(**fields)
> File "C:\web2py\trunk\gluon\sql.py", line 1304, in insert
> self._db._execute(query)
> File "C:\web2py\trunk\gluon\sql.py", line 789, in <lambda>
> self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
> ProgrammingError: ('42000', '[42000] [IBM][iSeries Access ODBC Driver]
> [DB2 UDB]SQL0104 - Token ; was not valid. Valid tokens: <END-OF-
> STATEMENT>. (-104) (SQLExecDirectW)')
>
> the offending ';' again...
>
> Denes.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
