go run main.go\n<\/pre>\n\n\n\n

? ????? ?? http:\/\/localhost:8080

?? ?????.\n? ??? ???? ?? ? ????.<\/p>\n\n

$\"Create$ <\/p>

\n \n \n ???\n<\/h2>\n\n

\n \n \n ??? ?? ???\n<\/h3>\n\n
'??? ??' ?????? 50? ???? ??? ??? ?????. ???? 50?? ???? ???? ??? ???? 5??? 2?? ?????.<\/p>\n\n
$\"Create$ <\/p>\n\n

\n \n \n ?? ???\n<\/h3>\n\n
? ?? ?? ??? ?????. id ??? ?????? ???? ?? ?? ? ? ????.<\/p>\n\n
$\"Create$ <\/p>\n\n

\n \n \n ?? ???\n<\/h3>\n\n
'??' ??? ???? '???'? ????? ???? ?? ???? ?? ? ????.<\/p>\n\n
$\"Create$ <\/p>\n\n

\n \n \n ??\n<\/h2>\n\n
????? ??? AG-Grid? Go API? ????? ???? ???? ???? ??? ??? ???? ??????. Go? ??? ??? ???? AG-Grid? ??? ???, ?? ? ??? ??? ??? ? ??? ?? ??? ??? ????? ??? ??? ??????. ? ??? ??? ??? ???? ?? ??? ?????? ?? ??? ???? ?? ??? ??? ??????. AG-Grid? Go? ???? ???? ?? ??????? ??? ?? ??? ??? ??? ???? ??????.<\/p>\n\n
?? ??: https:\/\/github.com\/stackpuz\/Example-AG-Grid-Go<\/p>\n\n
? ? ?? CRUD ? ? ???: https:\/\/stackpuz.com<\/p>\n\n\n \n\n \n <\/pre>"}

亚洲国产日韩欧美一区二区三区,精品亚洲国产成人av在线,国产99视频精品免视看7,99国产精品久久久久久久成人热,欧美日韩亚洲国产综合乱

?? ??

???

?? ?????

AI ??

???

??? ??

Golang

Go? ???? AG-Grid? API ???

Barbara Streisand

Nov 22, 2024 pm 10:51 PM

Create an API for AG-Grid with Go

AG-Grid? ??, ???, ??? ??? ?? ??? ?? ?? ??? ???? ???? ? ???? ??? JavaScript ??? ??? ????????. ? ????? AG-Grid? ???? ?? Go?? API? ???? ???, ??, ??? ??? ??? ???? ?? ? ??? ??? ???? ???. AG-Grid? Go API? ???? ??? ??? ??? ??? ?? ??? ??? ???? ??? ???? ??? ????.

?? ??

1.21? ??
MySQL

???? ??

Go ???? ???? ?????.

go mod init app
go get github.com/gin-gonic/gin
go get gorm.io/gorm
go get gorm.io/driver/mysql
go get github.com/joho/godotenv

"example"??? ???? ??????? ???? Database.sql ??? ???? ???? ???? ?????.

???? ??

├─ .env
├─ main.go
├─ config
│  └─ db.go
├─ controllers
│  └─ product_controller.go
├─ models
│  └─ product.go
├─ public
│  └─ index.html
└─ router
   └─ router.go

???? ??

.env

? ???? ?????? ?? ??? ???? ????.

DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=example
DB_USER=root
DB_PASSWORD=

db.go

? ??? GORM? ???? ?????? ??? ?????. ??? ???????? ??? ?????? ?? ????? ???? ?? ?? ?? DB? ?????.

package config

import (
    "fmt"
    "os"

    "github.com/joho/godotenv"
    "gorm.io/driver/mysql"
    "gorm.io/gorm"
    "gorm.io/gorm/schema"
)

var DB *gorm.DB

func SetupDatabase() {
    godotenv.Load()
    connection := fmt.Sprintf("%s:%s@tcp(%s:%s)/%s?charset=utf8mb4&parseTime=true", os.Getenv("DB_USER"), os.Getenv("DB_PASSWORD"), os.Getenv("DB_HOST"), os.Getenv("DB_PORT"), os.Getenv("DB_DATABASE"))
    db, _ := gorm.Open(mysql.Open(connection), &gorm.Config{NamingStrategy: schema.NamingStrategy{SingularTable: true}})
    DB = db
}

router.go

? ??? Gin ? ??????? ?? ???? ?????. DataTables API? ???? ????? ?? URL?? ?? index.html ??? ?????.

