1d273066b0
将 Markdown 编辑器替换为 TipTap WYSIWYG，新增帖子修订记录与 diff 展示；首页支持最新/回复排序与本地缓存；后台可配置编辑时限与锁定帖子；侧边栏整合板块导航并优化 Feed 布局。 Co-authored-by: Cursor <cursoragent@cursor.com>
47 lines
925 B
Go
47 lines
925 B
Go
package model
|
|
|
|
import (
|
|
"fmt"
|
|
"log"
|
|
"os"
|
|
"path/filepath"
|
|
|
|
"gorm.io/driver/sqlite"
|
|
"gorm.io/gorm"
|
|
"gorm.io/gorm/logger"
|
|
)
|
|
|
|
var DB *gorm.DB
|
|
|
|
// InitDB 初始化 SQLite 并自动迁移
|
|
func InitDB(dbPath string) error {
|
|
dir := filepath.Dir(dbPath)
|
|
if err := os.MkdirAll(dir, 0755); err != nil {
|
|
return fmt.Errorf("创建数据库目录失败: %w", err)
|
|
}
|
|
|
|
db, err := gorm.Open(sqlite.Open(dbPath), &gorm.Config{
|
|
Logger: logger.Default.LogMode(logger.Warn),
|
|
})
|
|
if err != nil {
|
|
return fmt.Errorf("连接 SQLite 失败: %w", err)
|
|
}
|
|
|
|
sqlDB, err := db.DB()
|
|
if err != nil {
|
|
return err
|
|
}
|
|
sqlDB.SetMaxOpenConns(1)
|
|
|
|
if err := db.AutoMigrate(
|
|
&User{}, &Board{}, &Post{}, &Comment{},
|
|
&PostLike{}, &PostFavorite{}, &PostRevision{}, &ForumSetting{},
|
|
); err != nil {
|
|
return fmt.Errorf("自动迁移失败: %w", err)
|
|
}
|
|
|
|
DB = db
|
|
log.Println("[model] SQLite 数据库初始化完成:", dbPath)
|
|
return nil
|
|
}
|