Log file Viewer
#mongodb logs for Wednesday the 21st of January, 2015
[04:46:03] <morenoh149> cheeser: thats not helpful. Unless I know what methods are available on the return type of .update()
[04:54:37] <cheeser> you can edit it the document in memory. saving it back, though, is a bit complicated.
[05:00:39] <morenoh149> can't even find what methods are avialable on documents http://docs.mongodb.org/manual/core/document/
[05:01:09] <morenoh149> cheeser: no way mongodb makes so much money. They would probably dismiss it. Probably a reason such functionality isn't there
[05:01:56] <cheeser> it's probably not there because there are more important features/fixes to focus on.
[05:02:39] <morenoh149> cheeser: no it's probably because you would have to overload the `update()` method
[05:03:17] <morenoh149> as of now it executes on a collection. I want to chain it to work on documents (resultset from queries)
[05:06:05] <morenoh149> ah I findOne returns a document though http://docs.mongodb.org/manual/reference/method/db.collection.findOne/
[05:10:04] <cheeser> joannac_: and then just pass the _id for the query and the document itself for the updates, yes?
[05:10:50] <joannac_> it doesn't make sense to have an update method on a document/object/whatever you want to call it
[05:15:04] <arussel> is there a way to update all the field named "foo" of a document without giving the full path ? ie: {a:1, foo: 3, bar: {foo: 4, c: 5}} would be updated in 2 places
[05:15:22] <cheeser> don't confuse refusing to agree with you with blind submission to something else.
[05:16:42] <morenoh149> cheeser: you still believe `db.kittens.findOne().update({'blah':'toblah'})` is non ituitive? I don't know what to say
[05:17:36] <cheeser> morenoh149: as joannac_ said, documents don't know where the they came from. a simple update() lacks any context with which to write back those documents to a collection.
[05:18:32] <morenoh149> I get it I just started the convo over whether that is something nice to have in the shell. Then it dove into 'it doesn't work that way so it shouldn't work that way' which I disagree with. meh
[05:20:05] <cheeser> for what it's worth, an ODM does what you're looking for. the shell just doesn't have one.
[05:20:13] <morenoh149> cheeser: it probably shouldn't work the way I thought. BTW its a mongoose idiom
[06:18:00] <morenoh149> what's the return value of http://docs.mongodb.org/manual/reference/method/cursor.sort/
[06:20:52] <morenoh149> anyone know why my cursor can't do `hasNext()`? https://gist.github.com/morenoh149/cd776855716fae57239c
[06:36:07] <morenoh149> ah I see the node driver api differs http://mongodb.github.io/node-mongodb-native/2.0/api-docs/
[06:38:37] <arussel> this is an aggregation command afaik, get it out of here and use find().sort() if you want to sort your stuff
[06:44:21] <morenoh149> okay rearranged things https://gist.github.com/morenoh149/cd776855716fae57239c
[08:34:53] <aaearon> could someone assist me with updating and dot notation? http://pastebin.com/pDJkw9xJ i am looking to update code ¨7¨ inProgress: true but i cannot get the syntax right
[09:01:20] <aaearon> not sure if this is a better schema: http://pastie.org/private/57yicvplghnqgf4onvu8rw
[10:02:38] <aaearon> how do i set the inProcess value for item ¨7¨? http://pastie.org/private/0teb2lwpayepotdv0wlq
[10:18:01] <Derick> e.g., then you could do: db.test.update( { 'codes.plz' : 6 }, { $set : { 'codes.$.inProcess': true } } );
[10:18:22] <Derick> db.test.update( { 'codes.plz' : '6' }, { $set : { 'codes.$.inProcess': true } } );
[10:18:50] <Derick> db.test.update( { 'orientation' : 154, 'codes.plz' : '6' }, { $set : { 'codes.$.inProcess': true } } );
[10:19:13] <Derick> db.test.update( { 'orientationId' : 154, 'codes.plz' : '6' }, { $set : { 'codes.$.inProcess': true } } );
[11:18:29] <aaearon> im running into problems with $currentDate: http://pastie.org/9847180 am i missing something obvious?
[12:47:52] <nukeu666> i use $project to rearrange fields in my collection but how to i write everything to a new colection?
[12:51:17] <Seb> I'm trying to write an aggregate, grouping by a field called 'env', where I could $push only the last, say, 40 elements instead of all of them
[12:55:17] <StephenLynx> http://stackoverflow.com/questions/25101203/mongo-aggregate-slice-for-subdocs
[12:55:26] <StephenLynx> "Unfortunately (as at MongoDB 2.6) there is no equivalent of $slice for the aggregation pipeline."
[12:55:40] <StephenLynx> I remember needing a slice for aggregate too and just falling flat on my ass.
[12:55:53] <nukeu666> If you only want the array to grow to a certain length, you can also use the "$slice"
[12:55:53] <nukeu666> operator in conjunction with "$push" to prevent an array from growing beyond a certain
[12:56:06] <cers> I have a bunch of records with the format {a: 42, p: {id:1, val1: 45, val2: "foo"}} using collection.aggregate() I group them by p.id, is there an easy way to make it not include p.id in the p object when returning the result?
[12:57:47] <cers> StephenLynx: is that done in the same manor as I would when doing a .find()? (that is, by simply inserting a {'p.id': 0} after?
[12:59:34] <Seb> StephenLynx, nukeu666: http://stackoverflow.com/questions/17757572/aggregate-push-n-number-of-array-results seems to be what I'm hitting
[13:00:27] <StephenLynx> yeah, that would be an option. but doesn't seen to be too different from just using aggregate and then manually handling it.
[13:01:14] <Seb> unfortunately my dataset is *way* too big to be returned in full to the application code
[13:02:25] <Seb> so even the map-reduce code listed there won't work, as it'll only truncate the resulting array *after* it's been stuffed with *all* the items
[13:03:13] <Seb> well, I guess reduce_f = ... result.reports = result.reports.concat(curr.reports) unless results.report.size >= limit
[13:04:51] <StephenLynx> you read a small number of elements, attach to your set, read another number, attach them
[13:45:50] <cers> some of my data has an error (which for silly reasons, I am not allowed to update) that affects whether or not it should be matched. Is there a way to run a js function on the value before matching?
[13:52:40] <Tomasso> I pick a document from a collection, and when i insert it into another collection I get duplicate id... i tried removing _id field before inserting but same result.. what should i do?
[13:54:46] <cers> StephenLynx: the data comes in from this embedded system which sends a binary blob. At some point there was an error in the parser, so some timestamps are a year off. I want to match records within a range of dates, and currently I do that and then later filter out the "wrongly" matched ones. But I'd like to do this in the query itself...
[13:57:05] <StephenLynx> Tomasso yes. you remove the id before inserting in the new collection, then it will get a new one.
[13:58:01] <cers> StephenLynx: in plain js, what I do is parse the timestamp via new Date(timestamp), and if .getMonth() returns certain values I do a .setYear() and finally .getTime() to get back to the timestamp. After doing this on all values, I run the same filter for the range as I already do in the query
[14:00:27] <cers> well, say I only want records where the timestamp is after a certain date. Some of the timestamps are a year wrong, so they will accidentally match that filter
[14:02:01] <cers> StephenLynx: I know if the year is 2015 and the month is above 9 (the project collecting the data will end before that)
[14:02:52] <cers> I can't just exclude those though, as after the correction they might be (for example) dec 29, 2014 - which is within the range I want to look at
[14:03:35] <StephenLynx> so what you need is to check 2 conditions? 1: check if date is greater than dateA and 2: check if date is less than dateB?
[14:04:30] <cers> if it's later than a certain date, I need to subtract a year from it, and then do the second check, I guess
[14:05:16] <StephenLynx> so you still need to retrieve the values but you need to perform a check on them?
[14:16:56] <edrocks> I was having problems with the old file not being removed if you spammed the upload but I just found out I should be able to put a unique index on a meta field with the account id
[14:19:52] <StephenLynx> I just had a field on my object where I put the string that represented the file
[15:01:34] <Tomasso> anyway... by removing the _id property keeps returning Duplicate id... basically I pick a document, modify it, remove the _id and insert it to another collection .. what could be wrong?
[15:59:38] <coalado> Does anybody know how to use the "point syntax" in a java DBObject like String str=(String)object.get("obj1.obj2.myString");
[16:00:59] <coalado> String string =(String) ((DBObject) ((DBObject)transaction.get("obj1")).get("obj2")).get("myString");
[16:02:45] <coalado> 2. Question: I'd like to do a query on this string. findOne({obj1.obj2.myString:bla})
[16:04:18] <StephenLynx> if that were on javascript, you would have to put "obj1.obj2.myString" as a string.
[16:08:01] <edrocks> do I have to manually delete chunks for my files if I use ensure index unquie on filename in gridfs? I'm getting leftover chunks
[16:38:02] <toter> Hi everybody... Is there a good tutorial on how to create users on mongoDB? I tried several online, created 2 users for different DB's and I still can't access anything
[16:55:39] <ehershey> http://docs.mongodb.org/manual/tutorial/model-referenced-one-to-many-relationships-between-documents/
[20:51:52] <mongo_noob> how do I replace it in place in the object? Or should I iterate and create a new object with the changes
[20:52:56] <mongo_noob> When I use mongoskin in node, this fails....but when I do the same from mongoimport..it inserts
[21:00:35] <wgreenberg> Hi, I'm running into some mongo connection issues that only seem to arise when my app is deployed onto heroku -- has anyone run into issues with a nodejs mongodb client intermittently failing to connect to a mongo backend when on heroku?
[21:00:59] <wgreenberg> my app's built on sailsjs, but the error seems to originate from its usage of the nodejs mongodb client
[21:01:28] <wgreenberg> I suspect it may be related to the 20 connection limit for hobby heroku servers, but don't know enough about the mongo client to investigate
[21:14:23] <morenoh149> db.posts.update({permalink:'how-to-survive-in-nyc'},{$push:{post.comments: {name:'amy',email:'a@a.com',body:'blasdfasdf'}}})
[21:15:45] <morenoh149> How do I reference the posts found from the `.update({permalink:'foo'}...` query in the update clause?
[21:17:03] <aaearon> im trying to update fields in an array but its not working. does it matter what order the fields are in the update command?
[21:17:26] <benjwadams> I just want to try to see if some commands work the way i think they do before throwing them into a document
[21:17:41] <morenoh149> benjwadams: limit? http://docs.mongodb.org/manual/reference/method/cursor.limit/
[21:19:21] <benjwadams> I want to really throw a timestamp onto a subdocument so i have something like {time: time, {subcoll: coll}}
[21:21:12] <benjwadams> i have a bunch of services i want to aggregate and take the count of. I want to also tack on a timestamp for said services so I know that the counts correspond to a certain time. Ignore my first example, it's just a toy example
[21:21:25] <morenoh149> wgreenberg: you need to modify your server to not crash if a mongo is not accessible. But %99 of the time your app should be able to reach the hosted mongo instance
[21:22:32] <benjwadams> I have the aggregation part set, now i just need to do something like {ts: time_now(), agg_counts: db.services.aggregate(...)}
[21:22:44] <wgreenberg> morenoh149, definitely good advice, but when I run my app locally I get no connection issues whatsoever. I was wondering if there was maybe a known issue with mongo client's connection pools when running on heroku
[21:24:03] <benjwadams> going back to the first example = in mongo shell, how can i return a plain json object with some constants.
[21:24:14] <jayjo> Is there a way to return an object from a query instead of the BaseQuerySet object or a cursor?
[21:24:21] <morenoh149> wgreenberg: no. Heroku doesn't have persistent disk storage. So if you're storing your mongo url to something like the filesystem you should expect errors. Hence why we all use hosted mongodb services
[21:24:57] <benjwadams> i tried plain `{'bar': 1}` on the mongo shell and it threw a syntax error, so i thought it would not work
[21:25:48] <morenoh149> db.posts.update({permalink:'how-to-survive-in-nyc'},{$push:{post.comments: {name:'amy',email:'a@a.com',body:'blasdfasdf'}}})
[21:26:42] <morenoh149> I want to reference the post resulting from the query clause. So I do `post.comments` in the update clause but that's wrong
[21:28:27] <joannac> morenoh149: actually, what does "I want to reference the post resulting from the query clause" mean?
[21:29:01] <morenoh149> joannac: so I want to find a specific post by it's permalink field. then add a comment to that posts list of comments
[21:29:11] <benjwadams> how about grabbing the current time in mongo? looking at google and it looks awfully complex just to get something like that
[21:34:28] <joannac> morenoh149: db.posts.update({permalink:'how-to-survive-in-nyc'},{$push:{comments: {name:'amy',email:'a@a.com',body:'blasdfasdf'}}})
[21:34:49] <joannac> dunno why you were using post.comments -- there's no field called post.comments in your document
[21:34:58] <Synt4x`> I have a mongo document, within it I had a list caled "statistics__list" , I want to add one stat to that list in every instance in the databse, how would I do this?
[21:35:01] <Rafzzz> I'd like to build myself a rest API. The app lets people record their daily sales figures and calculates weekly/monthly/annually accordingly. I have some products, that fall into categories, and i need an entry for each product in each category on every calendar day. Has anyone got any advice about how to structure such an API with express and mongoose? I'm okay with the code, but the structure is the tough thing for me...
[21:35:03] <morenoh149> so when does http://docs.mongodb.org/manual/core/document/#document-dot-notation come in? that's what tripped me up
[21:36:15] <Synt4x`> joannac: well it will be a different statistic (same stat but different #) for each instance, so I don't mind stepping through them I don't need to update all at once, it's just the first time I've ever added to a pre-existing document, I'm wondering how to modify it properly, never done it
[21:36:24] <benjwadams> ok, all well and good, but now the aggregation result returns a cursor when i try to put it in a document
[21:36:51] <joannac> morenoh149: sure, you could do something like $set: {"comments.0.name": "benjamin"}
[21:39:58] <joannac> benjwadams: i've read backscroll but it's still not clear to me what you're trying to do
[21:40:04] <Synt4x`> joannac: heh I think I'm misunderstanding you unfortunately or not explaining myself well, I need to know simply how to ADD a field to a pre-existing document without overwriting it. like right now I have x['statistics__list'] = {'stat1': stat1 , 'stat2':stat2, ... etc.}, I want x['statistics__list']['my_new_stat'] = mynewstat# and for that to be saved in the DB
[22:40:20] <Rafzzz> I'd like to build myself a rest API. The app lets people record their daily sales figures and calculates weekly/monthly/annually accordingly. I have some products, that fall into categories, and i need an entry for each product in each category on every calendar day. Has anyone got any advice about how to structure such an API with express and mongoose? I'm okay with the code, but the structure is the tough thing for me... (sorry to