main.go 2.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108
  1. package main
  2. import (
  3. "context"
  4. "data_ent_wuye/ent_contact"
  5. "data_ent_wuye/ent_legal"
  6. "data_ent_wuye/ent_util"
  7. "flag"
  8. "strings"
  9. "log"
  10. _ "github.com/gogf/gf/contrib/drivers/clickhouse/v2"
  11. "github.com/google/uuid"
  12. "github.com/robfig/cron"
  13. )
  14. func init() {
  15. ent_util.InitGlobalVar()
  16. }
  17. func main() {
  18. mode := flag.Int("m", 1, "")
  19. flag.Parse()
  20. if *mode == 1 {
  21. //全量
  22. go ent_legal.Save()
  23. log.Println("全量任务")
  24. // ent_contact.InjectContactTidbInfo()
  25. ent_legal.LegalFull()
  26. // projectT()
  27. select {}
  28. } else {
  29. //增量
  30. a := cron.New()
  31. a.AddFunc("0 0 20 * * ?", func() {
  32. ent_legal.LegalAdd()
  33. })
  34. a.Start()
  35. select {}
  36. }
  37. }
  38. // 以下测试...
  39. func test() {
  40. //tidb全量
  41. ent_contact.InjectContactTidbInfo()
  42. //凭安全量
  43. info := ent_util.GetOneQyxyInfo("湖南德成大药房连锁有限公司鼎城淮阳店")
  44. name_id := uuid.New().String()
  45. name_id = strings.ReplaceAll(name_id, "-", "")
  46. ent_contact.InjectContactPingAnInfo(name_id, info)
  47. //马克全量
  48. ent_contact.InjectContactMaKeInfo(name_id, map[string]interface{}{"phone": "手机号"})
  49. }
  50. func test1() {
  51. query := `SELECT id,title FROM information.information WHERE id = '000fcf377e334bcc9380b921df93c268'`
  52. rows, err := ent_util.ClickHouseConn.Query(context.Background(), query)
  53. if err != nil {
  54. log.Println(err)
  55. }
  56. isok := 0
  57. type TTT struct {
  58. title string
  59. id string
  60. }
  61. for rows.Next() {
  62. var T TTT
  63. if err := rows.Scan(
  64. &T.id,
  65. &T.title,
  66. ); err != nil {
  67. log.Fatal(err)
  68. }
  69. log.Println(T)
  70. //err := ent_util.ClickHouseConn.Exec(context.Background(), "alter table information.information UPDATE endtime = 1738252800 where id = ?", id)
  71. //if err != nil {
  72. // log.Debug("update err:", err)
  73. //}
  74. isok++
  75. }
  76. log.Println("总计数量", isok)
  77. }
  78. func test2() {
  79. query := `ALTER TABLE information.information DELETE WHERE id='676470119ae64a18bab5d1fdb5f06bb3' `
  80. query = `-- TRUNCATE TABLE information.information_copy;`
  81. err := ent_util.ClickHouseConn.Exec(context.Background(), query)
  82. if err != nil {
  83. log.Println(err)
  84. }
  85. rows, err := ent_util.ClickHouseConn.Query(context.Background(), "select bitmapToArray(tag_bitmap) tag_bitmap from information.information limit 10")
  86. if err != nil {
  87. log.Println(err)
  88. }
  89. for rows.Next() {
  90. var (
  91. tag_bitmap []uint64
  92. )
  93. if err := rows.Scan(
  94. &tag_bitmap,
  95. ); err != nil {
  96. log.Println(err)
  97. }
  98. }
  99. }