package main
import (
"time"
"fmt"
"html/template"
"net/http"
"database/sql"
_"github.com/go-sql-driver/mysql"
)
type Page struct {
Title string
Body []byte
Timestamp time.Time
}
func (p *Page) save() error {
_, err := stmtIns.Exec(p.Title, p.Body)
return err // ioutil.WriteFile(filename, p.Body, 0600)
}
func loadPage(ident string) (*Page, error) {
s := Page{}
err := stmtOut.QueryRow(ident).Scan(&s.Title, &s.Body, &s.Timestamp)
if err != nil {
return nil, err
}
return &s, nil
}
func viewHandler(w http.ResponseWriter, r *http.Request) {
title := r.URL.Path[len("/view/"):]
if len(title) < 1 {
http.Redirect(w, r, "/", http.StatusFound)
return
}
p, err := loadPage(title)
if err != nil {
http.NotFoundHandler()
} else {
renderTemplate(w, "view", p)
}
}
func editHandler(w http.ResponseWriter, r *http.Request) {
title := r.URL.Path[len("/edit/"):]
p, err := loadPage(title)
if err != nil {
p = &Page{Title: title}
}
renderTemplate(w, "edit", p)
}
func saveHandler(w http.ResponseWriter, r *http.Request) {
//title := r.URL.Path[len("/save/"):]
//if len(title) < 1 {
// http.Redirect(w, r, "/", http.StatusFound)
// return
//}
title:= r.FormValue("appname")
body := r.FormValue("body")
p := &Page{Title: title, Body: []byte(body)}
p.save()
http.Redirect(w, r, "/view/"+title, http.StatusFound)
}
func errorHandler(w http.ResponseWriter, r *http.Request, status int) {
w.WriteHeader(status)
if status == http.StatusNotFound {
fmt.Fprint(w, "file was not found on server")
}
}
var templates = template.Must(template.ParseFiles("edit.html", "view.html"))
func renderTemplate(w http.ResponseWriter, tmpl string, p *Page) {
err := templates.ExecuteTemplate(w, tmpl+".html", p)
if err != nil {
http.Error(w, err.Error(), http.StatusInternalServerError)
}
}
// var db *sql.DB
var stmtIns, stmtOut *sql.Stmt
func main() {
db, err := sql.Open("mysql", "root:feelssemibadman@/golang")
if err != nil {
fmt.Printf("failed to open mysql handle\n")
}
defer db.Close()
err = db.Ping()
if err != nil {
fmt.Printf("opened handle but failed to communicate with mysql\n")
}
// Prepare statement for inserting data
stmtIns, err := db.Prepare("INSERT Applications SET AppName=?, Description=?")
if err != nil {
fmt.Printf(err.Error())
}
defer stmtIns.Close() // Close the statement when we leave main() / the program terminates
// Prepare statement for reading data
stmtOut, err := db.Query("SELECT AppName, Description, CreatedOn FROM Applications WHERE AppID=?")
if err != nil {
fmt.Printf(err.Error())
}
defer stmtOut.Close()
http.HandleFunc("/view/", viewHandler)
http.HandleFunc("/edit/", editHandler)
http.HandleFunc("/save/", saveHandler)
http.ListenAndServe(":8080", nil)
}