Hi Costa , first im sorry for my wrong post above,It should be a new post
with new question. Actually i have same problem like you,
i did a quick test and have not solved this issue yet, here is what i did:
set driver to use mongodb in: DB.py :
if not request.env.web2py_runtime_gae:
## if NOT running on Google App Engine use SQLite or other DB
#db = DAL('sqlite://storage.sqlite')
db = DAL('mongodb://localhost:27017/foo')
Click Register on menu to put a new User into mongo, submit:
<type 'exceptions.ValueError'> invalid literal for int() with base 10: '
koko'
Go to web2py appadmin admindatabase, open
auth_user<http://127.0.0.1:8000/test/appadmin/insert/db/auth_user>
table:
Invalid Query
invalid literal for int() with base 10: 'koko'
Use mongo console to run query :
db.auth_user.find({})
new user is alread inserted into db,--> "insert" is done.
but the error happens when mapping value and key or key type in DAL, im not
sure, the type of value is not match. looks like DAL understands ID field
is FirstName field.
-
*File C:\w2py3\gluon\dal.py in parse_id at line 1641* code arguments
variables
Function argument list
(self=<gluon.dal.MongoDBAdapter object>, value='koko', field_type='id')
Code listing
1636.
1637.
1638.
1639.
1640.
1641.
1642.
1643.
1644.
1645.
if not self.dbengine=='google:datastore':
value = bar_decode_string(value)
return value
def parse_id(self, value, field_type):
return int(value)
def parse_integer(self, value, field_type):
return int(value)
Variablesbuiltinint<type 'int'>value'koko'
On Wednesday, May 9, 2012 7:42:56 PM UTC+9, Francisco Costa wrote:
>
> I've enumerated fields and colnames and they are like this:
>
> fields:
> id
> text
> integer
> string
>
>
> colnames:
> city
> age
> _id
> name
>
>
> I believe they don't match and thats why there's this error:
>
> File "/opt/web2py/gluon/dal.py", line 8134, in select
> return adapter.select(self.query,fields,attributes)
> File "/opt/web2py/gluon/dal.py", line 4711, in select
> return processor(rows,fields,colnames,False)
> File "/opt/web2py/gluon/dal.py", line 1681, in parse
> self.parse_value(value, fields[j].type,blob_decode)
> File "/opt/web2py/gluon/dal.py", line 1575, in parse_value
> return self.parsemap[key](value,field
>
> _type)
> File "/opt/web2py/gluon/dal.py", line 1641, in parse_id
>
> return int(value)
> ValueError: invalid literal for int() with base 10: 'Toronto'
>
>
>
>
>
> On Monday, May 7, 2012 11:40:36 PM UTC+1, Massimo Di Pierro wrote:
>>
>> Please try again.
>>
>> On Monday, 7 May 2012 15:48:04 UTC-5, Francisco Costa wrote:
>>>
>>> missing a colon at the end of the line 4677
>>>
>>> if key == 'id'
>>>
>>>
>>> and now I get this error
>>>
>>> File "/opt/web2py/gluon/dal.py", line 8134, in select
>>> return adapter.select(self.query,fields,attributes)
>>> File "/opt/web2py/gluon/dal.py", line 4711, in select
>>> return processor(rows,columns,False)
>>> File "/opt/web2py/gluon/dal.py", line 1675, in parse
>>> for j,colname in enumerate(colnames):
>>> TypeError: 'bool' object is not iterable
>>>
>>>
>>> maybe because of the False on line 4711
>>>
>>>
>>>
>>>
>>> On Monday, May 7, 2012 9:27:35 PM UTC+1, Massimo Di Pierro wrote:
>>>>
>>>> Thanks for your help and check on this. I just committed a fix in trunk
>>>> that should address it. Please let me know.
>>>>
>>>> On Monday, 7 May 2012 15:19:40 UTC-5, Francisco Costa wrote:
>>>>>
>>>>> I think that the mongofields_dict.keys() don't match to the data in
>>>>> the rows
>>>>>
>>>>> mongofields_dict:
>>>>> id
>>>>> name
>>>>> age
>>>>> city
>>>>> rows:
>>>>> Toronto
>>>>> 66L
>>>>> 24652490551171733682233802752L
>>>>> John
>>>>>
>>>>>
>>>>> On Monday, May 7, 2012 8:42:33 PM UTC+1, Massimo Di Pierro wrote:
>>>>>>
>>>>>> Your linennumbers do not much the code in trunk. Please try the code
>>>>>> in trunk. Anyway, something goes wrong in the parse(self, rows, fields,
>>>>>> colnames, blob_decode=True) function. I suspect mongo does not return
>>>>>> the
>>>>>> columns in the order web2py think it does. Can you print the input of
>>>>>> the
>>>>>> parse function?
>>>>>>
>>>>>> On Monday, 7 May 2012 13:20:39 UTC-5, Francisco Costa wrote:
>>>>>>>
>>>>>>> So I have this:
>>>>>>>
>>>>>>> import sys
>>>>>>> import time
>>>>>>> from gluon.dal import DAL, Field
>>>>>>> mongo = DAL('mongodb://localhost:27017/tymr')
>>>>>>> mongo.define_table('user',
>>>>>>> Field('name', 'text'),
>>>>>>> Field('age', 'integer'),
>>>>>>> Field('city', 'string')
>>>>>>> )
>>>>>>>
>>>>>>> def insert_users():
>>>>>>> mongo.user.insert(name='John', age=66, city='Toronto')
>>>>>>> mongo.user.insert(name='Mark', age=43, city='Boston')
>>>>>>> mongo.user.insert(name='Tom', age=43, city='Detroit')
>>>>>>> mongo.user.insert(name='Jim', age=18, city='Detroit')
>>>>>>> mongo.user.insert(name='Jack', age=18)
>>>>>>> mongo.user.insert(name='Eric', city='Boston')
>>>>>>> return 'users in database'
>>>>>>>
>>>>>>> def find_users():
>>>>>>> users = mongo(mongo.user.age==66).select()
>>>>>>> return dict(users=users)
>>>>>>>
>>>>>>>
>>>>>>> after I run *insert_users* I check in MongoDb via terminal and
>>>>>>> everything is correct:
>>>>>>> > db.user.find()
>>>>>>> { "_id" : ObjectId("4fa80feea34feb34f8000000"), "city" : "Toronto",
>>>>>>> "age" : NumberLong(66), "name" : "John" }
>>>>>>> { "_id" : ObjectId("4fa80feea34feb34f8000001"), "city" : "Boston",
>>>>>>> "age" : NumberLong(43), "name" : "Mark" }
>>>>>>> { "_id" : ObjectId("4fa80feea34feb34f8000002"), "city" : "Detroit",
>>>>>>> "age" : NumberLong(43), "name" : "Tom" }
>>>>>>> { "_id" : ObjectId("4fa80feea34feb34f8000003"), "city" : "Detroit",
>>>>>>> "age" : NumberLong(18), "name" : "Jim" }
>>>>>>> { "_id" : ObjectId("4fa80feea34feb34f8000004"), "age" :
>>>>>>> NumberLong(18), "name" : "Jack" }
>>>>>>> { "_id" : ObjectId("4fa80feea34feb34f8000005"), "city" : "Boston",
>>>>>>> "name" : "Eric" }
>>>>>>>
>>>>>>> but when I run *find_users* I get this error:
>>>>>>>
>>>>>>> File "/opt/web2py/gluon/dal.py", line 7578, in select
>>>>>>> return adapter.select(self.query,fields,attributes)
>>>>>>> File "/opt/web2py/gluon/dal.py", line 4290, in select
>>>>>>> return self.parse(rows,fields,mongofields_dict.keys(),False)
>>>>>>> File "/opt/web2py/gluon/dal.py", line 1600, in parse
>>>>>>> self.parse_value(value, fields[j].type,blob_decode)
>>>>>>> File "/opt/web2py/gluon/dal.py", line 1496, in parse_value
>>>>>>> return self.parsemap[key](value,field_type)
>>>>>>> File "/opt/web2py/gluon/dal.py", line 1562, in parse_id
>>>>>>> return int(value)
>>>>>>> ValueError: invalid literal for int() with base 10: 'Toronto'
>>>>>>>
>>>>>>>
>>>>>>>
