/
main.go
64 lines (62 loc) · 1.98 KB
/
main.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
package main
import (
_ "github.com/lib/pq"
"github.com/shop-r1/utils/models"
"log"
)
func main() {
models.InitDb(false, false)
goodsInfos := make([]models.GoodsInfo, 0)
models.Db.Model(&models.GoodsInfo{}).Where("goods_type = ?", models.GoodsTypeNormal).Find(&goodsInfos)
tenants := make([]models.Tenant, 0)
models.Db.Model(&models.Tenant{}).Where("system = ?", false).Find(&tenants)
amount := len(tenants)
var num int
var count int
var err error
//开始检查是否同步
for _, goods := range goodsInfos {
num = 0
models.Db.Model(&models.Goods{}).
Where("goods_info_id = ?", goods.ID).Count(&num)
if num >= amount {
log.Printf("%d-%s同步正常", goods.ID, goods.Name)
continue
}
//存在同步遗漏情况
for _, tenant := range tenants {
count = 0
models.Db.Model(&models.Goods{}).
Where("goods_info_id = ?", goods.ID).
Where("tenant_id = ?", tenant.ID).Count(&count)
if count <= 0 {
log.Printf("租户%d-%s 商品 %d-%s同步遗漏, 马上进行同步...", tenant.ID, tenant.Name, goods.ID, goods.Name)
//补漏
err = models.Db.Create(&models.Goods{
TenantId: tenant.No,
GoodsInfoId: goods.No,
Stage: []byte(`[]`),
SpecificationInfo: []byte(`[]`),
Used: false,
Metadata: []byte(`{}`),
Status: models.Enable,
Show: models.Disable,
ToppedAt: goods.CreatedAt,
Alias: goods.Name,
BarCode: goods.BarCode,
Unit: goods.Unit,
Image: goods.Image,
Albums: goods.Albums,
CategoryId: goods.CategoryId,
ParentCategoryId: goods.ParentCategoryId,
}).Error
if err != nil {
log.Printf("租户%d-%s 商品 %d-%s同步失败", tenant.ID, tenant.Name, goods.ID, goods.Name)
log.Println(err)
} else {
log.Printf("租户%d-%s 商品 %d-%s同步成功", tenant.ID, tenant.Name, goods.ID, goods.Name)
}
}
}
}
}