MongoDB 기초

MongoDB 기초

 

                        "content" : "nice post."
                }
        ],
        "content" : "content",
        "title" : "A blog post"
}
> db.blog.posts.update({"title":"A blog post"},{$push:{"comments": {"name":"joe", "email":"joe@aaa.c
om","content":"nice post!!!"}}})
> db.blog.posts.findOne()
{
        "_id" : ObjectId("510b8034b2440d8e4c547831"),
        "comments" : [
                {
                        "name" : "joe",
                        "email" : "joe@aaa.com",
                        "content" : "nice post."
                },
                {
                        "name" : "joe",
                        "email" : "joe@aaa.com",
                        "content" : "nice post!!!"
                }
        ],
        "content" : "content",
        "title" : "A blog post"
}
> db.blog.posts.update({"readCnt":{"$ne":1}})
assert failed : need an object
Error("Printing Stack Trace")@:0
()@src/mongo/shell/utils.js:37
("assert failed : need an object")@src/mongo/shell/utils.js:58
(undefined,"need an object")@src/mongo/shell/utils.js:66
([object Object])@src/mongo/shell/collection.js:197
@(shell):1

Fri Feb 01 17:48:58 uncaught exception: assert failed : need an object
> db.blog.posts.update({"title":"A blog post"},{"readCnt":{"$ne":1}})
Fri Feb 01 17:49:39 uncaught exception: field names cannot start with $ [$ne]
> db.blog.posts.update({"title":"A blog post"},{"readCnt":{"$ne":1}})
Fri Feb 01 17:50:13 uncaught exception: field names cannot start with $ [$ne]
> db.papers.update({"authors cited":{"$ne","Richie"}},
... {$push:{"authors cited":"Richie"}})
Fri Feb 01 17:51:06 SyntaxError: missing : after property id (shell):1
> db.papers.update({"authors cited":{"$ne","Richie"}}, {$push:{"authors cited":"Richie"}})
Fri Feb 01 17:51:36 SyntaxError: missing : after property id (shell):1
> db.users.findOne()
{
        "_id" : ObjectId("510b7be8b2440d8e4c54782e"),
        "age" : 30,
        "favorite book" : [
                "cat's cradle",
                "foundation trilogy",
                "ender's game"
        ],
        "location" : "Wisconsin",
        "name" : "joe",
        "sex" : "male"
}
> db.users.update({"name":"joe"},{$push:{"email":"aaa@aaa.com"}})
> db.users.findOne()
{
        "_id" : ObjectId("510b7be8b2440d8e4c54782e"),
        "age" : 30,
        "email" : [
                "aaa@aaa.com"
        ],
        "favorite book" : [
                "cat's cradle",
                "foundation trilogy",
                "ender's game"
        ],
        "location" : "Wisconsin",
        "name" : "joe",
        "sex" : "male"
}
> joe = db.users.findOne({"name":"joe"})
{
        "_id" : ObjectId("510b7be8b2440d8e4c54782e"),
        "age" : 30,
        "email" : [
                "aaa@aaa.com"
        ],
        "favorite book" : [
                "cat's cradle",
                "foundation trilogy",
                "ender's game"
        ],
        "location" : "Wisconsin",
        "name" : "joe",
        "sex" : "male"
}
> delete joe.email
true
> joe
{
        "_id" : ObjectId("510b7be8b2440d8e4c54782e"),
        "age" : 30,
        "favorite book" : [
                "cat's cradle",
                "foundation trilogy",
                "ender's game"
        ],
        "location" : "Wisconsin",
        "name" : "joe",
        "sex" : "male"
}
> joe.email = "aaa@aaa.com"
aaa@aaa.com
> joe
{
        "_id" : ObjectId("510b7be8b2440d8e4c54782e"),
        "age" : 30,
        "email" : "aaa@aaa.com",
        "favorite book" : [
                "cat's cradle",
                "foundation trilogy",
                "ender's game"
        ],
        "location" : "Wisconsin",
        "name" : "joe",
        "sex" : "male"
}
> db.users.update({"name":"joe"},joe)
> db.users.findOne()
{
        "_id" : ObjectId("510b7be8b2440d8e4c54782e"),
        "age" : 30,
        "email" : "aaa@aaa.com",
        "favorite book" : [
                "cat's cradle",
                "foundation trilogy",
                "ender's game"
        ],
        "location" : "Wisconsin",
        "name" : "joe",
        "sex" : "male"
}
> joe = db.users.findOne({"name":"joe"})
{
        "_id" : ObjectId("510b7be8b2440d8e4c54782e"),
        "age" : 30,
        "email" : "aaa@aaa.com",
        "favorite book" : [
                "cat's cradle",
                "foundation trilogy",
                "ender's game"
        ],
        "location" : "Wisconsin",
        "name" : "joe",
        "sex" : "male"
}
> delete joe.email
true
> joe
{
        "_id" : ObjectId("510b7be8b2440d8e4c54782e"),
        "age" : 30,
        "favorite book" : [
                "cat's cradle",
                "foundation trilogy",
                "ender's game"
        ],
        "location" : "Wisconsin",
        "name" : "joe",
        "sex" : "male"
}
> db.users.update({"name":"joe"},joe)
> db.users.fineOne(_
... )
Fri Feb 01 17:57:03 ReferenceError: _ is not defined (shell):1
> db.users.fineOne()
Fri Feb 01 17:57:07 TypeError: db.users.fineOne is not a function (shell):1
> db.users.findOne()
{
        "_id" : ObjectId("510b7be8b2440d8e4c54782e"),
        "age" : 30,
        "favorite book" : [
                "cat's cradle",
                "foundation trilogy",
                "ender's game"
        ],
        "location" : "Wisconsin",
        "name" : "joe",
        "sex" : "male"
}
> db.users.update({"name":"joe"},{$push:{"email":"aaa@mail.com"})
... )
Fri Feb 01 17:58:02 SyntaxError: missing } after property list (shell):1
> db.users.update({"name":"joe"},{$push:{"email":"aaa@mail.com"}})
> db.users.findOne()
{
        "_id" : ObjectId("510b7be8b2440d8e4c54782e"),
        "age" : 30,
        "email" : [
                "aaa@mail.com"
        ],
        "favorite book" : [
                "cat's cradle",
                "foundation trilogy",
                "ender's game"
        ],
        "location" : "Wisconsin",
        "name" : "joe",
        "sex" : "male"
}
> db.users.update({"name":"joe"},{$push:{"email":"bbb@mail.com"}})
> db.users.findOne()
{
        "_id" : ObjectId("510b7be8b2440d8e4c54782e"),
        "age" : 30,
        "email" : [
                "aaa@mail.com",
                "bbb@mail.com"
        ],
        "favorite book" : [
                "cat's cradle",
                "foundation trilogy",
                "ender's game"
        ],
        "location" : "Wisconsin",
        "name" : "joe",
        "sex" : "male"
}
> db.users.update({"name":"joe"},{"$addToSet":{email:"aaa@mail.com"}})
> db.users.findOne()
{
        "_id" : ObjectId("510b7be8b2440d8e4c54782e"),
        "age" : 30,
        "email" : [
                "aaa@mail.com",
                "bbb@mail.com"
        ],
        "favorite book" : [
                "cat's cradle",
                "foundation trilogy",
                "ender's game"
        ],
        "location" : "Wisconsin",
        "name" : "joe",
        "sex" : "male"
}
> db.users.update({"name":"joe"},{"$addToSet":{email:"ccc@mail.com"}})
> db.users.findOne()
{
        "_id" : ObjectId("510b7be8b2440d8e4c54782e"),
        "age" : 30,
        "email" : [
                "aaa@mail.com",
                "bbb@mail.com",
                "ccc@mail.com"
        ],
        "favorite book" : [
                "cat's cradle",
                "foundation trilogy",
                "ender's game"
        ],
        "location" : "Wisconsin",
        "name" : "joe",
        "sex" : "male"
}
> db.users.update({"name":"joe"},{"$addToSet":{email:{"$each":["aaa@mail.com","ddd@mail.com"]}}})
> db.users.findOne()
{
        "_id" : ObjectId("510b7be8b2440d8e4c54782e"),
        "age" : 30,
        "email" : [
                "aaa@mail.com",
                "bbb@mail.com",
                "ccc@mail.com",
                "ddd@mail.com"
        ],
        "favorite book" : [
                "cat's cradle",
                "foundation trilogy",
                "ender's game"
        ],
        "location" : "Wisconsin",
        "name" : "joe",
        "sex" : "male"
}
> db.users.update({"name":"joe"},{$pop:{"email":1}})
> db.users.findOne()
{
        "_id" : ObjectId("510b7be8b2440d8e4c54782e"),
        "age" : 30,
        "email" : [
                "aaa@mail.com",
                "bbb@mail.com",
                "ccc@mail.com"
        ],
        "favorite book" : [
                "cat's cradle",
                "foundation trilogy",
                "ender's game"
        ],
        "location" : "Wisconsin",
        "name" : "joe",
        "sex" : "male"
}
>