Skip to content

Instantly share code, notes, and snippets.

@s1s1ty
Created July 31, 2018 07:15
Show Gist options
  • Save s1s1ty/7cd05f43d737066110df6417168d1e01 to your computer and use it in GitHub Desktop.
Save s1s1ty/7cd05f43d737066110df6417168d1e01 to your computer and use it in GitHub Desktop.
go-sql-main
package main
import (
"fmt"
"net/http"
"os"
"github.com/go-chi/chi"
"github.com/go-chi/chi/middleware"
"github.com/s1s1ty/go-mysql-crud/driver"
ph "github.com/s1s1ty/go-mysql-crud/handler/http"
)
func main() {
dbName := os.Getenv("DB_NAME")
dbPass := os.Getenv("DB_PASS")
dbHost := os.Getenv("DB_HOST")
dbPort := os.Getenv("DB_PORT")
println("this is db", dbName, dbHost, dbPass, dbPort)
connection, err := driver.ConnectSQL(dbHost, dbPort, "root", dbPass, dbName)
if err != nil {
fmt.Println(err)
os.Exit(-1)
}
r := chi.NewRouter()
r.Use(middleware.Recoverer)
r.Use(middleware.Logger)
pHandler := ph.NewPostHandler(connection)
r.Get("/posts", pHandler.Fetch)
r.Get("/posts/{id}", pHandler.GetByID)
r.Post("/posts/create", pHandler.Create)
r.Put("/posts/update/{id}", pHandler.Update)
r.Delete("/posts/{id}", pHandler.Delete)
fmt.Println("Server listen at :8005")
http.ListenAndServe(":8005", r)
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment