can't edit/save date in json editor about mongohub-mac

[bububa]

can you show me the demo json string of your code?

[dakra]

Looks like it fails with any document with date in it..
Just tested it with a fresh db:

$ mongo MongoDB shell version: 1.6.6-pre- connecting to: test

use hubtest
switched to db hubtest
db.d.insert({'foo': 'bar', 'created': new Date()})
db.d.find()
{ "_id" : ObjectId("4d4032a1c4fbdf147d37f54a"), "foo" : "bar", "created" : "Wed Jan 26 2011 15:41:37 GMT+0100 (CET)" }


then I go to mongohub, 'find' all documents in hubtest.d,
edit it with the json editor and change bar to bar2
(I try to save it as:
{ "_id" : ObjectId( "4d4032a1c4fbdf147d37f54a" ),
"foo" : "bar2",
"created" : Date( "Wed Jan 26 15:41:37 2011" ) }
)
and I get the error:
Failure parsing JSON string near: ,
"creat


hope that helps..

[bububa]

Based on the introduction from mongo extended JSON type (http://mongodb.onconfluence.com/display/DOCS/Mongo+Extended+JSON), Date()'s parameter should be a timestamp integer not a string. I'll add a more convenient function to use string later.

[dakra]

I see..
The thing is that mongohub use text dates as default,
so if I open my document, do nothing and hit save it doesn't work..
I don't think it should be that way.
You should either make timestamp default or like you said a wrapper 'function' to edit the date string like you suggested.

thanks. like your work :)

[aurora]

mmm ... i've other issues, with this, too. i've tried with a timestamp, but it still won't save. i receive error messages like "assertion util/message.cpp:467", "connection died" and "DBClientBase::findOne: transport error" when i try to save edited JSON. would be a very useful feature, if it worked ...

UPDATE just noticed, that apparently it nevertheless saved my changes, even though it
throws these error messages ... strange ...

great feature btw. ...

[mannyvergel]

Would like to request for a convenient function to insert date in string format just like in mongodb documentation: http://docs.mongodb.org/manual/reference/method/db.collection.insert/

E.g. new Date('Sep 04, 1927')