mongodb.go 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829
  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. AuthSource string
  307. }
  308. func (m *MongodbSim) GetMgoConn() *MgoSess {
  309. //m.Open()
  310. ms := &MgoSess{}
  311. ms.M = m
  312. return ms
  313. }
  314. func (m *MongodbSim) DestoryMongoConn(ms *MgoSess) {
  315. //m.Close()
  316. ms.M = nil
  317. ms = nil
  318. }
  319. func (m *MongodbSim) Destroy() {
  320. //m.Close()
  321. m.C.Disconnect(nil)
  322. m.C = nil
  323. }
  324. func (m *MongodbSim) InitPool() {
  325. opts := options.Client()
  326. registry := bson.NewRegistryBuilder().RegisterTypeMapEntry(bson.TypeArray, reflect.TypeOf([]interface{}{})).Build()
  327. opts.SetRegistry(registry)
  328. opts.SetConnectTimeout(3 * time.Second)
  329. opts.SetHosts(strings.Split(m.MongodbAddr, ","))
  330. //opts.ApplyURI("mongodb://" + m.MongodbAddr)
  331. opts.SetMaxPoolSize(uint64(m.Size))
  332. if m.UserName != "" && m.Password != "" {
  333. cre := options.Credential{
  334. Username: m.UserName,
  335. Password: m.Password,
  336. AuthSource: m.AuthSource,
  337. }
  338. opts.SetAuth(cre)
  339. }
  340. /*ms := strings.Split(m.MongodbAddr, ",")
  341. if m.ReplSet == "" && len(ms) > 1 {
  342. m.ReplSet = "qfws"
  343. }*/
  344. if m.ReplSet != "" {
  345. opts.SetReplicaSet(m.ReplSet)
  346. opts.SetDirect(false)
  347. }
  348. m.pool = make(chan bool, m.Size)
  349. opts.SetMaxConnIdleTime(2 * time.Hour)
  350. m.Ctx, _ = context.WithTimeout(context.Background(), 99999*time.Hour)
  351. m.ShortCtx, _ = context.WithTimeout(context.Background(), 1*time.Minute)
  352. client, err := mongo.Connect(m.ShortCtx, opts)
  353. if err != nil {
  354. log.Println("mgo init error:", err.Error())
  355. } else {
  356. m.C = client
  357. }
  358. }
  359. func (m *MongodbSim) Open() {
  360. m.pool <- true
  361. }
  362. func (m *MongodbSim) Close() {
  363. <-m.pool
  364. }
  365. //新建表并生成索引
  366. func (m *MongodbSim) CreateIndex(c string, models []mongo.IndexModel) bool {
  367. defer catch()
  368. m.Open()
  369. defer m.Close()
  370. coll := m.C.Database(m.DbName).Collection(c)
  371. names, err := coll.Indexes().CreateMany(m.Ctx, models)
  372. if err == nil && len(names) > 0 {
  373. return true
  374. } else {
  375. log.Println("CreateIndex Error:", err)
  376. return false
  377. }
  378. }
  379. func (m *MongodbSim) Save(c string, doc interface{}) string {
  380. defer catch()
  381. m.Open()
  382. defer m.Close()
  383. coll := m.C.Database(m.DbName).Collection(c)
  384. obj := ObjToM(doc)
  385. id := primitive.NewObjectID()
  386. (*obj)["_id"] = id
  387. _, err := coll.InsertOne(m.Ctx, obj)
  388. if nil != err {
  389. log.Println("SaveError", err)
  390. return ""
  391. }
  392. return id.Hex()
  393. }
  394. //原_id不变
  395. func (m *MongodbSim) SaveByOriID(c string, doc interface{}) bool {
  396. defer catch()
  397. m.Open()
  398. defer m.Close()
  399. coll := m.C.Database(m.DbName).Collection(c)
  400. _, err := coll.InsertOne(m.Ctx, ObjToM(doc))
  401. if nil != err {
  402. log.Println("SaveByOriIDError", err)
  403. return false
  404. }
  405. return true
  406. }
  407. //批量插入
  408. func (m *MongodbSim) SaveBulk(c string, doc ...map[string]interface{}) bool {
  409. defer catch()
  410. m.Open()
  411. defer m.Close()
  412. coll := m.C.Database(m.DbName).Collection(c)
  413. var writes []mongo.WriteModel
  414. for _, d := range doc {
  415. write := mongo.NewInsertOneModel()
  416. write.SetDocument(d)
  417. writes = append(writes, write)
  418. }
  419. br, e := coll.BulkWrite(m.Ctx, writes)
  420. if e != nil {
  421. b := strings.Index(e.Error(), "duplicate") > -1
  422. log.Println("mgo savebulk error:", e.Error())
  423. if br != nil {
  424. log.Println("mgo savebulk size:", br.InsertedCount)
  425. }
  426. return b
  427. }
  428. return true
  429. }
  430. //批量插入
  431. func (m *MongodbSim) SaveBulkInterface(c string, doc ...interface{}) bool {
  432. defer catch()
  433. m.Open()
  434. defer m.Close()
  435. coll := m.C.Database(m.DbName).Collection(c)
  436. var writes []mongo.WriteModel
  437. for _, d := range doc {
  438. write := mongo.NewInsertOneModel()
  439. write.SetDocument(d)
  440. writes = append(writes, write)
  441. }
  442. br, e := coll.BulkWrite(m.Ctx, writes)
  443. if e != nil {
  444. b := strings.Index(e.Error(), "duplicate") > -1
  445. log.Println("mgo SaveBulkInterface error:", e.Error())
  446. if br != nil {
  447. log.Println("mgo SaveBulkInterface size:", br.InsertedCount)
  448. }
  449. return b
  450. }
  451. return true
  452. }
  453. //按条件统计
  454. func (m *MongodbSim) Count(c string, q interface{}) int {
  455. r, _ := m.CountByErr(c, q)
  456. return r
  457. }
  458. //统计
  459. func (m *MongodbSim) CountByErr(c string, q interface{}) (int, error) {
  460. defer catch()
  461. m.Open()
  462. defer m.Close()
  463. var res int64
  464. var err error
  465. if filter := ObjToM(q); filter != nil && len(*filter) > 0 {
  466. res, err = m.C.Database(m.DbName).Collection(c).CountDocuments(m.Ctx, filter)
  467. } else {
  468. res, err = m.C.Database(m.DbName).Collection(c).EstimatedDocumentCount(m.Ctx)
  469. }
  470. if err != nil {
  471. log.Println("统计错误", err.Error())
  472. return 0, err
  473. } else {
  474. return int(res), nil
  475. }
  476. }
  477. //按条件删除
  478. func (m *MongodbSim) Delete(c string, q interface{}) int64 {
  479. defer catch()
  480. m.Open()
  481. defer m.Close()
  482. res, err := m.C.Database(m.DbName).Collection(c).DeleteMany(m.Ctx, ObjToM(q))
  483. if err != nil && res == nil {
  484. log.Println("删除错误", err.Error())
  485. }
  486. return res.DeletedCount
  487. }
  488. //删除对象
  489. func (m *MongodbSim) Del(c string, q interface{}) bool {
  490. defer catch()
  491. m.Open()
  492. defer m.Close()
  493. _, err := m.C.Database(m.DbName).Collection(c).DeleteMany(m.Ctx, ObjToM(q))
  494. if err != nil {
  495. log.Println("删除错误", err.Error())
  496. return false
  497. }
  498. return true
  499. }
  500. //按条件更新
  501. func (m *MongodbSim) Update(c string, q, u interface{}, upsert bool, multi bool) bool {
  502. defer catch()
  503. m.Open()
  504. defer m.Close()
  505. ct := options.Update()
  506. if upsert {
  507. ct.SetUpsert(true)
  508. }
  509. coll := m.C.Database(m.DbName).Collection(c)
  510. ue := ObjToM(u)
  511. autoUpdateTime(m.DbName, c, ue)
  512. var err error
  513. if multi {
  514. _, err = coll.UpdateMany(m.Ctx, ObjToM(q), ue, ct)
  515. } else {
  516. _, err = coll.UpdateOne(m.Ctx, ObjToM(q), ue, ct)
  517. }
  518. if err != nil {
  519. log.Println("更新错误", err.Error())
  520. return false
  521. }
  522. return true
  523. }
  524. func (m *MongodbSim) UpdateById(c string, id interface{}, set interface{}) bool {
  525. defer catch()
  526. m.Open()
  527. defer m.Close()
  528. q := make(map[string]interface{})
  529. if sid, ok := id.(string); ok {
  530. q["_id"], _ = primitive.ObjectIDFromHex(sid)
  531. } else {
  532. q["_id"] = id
  533. }
  534. ue := ObjToM(set)
  535. autoUpdateTime(m.DbName, c, ue)
  536. _, err := m.C.Database(m.DbName).Collection(c).UpdateOne(m.Ctx, q, ue)
  537. if nil != err {
  538. log.Println("UpdateByIdError", err)
  539. return false
  540. }
  541. return true
  542. }
  543. //批量更新
  544. func (m *MongodbSim) UpdateBulkAll(db, c string, doc ...[]map[string]interface{}) bool {
  545. return m.NewUpdateBulk(db, c, false, false, doc...)
  546. }
  547. func (m *MongodbSim) UpdateBulk(c string, doc ...[]map[string]interface{}) bool {
  548. return m.UpdateBulkAll(m.DbName, c, doc...)
  549. }
  550. //批量插入
  551. func (m *MongodbSim) UpSertBulk(c string, doc ...[]map[string]interface{}) bool {
  552. return m.NewUpdateBulk(m.DbName, c, true, false, doc...)
  553. }
  554. //批量插入
  555. func (m *MongodbSim) UpSertMultiBulk(c string, upsert, multi bool, doc ...[]map[string]interface{}) bool {
  556. return m.NewUpdateBulk(m.DbName, c, upsert, multi, doc...)
  557. }
  558. //批量插入
  559. func (m *MongodbSim) NewUpdateBulk(db, c string, upsert, multi bool, doc ...[]map[string]interface{}) bool {
  560. defer catch()
  561. m.Open()
  562. defer m.Close()
  563. coll := m.C.Database(db).Collection(c)
  564. var writes []mongo.WriteModel
  565. for _, d := range doc {
  566. if multi {
  567. write := mongo.NewUpdateManyModel()
  568. write.SetFilter(d[0])
  569. ue := ObjToM(d[1])
  570. autoUpdateTime(m.DbName, c, ue)
  571. write.SetUpdate(ue)
  572. write.SetUpsert(upsert)
  573. writes = append(writes, write)
  574. } else {
  575. write := mongo.NewUpdateOneModel()
  576. write.SetFilter(d[0])
  577. ue := ObjToM(d[1])
  578. autoUpdateTime(m.DbName, c, ue)
  579. write.SetUpdate(ue)
  580. write.SetUpsert(upsert)
  581. writes = append(writes, write)
  582. }
  583. }
  584. br, e := coll.BulkWrite(m.Ctx, writes)
  585. if e != nil {
  586. log.Println("mgo upsert error:", e.Error())
  587. return br == nil || br.UpsertedCount == 0
  588. }
  589. // else {
  590. // if r.UpsertedCount != int64(len(doc)) {
  591. // log.Println("mgo upsert uncomplete:uc/dc", r.UpsertedCount, len(doc))
  592. // }
  593. // return true
  594. // }
  595. return true
  596. }
  597. //查询单条对象
  598. func (m *MongodbSim) FindOne(c string, query interface{}) (*map[string]interface{}, bool) {
  599. return m.FindOneByField(c, query, nil)
  600. }
  601. //查询单条对象
  602. func (m *MongodbSim) FindOneByField(c string, query interface{}, fields interface{}) (*map[string]interface{}, bool) {
  603. defer catch()
  604. res, ok := m.Find(c, query, nil, fields, true, -1, -1)
  605. if nil != res && len(*res) > 0 {
  606. return &((*res)[0]), ok
  607. }
  608. return nil, ok
  609. }
  610. //查询单条对象
  611. func (m *MongodbSim) FindById(c string, query string, fields interface{}) (*map[string]interface{}, bool) {
  612. defer catch()
  613. m.Open()
  614. defer m.Close()
  615. of := options.FindOne()
  616. of.SetProjection(ObjToOth(fields))
  617. res := make(map[string]interface{})
  618. _id, err := primitive.ObjectIDFromHex(query)
  619. if err != nil {
  620. log.Println("_id error", err)
  621. return &res, true
  622. }
  623. sr := m.C.Database(m.DbName).Collection(c).FindOne(m.Ctx, map[string]interface{}{"_id": _id}, of)
  624. if sr.Err() == nil {
  625. sr.Decode(&res)
  626. }
  627. return &res, true
  628. }
  629. //底层查询方法
  630. func (m *MongodbSim) Find(c string, query interface{}, order interface{}, fields interface{}, single bool, start int, limit int) (*[]map[string]interface{}, bool) {
  631. defer catch()
  632. m.Open()
  633. defer m.Close()
  634. var res []map[string]interface{}
  635. coll := m.C.Database(m.DbName).Collection(c)
  636. if single {
  637. res = make([]map[string]interface{}, 1)
  638. of := options.FindOne()
  639. of.SetProjection(ObjToOth(fields))
  640. of.SetSort(ObjToM(order))
  641. if sr := coll.FindOne(m.Ctx, ObjToM(query), of); sr.Err() == nil {
  642. sr.Decode(&res[0])
  643. }
  644. } else {
  645. res = []map[string]interface{}{}
  646. of := options.Find()
  647. of.SetProjection(ObjToOth(fields))
  648. of.SetSort(ObjToM(order))
  649. if start > -1 {
  650. of.SetSkip(int64(start))
  651. of.SetLimit(int64(limit))
  652. }
  653. cur, err := coll.Find(m.Ctx, ObjToM(query), of)
  654. if err == nil && cur.Err() == nil {
  655. cur.All(m.Ctx, &res)
  656. }
  657. }
  658. return &res, true
  659. }
  660. func ObjToOth(query interface{}) *bson.M {
  661. return ObjToMQ(query, false)
  662. }
  663. func ObjToM(query interface{}) *bson.M {
  664. return ObjToMQ(query, true)
  665. }
  666. //obj(string,M)转M,查询用到
  667. func ObjToMQ(query interface{}, isQuery bool) *bson.M {
  668. data := make(bson.M)
  669. defer catch()
  670. if s2, ok2 := query.(*map[string]interface{}); ok2 {
  671. data = bson.M(*s2)
  672. } else if s3, ok3 := query.(*bson.M); ok3 {
  673. return s3
  674. } else if s3, ok3 := query.(*primitive.M); ok3 {
  675. return s3
  676. } else if s, ok := query.(string); ok {
  677. json.Unmarshal([]byte(strings.Replace(s, "'", "\"", -1)), &data)
  678. if ss, oks := data["_id"]; oks && isQuery {
  679. switch ss.(type) {
  680. case string:
  681. data["_id"], _ = primitive.ObjectIDFromHex(ss.(string))
  682. case map[string]interface{}:
  683. tmp := ss.(map[string]interface{})
  684. for k, v := range tmp {
  685. tmp[k], _ = primitive.ObjectIDFromHex(v.(string))
  686. }
  687. data["_id"] = tmp
  688. }
  689. }
  690. } else if s1, ok1 := query.(map[string]interface{}); ok1 {
  691. data = s1
  692. } else if s4, ok4 := query.(bson.M); ok4 {
  693. data = s4
  694. } else if s4, ok4 := query.(primitive.M); ok4 {
  695. data = s4
  696. } else {
  697. data = nil
  698. }
  699. return &data
  700. }
  701. func intAllDef(num interface{}, defaultNum int) int {
  702. if i, ok := num.(int); ok {
  703. return int(i)
  704. } else if i0, ok0 := num.(int32); ok0 {
  705. return int(i0)
  706. } else if i1, ok1 := num.(float64); ok1 {
  707. return int(i1)
  708. } else if i2, ok2 := num.(int64); ok2 {
  709. return int(i2)
  710. } else if i3, ok3 := num.(float32); ok3 {
  711. return int(i3)
  712. } else if i4, ok4 := num.(string); ok4 {
  713. in, _ := strconv.Atoi(i4)
  714. return int(in)
  715. } else if i5, ok5 := num.(int16); ok5 {
  716. return int(i5)
  717. } else if i6, ok6 := num.(int8); ok6 {
  718. return int(i6)
  719. } else if i7, ok7 := num.(*big.Int); ok7 {
  720. in, _ := strconv.Atoi(fmt.Sprint(i7))
  721. return int(in)
  722. } else if i8, ok8 := num.(*big.Float); ok8 {
  723. in, _ := strconv.Atoi(fmt.Sprint(i8))
  724. return int(in)
  725. } else {
  726. return defaultNum
  727. }
  728. }
  729. //出错拦截
  730. func catch() {
  731. if r := recover(); r != nil {
  732. log.Println(r)
  733. for skip := 0; ; skip++ {
  734. _, file, line, ok := runtime.Caller(skip)
  735. if !ok {
  736. break
  737. }
  738. go log.Printf("%v,%v\n", file, line)
  739. }
  740. }
  741. }
  742. //根据bsonID转string
  743. func BsonIdToSId(uid interface{}) string {
  744. if uid == nil {
  745. return ""
  746. } else if u, ok := uid.(string); ok {
  747. return u
  748. } else if u, ok := uid.(primitive.ObjectID); ok {
  749. return u.Hex()
  750. } else {
  751. return ""
  752. }
  753. }
  754. func StringTOBsonId(id string) (bid primitive.ObjectID) {
  755. defer catch()
  756. if id != "" {
  757. bid, _ = primitive.ObjectIDFromHex(id)
  758. }
  759. return
  760. }
  761. func ToObjectIds(ids []string) []primitive.ObjectID {
  762. _ids := []primitive.ObjectID{}
  763. for _, v := range ids {
  764. _id, _ := primitive.ObjectIDFromHex(v)
  765. _ids = append(_ids, _id)
  766. }
  767. return _ids
  768. }
  769. //自动添加更新时间
  770. func autoUpdateTime(db, coll string, ue *bson.M) {
  771. if coll == "user" {
  772. set := ObjToM((*ue)["$set"])
  773. if *set == nil {
  774. set = &bson.M{}
  775. }
  776. (*set)["auto_updatetime"] = time.Now().Unix()
  777. (*ue)["$set"] = set
  778. }
  779. }
  780. func IsObjectIdHex(hex string) bool {
  781. _, err := primitive.ObjectIDFromHex(hex)
  782. if err != nil {
  783. return false
  784. }
  785. return true
  786. }