Skip to content

Instantly share code, notes, and snippets.

@adkron

adkron/embeded_fields.js

Created October 26, 2010 01:53
Show Gist options
  • Save adkron/646178 to your computer and use it in GitHub Desktop.
Save adkron/646178 to your computer and use it in GitHub Desktop.
Download ZIP
mongodb document
Raw
embeded_fields.js
{ "_id" : ObjectId("4cc624373437595e787c1d0e"), "attrs" : [
{
"name" : "First Name",
"value" : "Amos",
public : false
},
{
"name" : "age",
"value" : 29,
"public" : true
}
] }
Raw
example_user.js
db.users.find({$or : [{$elemMatch : {field_value : /nick1/i, visible_site_wide:true}}, {nickname : /nick1/i}]}).next()
{
"_id" : ObjectId("4ce44cee75f5717590000001"),
"attributes" : [
{
"field_name" : "first_name",
"field_value" : "nick1",
"visible_sitewide" : false,
"connections_visible_to" : [
ObjectId("4ce44cef75f57175900022e9"),
ObjectId("4ce44cee75f57175900005b8"),
ObjectId("4ce44cee75f57175900004fe"),
ObjectId("4ce44cef75f5717590001f24"),
ObjectId("4ce44cee75f571759000032c"),
ObjectId("4ce44cee75f5717590000396"),
ObjectId("4ce44cef75f57175900021e9"),
ObjectId("4ce44cef75f571759000257f"),
ObjectId("4ce44cef75f571759000169a"),
ObjectId("4ce44cee75f57175900012cd"),
ObjectId("4ce44cef75f5717590001adb"),
ObjectId("4ce44cef75f5717590002321"),
ObjectId("4ce44cee75f5717590000d52"),
ObjectId("4ce44cee75f5717590000bcd"),
ObjectId("4ce44cef75f571759000174a"),
ObjectId("4ce44cef75f5717590001d60"),
ObjectId("4ce44cef75f571759000267a"),
ObjectId("4ce44cef75f5717590001df9"),
ObjectId("4ce44cef75f571759000167a"),
ObjectId("4ce44cee75f5717590001350"),
ObjectId("4ce44cee75f571759000034a"),
ObjectId("4ce44cef75f5717590001535"),
ObjectId("4ce44cef75f5717590001ce5"),
ObjectId("4ce44cef75f5717590001ce7"),
ObjectId("4ce44cef75f5717590002608"),
ObjectId("4ce44cee75f5717590000a8c"),
ObjectId("4ce44cef75f57175900024e5"),
ObjectId("4ce44cef75f571759000243d"),
ObjectId("4ce44cee75f57175900001a6"),
ObjectId("4ce44cee75f5717590000221"),
ObjectId("4ce44cee75f5717590000057"),
ObjectId("4ce44cef75f57175900020e5"),
ObjectId("4ce44cee75f57175900002cb"),
ObjectId("4ce44cee75f5717590000b6a"),
ObjectId("4ce44cef75f5717590002274"),
ObjectId("4ce44cef75f57175900017f8"),
ObjectId("4ce44cee75f5717590001022"),
ObjectId("4ce44cef75f5717590002308"),
ObjectId("4ce44cee75f571759000111f"),
ObjectId("4ce44cee75f5717590001346"),
ObjectId("4ce44cef75f57175900018c3"),
ObjectId("4ce44cef75f5717590001a5c"),
ObjectId("4ce44cee75f57175900002eb"),
ObjectId("4ce44cee75f571759000023f"),
ObjectId("4ce44cee75f57175900001d4"),
ObjectId("4ce44cee75f571759000089a"),
ObjectId("4ce44cee75f571759000016d"),
ObjectId("4ce44cee75f57175900007c3"),
ObjectId("4ce44cef75f5717590001a7e"),
ObjectId("4ce44cef75f5717590001e9e")
]
},
{
"field_name" : "middle_initial",
"field_value" : "a",
"visible_sitewide" : false,
"connections_visible_to" : [
ObjectId("4ce44cee75f5717590000ba4"),
ObjectId("4ce44cef75f571759000169b"),
ObjectId("4ce44cee75f5717590000f24"),
ObjectId("4ce44cef75f57175900025bb"),
ObjectId("4ce44cee75f571759000043e"),
ObjectId("4ce44cef75f5717590001ccd"),
ObjectId("4ce44cee75f57175900010a6"),
ObjectId("4ce44cef75f5717590001a26"),
ObjectId("4ce44cee75f5717590001211"),
ObjectId("4ce44cee75f5717590000388"),
ObjectId("4ce44cee75f57175900006c9"),
ObjectId("4ce44cef75f5717590001eee"),
ObjectId("4ce44cee75f571759000093b"),
ObjectId("4ce44cef75f57175900021e0"),
ObjectId("4ce44cef75f57175900025a0"),
ObjectId("4ce44cef75f5717590001c62"),
ObjectId("4ce44cee75f57175900004e3"),
ObjectId("4ce44cee75f5717590000392"),
ObjectId("4ce44cee75f5717590001124"),
ObjectId("4ce44cef75f57175900015f5"),
ObjectId("4ce44cee75f57175900012bc"),
ObjectId("4ce44cee75f57175900012fa"),
ObjectId("4ce44cef75f5717590001809"),
ObjectId("4ce44cee75f57175900005a7"),
ObjectId("4ce44cef75f5717590002304"),
ObjectId("4ce44cee75f5717590000704"),
ObjectId("4ce44cef75f5717590001781"),
ObjectId("4ce44cee75f5717590000263"),
ObjectId("4ce44cee75f571759000024f"),
ObjectId("4ce44cee75f5717590001083"),
ObjectId("4ce44cee75f57175900009d5"),
ObjectId("4ce44cef75f57175900017a5"),
ObjectId("4ce44cef75f5717590001c93"),
ObjectId("4ce44cef75f571759000165b"),
ObjectId("4ce44cee75f57175900006b5"),
ObjectId("4ce44cee75f571759000029f"),
ObjectId("4ce44cee75f57175900010a2"),
ObjectId("4ce44cee75f5717590000de9"),
ObjectId("4ce44cef75f57175900022a8"),
ObjectId("4ce44cee75f5717590000aba"),
ObjectId("4ce44cef75f5717590001d13"),
ObjectId("4ce44cef75f57175900026f3"),
ObjectId("4ce44cef75f571759000255d"),
ObjectId("4ce44cee75f5717590000766"),
ObjectId("4ce44cef75f5717590002456"),
ObjectId("4ce44cef75f571759000216e"),
ObjectId("4ce44cef75f5717590001fb1"),
ObjectId("4ce44cee75f5717590000dd2"),
ObjectId("4ce44cee75f57175900004a8"),
ObjectId("4ce44cef75f5717590001661")
]
},
{
"field_name" : "last_name",
"field_value" : "txibgpypjkhipxfezf",
"visible_sitewide" : false,
"connections_visible_to" : [
ObjectId("4ce44cef75f5717590001a90"),
ObjectId("4ce44cef75f5717590001b9d"),
ObjectId("4ce44cef75f571759000147c"),
ObjectId("4ce44cee75f5717590000a88"),
ObjectId("4ce44cef75f5717590001f92"),
ObjectId("4ce44cee75f5717590000835"),
ObjectId("4ce44cef75f5717590001cf2"),
ObjectId("4ce44cee75f57175900002f3"),
ObjectId("4ce44cef75f57175900024f9"),
ObjectId("4ce44cee75f5717590000c4d"),
ObjectId("4ce44cee75f5717590000696"),
ObjectId("4ce44cee75f5717590000ce3"),
ObjectId("4ce44cef75f57175900017a3"),
ObjectId("4ce44cef75f5717590001665"),
ObjectId("4ce44cef75f571759000175b"),
ObjectId("4ce44cef75f5717590002637"),
ObjectId("4ce44cef75f5717590001d0e"),
ObjectId("4ce44cef75f5717590001b99"),
ObjectId("4ce44cee75f571759000094e"),
ObjectId("4ce44cef75f571759000216b"),
ObjectId("4ce44cef75f57175900019a5"),
ObjectId("4ce44cee75f571759000095c"),
ObjectId("4ce44cef75f57175900025e1"),
ObjectId("4ce44cee75f5717590000d50"),
ObjectId("4ce44cef75f5717590001584"),
ObjectId("4ce44cee75f5717590000df9"),
ObjectId("4ce44cee75f57175900010a3"),
ObjectId("4ce44cee75f5717590001032"),
ObjectId("4ce44cef75f57175900022e2"),
ObjectId("4ce44cef75f571759000147e"),
ObjectId("4ce44cee75f571759000118b"),
ObjectId("4ce44cef75f5717590001980"),
ObjectId("4ce44cef75f571759000159b"),
ObjectId("4ce44cef75f57175900019e3"),
ObjectId("4ce44cef75f571759000200c"),
ObjectId("4ce44cef75f5717590001939"),
ObjectId("4ce44cee75f57175900005ae"),
ObjectId("4ce44cee75f57175900010d7"),
ObjectId("4ce44cef75f57175900016b0"),
ObjectId("4ce44cee75f5717590000ff6"),
ObjectId("4ce44cee75f5717590000863"),
ObjectId("4ce44cef75f5717590002114"),
ObjectId("4ce44cee75f5717590000b55"),
ObjectId("4ce44cee75f57175900011fe"),
ObjectId("4ce44cef75f5717590002396"),
ObjectId("4ce44cef75f5717590001539"),
ObjectId("4ce44cee75f57175900007ed"),
ObjectId("4ce44cee75f5717590000a7c"),
ObjectId("4ce44cef75f571759000222e"),
ObjectId("4ce44cee75f571759000053d")
]
},
{
"field_name" : "dob_day",
"field_value" : 12,
"visible_sitewide" : true,
"connections_visible_to" : [
ObjectId("4ce44cef75f57175900016e8"),
ObjectId("4ce44cef75f5717590001dc6"),
ObjectId("4ce44cef75f5717590002208"),
ObjectId("4ce44cee75f5717590000e3d"),
ObjectId("4ce44cef75f5717590001c10"),
ObjectId("4ce44cee75f571759000084e"),
ObjectId("4ce44cee75f571759000064f"),
ObjectId("4ce44cef75f57175900015d2"),
ObjectId("4ce44cef75f571759000224e"),
ObjectId("4ce44cef75f5717590002478"),
ObjectId("4ce44cee75f5717590000923"),
ObjectId("4ce44cee75f5717590000ae2"),
ObjectId("4ce44cee75f571759000020a"),
ObjectId("4ce44cef75f5717590001ddb"),
ObjectId("4ce44cee75f5717590000bae"),
ObjectId("4ce44cee75f5717590000af5"),
ObjectId("4ce44cee75f5717590001341"),
ObjectId("4ce44cee75f5717590000186"),
ObjectId("4ce44cef75f5717590001b58"),
ObjectId("4ce44cef75f571759000260f"),
ObjectId("4ce44cef75f5717590001721"),
ObjectId("4ce44cef75f5717590002385"),
ObjectId("4ce44cef75f571759000190a"),
ObjectId("4ce44cee75f57175900010a6"),
ObjectId("4ce44cef75f5717590002483"),
ObjectId("4ce44cee75f5717590001320"),
ObjectId("4ce44cef75f5717590001d6f"),
ObjectId("4ce44cef75f5717590001f3f"),
ObjectId("4ce44cef75f571759000204b"),
ObjectId("4ce44cef75f5717590002534"),
ObjectId("4ce44cee75f57175900002fc"),
ObjectId("4ce44cef75f5717590001560"),
ObjectId("4ce44cef75f57175900015ff"),
ObjectId("4ce44cef75f5717590001d65"),
ObjectId("4ce44cef75f57175900014e6"),
ObjectId("4ce44cee75f5717590000d1a"),
ObjectId("4ce44cef75f571759000228e"),
ObjectId("4ce44cee75f571759000058f"),
ObjectId("4ce44cef75f5717590001677"),
ObjectId("4ce44cee75f57175900004de"),
ObjectId("4ce44cee75f5717590000c90"),
ObjectId("4ce44cef75f5717590001517"),
ObjectId("4ce44cef75f5717590001bde"),
ObjectId("4ce44cef75f57175900019ed"),
ObjectId("4ce44cef75f5717590001d35"),
ObjectId("4ce44cef75f57175900014cf"),
ObjectId("4ce44cef75f5717590001b27"),
ObjectId("4ce44cef75f571759000246a"),
ObjectId("4ce44cee75f57175900002ca"),
ObjectId("4ce44cee75f571759000107f")
]
},
{
"field_name" : "dob_month",
"field_value" : 12,
"visible_sitewide" : false,
"connections_visible_to" : [
ObjectId("4ce44cef75f5717590001dec"),
ObjectId("4ce44cef75f571759000269e"),
ObjectId("4ce44cef75f5717590001e95"),
ObjectId("4ce44cee75f5717590000f7c"),
ObjectId("4ce44cef75f5717590002333"),
ObjectId("4ce44cef75f5717590001c16"),
ObjectId("4ce44cee75f57175900002f0"),
ObjectId("4ce44cef75f571759000170d"),
ObjectId("4ce44cee75f57175900008ed"),
ObjectId("4ce44cee75f57175900006c1"),
ObjectId("4ce44cee75f5717590000eeb"),
ObjectId("4ce44cee75f5717590000c0c"),
ObjectId("4ce44cee75f571759000127c"),
ObjectId("4ce44cee75f5717590001138"),
ObjectId("4ce44cee75f5717590000c1e"),
ObjectId("4ce44cef75f5717590002465"),
ObjectId("4ce44cee75f5717590000fa3"),
ObjectId("4ce44cef75f57175900021b1"),
ObjectId("4ce44cee75f5717590000f39"),
ObjectId("4ce44cef75f5717590001b64"),
ObjectId("4ce44cee75f571759000113d"),
ObjectId("4ce44cee75f5717590000ca8"),
ObjectId("4ce44cee75f5717590001230"),
ObjectId("4ce44cef75f57175900022b0"),
ObjectId("4ce44cee75f571759000140f"),
ObjectId("4ce44cef75f571759000193b"),
ObjectId("4ce44cee75f5717590000099"),
ObjectId("4ce44cef75f5717590002118"),
ObjectId("4ce44cee75f57175900002f9"),
ObjectId("4ce44cee75f57175900004b7"),
ObjectId("4ce44cef75f571759000175e"),
ObjectId("4ce44cee75f5717590000dfb"),
ObjectId("4ce44cee75f57175900000b1"),
ObjectId("4ce44cee75f571759000097d"),
ObjectId("4ce44cef75f5717590001dd4"),
ObjectId("4ce44cee75f571759000096d"),
ObjectId("4ce44cef75f5717590001db9"),
ObjectId("4ce44cef75f5717590001eb7"),
ObjectId("4ce44cef75f571759000189b"),
ObjectId("4ce44cef75f5717590001942"),
ObjectId("4ce44cef75f5717590001852"),
ObjectId("4ce44cee75f571759000037e"),
ObjectId("4ce44cef75f57175900015ce"),
ObjectId("4ce44cef75f5717590001850"),
ObjectId("4ce44cee75f5717590000473"),
ObjectId("4ce44cef75f5717590002082"),
ObjectId("4ce44cee75f5717590001223"),
ObjectId("4ce44cee75f5717590000f0e"),
ObjectId("4ce44cee75f57175900011bd"),
ObjectId("4ce44cee75f57175900001de")
]
},
{
"field_name" : "dob_year",
"field_value" : 1995,
"visible_sitewide" : true,
"connections_visible_to" : [
ObjectId("4ce44cee75f57175900009da"),
ObjectId("4ce44cef75f571759000219e"),
ObjectId("4ce44cef75f571759000150e"),
ObjectId("4ce44cee75f571759000133d"),
ObjectId("4ce44cef75f571759000221a"),
ObjectId("4ce44cee75f5717590000e06"),
ObjectId("4ce44cee75f5717590000da1"),
ObjectId("4ce44cee75f5717590000300"),
ObjectId("4ce44cee75f5717590000821"),
ObjectId("4ce44cef75f5717590002416"),
ObjectId("4ce44cee75f5717590000816"),
ObjectId("4ce44cef75f57175900026bd"),
ObjectId("4ce44cee75f57175900007fe"),
ObjectId("4ce44cee75f5717590000018"),
ObjectId("4ce44cee75f5717590001409"),
ObjectId("4ce44cef75f5717590002329"),
ObjectId("4ce44cef75f57175900020db"),
ObjectId("4ce44cef75f571759000231c"),
ObjectId("4ce44cef75f571759000243f"),
ObjectId("4ce44cef75f5717590001a7e"),
ObjectId("4ce44cee75f5717590000cdd"),
ObjectId("4ce44cef75f571759000198e"),
ObjectId("4ce44cef75f57175900014fa"),
ObjectId("4ce44cef75f57175900018b7"),
ObjectId("4ce44cee75f5717590000d24"),
ObjectId("4ce44cee75f571759000017d"),
ObjectId("4ce44cee75f57175900003a8"),
ObjectId("4ce44cef75f5717590001bcd"),
ObjectId("4ce44cef75f571759000183a"),
ObjectId("4ce44cee75f5717590000e8a"),
ObjectId("4ce44cef75f5717590001796"),
ObjectId("4ce44cee75f5717590000d93"),
ObjectId("4ce44cef75f5717590001f16"),
ObjectId("4ce44cef75f57175900015dd"),
ObjectId("4ce44cee75f5717590000bab"),
ObjectId("4ce44cef75f57175900015aa"),
ObjectId("4ce44cee75f5717590000b83"),
ObjectId("4ce44cef75f571759000247e"),
ObjectId("4ce44cee75f571759000104e"),
ObjectId("4ce44cef75f57175900019c3"),
ObjectId("4ce44cee75f5717590000c18"),
ObjectId("4ce44cef75f5717590001b05"),
ObjectId("4ce44cef75f5717590001440"),
ObjectId("4ce44cef75f5717590001d1a"),
ObjectId("4ce44cef75f5717590002523"),
ObjectId("4ce44cef75f571759000261b"),
ObjectId("4ce44cef75f571759000244d"),
ObjectId("4ce44cee75f5717590000402"),
ObjectId("4ce44cef75f5717590001ae6"),
ObjectId("4ce44cee75f57175900000b3")
]
},
{
"field_name" : "gender",
"field_value" : "female",
"visible_sitewide" : false,
"connections_visible_to" : [
ObjectId("4ce44cee75f57175900011a8"),
ObjectId("4ce44cee75f5717590001081"),
ObjectId("4ce44cef75f5717590001796"),
ObjectId("4ce44cee75f5717590000600"),
ObjectId("4ce44cef75f5717590001d56"),
ObjectId("4ce44cee75f5717590000b21"),
ObjectId("4ce44cee75f57175900010e7"),
ObjectId("4ce44cee75f57175900001c6"),
ObjectId("4ce44cee75f57175900005ee"),
ObjectId("4ce44cee75f5717590000853"),
ObjectId("4ce44cee75f5717590000b08"),
ObjectId("4ce44cee75f5717590000a43"),
ObjectId("4ce44cee75f5717590000e01"),
ObjectId("4ce44cee75f571759000120d"),
ObjectId("4ce44cef75f5717590002004"),
ObjectId("4ce44cee75f5717590000721"),
ObjectId("4ce44cee75f5717590000010"),
ObjectId("4ce44cef75f57175900018b3"),
ObjectId("4ce44cee75f5717590000990"),
ObjectId("4ce44cee75f5717590000511"),
ObjectId("4ce44cee75f5717590000ad3"),
ObjectId("4ce44cef75f57175900021c1"),
ObjectId("4ce44cef75f571759000195a"),
ObjectId("4ce44cee75f5717590001260"),
ObjectId("4ce44cee75f5717590000cac"),
ObjectId("4ce44cef75f57175900026c3"),
ObjectId("4ce44cee75f57175900012f6"),
ObjectId("4ce44cef75f571759000263e"),
ObjectId("4ce44cee75f571759000019f"),
ObjectId("4ce44cee75f5717590000145"),
ObjectId("4ce44cee75f5717590000bec"),
ObjectId("4ce44cee75f5717590000890"),
ObjectId("4ce44cee75f5717590000f6d"),
ObjectId("4ce44cee75f5717590000644"),
ObjectId("4ce44cef75f57175900014ba"),
ObjectId("4ce44cee75f5717590000c5c"),
ObjectId("4ce44cee75f57175900008bd"),
ObjectId("4ce44cee75f57175900013aa"),
ObjectId("4ce44cee75f57175900012e6"),
ObjectId("4ce44cee75f5717590000483"),
ObjectId("4ce44cee75f571759000000f"),
ObjectId("4ce44cef75f5717590001bec"),
ObjectId("4ce44cee75f5717590000435"),
ObjectId("4ce44cee75f5717590000008"),
ObjectId("4ce44cef75f5717590001c6d"),
ObjectId("4ce44cee75f5717590000ce0"),
ObjectId("4ce44cee75f57175900006c0"),
ObjectId("4ce44cef75f5717590001a57"),
ObjectId("4ce44cef75f5717590002097"),
ObjectId("4ce44cef75f571759000262d")
]
},
{
"field_name" : "email",
"field_value" : "[email protected]",
"visible_sitewide" : true,
"connections_visible_to" : [
ObjectId("4ce44cef75f5717590002207"),
ObjectId("4ce44cef75f5717590001976"),
ObjectId("4ce44cef75f57175900019bb"),
ObjectId("4ce44cee75f57175900010ba"),
ObjectId("4ce44cee75f5717590000287"),
ObjectId("4ce44cee75f571759000006c"),
ObjectId("4ce44cee75f5717590000b44"),
ObjectId("4ce44cef75f5717590001ada"),
ObjectId("4ce44cef75f5717590002083"),
ObjectId("4ce44cef75f5717590001c33"),
ObjectId("4ce44cee75f5717590000f6b"),
ObjectId("4ce44cef75f571759000189c"),
ObjectId("4ce44cee75f5717590000557"),
ObjectId("4ce44cef75f57175900020c7"),
ObjectId("4ce44cee75f5717590000d52"),
ObjectId("4ce44cee75f57175900005ae"),
ObjectId("4ce44cee75f57175900000ff"),
ObjectId("4ce44cee75f571759000106e"),
ObjectId("4ce44cef75f5717590001e06"),
ObjectId("4ce44cee75f571759000043e"),
ObjectId("4ce44cef75f57175900021b1"),
ObjectId("4ce44cee75f57175900009d1"),
ObjectId("4ce44cee75f5717590000cb9"),
ObjectId("4ce44cee75f5717590000cb9"),
ObjectId("4ce44cef75f57175900015de"),
ObjectId("4ce44cef75f571759000153b"),
ObjectId("4ce44cee75f57175900000c4"),
ObjectId("4ce44cef75f5717590001963"),
ObjectId("4ce44cef75f57175900019c4"),
ObjectId("4ce44cef75f57175900018e6"),
ObjectId("4ce44cee75f5717590000861"),
ObjectId("4ce44cef75f5717590002618"),
ObjectId("4ce44cee75f5717590000560"),
ObjectId("4ce44cee75f57175900007f4"),
ObjectId("4ce44cee75f5717590001175"),
ObjectId("4ce44cef75f57175900020b6"),
ObjectId("4ce44cee75f5717590000046"),
ObjectId("4ce44cef75f57175900023a4"),
ObjectId("4ce44cef75f57175900025ec"),
ObjectId("4ce44cee75f5717590000454"),
ObjectId("4ce44cef75f571759000147b"),
ObjectId("4ce44cef75f5717590002425"),
ObjectId("4ce44cee75f5717590000786"),
ObjectId("4ce44cef75f5717590001ea7"),
ObjectId("4ce44cee75f5717590000c98"),
ObjectId("4ce44cee75f5717590000ad3"),
ObjectId("4ce44cef75f5717590001781"),
ObjectId("4ce44cef75f57175900018a2"),
ObjectId("4ce44cef75f5717590001f9c"),
ObjectId("4ce44cef75f5717590002190")
]
}
],
"nickname" : "nick1"
}
Raw
query.js
db.users.find({'attrs':{$elemMatch : {'value':29, 'public':true}}}); #=> obj
db.users.find({'attrs':{$elemMatch : {'value':'Amos', 'public':false}}}); #=> obj
db.users.find({'attrs':{$elemMatch : {'value':'Amos', 'public':true}}}); #=> null
db.users.find({'attrs':{$elemMatch : {'value':28, 'public':true}}}); #=> null
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment