跳转至

go mapping 项目相关配置

状态: 📝 草稿

创建日期: 2026-02-28 最后更新: 2026-02-28


SQL 操作

连接数据库

mongosh "mongodb://cab4user:PvUZy5kwqrfN@167.114.208.35:27017/importer?authSource=admin&minPoolSize=1&maxPoolSize=20&tls=false"

删除相关数据

db.mapping.deleteMany({})
db.mapping_enum.deleteMany({})
db.init_task.deleteMany({})
db.translation_state.deleteMany({})

统计重复的 enum 情况

db.mapping_enum.aggregate([
  { $match: { board_id: "TRB" } },
  { $group: { _id: "$mapping_id", count: { $sum: 1 } } },
  { $sort: { count: -1 } }
])

db.mapping_enum.aggregate([
  { $match: { board_id: "DDF" } },
  { $group: { _id: "$mapping_id", count: { $sum: 1 } } },
  { $sort: { count: -1 } }
])

文件同步

# v1 修改文件同步到远程
rsync -avz --progress \
  --include '*/' --include '*.go' --exclude '*' \
  /Users/pengxin/data/real/gomapping/ cab5:~/gomapping

# v2 使用 .gitignore 的规则忽略文件
rsync -avz --progress \
  --filter=':- .gitignore' \
  --include '*/' --include '*.go' --include '*.sh' --exclude '*' \
  /Users/pengxin/data/real/gomapping/ cab5:~/gomapping

# v3 强制同步,删除目标端多余文件
rsync -avz --delete --progress \
  --filter=':- .gitignore' \
  --include '*/' --include '*.go' --include '*.sh' \
  --include '*.html' --include '*.css' --include '*.js' \
  --include '*.ico' --include '*.sum' --include '*.mod' --exclude '*' \
  /Users/pengxin/data/real/gomapping/ cab5:~/gomapping

knock cab5 20234 10123 && rsync -avz --delete --progress \
  --filter=':- .gitignore' \
  --include '*/' --include '*.go' --include '*.sh' \
  --include '*.html' --include '*.css' --include '*.js' \
  --include '*.ico' --exclude '*' \
  /Users/pengxin/data/real/gomapping/ cab5:~/gomapping

程序运行

API 请求

curl -H "Authorization: Bearer test_520c73638001e49694067b3ce09526ed" http://cab5:8080/api/v1/board

单个 board 初始化

go run ./cmd/init -config=configs/app.toml -board-id=TST

go run ./cmd/init -config=configs/app.toml -force -preview -board-id=TST

go run ./cmd/init -config=configs/app.toml -force -preview -board-id=TRB batch-size=10

任务进度查看

go run ./cmd/init -config=configs/app.toml -status

杀掉相关进程

ps aux | grep "server --config=configs/app.toml" | grep -v grep | awk '{print $2}' | xargs kill

翻译

go run ./cmd/translate -config=configs/app.toml -board-id=TST -type=mapping

测试用例

RMBASE_FILE_CFG=configs/app.toml go test -v -run TestBoardRepository ./tests/unit/

go test -v ./tests/unit -run ^TestAlertHandlerNewAlertHandler$

export RMBASE_FILE_CFG=configs/app.toml && go run test_ai_real.go

数据导出

从 ca12 导出到 cab4

导出:

