// CategoryById получить категорию по ID func CategoryById(id int) (map[string]string, error) { app := webapp.GetApplication() res, err := app.DB.Query("SELECT * FROM content_categories WHERE id = ?", id) if len(res) != 1 { err = errors.New("Not found in database") return nil, err } return res[0], err }
// CategoryByUrl получить категорию по alias (sef ссылка) func CategoryByUrl(url string) (map[string]string, error) { app := webapp.GetApplication() url_crc32 := crc32.ChecksumIEEE([]byte(url)) res, err := app.DB.Query("SELECT * FROM content_categories WHERE hash_url_crc32 = ? and url = ?", url_crc32, url) if len(res) != 1 { err = errors.New("Not found in database") return nil, err } return res[0], err }
func main() { log.Println("Server is preparing to start") Application := app.GetApplication() if Application.Config.Site.Disabled { log.Println("Site is disabled") Application.Routes(app.MapRoutes{{"/": handlers.HandleDisabled{}}}) } else { Application.Routes(app.MapRoutes{ {"/": handlers.HandleHome{}}, //"/else": handlers.HandleElse{}, {"/{url:.*}": handlers.Handle404{}}, }) } Application.Run() log.Println("Exit") }
// TableRowById получить таблицу по ID func TableRowById(tableName string, id int) ([]map[string]string, error) { res, err := webapp.GetApplication().DB.Query("SELECT * FROM ? WHERE id = ?", tableName, id) return res, err }