chengma/cmautobuy
2
0
Fork 0
Code Issues 89 Pull Requests Actions Packages Projects Releases Wiki Activity

Admin:??? config.yaml ?? MySQL 8 ?? #83

New Issue
Closed
opened 2026-08-10 09:16:05 +08:00 by ila · 2 comments
ila commented 2026-08-10 09:16:05 +08:00
Owner
Copy Link
Copy Source

????

  • ??:??
  • ?????:#76
  • ?? MVP / ??:#77 / ?? MySQL 8 ??
  • ??:#81 ??????

?????

Admin ??????? CMAUTOBUY_DB_* ?????? MySQL ?????Windows ???? run_admin.bat ????????????????,?????????????????????? Git ??? admin/config.yaml ???? MySQL 8 ??,??????? systemd ?????????

??? / ????

  • ?:?? database: YAML ??;????????????? YAML;??????????? YAML;?????????? Admin ??/????;?? config.yaml ??? Git ???
  • ??:????????? Git?Gitea???? docs/task;????? MySQL ??;????? SSH ??;??? SQLite ??????

???

  • ?? admin/config/config.go:??????? Database,???????????????,??????????????
  • ?? admin/main.go ? SQLite?MySQL ????,??????????????
  • ?? admin/config.example.yaml,?????? database: ???
  • ?? admin/config/config_test.go,?? YAML?????????????????
  • ?? docs/admin/00-getting-started.md?docs/admin/06-quality-security.md ?????????????
  • ????????? Client API?

????

  • ???????????,?? database: ????? MySQL 8 Admin?
  • ????????? config.yaml,?? systemd ???????????
  • config.example.yaml ?? host?port?name?user?password ????????????
  • ???????????????????
  • admin/config.yaml ?? Git ??,????????????????
  • Go 1.23.0 ? go vet ./...?go build ./...?go test ./... -count=1 ???

????

? admin/ ????:

$env:GOTOOLCHAIN="go1.23.0"
go vet ./...
go build ./...
go test ./... -count=1
Remove-Item Env:GOTOOLCHAIN

???? YAML ?????????????;?????? MySQL ???? SSH ??,??? 3307 ?????

?????

  • ??:config.yaml ?????????,???????????????? .gitignore??????????????;????????? root-only ? /etc/cmautobuy/admin.env?
  • ???:?????????,?? systemd ??????
  • ??:??????????,??????? database:;??????????????
## ???? - ??:?? - ?????:#76 - ?? MVP / ??:#77 / ?? MySQL 8 ?? - ??:#81 ?????? ## ????? Admin ??????? `CMAUTOBUY_DB_*` ?????? MySQL ?????Windows ???? `run_admin.bat` ????????????????,?????????????????????? Git ??? `admin/config.yaml` ???? MySQL 8 ??,??????? systemd ????????? ## ??? / ???? - ?:?? `database:` YAML ??;????????????? YAML;??????????? YAML;?????????? Admin ??/????;?? `config.yaml` ??? Git ??? - ??:????????? Git?Gitea???? `docs/task`;????? MySQL ??;????? SSH ??;??? SQLite ?????? ## ??? - ?? `admin/config/config.go`:??????? `Database`,???????????????,?????????????? - ?? `admin/main.go` ? SQLite?MySQL ????,?????????????? - ?? `admin/config.example.yaml`,?????? `database:` ??? - ?? `admin/config/config_test.go`,?? YAML????????????????? - ?? `docs/admin/00-getting-started.md`?`docs/admin/06-quality-security.md` ????????????? - ????????? Client API? ## ???? - [x] ???????????,?? `database:` ????? MySQL 8 Admin? - [x] ????????? `config.yaml`,?? systemd ??????????? - [x] `config.example.yaml` ?? host?port?name?user?password ???????????? - [x] ??????????????????? - [x] `admin/config.yaml` ?? Git ??,???????????????? - [x] Go 1.23.0 ? `go vet ./...`?`go build ./...`?`go test ./... -count=1` ??? ## ???? ? `admin/` ????: ```powershell $env:GOTOOLCHAIN="go1.23.0" go vet ./... go build ./... go test ./... -count=1 Remove-Item Env:GOTOOLCHAIN ``` ???? YAML ?????????????;?????? MySQL ???? SSH ??,??? `3307` ????? ## ????? - ??:`config.yaml` ?????????,???????????????? `.gitignore`??????????????;????????? root-only ? `/etc/cmautobuy/admin.env`? - ???:?????????,?? systemd ?????? - ??:??????????,??????? `database:`;??????????????
ila commented 2026-08-10 09:25:01 +08:00
Author
Owner
Copy Link
Copy Source

实施完成，待验收

  • 实现提交：04a777d（支持 database: YAML、环境变量按字段覆盖、主程序与迁移命令接入）
  • 归档提交：dee9f34
  • 归档文档：docs/task/83-config-yaml-mysql配置.md
  • 本机真实 admin/config.yaml 已写入 buy 配置，端口为 SSH 隧道本地端口 13307；文件继续被 Git 忽略，工单未记录密码。

验证（GOTOOLCHAIN=go1.23.0）：

go vet ./...
go build ./...
go test ./... -count=1

结果：全部通过。

未验证：本机执行策略阻止自动后台启动 SSH 隧道，因此 run_admin.bat 连接线上 MySQL 的页面冒烟留在部署工单 #81；未开放 MySQL 公网端口。

## 实施完成，待验收 - 实现提交：`04a777d`（支持 `database:` YAML、环境变量按字段覆盖、主程序与迁移命令接入） - 归档提交：`dee9f34` - 归档文档：`docs/task/83-config-yaml-mysql配置.md` - 本机真实 `admin/config.yaml` 已写入 `buy` 配置，端口为 SSH 隧道本地端口 `13307`；文件继续被 Git 忽略，工单未记录密码。 验证（`GOTOOLCHAIN=go1.23.0`）： ```powershell go vet ./... go build ./... go test ./... -count=1 ``` 结果：全部通过。 未验证：本机执行策略阻止自动后台启动 SSH 隧道，因此 `run_admin.bat` 连接线上 MySQL 的页面冒烟留在部署工单 #81；未开放 MySQL 公网端口。
ila commented 2026-08-10 23:23:14 +08:00
Author
Owner
Copy Link
Copy Source

用户已明确验收通过。验收清单已回填，本工单关闭。

用户已明确验收通过。验收清单已回填，本工单关闭。
ila closed this issue 2026-08-10 23:23:16 +08:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
admin ila
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: chengma/cmautobuy#83