mongodump --uri "mongodb://rniRead:A6Nsr058J1yF@ca8:27037/rni?authSource=admin&tls=true&tlsCAFile=/etc/mongoRni/ca.crt&tlsCertificateKeyFile=/etc/mongoRni/server.pem" --collection=mls_treb_master_records --gzip
mongodump --uri "mongodb://rniRead:A6Nsr058J1yF@ca8:27037/rni?authSource=admin&tls=true&tlsCAFile=/etc/mongoRni/ca.crt&tlsCertificateKeyFile=/etc/mongoRni/server.pem" --collection=mls_crea_ddf_records --gzip
mongodump --uri "mongodb://rniRead:A6Nsr058J1yF@ca8:27037/rni?authSource=admin&tls=true&tlsCAFile=/etc/mongoRni/ca.crt&tlsCertificateKeyFile=/etc/mongoRni/server.pem" --collection=mls_bcre_records --gzip
mongodump --uri "mongodb://rniRead:A6Nsr058J1yF@ca8:27037/rni?authSource=admin&tls=true&tlsCAFile=/etc/mongoRni/ca.crt&tlsCertificateKeyFile=/etc/mongoRni/server.pem" --collection=mls_treb_evow_delete_ids --gzip
mongodump --uri "mongodb://rniRead:A6Nsr058J1yF@ca8:27037/rni?authSource=admin&tls=true&tlsCAFile=/etc/mongoRni/ca.crt&tlsCertificateKeyFile=/etc/mongoRni/server.pem" --collection=mls_bcre_deleted --gzip
mongodump --uri "mongodb://rniRead:A6Nsr058J1yF@ca8:27037/rni?authSource=admin&tls=true&tlsCAFile=/etc/mongoRni/ca.crt&tlsCertificateKeyFile=/etc/mongoRni/server.pem" --collection=mls_oreb_master_records --gzip
mongodump --uri "mongodb://rniRead:A6Nsr058J1yF@ca8:27037/rni?authSource=admin&tls=true&tlsCAFile=/etc/mongoRni/ca.crt&tlsCertificateKeyFile=/etc/mongoRni/server.pem" --collection=mls_rahb_records --gzip

scp -r dump/ 167.114.208.35:~/

导入:

mongorestore "mongodb://cab4user:PvUZy5kwqrfN@127.0.0.1:27017/rni?authSource=admin" --db rni --collection mls_treb_master_records --drop --gzip dump/rni/mls_treb_master_records.bson.gz
mongorestore "mongodb://cab4user:PvUZy5kwqrfN@127.0.0.1:27017/rni?authSource=admin" --db rni --collection mls_crea_ddf_records --drop --gzip dump/rni/mls_crea_ddf_records.bson.gz
mongorestore "mongodb://cab4user:PvUZy5kwqrfN@127.0.0.1:27017/rni?authSource=admin" --db rni --collection mls_bcre_records --drop --gzip dump/rni/mls_bcre_records.bson.gz
mongorestore "mongodb://cab4user:PvUZy5kwqrfN@127.0.0.1:27017/rni?authSource=admin" --db rni --collection mls_treb_evow_delete_ids --drop --gzip dump/rni/mls_treb_evow_delete_ids.bson.gz
mongorestore "mongodb://cab4user:PvUZy5kwqrfN@127.0.0.1:27017/rni?authSource=admin" --db rni --collection mls_bcre_deleted --drop --gzip dump/rni/mls_bcre_deleted.bson.gz
mongorestore "mongodb://cab4user:PvUZy5kwqrfN@127.0.0.1:27017/rni?authSource=admin" --db rni --collection mls_oreb_master_records --drop --gzip dump/rni/mls_oreb_master_records.bson.gz
mongorestore "mongodb://cab4user:PvUZy5kwqrfN@127.0.0.1:27017/rni?authSource=admin" --db rni --collection mls_rahb_records --drop --gzip dump/rni/mls_rahb_records.bson.gz

备份 3 个表:

mongodump --uri "mongodb://cab4user:PvUZy5kwqrfN@127.0.0.1:27017/importer?authSource=admin" --collection board --gzip
mongodump --uri "mongodb://cab4user:PvUZy5kwqrfN@127.0.0.1:27017/importer?authSource=admin" --collection mapping --gzip
mongodump --uri "mongodb://cab4user:PvUZy5kwqrfN@127.0.0.1:27017/importer?authSource=admin" --collection mapping_enum --gzip
mongodump --uri "mongodb://cab4user:PvUZy5kwqrfN@127.0.0.1:27017/importer?authSource=admin" --collection mapping_reserved --gzip

基础配置

Go 私有仓库设置:

export GOPRIVATE=*

编辑 ~/.gitconfig,加入:

[url "ssh://git@github.com"]
    insteadOf = https://github.com

[url "git@github.com:"]
    insteadOf = https://github.com/