python操作mongodb数据库①mongodb的安装和简单使用
参考文档：
中文版：http://www.mongoing.com/docs/crud.html
英文版：https://docs.mongodb.com/
环境准备：
1.下载mongodb for windows 2008r2版本，进行安装，建议安装在盘的根目录
比如安装在d:/mongodbserver目录下
安装完数据库以后可以设置环境变量，这样直接就可以在cmd命令行进行操作了
2.创建数据目录
D:mongodbserverdata
3.cmd命令行下启动mongodb程序
D:mongodbserverin>mongod --dbpath D:mongodbserverdata
基本概念：
文档：区分大小写、key唯一不可重复、文档可嵌套、键值对是有序的
集合：集合就是一组文档，文档类似关系数据库里的行，集合类似于关系数据库里的表，集合中的文档无需固定的结构(与关系型数据库的区别)
集合的命名规范：
1.不能是空字符串("")
2.不能包含 字符(空字符)
3.不能使用system.的前缀(系统保留)
4.建议不包含保留字"$"
5.用.分割不同命名空间的子集合(如：blog.users, blog.posts)
重点：
1.多个文档组成集合，多个集合组成数据库
2.一个实例可以承载多个数据库
3.每个数据库都有独立的权限
4.保留的数据库名称(admin,local,config)
基本操作：
cmd窗口敲入mongo回车进入命令行
1.函数的定义和使用
2.新增数据
> use students; switched to db students > stu = {"name":"jack","age":20 } { "name" : "jack", "age" : 20 } > db.students.insert(stu) WriteResult({ "nInserted" : 1 })
插入单条、多条数据
>db.students.insertMany([{"name":"lucy","age":25},{"name":"lilei","age":30},{"name":"hanmeimei","age":28}])
{
"acknowledged" : true,
"insertedIds" : [
ObjectId("5a9d58fbcfb5edc5e31235f4"),
ObjectId("5a9d58fbcfb5edc5e31235f5"),
ObjectId("5a9d58fbcfb5edc5e31235f6")
]
}
> db.students.find()
{ "_id" : ObjectId("5a9d5822cfb5edc5e31235f0"), "name" : "jack", "age" : 20 }
{ "_id" : ObjectId("5a9d5892cfb5edc5e31235f1"), "name" : "lily", "age" : 18 }
{ "_id" : ObjectId("5a9d58a3cfb5edc5e31235f2"), "name" : "tom", "age" : 25 }
{ "_id" : ObjectId("5a9d58cdcfb5edc5e31235f3"), "name" : "lucy", "age" : 25 }
{ "_id" : ObjectId("5a9d58fbcfb5edc5e31235f4"), "name" : "lucy", "age" : 25 }
{ "_id" : ObjectId("5a9d58fbcfb5edc5e31235f5"), "name" : "lilei", "age" : 30 }
{ "_id" : ObjectId("5a9d58fbcfb5edc5e31235f6"), "name" : "hanmeimei", "age" : 28 }
2.数据的查询
查询所有数据
3.查询单条数据
4.修改数据
5.删除数据
6.删除所有数据
> db.students.deleteMany({}) { "acknowledged" : true, "deletedCount" : 6 } > db.students.find()
练习任务：
1.创建一个学生信息表(至少包含：姓名、性别、成绩、年龄)
2.写入15条不同的数据
db.students.insertMany( [ {name: "bob", age:16, gender:"male", grade:95}, {name: "ana", age:18, gender:"female", grade:45}, {name: "xi", age:15, gender:"male", grade:75}, {name: "bob1", age:16, gender:"male", grade:95}, {name: "ana1", age:18, gender:"female", grade:45}, {name: "jack", age:18, gender:"male", grade:85}, {name: "tom", age:19, gender:"male", grade:65}, {name: "lily", age:16, gender:"female", grade:59}, {name: "lucy", age:18, gender:"female", grade:68}, {name: "lilei", age:18, gender:"female", grade:68}, {name: "hanmeimei", age:16, gender:"female", grade:90}, {name: "harry", age:16, gender:"male", grade:81}, {name: "json", age:16, gender:"male", grade:75}, {name: "jim", age:16, gender:"male", grade:36}, {name: "rose", age:16, gender:"female", grade:91}, {name: "moli", age:16, gender:"female", grade:93}, {name: "linda", age:16, gender:"female", grade:96} ] )
3.查询所有的男生数据(只需要学生的姓名和年龄)
> db.students.find({gender:"male"},{age:true,name:1,_id:0})
{ "name" : "bob", "age" : 16 }
{ "name" : "xi", "age" : 15 }
{ "name" : "bob1", "age" : 16 }
{ "name" : "jack", "age" : 18 }
{ "name" : "tom", "age" : 19 }
{ "name" : "harry", "age" : 16 }
{ "name" : "json", "age" : 16 }
{ "name" : "jim", "age" : 16 }
4.查询成绩几个的学生信息(学生成绩大于或等于60分)
> db.students.find({grade :{$gte:60}})
5.查询所有18岁的男生和16岁女生的数据
> db.students.find({$or :[{gender:"female",age:16},{gender:"male",age:18}]})
{ "_id" : ObjectId("5a9df2e48a86b467d4a2c44e"), "name" : "jack", "age" : 18, "gender" : "male", "grade" : 85 }
{ "_id" : ObjectId("5a9df2e48a86b467d4a2c450"), "name" : "lily", "age" : 16, "gender" : "female", "grade" : 59 }
{ "_id" : ObjectId("5a9df2e48a86b467d4a2c453"), "name" : "hanmeimei", "age" : 16, "gender" : "female", "grade" : 90 }
{ "_id" : ObjectId("5a9df2e48a86b467d4a2c457"), "name" : "rose", "age" : 16, "gender" : "female", "grade" : 91 }
{ "_id" : ObjectId("5a9df2e48a86b467d4a2c458"), "name" : "moli", "age" : 16, "gender" : "female", "grade" : 93 }
{ "_id" : ObjectId("5a9df2e48a86b467d4a2c459"), "name" : "linda", "age" : 16, "gender" : "female", "grade" : 96 }
6.按照学生的分数进行排序
从小到大
> db.students.find().sort({grade:1})
从大到小，倒序
> db.students.find().sort({grade:-1})
7.将所有女生年龄增加一岁
> db.students.update({gender:"female"}, {$inc:{age:1}}, {multi:true})
WriteResult({ "nMatched" : 9, "nUpserted" : 0, "nModified" : 9 })