// UpdateAllDottedIds is not required any more?
func UpdateAllDottedIds() error {
// Regenerate dotted ids - we fetch all tags first to avoid db calls
q := tags.Query().Select("select id,parent_id from tags").Order("id asc")
tagsList, err := tags.FindAll(q)
if err == nil {
for _, tag := range tagsList {
params := map[string]string{
"dotted_ids": tag.CalculateDottedIds(tagsList),
}
fmt.Printf("\n%d -> %s\n", tag.Id, params["dotted_ids"])
err = tags.Query().Where("id=?", tag.Id).Update(params)
}
} else {
fmt.Printf("%s", err)
return err
}
return nil
}
// HandleCreate responds to POST tags/create
func HandleCreate(context router.Context) error {
// Authorise
err := authorise.Path(context)
if err != nil {
return router.NotAuthorizedError(err)
}
// Setup context
params, err := context.Params()
if err != nil {
return router.InternalError(err)
}
id, err := tags.Create(params.Map())
if err != nil {
context.Logf("#info Failed to create tag %v", params)
return router.InternalError(err)
}
// Log creation
context.Logf("#info Created tag id,%d", id)
// Redirect to the new tag
tag, err := tags.Find(id)
if err != nil {
context.Logf("#error Error creating tag,%s", err)
}
// Always regenerate dotted ids - we fetch all tags first to avoid db calls
q := tags.Query().Select("select id,parent_id from tags").Order("id asc")
tagsList, err := tags.FindAll(q)
if err == nil {
dottedParams := map[string]string{}
dottedParams["dotted_ids"] = tag.CalculateDottedIds(tagsList)
tags.Query().Where("id=?", tag.Id).Update(dottedParams)
}
return router.Redirect(context, tag.URLIndex())
}
// HandleIndex serves a get request at /tags
func HandleIndex(context router.Context) error {
// Authorise
err := authorise.Path(context)
if err != nil {
return router.NotAuthorizedError(err)
}
//UpdateAllDottedIds()
// Setup context for template
view := view.New(context)
// Fetch the tags
q := tags.RootTags().Order("name asc")
// Filter if necessary
filter := context.Param("filter")
if len(filter) > 0 {
filter = strings.Replace(filter, "&", "", -1)
filter = strings.Replace(filter, " ", "", -1)
filter = strings.Replace(filter, " ", " & ", -1)
q.Where("(to_tsvector(name) || to_tsvector(summary) @@ to_tsquery(?))", filter)
}
tagList, err := tags.FindAll(q)
if err != nil {
return router.InternalError(err)
}
// Serve template
view.AddKey("filter", filter)
view.AddKey("tags", tagList)
return view.Render()
}