Golang如何开发简单的项目管理系统_Golang 项目管理系统实践

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" {
        // 查询所有项目
    }
})</font>

<p>启动服务：</p>
<font color="#006400">
<pre class="brush:php;toolbar:false;">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