第十一篇:练习-新增数据、封装DB初步、结合Gin实现查询API

一:模型数据

type Topics struct {
	TopicID int `json:"id" gorm:"PRIMARY_KEY"`
	TopicTitle string `json:"title" binding:"min=4,max=10"`
	TopicShortTitle string `json:"stitle" binding:"required,nefield=TopicTitle"`
	UserIp string `json:"ip" binding:"ipv4"`
	TopicScore int `json:"score" binding:"omitempty,gt=5"`
	TopicUrl string `json:"url" binding:"omitempty,topicurl"`
	TopicDate time.Time `json:"url" binding:"required"`
}

 二:main 函数代码

package main

import (
	"fmt"
	_ "github.com/go-sql-driver/mysql"
	"github.com/jinzhu/gorm"
	"time"
	."topic.pizixu.com/src"
)

func main() {
	db,_:= gorm.Open("mysql", "root:root@tcp(localhost:3306)" +
		"/gin?charset=utf8mb4&parseTime=True&loc=Local")
	db.LogMode(true)
	db.SingularTable(true)
	defer db.Close()
	topics:=Topics{
		TopicTitle:"TopicTitle",
		TopicShortTitle:"TopicShortTitle",
		UserIp:"127.0.0.1",
		TopicScore:0,TopicUrl:"testurl",
		TopicDate:time.Now(),
	}
	fmt.Println(db.Create(&topics).RowsAffected)
	fmt.Println(topics.TopicID)
}

 三:db 初始化封装

 

方法: