Files
小K a5692bfd7d feat: OPC 平台初版(Go+PG backend / Vue frontend)+ 尚数网融合方案 + db/0824 数据库备份
- backend: 25 张表 schema/seed,config 指向 127.0.0.1:15432 opc 库
- docs: 尚数网七维融合方案、行业老炮切入方案、竞品分析等
- db/0824/opc_0824.sql(.gz): pg_dump 全量备份(25 表,含数据)
2026-08-24 13:44:40 +08:00

34 lines
799 B
Go
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
package db
import (
"fmt"
"log"
"opc-backend/config"
"opc-backend/models"
"gorm.io/driver/postgres"
"gorm.io/gorm"
)
var DB *gorm.DB
func Init() {
dsn := fmt.Sprintf("host=%s port=%d user=%s password=%s dbname=%s sslmode=disable TimeZone=Asia/Shanghai",
config.DBHost, config.DBPort, config.DBUser, config.DBPassword, config.DBName)
d, err := gorm.Open(postgres.Open(dsn), &gorm.Config{})
if err != nil {
log.Fatalf("连接数据库失败: %v", err)
}
DB = d
log.Println("数据库连接成功")
}
// AutoMigrate 跳过 — 表已用 SQL 初始化(schema.sql)
func AutoMigrate() {
// 不再调用 GORM AutoMigrate,避免与已有 unique 约束冲突。
// 如果未来需要新增字段,请直接修改 schema.sql 中的 ALTER TABLE。
_ = (*models.Project)(nil)
}