wangjia
52857d1d55
- internal/config: rewrite Config with PANGOLIN_ prefix fields (HTTPAddr, AdminAddr, GRPCAddr, MySQL DSN/fields, RedisAddr, AutoMigrate, JWTSecret placeholder, WebhookSecret); Load() replaces FromEnv(); missing required MySQL vars return named-field error. - internal/store/mysql.go: single Open(cfg) entry point; uses mysql.ParseDSN to structurally override ParseTime=true, Loc=UTC, Collation=utf8mb4_unicode_ci, Params[time_zone]='+00:00'; asserts SELECT @@session.time_zone=+00:00 after Ping (startup fatal). - migrations/embed.go: //go:embed *.sql exposes var FS embed.FS. - internal/store/migrate.go: MigrateUp/MigrateDown/MigrateVersion backed by golang-migrate iofs source + mysql driver; ErrNoChange treated as success. - cmd/migrate/main.go: filled — up/down/version subcommands, reads config.Load() + store.Open. - cmd/server/main.go: startup sequence Load → store.Open (UTC assert) → MigrateUp (if PANGOLIN_AUTO_MIGRATE=true) → HTTP listen; structured slog output at each step. - internal/store/mysql_test.go: pure-function unit tests for buildDSN (empty-fields case + conflicting params overridden case); both pass. - internal/store/mysql_integration_test.go: //go:build integration; testcontainers mysql:8 — UTC assertion + MigrateUp idempotency. Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
12 lines
594 B
Go
12 lines
594 B
Go
// Package store provides the database access layer for Pangolin.
|
|
// It wraps MySQL (via database/sql) and exposes:
|
|
// - Open: the single canonical entry point for all MySQL connections,
|
|
// which enforces UTC DSN parameters and asserts the session time_zone.
|
|
// - MigrateUp / MigrateDown / MigrateVersion: golang-migrate helpers backed
|
|
// by the embedded SQL files in server/migrations.
|
|
//
|
|
// Typed repository interfaces for each domain entity (users, devices, plans,
|
|
// subscriptions, codes, nodes, usage, audit log) are added as the feature
|
|
// tasks implement them.
|
|
package store
|