如何使用Go语言开发点餐系统的餐厅搜索功能

CREATE TABLE `restaurants` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `province` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `latitude` float(10,6) NOT NULL,
  `longitude` float(10,6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

go get -u GitHub.com/gin-gonic/gin
go get -u gorm.io/gorm
go get -u gorm.io/driver/Mysql

package main

import (
    "fmt"
    "github.com/gin-gonic/gin"
    "gorm.io/driver/mysql"
    "gorm.io/gorm"
    "net/http"
)

type Restaurant struct {
    ID        uint   `gorm:"primaryKey"`
    Name      string `gorm:"column:name"`
    Address   string `gorm:"column:address"`
    City      string `gorm:"column:city"`
    Province  string `gorm:"column:province"`
    Country   string `gorm:"column:country"`
    Latitude  float64 `gorm:"column:latitude"`
    Longitude float64 `gorm:"column:longitude"`
}

func main() {
    dsn := "<mysql connection string>"
    db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})
    if err != nil {
        panic("Failed to connect to database")
    }

    db.AutoMigrate(&Restaurant{})

    router := gin.Default()

    router.GET("/restaurants/search", func(c *gin.Context) {
        keyWord := c.Query("keyword")

        var restaurants []Restaurant
        result := db.Where("name LIKE ?", fmt.Sprintf("%%%s%%", keyword)).Find(&restaurants)
        if result.Error != nil {
            c.JSON(http.StatusInternalServerError, gin.H{"error": "Failed to retrieve restaurants"})
            return
        }

        c.jsON(http.StatusOK, restaurants)
    })

    router.Run(":8080")
}