fix: update SaveModelProvider to use model_providers table

MiaoMint · MiaoMint · commit e8d134a02774 · 2026-01-12T20:54:10.000+08:00
diff --git a/database/db.go b/database/db.go
@@ -66,11 +66,6 @@ func InitDB() error {
 		return err
 	}
 
-	// Auto-migrate for existing tables
-	// Ignore errors if columns already exist
-	DB.Exec("ALTER TABLE projects ADD COLUMN workflow TEXT DEFAULT ''")
-	DB.Exec("ALTER TABLE projects ADD COLUMN cover_image TEXT DEFAULT ''")
-
 	log.Println("Database initialized successfully")
 	return nil
 }
diff --git a/database/repository.go b/database/repository.go
@@ -46,7 +46,7 @@ func SaveModelProvider(config ModelProvider) error {
 
 	// Update
 	_, err := DB.NamedExec(`
-		UPDATE projects 
+		UPDATE model_providers 
 		SET name = :name, type = :type, api_key = :api_key, base_url = :base_url, updated_at = CURRENT_TIMESTAMP
 		WHERE id = :id
 	`, config)

Original file line number	Diff line number	Diff line change
`@@ -66,11 +66,6 @@ func InitDB() error {`
`66`	`66`	`return err`
`67`	`67`	`}`
`68`	`68`
`69`		`- // Auto-migrate for existing tables`
`70`		`- // Ignore errors if columns already exist`
`71`		`- DB.Exec("ALTER TABLE projects ADD COLUMN workflow TEXT DEFAULT ''")`
`72`		`- DB.Exec("ALTER TABLE projects ADD COLUMN cover_image TEXT DEFAULT ''")`
`73`		`-`
`74`	`69`	`log.Println("Database initialized successfully")`
`75`	`70`	`return nil`
`76`	`71`	`}`