main.go 2.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384
  1. package main
  2. import (
  3. log "github.com/donnie4w/go-logger/logger"
  4. "go.mongodb.org/mongo-driver/bson"
  5. qu "qfw/util"
  6. u "ul"
  7. )
  8. func init() {
  9. //u.IsLocal = true
  10. //u.IsDev = true
  11. u.InitVar()
  12. }
  13. func main() {
  14. readTowerBxInfo()
  15. writeTowerBxInfo()
  16. //readTowerNhInfo()
  17. writeTowerNhInfo()
  18. return
  19. lock := make(chan bool)
  20. <-lock
  21. }
  22. func test1() {
  23. dataArr := u.MysqlBiTool.Find("customer_data_ttzl_project", map[string]interface{}{}, "area,msg_id", "msg_id", -1, -1)
  24. log.Debug(len(*dataArr))
  25. for k, v := range *dataArr {
  26. if k%1000 == 0 {
  27. log.Debug("cur index ", k)
  28. }
  29. msg_id := qu.IntAll(v["msg_id"])
  30. area := qu.ObjToString(v["area"])
  31. new_area := ""
  32. if area == "" {
  33. new_area = "全国"
  34. } else {
  35. if u.Regions[area] != "" {
  36. new_area = u.Regions[area]
  37. }
  38. }
  39. u.MysqlBiTool.Update("customer_data_ttzl_project", bson.M{"msg_id": msg_id}, bson.M{"area": new_area})
  40. }
  41. log.Debug("is over ...")
  42. }
  43. func test() {
  44. dataArr := u.MysqlBiTool.Find("customer_data_ttzl_project", map[string]interface{}{}, "zb_infoid,infoid,msg_id", "msg_id", -1, -1)
  45. log.Debug(len(*dataArr))
  46. for k, v := range *dataArr {
  47. if k%1000 == 0 {
  48. log.Debug("cur index ", k)
  49. }
  50. msg_id := qu.IntAll(v["msg_id"])
  51. update := map[string]interface{}{}
  52. if zb_infoid := qu.ObjToString(v["zb_infoid"]); zb_infoid != "" {
  53. zb_jybxhref := "https://www.jianyu360.cn/succbi/ttzl/app/dzbi.app/detail.spg?I_id=" + zb_infoid
  54. update["zb_jybxhref"] = zb_jybxhref
  55. }
  56. if infoid := qu.ObjToString(v["infoid"]); infoid != "" {
  57. jybxhref := "https://www.jianyu360.cn/succbi/ttzl/app/dzbi.app/detail.spg?I_id=" + infoid
  58. update["jybxhref"] = jybxhref
  59. }
  60. if len(update) > 0 && msg_id > 0 {
  61. u.MysqlBiTool.Update("customer_data_ttzl_project", bson.M{"msg_id": msg_id}, update)
  62. }
  63. }
  64. log.Debug("is over ...")
  65. //dataArr := u.MysqlBiTool.Find("customer_data_ttzl", map[string]interface{}{}, "id,msg_id", "msg_id", -1, -1)
  66. //log.Debug(len(*dataArr))
  67. //for k, v := range *dataArr {
  68. // if k%1000 == 0 {
  69. // log.Debug("cur index ", k)
  70. // }
  71. // msg_id := qu.IntAll(v["msg_id"])
  72. // jybxhref := "https://www.jianyu360.cn/succbi/ttzl/app/dzbi.app/detail.spg?I_id=" + qu.ObjToString(v["id"])
  73. // u.MysqlBiTool.Update("customer_data_ttzl", bson.M{"msg_id": msg_id}, bson.M{"jybxhref": jybxhref})
  74. //}
  75. //log.Debug("is over ...")
  76. }