霍城延的随笔

官网4.0~ 安装https://docs.mongodb.com/v4.0/tutorial/install-mongodb-on-ubuntu/如果报缺库mongodb-org-server : Depends: libcurl3 (>= 7.16.2) but it is not going to be installed执行sudo apt-get insta...

db.getCollection('userinfo').find({"sex":"1"}).forEach( function(item){ db.getCollection('userinfo').update({"_id":item._id},{$set:{"name": "back_up"+item.name}})...

sudo mongod -f /etc/mongod.conf &

错误信息sudo apt-get install mongodb-org-serverReading package lists... DoneBuilding dependency tree Reading state information... DoneSome packages could not be installed. This may mean th...

备份mongodump -h dbhost -d dbname -o dbdirectory还原目录/home/thkadmindb/thkadmindbmongorestore -h localhost -d publicDB /home/thk/164/dump/publicDB

数据 1800万 数据一直增加中优化前 耗时：7.9s(未加索引，查询时CPU飞了)filter = bson.D{{"userid", userid}, {"height", height}}Txs, err := c.Mgo.Collection(m.UserTxs).Find(context.Background(), filter, opts)sCount, err := c...

本博客代码已发布在github：https://github.com/Huochengyan/myGoProject第一步： 服务器生成Token package apiimport ( "github.com/astaxie/beego/validation" "github.com/gin-gonic/gin" "log" "myProject/corll" ...

分页查询：/* 分页获取用户 */func (c *UserC) GetALLUserByPage(g *gin.Context) { rsp := new(Rsp) var info PostParamTx err := g.BindJSON(&info) if err != nil { rsp.Msg = "json faild" rsp.Code = 201...

1. 范围查询： 类似sql: between and ... （ 30<x<40 ） 举例： filter := bson.D{{"cid", cid}, {"height", bson.M{"$gte": startheight, "$lt": endheight}}}2.包含查询： 类似sql: where id in(........

直接代码：想实现类似sql where nickname="张三" sex=1or sex=2 的效果。mongo官方的例子使用一直报错。查资料呗。终于找到，这里记录下。filter=bson.D{{"nickname","张三"},{"$or",[]interface{}{bson.D{{"sex",1}},bson.D{{"sex",2}}}}}...

三种方式：方式一：使用可视化工具Robo 3T 创建右键 选择add index 添加索引如下图：方式二：脚本创建：db.test.createindex({"phone":1})方式三：使用代码创建：db.collection.indexs().create({})//两个字段关联 ，创建唯一索引_, err = mongoCl...

实验前：func TestInsert(g *gin.Context) { rsp := new(Rsp) var tests [] interface{} for i:=0; i<1000000 ;i++ { newuser := new(Test) newuser.Email =strconv.Itoa(i) newuser.Username =strco...