// DeleteEvent : used to delete events from SQL DB
func DeleteEvent(w http.ResponseWriter, r *http.Request) {
// Extract API resource ID
vars := mux.Vars(r)
eventid := vars["eventid"]
if eventid == "" {
ThrowForbiddenedAndExit(w)
return
}
// Used for per user connection to DB
dbconn := db.GetDBConn(DBName)
defer dbconn.Close()
rows, _ := dbconn.Query("SELECT event_name from Events where id=$1", eventid)
if rows.Next() == false {
ThrowForbiddenedAndExit(w)
return
}
// Execute delete if eventid is found
dbconn.Query("DELETE from Events where id=$1", eventid)
// If no error then give a success response
RespondSuccessAndExit(w, "Event Deleted Successfully")
}
// CreateEvent : creates a new event at a base location
func CreateEvent(w http.ResponseWriter, r *http.Request) {
routeHits.Add("/v1/create_event", 1)
decoder := json.NewDecoder(r.Body)
var eventcreationdata generics.EventCreationData
// Expand the json attached in post request
err := decoder.Decode(&eventcreationdata)
if err != nil {
panic(err)
}
// Convert Str input data to respective float / time fmt.
creationTimeStr := time.Now().Format(time.RFC3339)
fmt.Println(creationTimeStr)
lat, _ := strconv.ParseFloat(eventcreationdata.Lat, 64)
long, _ := strconv.ParseFloat(eventcreationdata.Long, 64)
maxMem, _ := strconv.ParseInt(eventcreationdata.MaxMem, 10, 64)
minMem, _ := strconv.ParseInt(eventcreationdata.MinMem, 10, 64)
maxAge, _ := strconv.ParseInt(eventcreationdata.MaxAge, 10, 64)
minAge, _ := strconv.ParseInt(eventcreationdata.MinAge, 10, 64)
currentMem := 0
// Used for per user connection to DB
dbconn := db.GetDBConn(DBName)
defer dbconn.Close()
// Add code to manage event creation request
// Add an err handler here to ensure a failed signup request is handled
stmt, _ := dbconn.Prepare(`INSERT INTO Events(event_name, lat, lng,
creation_time, creator_id, start_time, end_time, max_mem, min_mem,
friend_only, gender, min_age, max_age,current_mem)
VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14);`)
_, execerr := stmt.Exec(string(eventcreationdata.EventName),
lat, long, creationTimeStr,
string(eventcreationdata.Creatorid), eventcreationdata.StartTime,
eventcreationdata.EndTime, maxMem, minMem, eventcreationdata.FriendOnly,
eventcreationdata.Gender, minAge, maxAge, currentMem)
if execerr != nil {
// If execution err occurs then throw error
log.Fatal(execerr)
ThrowInternalErrAndExit(w)
return
}
// If no error then give a success response
RespondSuccessAndExit(w, "Event Created Successfully")
}
// UserHandler : Get User
func UserHandler(w http.ResponseWriter, r *http.Request) {
vars := mux.Vars(r)
userid := vars["userid"]
if userid == "" {
ThrowForbiddenedAndExit(w)
return
}
// Extract a user from DB
var u models.User
// Used for per user connection to DB
dbconn := db.GetDBConn(DBName)
defer dbconn.Close()
err := dbconn.
QueryRow("SELECT userid, firstname, lastname, gender, age, phonenumber FROM users WHERE userid = $1", userid).
Scan(&u.UserID, &u.FirstName, &u.LastName, &u.Gender, &u.Age, &u.PhoneNumber)
if err != nil {
// If execution err occurs then throw error
ThrowForbiddenedAndExit(w)
return
}
jsonResponse, err := json.Marshal(u)
if err != nil {
http.Error(w, err.Error(), http.StatusInternalServerError)
return
}
// Append the data to response writer
w.Header().Set("Content-Type", "application/json")
w.WriteHeader(http.StatusOK)
w.Write(jsonResponse)
}
// GetEventHandler : Get Event
func GetEventHandler(w http.ResponseWriter, r *http.Request) {
// Vars to handle Event Struct
var (
id string
eventname string
creationtime time.Time
creatorid string
starttime time.Time
endtime time.Time
maxMem int64
minMem int64
friendOnly bool
gender string
minAge int64
maxAge int64
lat float64
long float64
currentMem int64
)
// Extract API resource ID
vars := mux.Vars(r)
eventid := vars["eventid"]
if eventid == "" {
ThrowForbiddenedAndExit(w)
return
}
// Used for per user connection to DB
dbconn := db.GetDBConn(DBName)
defer dbconn.Close()
err := dbconn.
QueryRow("SELECT id, event_name, lat, lng, creation_time, creator_id, start_time, end_time, max_mem, min_mem, friend_only, gender, min_age, max_age, current_mem FROM Events WHERE id = $1", eventid).
Scan(&id, &eventname, &lat, &long,
&creationtime, &creatorid, &starttime, &endtime, &maxMem, &minMem,
&friendOnly, &gender, &minAge, &maxAge, ¤tMem)
if err != nil {
// If execution err occurs then throw error
fmt.Println(err)
ThrowForbiddenedAndExit(w)
return
}
event := models.Event{
id,
eventname,
strconv.FormatFloat(lat, 'f', 6, 64),
strconv.FormatFloat(long, 'f', 6, 64),
creationtime.Format("2014-06-08T02:02:22Z"),
creatorid,
starttime.Format("2014-06-08T02:02:22Z"),
endtime.Format("2014-06-08T02:02:22Z"),
strconv.FormatInt(maxMem, 10),
strconv.FormatInt(minMem, 10),
strconv.FormatBool(friendOnly),
gender,
strconv.FormatInt(minAge, 10),
strconv.FormatInt(maxAge, 10),
strconv.FormatInt(currentMem, 10),
}
jsonResponse, err := json.Marshal(event)
if err != nil {
http.Error(w, err.Error(), http.StatusInternalServerError)
return
}
// Append the data to response writer
w.Header().Set("Content-Type", "application/json")
w.WriteHeader(http.StatusOK)
w.Write(jsonResponse)
}