mongodb.go 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827
  1. package mongodb
  2. import (
  3. "context"
  4. "encoding/json"
  5. "fmt"
  6. "log"
  7. "math/big"
  8. "reflect"
  9. "runtime"
  10. "strconv"
  11. "strings"
  12. "time"
  13. "go.mongodb.org/mongo-driver/bson"
  14. "go.mongodb.org/mongo-driver/bson/primitive"
  15. "go.mongodb.org/mongo-driver/mongo"
  16. "go.mongodb.org/mongo-driver/mongo/options"
  17. )
  18. func NewMgo(addr, db string, size int) *MongodbSim {
  19. mgo := &MongodbSim{
  20. MongodbAddr: addr,
  21. Size: size,
  22. DbName: db,
  23. }
  24. mgo.InitPool()
  25. return mgo
  26. }
  27. func NewMgoWithUser(addr, db, uname, upwd string, size int) *MongodbSim {
  28. mgo := &MongodbSim{
  29. MongodbAddr: addr,
  30. Size: size,
  31. DbName: db,
  32. UserName: uname,
  33. Password: upwd,
  34. }
  35. mgo.InitPool()
  36. return mgo
  37. }
  38. type Bluk struct {
  39. ms *MgoSess
  40. writes []mongo.WriteModel
  41. }
  42. func (b *Bluk) Insert(doc interface{}) {
  43. write := mongo.NewInsertOneModel()
  44. write.SetDocument(doc)
  45. b.writes = append(b.writes, write)
  46. }
  47. func (b *Bluk) Update(doc ...interface{}) {
  48. write := mongo.NewUpdateOneModel()
  49. write.SetFilter(doc[0])
  50. ue := ObjToM(doc[1])
  51. autoUpdateTime(b.ms.db, b.ms.coll, ue)
  52. write.SetUpdate(ue)
  53. write.SetUpsert(false)
  54. b.writes = append(b.writes, write)
  55. }
  56. func (b *Bluk) UpdateAll(doc ...interface{}) {
  57. write := mongo.NewUpdateManyModel()
  58. write.SetFilter(doc[0])
  59. ue := ObjToM(doc[1])
  60. autoUpdateTime(b.ms.db, b.ms.coll, ue)
  61. write.SetUpdate(ue)
  62. write.SetUpsert(false)
  63. b.writes = append(b.writes, write)
  64. }
  65. func (b *Bluk) Upsert(doc ...interface{}) {
  66. write := mongo.NewUpdateOneModel()
  67. write.SetFilter(doc[0])
  68. ue := ObjToM(doc[1])
  69. autoUpdateTime(b.ms.db, b.ms.coll, ue)
  70. write.SetUpdate(ue)
  71. write.SetUpsert(true)
  72. b.writes = append(b.writes, write)
  73. }
  74. func (b *Bluk) Remove(doc interface{}) {
  75. write := mongo.NewDeleteOneModel()
  76. write.SetFilter(doc)
  77. b.writes = append(b.writes, write)
  78. }
  79. func (b *Bluk) RemoveAll(doc interface{}) {
  80. write := mongo.NewDeleteManyModel()
  81. write.SetFilter(doc)
  82. b.writes = append(b.writes, write)
  83. }
  84. func (b *Bluk) Run() (*mongo.BulkWriteResult, error) {
  85. return b.ms.M.C.Database(b.ms.db).Collection(b.ms.coll).BulkWrite(b.ms.M.Ctx, b.writes)
  86. }
  87. //
  88. type MgoIter struct {
  89. Cursor *mongo.Cursor
  90. Ctx context.Context
  91. }
  92. func (mt *MgoIter) Next(result interface{}) bool {
  93. if mt.Cursor != nil {
  94. if mt.Cursor.Next(mt.Ctx) {
  95. rType := reflect.TypeOf(result)
  96. rVal := reflect.ValueOf(result)
  97. if rType.Kind() == reflect.Ptr {
  98. rType = rType.Elem()
  99. rVal = rVal.Elem()
  100. }
  101. var err error
  102. if rType.Kind() == reflect.Map {
  103. r := make(map[string]interface{})
  104. err = mt.Cursor.Decode(&r)
  105. if rVal.CanSet() {
  106. rVal.Set(reflect.ValueOf(r))
  107. } else {
  108. for it := rVal.MapRange(); it.Next(); {
  109. rVal.SetMapIndex(it.Key(), reflect.Value{})
  110. }
  111. for it := reflect.ValueOf(r).MapRange(); it.Next(); {
  112. rVal.SetMapIndex(it.Key(), it.Value())
  113. }
  114. }
  115. } else {
  116. err = mt.Cursor.Decode(&result)
  117. }
  118. if err != nil {
  119. log.Println("mgo cur err", err.Error())
  120. mt.Cursor.Close(mt.Ctx)
  121. return false
  122. }
  123. return true
  124. } else {
  125. mt.Cursor.Close(mt.Ctx)
  126. return false
  127. }
  128. } else {
  129. return false
  130. }
  131. }
  132. //
  133. type MgoSess struct {
  134. db string
  135. coll string
  136. query interface{}
  137. sorts []string
  138. fields interface{}
  139. limit int64
  140. skip int64
  141. pipe []map[string]interface{}
  142. all interface{}
  143. M *MongodbSim
  144. }
  145. func (ms *MgoSess) DB(name string) *MgoSess {
  146. ms.db = name
  147. return ms
  148. }
  149. func (ms *MgoSess) C(name string) *MgoSess {
  150. ms.coll = name
  151. return ms
  152. }
  153. func (ms *MgoSess) Bulk() *Bluk {
  154. return &Bluk{ms: ms}
  155. }
  156. func (ms *MgoSess) Find(q interface{}) *MgoSess {
  157. if q == nil {
  158. q = map[string]interface{}{}
  159. }
  160. ms.query = q
  161. return ms
  162. }
  163. func (ms *MgoSess) FindId(_id interface{}) *MgoSess {
  164. ms.query = map[string]interface{}{"_id": _id}
  165. return ms
  166. }
  167. func (ms *MgoSess) Select(fields interface{}) *MgoSess {
  168. ms.fields = fields
  169. return ms
  170. }
  171. func (ms *MgoSess) Limit(limit int64) *MgoSess {
  172. ms.limit = limit
  173. return ms
  174. }
  175. func (ms *MgoSess) Skip(skip int64) *MgoSess {
  176. ms.skip = skip
  177. return ms
  178. }
  179. func (ms *MgoSess) Sort(sorts ...string) *MgoSess {
  180. ms.sorts = sorts
  181. return ms
  182. }
  183. func (ms *MgoSess) Pipe(p []map[string]interface{}) *MgoSess {
  184. ms.pipe = p
  185. return ms
  186. }
  187. func (ms *MgoSess) Insert(doc interface{}) error {
  188. _, err := ms.M.C.Database(ms.db).Collection(ms.coll).InsertOne(ms.M.Ctx, doc)
  189. return err
  190. }
  191. func (ms *MgoSess) Remove(filter interface{}) error {
  192. _, err := ms.M.C.Database(ms.db).Collection(ms.coll).DeleteOne(ms.M.Ctx, filter)
  193. return err
  194. }
  195. func (ms *MgoSess) RemoveId(_id interface{}) error {
  196. _, err := ms.M.C.Database(ms.db).Collection(ms.coll).DeleteOne(ms.M.Ctx, map[string]interface{}{"_id": _id})
  197. return err
  198. }
  199. func (ms *MgoSess) RemoveAll(filter interface{}) (*mongo.DeleteResult, error) {
  200. return ms.M.C.Database(ms.db).Collection(ms.coll).DeleteMany(ms.M.Ctx, filter)
  201. }
  202. func (ms *MgoSess) Upsert(filter, update interface{}) (*mongo.UpdateResult, error) {
  203. ct := options.Update()
  204. ct.SetUpsert(true)
  205. ue := ObjToM(update)
  206. autoUpdateTime(ms.db, ms.coll, ue)
  207. return ms.M.C.Database(ms.db).Collection(ms.coll).UpdateOne(ms.M.Ctx, filter, ue, ct)
  208. }
  209. func (ms *MgoSess) UpsertId(filter, update interface{}) (*mongo.UpdateResult, error) {
  210. ct := options.Update()
  211. ct.SetUpsert(true)
  212. ue := ObjToM(update)
  213. autoUpdateTime(ms.db, ms.coll, ue)
  214. return ms.M.C.Database(ms.db).Collection(ms.coll).UpdateOne(ms.M.Ctx, map[string]interface{}{"_id": filter}, ue, ct)
  215. }
  216. func (ms *MgoSess) UpdateId(filter, update interface{}) error {
  217. ue := ObjToM(update)
  218. autoUpdateTime(ms.db, ms.coll, ue)
  219. _, err := ms.M.C.Database(ms.db).Collection(ms.coll).UpdateOne(ms.M.Ctx, map[string]interface{}{"_id": filter}, ue)
  220. return err
  221. }
  222. func (ms *MgoSess) Update(filter, update interface{}) error {
  223. ue := ObjToM(update)
  224. autoUpdateTime(ms.db, ms.coll, ue)
  225. _, err := ms.M.C.Database(ms.db).Collection(ms.coll).UpdateOne(ms.M.Ctx, filter, ue)
  226. return err
  227. }
  228. func (ms *MgoSess) Count() (int64, error) {
  229. return ms.M.C.Database(ms.db).Collection(ms.coll).CountDocuments(ms.M.Ctx, ms.query)
  230. }
  231. func (ms *MgoSess) One(v *map[string]interface{}) {
  232. of := options.FindOne()
  233. of.SetProjection(ms.fields)
  234. sr := ms.M.C.Database(ms.db).Collection(ms.coll).FindOne(ms.M.Ctx, ms.query, of)
  235. if sr.Err() == nil {
  236. sr.Decode(&v)
  237. }
  238. }
  239. func (ms *MgoSess) All(v *[]map[string]interface{}) {
  240. cur, err := ms.M.C.Database(ms.db).Collection(ms.coll).Aggregate(ms.M.Ctx, ms.pipe)
  241. if err == nil && cur.Err() == nil {
  242. cur.All(ms.M.Ctx, v)
  243. }
  244. }
  245. func (ms *MgoSess) Iter() *MgoIter {
  246. it := &MgoIter{}
  247. coll := ms.M.C.Database(ms.db).Collection(ms.coll)
  248. var cur *mongo.Cursor
  249. var err error
  250. if ms.query != nil {
  251. find := options.Find()
  252. if ms.skip > 0 {
  253. find.SetSkip(ms.skip)
  254. }
  255. if ms.limit > 0 {
  256. find.SetLimit(ms.limit)
  257. }
  258. find.SetBatchSize(100)
  259. if len(ms.sorts) > 0 {
  260. sort := bson.D{}
  261. for _, k := range ms.sorts {
  262. switch k[:1] {
  263. case "-":
  264. sort = append(sort, bson.E{k[1:], -1})
  265. case "+":
  266. sort = append(sort, bson.E{k[1:], 1})
  267. default:
  268. sort = append(sort, bson.E{k, 1})
  269. }
  270. }
  271. find.SetSort(sort)
  272. }
  273. if ms.fields != nil {
  274. find.SetProjection(ms.fields)
  275. }
  276. cur, err = coll.Find(ms.M.Ctx, ms.query, find)
  277. if err != nil {
  278. log.Println("mgo find err", err.Error())
  279. }
  280. } else if ms.pipe != nil {
  281. aggregate := options.Aggregate()
  282. aggregate.SetBatchSize(100)
  283. cur, err = coll.Aggregate(ms.M.Ctx, ms.pipe, aggregate)
  284. if err != nil {
  285. log.Println("mgo aggregate err", err.Error())
  286. }
  287. }
  288. if err == nil {
  289. it.Cursor = cur
  290. it.Ctx = ms.M.Ctx
  291. }
  292. return it
  293. }
  294. type MongodbSim struct {
  295. MongodbAddr string
  296. Size int
  297. // MinSize int
  298. DbName string
  299. C *mongo.Client
  300. Ctx context.Context
  301. ShortCtx context.Context
  302. pool chan bool
  303. UserName string
  304. Password string
  305. ReplSet string
  306. }
  307. func (m *MongodbSim) GetMgoConn() *MgoSess {
  308. //m.Open()
  309. ms := &MgoSess{}
  310. ms.M = m
  311. return ms
  312. }
  313. func (m *MongodbSim) DestoryMongoConn(ms *MgoSess) {
  314. //m.Close()
  315. ms.M = nil
  316. ms = nil
  317. }
  318. func (m *MongodbSim) Destroy() {
  319. //m.Close()
  320. m.C.Disconnect(nil)
  321. m.C = nil
  322. }
  323. func (m *MongodbSim) InitPool() {
  324. opts := options.Client()
  325. registry := bson.NewRegistryBuilder().RegisterTypeMapEntry(bson.TypeArray, reflect.TypeOf([]interface{}{})).Build()
  326. opts.SetRegistry(registry)
  327. opts.SetConnectTimeout(3 * time.Second)
  328. opts.SetHosts(strings.Split(m.MongodbAddr, ","))
  329. //opts.ApplyURI("mongodb://" + m.MongodbAddr)
  330. opts.SetMaxPoolSize(uint64(m.Size))
  331. if m.UserName != "" && m.Password != "" {
  332. cre := options.Credential{
  333. Username: m.UserName,
  334. Password: m.Password,
  335. }
  336. opts.SetAuth(cre)
  337. }
  338. /*ms := strings.Split(m.MongodbAddr, ",")
  339. if m.ReplSet == "" && len(ms) > 1 {
  340. m.ReplSet = "qfws"
  341. }*/
  342. if m.ReplSet != "" {
  343. opts.SetReplicaSet(m.ReplSet)
  344. opts.SetDirect(false)
  345. }
  346. m.pool = make(chan bool, m.Size)
  347. opts.SetMaxConnIdleTime(2 * time.Hour)
  348. m.Ctx, _ = context.WithTimeout(context.Background(), 99999*time.Hour)
  349. m.ShortCtx, _ = context.WithTimeout(context.Background(), 1*time.Minute)
  350. client, err := mongo.Connect(m.ShortCtx, opts)
  351. if err != nil {
  352. log.Println("mgo init error:", err.Error())
  353. } else {
  354. m.C = client
  355. }
  356. }
  357. func (m *MongodbSim) Open() {
  358. m.pool <- true
  359. }
  360. func (m *MongodbSim) Close() {
  361. <-m.pool
  362. }
  363. //新建表并生成索引
  364. func (m *MongodbSim) CreateIndex(c string, models []mongo.IndexModel) bool {
  365. defer catch()
  366. m.Open()
  367. defer m.Close()
  368. coll := m.C.Database(m.DbName).Collection(c)
  369. names, err := coll.Indexes().CreateMany(m.Ctx, models)
  370. if err == nil && len(names) > 0 {
  371. return true
  372. } else {
  373. log.Println("CreateIndex Error:", err)
  374. return false
  375. }
  376. }
  377. func (m *MongodbSim) Save(c string, doc interface{}) string {
  378. defer catch()
  379. m.Open()
  380. defer m.Close()
  381. coll := m.C.Database(m.DbName).Collection(c)
  382. obj := ObjToM(doc)
  383. id := primitive.NewObjectID()
  384. (*obj)["_id"] = id
  385. _, err := coll.InsertOne(m.Ctx, obj)
  386. if nil != err {
  387. log.Println("SaveError", err)
  388. return ""
  389. }
  390. return id.Hex()
  391. }
  392. //原_id不变
  393. func (m *MongodbSim) SaveByOriID(c string, doc interface{}) bool {
  394. defer catch()
  395. m.Open()
  396. defer m.Close()
  397. coll := m.C.Database(m.DbName).Collection(c)
  398. _, err := coll.InsertOne(m.Ctx, ObjToM(doc))
  399. if nil != err {
  400. log.Println("SaveByOriIDError", err)
  401. return false
  402. }
  403. return true
  404. }
  405. //批量插入
  406. func (m *MongodbSim) SaveBulk(c string, doc ...map[string]interface{}) bool {
  407. defer catch()
  408. m.Open()
  409. defer m.Close()
  410. coll := m.C.Database(m.DbName).Collection(c)
  411. var writes []mongo.WriteModel
  412. for _, d := range doc {
  413. write := mongo.NewInsertOneModel()
  414. write.SetDocument(d)
  415. writes = append(writes, write)
  416. }
  417. br, e := coll.BulkWrite(m.Ctx, writes)
  418. if e != nil {
  419. b := strings.Index(e.Error(), "duplicate") > -1
  420. log.Println("mgo savebulk error:", e.Error())
  421. if br != nil {
  422. log.Println("mgo savebulk size:", br.InsertedCount)
  423. }
  424. return b
  425. }
  426. return true
  427. }
  428. //批量插入
  429. func (m *MongodbSim) SaveBulkInterface(c string, doc ...interface{}) bool {
  430. defer catch()
  431. m.Open()
  432. defer m.Close()
  433. coll := m.C.Database(m.DbName).Collection(c)
  434. var writes []mongo.WriteModel
  435. for _, d := range doc {
  436. write := mongo.NewInsertOneModel()
  437. write.SetDocument(d)
  438. writes = append(writes, write)
  439. }
  440. br, e := coll.BulkWrite(m.Ctx, writes)
  441. if e != nil {
  442. b := strings.Index(e.Error(), "duplicate") > -1
  443. log.Println("mgo SaveBulkInterface error:", e.Error())
  444. if br != nil {
  445. log.Println("mgo SaveBulkInterface size:", br.InsertedCount)
  446. }
  447. return b
  448. }
  449. return true
  450. }
  451. //按条件统计
  452. func (m *MongodbSim) Count(c string, q interface{}) int {
  453. r, _ := m.CountByErr(c, q)
  454. return r
  455. }
  456. //统计
  457. func (m *MongodbSim) CountByErr(c string, q interface{}) (int, error) {
  458. defer catch()
  459. m.Open()
  460. defer m.Close()
  461. var res int64
  462. var err error
  463. if filter := ObjToM(q); filter != nil && len(*filter) > 0 {
  464. res, err = m.C.Database(m.DbName).Collection(c).CountDocuments(m.Ctx, filter)
  465. } else {
  466. res, err = m.C.Database(m.DbName).Collection(c).EstimatedDocumentCount(m.Ctx)
  467. }
  468. if err != nil {
  469. log.Println("统计错误", err.Error())
  470. return 0, err
  471. } else {
  472. return int(res), nil
  473. }
  474. }
  475. //按条件删除
  476. func (m *MongodbSim) Delete(c string, q interface{}) int64 {
  477. defer catch()
  478. m.Open()
  479. defer m.Close()
  480. res, err := m.C.Database(m.DbName).Collection(c).DeleteMany(m.Ctx, ObjToM(q))
  481. if err != nil && res == nil {
  482. log.Println("删除错误", err.Error())
  483. }
  484. return res.DeletedCount
  485. }
  486. //删除对象
  487. func (m *MongodbSim) Del(c string, q interface{}) bool {
  488. defer catch()
  489. m.Open()
  490. defer m.Close()
  491. _, err := m.C.Database(m.DbName).Collection(c).DeleteMany(m.Ctx, ObjToM(q))
  492. if err != nil {
  493. log.Println("删除错误", err.Error())
  494. return false
  495. }
  496. return true
  497. }
  498. //按条件更新
  499. func (m *MongodbSim) Update(c string, q, u interface{}, upsert bool, multi bool) bool {
  500. defer catch()
  501. m.Open()
  502. defer m.Close()
  503. ct := options.Update()
  504. if upsert {
  505. ct.SetUpsert(true)
  506. }
  507. coll := m.C.Database(m.DbName).Collection(c)
  508. ue := ObjToM(u)
  509. autoUpdateTime(m.DbName, c, ue)
  510. var err error
  511. if multi {
  512. _, err = coll.UpdateMany(m.Ctx, ObjToM(q), ue, ct)
  513. } else {
  514. _, err = coll.UpdateOne(m.Ctx, ObjToM(q), ue, ct)
  515. }
  516. if err != nil {
  517. log.Println("更新错误", err.Error())
  518. return false
  519. }
  520. return true
  521. }
  522. func (m *MongodbSim) UpdateById(c string, id interface{}, set interface{}) bool {
  523. defer catch()
  524. m.Open()
  525. defer m.Close()
  526. q := make(map[string]interface{})
  527. if sid, ok := id.(string); ok {
  528. q["_id"], _ = primitive.ObjectIDFromHex(sid)
  529. } else {
  530. q["_id"] = id
  531. }
  532. ue := ObjToM(set)
  533. autoUpdateTime(m.DbName, c, ue)
  534. _, err := m.C.Database(m.DbName).Collection(c).UpdateOne(m.Ctx, q, ue)
  535. if nil != err {
  536. log.Println("UpdateByIdError", err)
  537. return false
  538. }
  539. return true
  540. }
  541. //批量更新
  542. func (m *MongodbSim) UpdateBulkAll(db, c string, doc ...[]map[string]interface{}) bool {
  543. return m.NewUpdateBulk(db, c, false, false, doc...)
  544. }
  545. func (m *MongodbSim) UpdateBulk(c string, doc ...[]map[string]interface{}) bool {
  546. return m.UpdateBulkAll(m.DbName, c, doc...)
  547. }
  548. //批量插入
  549. func (m *MongodbSim) UpSertBulk(c string, doc ...[]map[string]interface{}) bool {
  550. return m.NewUpdateBulk(m.DbName, c, true, false, doc...)
  551. }
  552. //批量插入
  553. func (m *MongodbSim) UpSertMultiBulk(c string, upsert, multi bool, doc ...[]map[string]interface{}) bool {
  554. return m.NewUpdateBulk(m.DbName, c, upsert, multi, doc...)
  555. }
  556. //批量插入
  557. func (m *MongodbSim) NewUpdateBulk(db, c string, upsert, multi bool, doc ...[]map[string]interface{}) bool {
  558. defer catch()
  559. m.Open()
  560. defer m.Close()
  561. coll := m.C.Database(db).Collection(c)
  562. var writes []mongo.WriteModel
  563. for _, d := range doc {
  564. if multi {
  565. write := mongo.NewUpdateManyModel()
  566. write.SetFilter(d[0])
  567. ue := ObjToM(d[1])
  568. autoUpdateTime(m.DbName, c, ue)
  569. write.SetUpdate(ue)
  570. write.SetUpsert(upsert)
  571. writes = append(writes, write)
  572. } else {
  573. write := mongo.NewUpdateOneModel()
  574. write.SetFilter(d[0])
  575. ue := ObjToM(d[1])
  576. autoUpdateTime(m.DbName, c, ue)
  577. write.SetUpdate(ue)
  578. write.SetUpsert(upsert)
  579. writes = append(writes, write)
  580. }
  581. }
  582. br, e := coll.BulkWrite(m.Ctx, writes)
  583. if e != nil {
  584. log.Println("mgo upsert error:", e.Error())
  585. return br == nil || br.UpsertedCount == 0
  586. }
  587. // else {
  588. // if r.UpsertedCount != int64(len(doc)) {
  589. // log.Println("mgo upsert uncomplete:uc/dc", r.UpsertedCount, len(doc))
  590. // }
  591. // return true
  592. // }
  593. return true
  594. }
  595. //查询单条对象
  596. func (m *MongodbSim) FindOne(c string, query interface{}) (*map[string]interface{}, bool) {
  597. return m.FindOneByField(c, query, nil)
  598. }
  599. //查询单条对象
  600. func (m *MongodbSim) FindOneByField(c string, query interface{}, fields interface{}) (*map[string]interface{}, bool) {
  601. defer catch()
  602. res, ok := m.Find(c, query, nil, fields, true, -1, -1)
  603. if nil != res && len(*res) > 0 {
  604. return &((*res)[0]), ok
  605. }
  606. return nil, ok
  607. }
  608. //查询单条对象
  609. func (m *MongodbSim) FindById(c string, query string, fields interface{}) (*map[string]interface{}, bool) {
  610. defer catch()
  611. m.Open()
  612. defer m.Close()
  613. of := options.FindOne()
  614. of.SetProjection(ObjToOth(fields))
  615. res := make(map[string]interface{})
  616. _id, err := primitive.ObjectIDFromHex(query)
  617. if err != nil {
  618. log.Println("_id error", err)
  619. return &res, true
  620. }
  621. sr := m.C.Database(m.DbName).Collection(c).FindOne(m.Ctx, map[string]interface{}{"_id": _id}, of)
  622. if sr.Err() == nil {
  623. sr.Decode(&res)
  624. }
  625. return &res, true
  626. }
  627. //底层查询方法
  628. func (m *MongodbSim) Find(c string, query interface{}, order interface{}, fields interface{}, single bool, start int, limit int) (*[]map[string]interface{}, bool) {
  629. defer catch()
  630. m.Open()
  631. defer m.Close()
  632. var res []map[string]interface{}
  633. coll := m.C.Database(m.DbName).Collection(c)
  634. if single {
  635. res = make([]map[string]interface{}, 1)
  636. of := options.FindOne()
  637. of.SetProjection(ObjToOth(fields))
  638. of.SetSort(ObjToM(order))
  639. if sr := coll.FindOne(m.Ctx, ObjToM(query), of); sr.Err() == nil {
  640. sr.Decode(&res[0])
  641. }
  642. } else {
  643. res = []map[string]interface{}{}
  644. of := options.Find()
  645. of.SetProjection(ObjToOth(fields))
  646. of.SetSort(ObjToM(order))
  647. if start > -1 {
  648. of.SetSkip(int64(start))
  649. of.SetLimit(int64(limit))
  650. }
  651. cur, err := coll.Find(m.Ctx, ObjToM(query), of)
  652. if err == nil && cur.Err() == nil {
  653. cur.All(m.Ctx, &res)
  654. }
  655. }
  656. return &res, true
  657. }
  658. func ObjToOth(query interface{}) *bson.M {
  659. return ObjToMQ(query, false)
  660. }
  661. func ObjToM(query interface{}) *bson.M {
  662. return ObjToMQ(query, true)
  663. }
  664. //obj(string,M)转M,查询用到
  665. func ObjToMQ(query interface{}, isQuery bool) *bson.M {
  666. data := make(bson.M)
  667. defer catch()
  668. if s2, ok2 := query.(*map[string]interface{}); ok2 {
  669. data = bson.M(*s2)
  670. } else if s3, ok3 := query.(*bson.M); ok3 {
  671. return s3
  672. } else if s3, ok3 := query.(*primitive.M); ok3 {
  673. return s3
  674. } else if s, ok := query.(string); ok {
  675. json.Unmarshal([]byte(strings.Replace(s, "'", "\"", -1)), &data)
  676. if ss, oks := data["_id"]; oks && isQuery {
  677. switch ss.(type) {
  678. case string:
  679. data["_id"], _ = primitive.ObjectIDFromHex(ss.(string))
  680. case map[string]interface{}:
  681. tmp := ss.(map[string]interface{})
  682. for k, v := range tmp {
  683. tmp[k], _ = primitive.ObjectIDFromHex(v.(string))
  684. }
  685. data["_id"] = tmp
  686. }
  687. }
  688. } else if s1, ok1 := query.(map[string]interface{}); ok1 {
  689. data = s1
  690. } else if s4, ok4 := query.(bson.M); ok4 {
  691. data = s4
  692. } else if s4, ok4 := query.(primitive.M); ok4 {
  693. data = s4
  694. } else {
  695. data = nil
  696. }
  697. return &data
  698. }
  699. func intAllDef(num interface{}, defaultNum int) int {
  700. if i, ok := num.(int); ok {
  701. return int(i)
  702. } else if i0, ok0 := num.(int32); ok0 {
  703. return int(i0)
  704. } else if i1, ok1 := num.(float64); ok1 {
  705. return int(i1)
  706. } else if i2, ok2 := num.(int64); ok2 {
  707. return int(i2)
  708. } else if i3, ok3 := num.(float32); ok3 {
  709. return int(i3)
  710. } else if i4, ok4 := num.(string); ok4 {
  711. in, _ := strconv.Atoi(i4)
  712. return int(in)
  713. } else if i5, ok5 := num.(int16); ok5 {
  714. return int(i5)
  715. } else if i6, ok6 := num.(int8); ok6 {
  716. return int(i6)
  717. } else if i7, ok7 := num.(*big.Int); ok7 {
  718. in, _ := strconv.Atoi(fmt.Sprint(i7))
  719. return int(in)
  720. } else if i8, ok8 := num.(*big.Float); ok8 {
  721. in, _ := strconv.Atoi(fmt.Sprint(i8))
  722. return int(in)
  723. } else {
  724. return defaultNum
  725. }
  726. }
  727. //出错拦截
  728. func catch() {
  729. if r := recover(); r != nil {
  730. log.Println(r)
  731. for skip := 0; ; skip++ {
  732. _, file, line, ok := runtime.Caller(skip)
  733. if !ok {
  734. break
  735. }
  736. go log.Printf("%v,%v\n", file, line)
  737. }
  738. }
  739. }
  740. //根据bsonID转string
  741. func BsonIdToSId(uid interface{}) string {
  742. if uid == nil {
  743. return ""
  744. } else if u, ok := uid.(string); ok {
  745. return u
  746. } else if u, ok := uid.(primitive.ObjectID); ok {
  747. return u.Hex()
  748. } else {
  749. return ""
  750. }
  751. }
  752. func StringTOBsonId(id string) (bid primitive.ObjectID) {
  753. defer catch()
  754. if id != "" {
  755. bid, _ = primitive.ObjectIDFromHex(id)
  756. }
  757. return
  758. }
  759. func ToObjectIds(ids []string) []primitive.ObjectID {
  760. _ids := []primitive.ObjectID{}
  761. for _, v := range ids {
  762. _id, _ := primitive.ObjectIDFromHex(v)
  763. _ids = append(_ids, _id)
  764. }
  765. return _ids
  766. }
  767. //自动添加更新时间
  768. func autoUpdateTime(db, coll string, ue *bson.M) {
  769. if coll == "user" {
  770. set := ObjToM((*ue)["$set"])
  771. if *set == nil {
  772. set = &bson.M{}
  773. }
  774. (*set)["auto_updatetime"] = time.Now().Unix()
  775. (*ue)["$set"] = set
  776. }
  777. }
  778. func IsObjectIdHex(hex string) bool {
  779. _, err := primitive.ObjectIDFromHex(hex)
  780. if err != nil {
  781. return false
  782. }
  783. return true
  784. }