it seems move existing code that use a rdms (sqlite, mysql, postgresql) to mongodb need an extra effort. e.g. *DAL connection from book* >>> db = DAL('mongodb://user:password@localhost/connect_test') *Error:* ... OperationFailure: command SON([('authenticate', 1), ('user', u'user'), ('nonce', u'7f46671524655a7d'), ('key', u'2be426ffba7c067a8a4ddb2a5e5056bf')]) on namespace connect_test.$cmd failed: auth failed *Solution:* 1. without mongodb user and password db = DAL('mongodb://localhost/connect_test') or 2. create mongodb user and password in terminal shell cat <<EOL > userMongoDB.js use connect_test db.createUser( { user: "username", pwd: "password", roles: [ { role: "dbAdmin", db: "connect_test" }, { role: "userAdmin", db: "connect_test" } ] } ) EOL mongo test < userMongoDB.js
*Date not str* >>> db.table0.insert(date0 = "2017-01-01", datetime0 = "2017-01-01 00:00:00") *Error:* ... TypeError: combine() argument 1 must be datetime.date, not str *Solution (strange that datetime field type didn't get affected by an error traceback):* from datetime import datetime db.table0.insert(date0 = datetime.strptime('2017-01-01', '%Y-%m-%d'), datetime0 = "2017-01-01 00:00:00") *Iterselect* >>> rows = db().iterselect(db.table0.ALL) *Error:* ... AttributeError: 'Mongo' object has no attribute 'iterselect' *Solution:* rows = db().select(db.table0.ALL) not sure is there any difficulties i'll face during the moving, but grateful a lot things to learn from obstacles. best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.