func Redirect(ctx *godzilla.Context) {
u := ctx.FindById("url", ctx.Splat[1])
if u == nil {
ctx.Error("not found", 404)
} else {
ctx.Redirect(reflect.ValueOf(u["url"]).String())
}
}
func List(ctx *godzilla.Context) {
ctx.O["title"] = "godzilla blog!"
ctx.O["categories"] = ctx.Query("SELECT * FROM categories ORDER BY name")
ctx.O["selected"], _ = strconv.ParseInt(reflect.ValueOf(ctx.Params["category"]).String(), 10, 64)
link := map[int64][]map[string]interface{}{}
x := ctx.Query("SELECT b.id AS link_id, b.category_id AS cid, b.post_id AS pid,a.name as category FROM categories a,post_category b WHERE a.id=b.category_id")
for _, v := range x {
key := reflect.ValueOf(v["pid"]).Int()
if link[key] == nil {
link[key] = make([]map[string]interface{}, 0)
}
link[key] = append(link[key], v)
}
ctx.O["link"] = link
_, ok := ctx.Params["category"]
if ok {
ctx.O["items"] = ctx.Query("SELECT a.*,(strftime('%s', 'now') - a.updated_at) as ago FROM posts a, post_category b WHERE a.id = b.post_id AND b.category_id=? ORDER BY a.updated_at DESC", ctx.Params["category"])
} else {
ctx.O["items"] = ctx.Query("SELECT *,(strftime('%s', 'now') - updated_at) as ago FROM posts ORDER BY updated_at DESC")
}
ctx.O["is_admin"] = is_admin(ctx)
ctx.Render()
}
func Show(ctx *godzilla.Context) {
o := ctx.FindById("posts", ctx.Splat[1])
if o == nil {
ctx.Error("nothing to do here.. \\o/", 404)
return
}
ctx.O["title"] = o["title"]
ctx.O["item"] = o
ctx.Render()
}
func Append(ctx *godzilla.Context) {
id, _ := ctx.Replace("url", map[string]interface{}{"url": ctx.Splat[1]})
ctx.Write(fmt.Sprintf("/url/%d", id))
}
func Modify(ctx *godzilla.Context) {
if !is_admin(ctx) {
ctx.Error("not allowed", 404)
return
}
object_id := ctx.Splat[2]
object_type := ctx.Splat[1]
if object_type != "posts" && object_type != "categories" && object_type != "post_category" {
ctx.Error("bad object type", 500)
return
}
var output interface{}
switch ctx.R.Method {
case "GET":
output = ctx.FindById(object_type, object_id)
case "POST":
var j map[string]interface{}
json.Unmarshal([]byte(ctx.Sparams["json"]), &j)
if j == nil {
j = map[string]interface{}{}
}
j["updated_at"] = time.Now().Unix()
id, _ := ctx.Replace(object_type, j)
output = ctx.FindById(object_type, id)
case "DELETE":
ctx.DeleteById(object_type, object_id)
output = "deleted " + object_id + "@" + object_type
}
ctx.RenderJSON(output, 404)
}