I think I am trying to do something very simple, but I don't understand row
objects (why can't they be a normal Python type instead of a web2py class?).
I have gotten this error no matter what I try:
<type 'exceptions.TypeError'> insert() takes exactly 1 argument (2 given)
All I want to do is retrieve a row from one table in one db and insert it
into an identical table in another db just one row at a time.
Here are several attempts, all of which result in the above error:
1. row = jodb.pending.insert(
jodb(jodb.joke.id==jokenum).select().as_list())
2. row = jodb(jodb.joke.id==jokenum).select()
jodb.pending.insert(row)
I have tried using jodb.pending.insert(**row) whch also does not work.
I have tried select().as_dict() which also does not work.
Every time i try to do something with a row object I have to do something
like row[0]['field'].
The row object and its strangeness is not described very well in the DAL
section of the book. It's too magical. It's need to be more transparent.