package router

import (
    "app/controllers"

    "github.com/gin-gonic/gin"
)

func SetupRouter() {
    productController := controllers.ProductController{}
    router := gin.Default()
    router.StaticFile("/", "./public/index.html")
    router.GET("/api/products", productController.Index)
    router.Run()
}

product.go

? ??? ??????? ?? ??? ?????.

package models

type Product struct {
    Id int
    Name string
    Price float64
}

product_controller.go

? ??? ???? ??? ???? DataTables ???? ???? ??? ?????.

package controllers

import (
    "app/config"
    "app/models"
    "net/http"
    "strconv"

    "github.com/gin-gonic/gin"
)

type ProductController struct {
}

func (con *ProductController) Index(c *gin.Context) {
    size, _ := strconv.Atoi(c.DefaultQuery("length", "10"))
    start, _ := strconv.Atoi(c.Query("start"))
    order := "id"
    if c.Query("order[0][column]") != "" {
        order = c.Query("columns[" + c.Query("order[0][column]") + "][data]")
    }
    direction := c.DefaultQuery("order[0][dir]", "asc")
    var products []models.Product
    query := config.DB.Model(&products)
    var recordsTotal, recordsFiltered int64
    query.Count(&recordsTotal)
    search := c.Query("search[value]")
    if search != "" {
        search = "%" + search + "%"
        query.Where("name like ?", search)
    }
    query.Count(&recordsFiltered)
    query.Order(order + " " + direction).
        Offset(start).
        Limit(size).
        Find(&products)
    c.JSON(http.StatusOK, gin.H{"draw": c.Query("draw"), "recordsTotal": recordsTotal, "recordsFiltered": recordsFiltered, "data": products})
}

product_controller.go ??? Gin ?????? ???? Go ???????? ?? ?? API ??? ???? ?? ????? ?????. ??? ??, ?? ? ??? ?? ?? ????? ???? ???? ??? ?? ??? ???? Index ???? ?????. ? ???? ??? ??? ?? ?? ??? ????, ???????? ??? ???? ??? ????, ???? ???? ???? ?????. ???? ? ?? ?? ??? ? ?? ???? ? ??? ??? JSON ??? ???? ?? ??? ???? ???? ????? ???????? ??? ???? ???.

main.go

? ??? ??????? ?? ??????. Gin ? ??????? ???? ?????.

package main

import (
    "app/config"
    "app/router"
)

func main() {
    config.SetupDatabase()
    router.SetupRouter()
}

index.html

<!DOCTYPE html>
<head>
    <script src="https://cdn.jsdelivr.net/npm/ag-grid-community/dist/ag-grid-community.min.js"></script>
</head>
<body>
    <div>



<p>The index.html file sets up a web page that uses the AG-Grid library to display a dynamic data grid for products. It includes a grid styled with the AG-Grid theme and a JavaScript section that constructs query parameters for pagination, sorting, and filtering. The grid is configured with columns for ID, Name, and Price, and it fetches product data from an API endpoint based on user interactions. Upon loading, the grid is initialized, allowing users to view and manipulate the product list effectively.</p>

<h2>
  
  
  Run project
</h2>



<pre class="brush:php;toolbar:false">go run main.go

? ????? ?? http://localhost:8080

?? ?????. ? ??? ???? ?? ? ????.

Create an API for AG-Grid with Go

???

??? ?? ???

'??? ??' ?????? 50? ???? ??? ??? ?????. ???? 50?? ???? ???? ??? ???? 5??? 2?? ?????.

Create an API for AG-Grid with Go

?? ???

? ?? ?? ??? ?????. id ??? ?????? ???? ?? ?? ? ? ????.

Create an API for AG-Grid with Go

?? ???

'??' ??? ???? '???'? ????? ???? ?? ???? ?? ? ????.

Create an API for AG-Grid with Go

??

????? ??? AG-Grid? Go API? ????? ???? ???? ???? ??? ??? ???? ??????. Go? ??? ??? ???? AG-Grid? ??? ???, ?? ? ??? ??? ??? ? ??? ?? ??? ??? ????? ??? ??? ??????. ? ??? ??? ??? ???? ?? ??? ?????? ?? ??? ???? ?? ??? ??? ??????. AG-Grid? Go? ???? ???? ?? ??????? ??? ?? ??? ??? ??? ???? ??????.

?? ??: https://github.com/stackpuz/Example-AG-Grid-Go

? ? ?? CRUD ? ? ???: https://stackpuz.com