13.5 Adding, deleting and updating blogs

We’ve already introduced the entire concept behind the Beego framework through examples and pseudo-code. This section will describe how to implement a blogging system using Beego, including the ability to browse, add, modify and delete blog posts.

Blog directory

Our blog’s directory structure can be seen below: 

  1. /main.go
  2. /views:
  3.     /view.tpl
  4.     /new.tpl
  5.     /layout.tpl
  6.     /index.tpl
  7.     /edit.tpl
  8. /models/model.go
  9. /controllers:
  10.     /index.go
  11.     /view.go
  12.     /new.go
  13.     /delete.go
  14.     /edit.go

Blog routing

Our blog’s main routing rules are as follows:

  1. //Show blog Home
  2. beego.RegisterController("/", &controllers.IndexController{})
  3. //View blog details
  4. beego.RegisterController("/view/: id([0-9]+)", &controllers.ViewController{})
  5. //Create blog Bowen
  6. beego.RegisterController("/new", &controllers.NewController{})
  7. //Delete Bowen
  8. beego.RegisterController("/delete/: id([0-9]+)", &controllers.DeleteController{})
  9. //Edit Bowen
  10. beego.RegisterController("/edit/: id([0-9]+)", &controllers.EditController{})

Database structure

A trivial database table to store basic blog information:

  1. CREATE TABLE entries (
  2.     id INT AUTO_INCREMENT,
  3.     title TEXT,
  4.     content TEXT,
  5.     created DATETIME,
  6.     primary key (id)
  7. );

Controller

IndexController:

  1. type IndexController struct {
  2.     beego.Controller
  3. }
  5. func (this *IndexController) Get() {
  6.     this.Data["blogs"] = models.GetAll()
  7.     this.Layout = "layout.tpl"
  8.     this.TplNames = "index.tpl"
  9. }

ViewController:

  1. type ViewController struct {
  2.     beego.Controller
  3. }
  5. func (this *ViewController) Get() {
  6.     inputs := this.Input()
  7.     id, _ := strconv.Atoi(this.Ctx.Params[":id"])
  8.     this.Data["Post"] = models.GetBlog(id)
  9.     this.Layout = "layout.tpl"
  10.     this.TplNames = "view.tpl"
  11. }

NewController

  1. type NewController struct {
  2.     beego.Controller
  3. }
  5. func (this *NewController) Get() {
  6.     this.Layout = "layout.tpl"
  7.     this.TplNames = "new.tpl"
  8. }
  10. func (this *NewController) Post() {
  11.     inputs := this.Input()
  12.     var blog models.Blog
  13.     blog.Title = inputs.Get("title")
  14.     blog.Content = inputs.Get("content")
  15.     blog.Created = time.Now()
  16.     models.SaveBlog(blog)
  17.     this.Ctx.Redirect(302, "/")
  18. }

EditController

  1. type EditController struct {
  2.     beego.Controller
  3. }
  5. func (this *EditController) Get() {
  6.     inputs := this.Input()
  7.     id, _ := strconv.Atoi(this.Ctx.Params[":id"])
  8.     this.Data["Post"] = models.GetBlog(id)
  9.     this.Layout = "layout.tpl"
  10.     this.TplNames = "edit.tpl"
  11. }
  13. func (this *EditController) Post() {
  14.     inputs := this.Input()
  15.     var blog models.Blog
  16.     blog.Id, _ = strconv.Atoi(inputs.Get("id"))
  17.     blog.Title = inputs.Get("title")
  18.     blog.Content = inputs.Get("content")
  19.     blog.Created = time.Now()
  20.     models.SaveBlog(blog)
  21.     this.Ctx.Redirect(302, "/")
  22. }

DeleteController

  1. type DeleteController struct {
  2.     beego.Controller
  3. }
  5. func (this *DeleteController) Get() {
  6.     id, _ := strconv.Atoi(this.Ctx.Input.Params[":id"])
  7.     blog := models.GetBlog(id)
  8.      this.Data["Post"] = blog
  9.      models.DelBlog(blog)
  10.      this.Ctx.Redirect(302, "/")
  11. }

Model layer

  1. package models
  3. import (
  4.     "database/sql"
  5.     "github.com/astaxie/beedb"
  6.     _ "github.com/ziutek/mymysql/godrv"
  7.     "time"
  8. )
  10. type Blog struct {
  11.     Id      int `PK`
  12.     Title   string
  13.     Content string
  14.     Created time.Time
  15. }
  17. func GetLink() beedb.Model {
  18.     db, err := sql.Open("mymysql", "blog/astaxie/123456")
  19.     if err != nil {
  20.         panic(err)
  21.     }
  22.     orm := beedb.New(db)
  23.     return orm
  24. }
  26. func GetAll() (blogs []Blog) {
  27.     db := GetLink()
  28.     db.FindAll(&blogs)
  29.     return
  30. }
  32. func GetBlog(id int) (blog Blog) {
  33.     db := GetLink()
  34.     db.Where("id=?", id).Find(&blog)
  35.     return
  36. }
  38. func SaveBlog(blog Blog) (bg Blog) {
  39.     db := GetLink()
  40.     db.Save(&blog)
  41.     return bg
  42. }
  44. func DelBlog(blog Blog) {
  45.     db := GetLink()
  46.     db.Delete(&blog)
  47.     return
  48. }

View layer

layout.tpl

  1. <html>
  2. <head>
  3.     <title>My Blog</title>
  4.     <style>
  5.         #menu {
  6.             width: 200px;
  7.             float: right;
  8.         }
  9.     </style>
  10. </head>
  11. <body>
  13. <ul id="menu">
  14.     <li><a href="/">Home</a></li>
  15.     <li><a href="/new">New Post</a></li>
  16. </ul>
  18. {{.LayoutContent}}
  20. </body>
  21. </html>

index.tpl

  1. <h1>Blog posts</h1>
  3. <ul>
  4. {{range .blogs}}
  5.     <li>
  6.         <a href="/view/{{.Id}}">{{.Title}}</a> 
  7.         from {{.Created}}
  8.         <a href="/edit/{{.Id}}">Edit</a>
  9.         <a href="/delete/{{.Id}}">Delete</a>
  10.     </li>
  11. {{end}}
  12. </ul>

view.tpl

  1. <h1>{{.Post.Title}}</h1>
  2. {{.Post.Created}}<br/>
  4. {{.Post.Content}}

new.tpl

  1. <h1>New Blog Post</h1>
  2. <form action="" method="post">
  3. Title:<input type="text" name="title"><br>
  4. Content<textarea name="content" colspan="3" rowspan="10"></textarea>
  5. <input type="submit">
  6. </form>

edit.tpl

  1. <h1>Edit {{.Post.Title}}</h1>
  3. <h1>New Blog Post</h1>
  4. <form action="" method="post">
  5. Title:<input type="text" name="title" value="{{.Post.Title}}"><br>
  6. Content<textarea name="content" colspan="3" rowspan="10">{{.Post.Content}}</textarea>
  7. <input type="hidden" name="id" value="{{.Post.Id}}">
  8. <input type="submit">
  9. </form>