Golang开发项目管理系统教程

• /cmd：主程序入口，如 main.go
• /internal/project：项目相关业务逻辑
• /internal/user：用户管理（可扩展）
• /pkg/db：数据库操作封装
• /pkg/router：HTTP 路由配置
• /config：配置文件（如 config.yaml）
• /migrations：数据库迁移脚本

type Project struct {
    ID          int       `json:"id"`
    Name        string    `json:"name"`
    Description string    `json:"description"`
    Status      string    `json:"status"` // pending, ongoing, done
    CreatedAt   time.Time `json:"created_at"`
}

db, err := sql.Open("sqlite3", "./projects.db")
if err != nil {
    log.Fatal(err)
}
defer db.Close()

func CreateProject(db *sql.DB, name, desc, status string) error {
    _, err := db.Exec(
        "INSERT INTO projects (name, description, status, created_at) VALUES (?, ?, ?, ?)",
        name, desc, status, time.Now(),
    )
    return err
}

http.HandleFunc("/projects", func(w http.ResponseWriter, r *http.Request) {
    if r.Method == "POST" {
        var proj Project
        json.NewDecoder(r.Body).Decode(&proj)
        err := CreateProject(db, proj.Name, proj.Description, proj.Status)
        if err != nil {
            http.Error(w, "Server Error", http.StatusInternalServerError)
            return
        }
        w.WriteHeader(http.StatusCreated)
        json.NewEncoder(w).Encode(map[string]string{"message": "Project created"})
    } else if r.Method == "GET" {
        // 查询所有项目
    }
})

log.Println("Server starting on :8080")
log.Fatal(http.ListenAndServe(":8080", nil))

func TestCreateProject(t *testing.T) {
    db, _ := sql.Open("sqlite3", ":memory:")
    setupTestDB(db)
    err := CreateProject(db, "Test Project", "Desc", "pending")
    if err != nil {
        t.Errorf("Expected no error, got %v", err)
    }
}

GOOS=linux GOARCH=amd64 go build -o project-manager main.go