MongoDB 'document' or 'dict' filetype

[Francisco Costa]

At the moment MongodbAdapter only has these filetypes

class MongoDBAdapter(NoSQLAdapter):
    uploads_in_blob = True

    types = {
                'boolean': bool,
                'string': str,
                'text': str,
                'password': str,
                'blob': str,
                'upload': str,
                'integer': long,
                'bigint': long,
                'float': float,
                'double': float,
                'date': datetime.date,
                'time': datetime.time,
                'datetime': datetime.datetime,
                'id': long,
                'reference': long,
                'list:string': list,
                'list:integer': list,
                'list:reference': list,
        }

Which means that if you want to insert or manage this:

{

    "field1": "super",

    "field2": 300,

    "field3": ["one", "two", "three"],
    "field4" = {foo: "bar", michael: "jordan"}

}

You can't do it for field4

Most MongoDB Collections do make use of document/dict datatype so this should be possible!

[Massimo Di Pierro]

I think if that is what you want to do, you go beyond the scope of the dal and perhaps you should use the mongodb api instead of the dal. Perhaps we should discuss it on web2py developers. Anyway, feel free to open a ticket about this.

[Alan Etkin]

At the moment MongodbAdapter only has these filetypes

The MongoDBAdapter now supports storing JSON documents, plus a json widget and IS_JSON validator. See this slice for more details:
http://www.web2pyslices.com/slice/show/1580/save-the-earth-from-a-total-data-mess-with-mongodbadapter