Log file Viewer
#mongodb logs for Friday the 29th of May, 2015
[00:10:39] <windsurf_> I have several forms I need to collect data in, they are each subsections of an overall form. should I create a collection called 'subsection' and have a property called 'type' or should I make different collections for each unique structure, like 'subsectionFoo', 'subsectionBar'...
[00:22:29] <bluesnow> Hi, if anyone here is familiar with Pymongo, I'm having trouble with a query. I'm running " return get_db_client().content.find(
[00:22:29] <bluesnow> {'$or': [{'slug': slug}, {'aliases': slug}], '$or': [{'published': True}, {'published': None}]}
[00:22:55] <bluesnow> My understanding that this will return documents that match both or conditions
[00:44:42] <bluesnow> Yeah so, that above query seems to actually find documents that match either "or" condition, instead of both..
[01:33:27] <Boomtime> @bluesnow: (ok, checked the archives) could you provide an example of a document that is returned but shouldn't?
[01:38:26] <Boomtime> that sounds possible, $or will only count a document once, but if you run the predicates seperately the same document could show up in multiple clauses
[01:40:06] <bros> https://gist.github.com/brandonros/ae702a7767f320be10a1 Can I upsert a subdocument like this?
[01:40:54] <Boomtime> @bluesnow: i see what is going on actually, you have two $or at the same level, which in a hashmap means that one overwrites the other - you don't have two $or clauses, only one of them survives
[01:43:20] <pingboy> man... i can only find one damned message regarding this error i'm seeing.. newly sharded database.. the balancer is croaking on 2.6.10 saying no primary shared configured for db:config
[07:36:15] <OS-16396> Good morning, I was wondering if anyone could help me with some syntax, I am trying to stack some queries together. I know there are ways using $or and $and operators but I wanted to know if it is possible just using an inline query. The query I am running at the moment is collection.find({"$where": "this.Name == 'XXX'" },{'$where':"this.OtherName"=="'1'" })
[08:57:06] <koren> hello! any way make something similar to $each in $addToSet/$push in $group of aggregation framework?
[09:28:15] <techie28> I have to update a field for one or many documents depending on the data supplied.
[09:29:24] <techie28> API will get any number of email addresses for which I have to update a field for each of them
[09:30:33] <koren> db.col.update({email: {$in: []}, {$set: {updatedField: "value"}}, {multi: true}); //something like this
[09:35:36] <koren> so bulk don't have to be used, unless you want to update a field to a different value for each email
[09:38:02] <techie28> koren:I have a scenario where I may need to perform lots of insert and lots of updates simultaneously..
[09:38:42] <techie28> API is passed some JSON data and there is a param in each object which determines that this data will be updated or inserted.
[09:40:13] <techie28> JSON data can have only one object also which can mean only one update/insert.
[10:12:36] <KekSi> i'm having trouble logging in with a x509 certificate on a stand alone node with ssl enabled and the user added - i get Error: 18 { ok: 0.0, errmsg: "auth failed", code: 18 }
[10:24:57] <erenburakalic> Hi there, is it allowed to make a Mac OSX App for MongoDB advertisement here?
[10:38:23] <erenburakalic> a pro version with paid (for specially donation), a free version and opensource version in github
[10:52:07] <techie28> cheeser: I want to match the email address with existing records and add if it is non existent.
[10:52:27] <OS-16396> Heya, I am new to mongo db. I was wondering if syntactically something like the following should work? collection.find({"$where": "this.Name == 'XXX'||function() {return "test"} ||'YYY'"). I have tried it when I know I have results for Name=test but didn't get anything back
[10:55:48] <koren> since awesome support is here I'll ask again about $each in aggregation framework
[10:55:58] <koren> any way make something similar to $each in $addToSet/$push in $group of aggregation framework?
[10:59:38] <OS-16396> thanks cheeser, will look into why that is. The main thing I am trying to get right is the running a function in there. If i do collection.find({"$where": "this.Name == 'XXX'||true||'YYY'") I get a full result set while if I do collection.find({"$where": "this.Name == 'XXX'||function() {return true} ||'YYY'") I get nothing so I think I am doing something wrong there
[11:00:24] <cheeser> OS-16396: iirc, it's because $where bypasses any indexing since it's essentially a js block that gets applied to each document in the collection
[11:02:25] <cheeser> i could take a stab with the java driver API if that'd help at all. but it'll be a bit before I get that chance. have to get the kids off to school...
[11:03:01] <techie28> cheeser:There is a dataset with email and other data in it.. I have to find if the email exist in the collection.. if it doesnt then add the email and other dataset to the collection else not
[11:03:18] <koren> cheeser: I have an array of subdocuments into a document that is $group-ed, and I want to return an array filled with unique values from a field contained in the array of subdocuments, inside the $group-ed items
[11:04:27] <koren> I tried this: { $group: { id: "$sessionId", events: { $addToSet: { $each: "$events.action"} } }
[11:06:22] <koren> (and addToSet on the array without each does append multiple arrays of values (as expected) and I had big trouble unwinding this)
[11:10:56] <koren> is there a reason why $each can't be used inside aggregation framework? or is it planned in future versions of mongo?
[11:11:28] <Siyfion> Am I right in thinking that the new v2.x Mongo Ruby driver, has no form of "find_one" method?
[11:12:06] <KekSi> what a stupid-ass problem that was just there -- apparently i was always connecting as a cluster member (certificate was ok by those requirements but not the ones for a client doing x509 authentication)
[15:02:03] <RedWraith> I'm trying to get a list of all entries that both weren't created by a particular person and haven't voted on the entry yet
[15:02:21] <RedWraith> I'm doing this, but my results indicate that it isn't bulletproof for keeping them from voting twice:
[15:03:15] <RedWraith> Is there something about $elemMatch I'm not getting? is there a better way to do this?
[15:06:46] <StephenLynx> does it act like heroin on their brains so they get withdraw if they stop using?
[15:07:39] <StephenLynx> and probably its not working because you are passing an array instead of an object.
[15:08:06] <koren> {$createdBy: {$ne: userId}, votes: {$elemMatch: { createdBy: {$ne: userId}}} i would try something like this
[15:12:18] <RedWraith> StephenLynx, I know there are criticisms of it, but it's perfectly clear to me what's going on. I use an IDE so indentation-based languages work quite well for me.
[15:17:34] <koren> {$createdBy: {$ne: userId}, 'votes.createdBy': {$ne: userId}} I think you dont need the elemMatch since using $ne
[15:18:20] <koren> StephenLynx: you know some people are working and they don't have choice sometimes, you don't know why he uses that stop being a dick
[15:20:48] <RedWraith> StephenLynx, what's so bad about CoffeeScript? I'm from the Java world originally and my coworker requested we use it because it makes code more legible. Thus far, I've seen him proven right (JavaScript loves brackets like Java loves parens). Then again, without an IDE, I'd imagine this language would be maddeningly difficult to use for exactly the same reasons Python would be.
[15:21:52] <StephenLynx> you are using js in your deploy, but now you have to transpile and in the process you are increasing the learning curve.
[15:22:20] <StephenLynx> because knowing js is not enough, now you have to know this small-time thing too to handle the code.
[15:23:08] <StephenLynx> koren, don't make assumptions on what I will fight or not. I don't use Go and I would still recommend for a given scenario.
[15:23:59] <StephenLynx> people are just making lame excuses and adding bloat to projects for not reason
[15:25:06] <RedWraith> StephenLynx, fair enough - I'm sure it's an issue for newer developers. This is a project with a small team though. And even before I learned coffeescript, I preferred reading code in it. It's definitely clearer, at least from my perspective.
[15:25:08] <StephenLynx> if people were to just do their homework instead of being dumb apes, they would just slap strict mode and move along with js.
[15:27:19] <StephenLynx> so are you saying that differentiating between INVISIBLE characters is more readable than brackets?
[15:27:41] <RedWraith> StephenLynx, but they aren't invisible, at least not in any modern text editor.
[15:29:05] <StephenLynx> so now you are telling me I have to use this obscure editor to use this awful and useless language?
[15:29:28] <RedWraith> StephenLynx, have you ever worked in industry? JetBrains makes the best IDE's available.
[15:30:39] <StephenLynx> but you have these crippled languages that need this feature to jumble your screen with whitespaces to be usable.
[15:31:10] <RedWraith> StephenLynx, it's much faster to write and it's easier to read, at least from my perspective.
[15:32:01] <mike_edmr> i dont enjoy typing {}s but typing code NOT the most time consuming part of development
[15:33:08] <mike_edmr> RedWraith: js doesnt lend itself to continuation passing, the function( param, function( param, function( param ){ })})})
[15:36:43] <RedWraith> StephenLynx, if it's easier to read and write for you and for your particular application, that's what's important. JS doesn't provide actual code benefits over coffeescript - the only differences are semantic. Many people find using tabs to be cleaner. If you don't, that's your business. I personally find unnecessary brackets and parentheses to be something of an inconvenience.
[15:38:24] <RedWraith> StephenLynx, your facts are the reason the only difference is semantic. Though, I've never personally experienced a bug because of coffeescript -> javascript transpilation.
[15:42:32] <StephenLynx> frameworks and ODMs are only good to get your software to a crawl and make marketing guys look good with buzzwords.
[15:45:48] <RedWraith> StephenLynx, Meteor is more than a framework. It lets you use the same code for the frontend as you use on the backend. Also, it simulates the backend with minimongo on the frontend. Other nice things as well.
[15:46:30] <koren> its like symfony was for php, it add lots of dependencies and things you will never need
[15:47:20] <koren> when you have npm I don't see the use of metor, realy. need to do something?npm install something
[15:47:56] <StephenLynx> I have a package.json that you just run npm install and bam, all deps are in place.
[15:48:55] <StephenLynx> if people were to actually LEARN what they are doing, they would stop using 90% of popular web tools in existence.
[15:49:53] <StephenLynx> and they wouldn't end up with unmaintainable crap projects bloated with two dozens of dependencies.
[15:50:31] <RedWraith> StephenLynx, the main point of Meteor, from what I've used so far, is that it automatically updates the client without having to use any sort of event code, including dependencies and does it hierarchically.
[15:52:29] <koren> StephenLynx: you come from java come on, you had jee whats the difference you used a whole massive framework. you don't liked programming back then?
[15:53:35] <StephenLynx> and I never used a whole massive framework, I used some elements from the standard SDK. which in turn, I must say its bloated as hell.
[15:53:35] <koren> http://en.wikipedia.org/wiki/Java_Platform,_Enterprise_Edition what comes with the jdk/jre
[15:54:20] <RedWraith> Also, StephenLynx, you're quite right to say I don't like programming. Ideally, any piece of software I write is 0 lines of code. I want to write as little code as necessary for my intended effect.
[15:55:18] <koren> StephenLynx: you said you use android studio, make the industry a better place and stop using it... oh wait
[17:22:15] <deathanchor> anyone ever experience issues with mongo not returning the same results for the same query (assuming no updates to the items being queried)?
[18:27:17] <arussel> with mongodump, how do you use the --query ? is it just in the case where you dump a single colletion so you pass a query on that collection ?
[18:50:14] <cheeser> odd would be the query that applied to multiple collections. unless you had something like a common timestamp or something.
[18:50:48] <Riobe> http://docs.mongodb.org/manual/reference/program/mongodump/#use shows an example of how to specify a collection
[18:51:02] <Riobe> http://docs.mongodb.org/manual/reference/program/mongodump/#cmdoption--collection is the flag
[20:34:52] <keeger> if I have a sharded system, can i have a client that only interacts with a specific shard's data? ie, a local client?
[20:52:55] <devenvy> I have a collection called groups with an org_id and name fields. Each org should only have 1 group with a distinct name. Should I just add a check in the application or create a unique index on those 2 fields?
[21:32:45] <techie28> bulk.find({enable:"D"}).upsert().update({$setOnInsert:{status:"I",points:"0"} });.. is this operation correct if I want to add records when enable = D is not found.
[21:37:29] <techie28> if that is right how to stack up bulk db operations while looping over a data array in JS?
[23:16:12] <Eduard_Munteanu> Is MongoDB used as a document management system / filesystem replacement for end-users? I'm looking for something like that and I wonder if some web-based interface does it.
[23:17:39] <Eduard_Munteanu> Well, I was hoping there was something already done. Like ownCloud, Alfresco or other stuff like that.
[23:18:24] <Eduard_Munteanu> Document-oriented databases / MongoDB seems rather well-suited for this.
[23:39:39] <Eduard_Munteanu> Is there any downside to using a top-level document as root for all documents to get atomicity? Why doesn't MongoDB provide root documents instead of collections?