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)
}