Something went wrong. Try again.
An online platform for automata theory assignments
Something went wrong. Try again.
automata-web-platform assignment.go
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215package main
import ( "database/sql" "errors" "fmt" "net/http" "strconv" "time")
func registerAssignmentRoutes(mux *http.ServeMux) error { mux.HandleFunc("/assignment/{id}", authenticatedPage(func(w http.ResponseWriter, r *http.Request, u user) { id, err := strconv.Atoi(r.PathValue("id")) if err != nil { httpErrorLog(w, "invalid assignment id", err) } a := assignment{Id: id}
if u.Admin { switch r.Method { case "POST": if err := (&a).fromForm(r); err != nil { httpErrorLog(w, "could not parse form", err) return } if id == -1 { if err := a.create(); err != nil { httpErrorLog(w, "could not create assignment", err) return } } else { if err := a.update(); err != nil { httpErrorLog(w, "could not update assignment", err) return } } http.Redirect(w, r, "/home", http.StatusFound) case "GET": tmpl, err := getTemplate("edit-assignment") if err != nil { httpErrorLog(w, "could not get assignment template", err) return }
err = a.fetch()
amap := map[string]any{"id": id}
if err == nil { amap = a.formValues() // amap["name"] = a.Name // amap["start"] = a.Start.Format("2006-01-02T15:04") // amap["end"] = a.End.Format("2006-01-02T15:04") } else { fmt.Println(err.Error()) }
tmpl.Execute(w, map[string]any{ "new": err != nil, "assignment": amap, }) } } else { // Just show the assignment } })) return nil}
func createAssignmentTable() error { db, err := openDB() if err != nil { return err } _, err = db.Exec( `CREATE TABLE IF NOT EXISTS assignments ( id INTEGER PRIMARY KEY, name TEXT UNIQUE NOT NULL, start INT NOT NULL, end INT NOT NULL) `, ) return err}
type assignment struct { Id int Name string Start time.Time End time.Time}
func (a *assignment) fromForm(r *http.Request) error { a.Name = r.FormValue("name")
loc, err := time.LoadLocation("America/New_York") if err != nil { return err }
if t, err := time.ParseInLocation("2006-01-02T15:04", r.FormValue("start"), loc); err != nil { return err } else { a.Start = t }
if t, err := time.ParseInLocation("2006-01-02T15:04", r.FormValue("end"), loc); err != nil { return err } else { a.End = t }
return nil
}
func (a assignment) create() error { db, err := openDB() if err != nil { return err }
_, err = db.Exec("INSERT INTO assignments (name, start, end) VALUES ($1, $2, $3)", a.Name, a.Start.Unix(), a.End.Unix()) return err}
func (a assignment) update() error { db, err := openDB() if err != nil { return err }
affected, err := db.Exec(`UPDATE assignmentsSET name = $1, start = $2, end = $3WHERE id = $4`, a.Name, a.Start.Unix(), a.End.Unix(), a.Id, ) if err != nil { return err } else if count, err := affected.RowsAffected(); err != nil { return err } else if count != 1 { return errors.New("did not update a row") } return nil}
func (a *assignment) fetch() error { db, err := openDB() if err != nil { return err }
var ( start int64 end int64 ) err = db.QueryRow("SELECT name, start, end FROM assignments WHERE id = $1", a.Id).Scan(&a.Name, &start, &end) if err != nil { if errors.Is(err, sql.ErrNoRows) { return errors.New("no such assignment") } return err } a.Start = time.Unix(start, 0) a.End = time.Unix(end, 0)
return nil}
func (a assignment) formValues() map[string]any { return map[string]any{ "id": a.Id, "name": a.Name, "start": a.Start.Format("2006-01-02T15:04"), "end": a.End.Format("2006-01-02T15:04"), }}
func getAssignments() ([]assignment, error) { db, err := openDB() if err != nil { return nil, err }
rows, err := db.Query("SELECT id, name, start, end FROM assignments") if err != nil { return nil, err }
var assignments []assignment
for rows.Next() { var ( a assignment start int64 end int64 ) err := rows.Scan(&a.Id, &a.Name, &start, &end) if err != nil { return nil, err } a.Start = time.Unix(start, 0) a.End = time.Unix(end, 0) assignments = append(assignments, a) }
return assignments, nil}