Setup profile

Create in the root directory config Catalog , The directory stores some configuration files needed by the global
create profile config.ini

#  The configuration file [mysql]Db = mysqlHost = 127.0.0.1Port = 3306User = rootPwd = root#DbName = beeDbName = gochat[redis]Db = redisAddr = 127.0.0.1:6379Pwd = rootDbName = 1

Create... For parsing configuration files config.go

package configimport "gopkg.in/ini.v1"// Global profile   The pointer var ConfigFile *ini.Filefunc init(){    // download ini package     // First execution go get command , It has to be executed first ：go env -w GOSUMDB="sum.golang.google.cn    // The purpose is to modify GOSUMDB  Verify address , The default address is the wall , It will cause connection timeout     // And then execute     //go get gopkg.in/ini.v1    if file,err := ini.Load("./config/config.ini");err != nil{        panic(err)    }else{        ConfigFile = file    }}

Connect to database

Created in the root directory models Catalog , Deposit mysql Relevant operation documents
establish mysql.go

package modelsimport (    "github.com/jinzhu/gorm"    _ "github.com/jinzhu/gorm/dialects/mysql"    "project1/config"    "time")func GetMysql() *gorm.DB{    host := config.ConfigFile.Section("mysql").Key("Host").String()    user := config.ConfigFile.Section("mysql").Key("User").String()    pwd := config.ConfigFile.Section("mysql").Key("Pwd").String()    dbName := config.ConfigFile.Section("mysql").Key("DbName").String()    port := config.ConfigFile.Section("mysql").Key("Port").String()    db,err := gorm.Open("mysql",user+":"+pwd+"@tcp("+host+":"+port+")/"+dbName+"?charset=utf8mb4&parseTime=True")    if err != nil {        panic(err)    }    db.SingularTable(true)// Do not add s    db.DB().SetMaxIdleConns(20)// Number of connection pools     db.DB().SetMaxOpenConns(100)// Maximum concurrency     db.DB().SetConnMaxLifetime(time.Second*30)// Link timeout     return db    // Back to  Conn  It can only be used once  goroutine  The operation of , That is to say, you can't put this  Conn  be applied to  Go  The multiple  goroutine  Inside .    //Go  I don't know which operation is caused by  goroutine  Sponsored , This leads to a number of   According to chaos , For example, it might put  goroutineA  The result of the query operation performed inside is returned to  goroutineB  So that  B  Mistakenly regard this result as self executing insert data .}

Create data table model

gorm Operation data sheet , It's based on a struct Variable of type ,struct The attributes and types in the need to be one-to-one corresponding to the table , So you need to create two files , Equivalent to the corresponding table model, Used to declare and operate on two tables
First create two tables ,user and msg

stay models Create under folder user.go file , as follows

package models//  Introduce the required package import (    "crypto/md5"    "fmt"    "github.com/go-playground/validator/v10"    "github.com/jinzhu/gorm"    "github.com/gin-gonic/gin")// Create custom types User , Capitalization , So that the external needs to reference this type type User struct{    //gorm.Model by gorm Predefined mysql Field , It includes ,ID,CreateAt,UpdateAt,DeleteAt Four fields . Don't have to , Completely define yourself . But use gorm deleted , Unable to automatically mark soft deletion     gorm.Model    // All attributes are capitalized , Convenient for external calls     //tag It is mainly used for gorm Build table , No need to use gorm If you build a table , Don't write tag. Although the attribute is capitalized , But when creating a table, the fields will be converted to lowercase and underlined     Phone string `gorm:"size:11;not null;unique_index"`    Password string `gorm:"type:varchar(50);not null;"`    Name string `gorm:"type:varchar(30);default:'';"`}// Register new users // Can be found in api Call this method after the validation data passes //*RegisterRule by gin After the framework validation parameters pass , Created with incoming parameters RegisterRule Variable pointer of type func (user *RegisterRule) RegisterUser(){    var userModel User    var back Response    // Encrypted password     md5Pwd := md5.Sum([]byte(rule.Password+"12345"))    // md5.Sum Back to a [16]byte Array , Can't use string() Direct conversion     newPwd := fmt.Sprintf("%x",md5Pwd)    // Set the field values to be inserted into the table     userModel = User{Phone:rule.Phone,Password:newPwd,Name:rule.Name}    // Get one mysql Connect     mysql := GetMysql()    defer mysql.Close()    // insert data     if err := mysql.Create(&userModel).Error;err == nil {        back = gin.H{"status":1,"msg":" Registered successfully ","data":userModel}    }else{        back = gin.H{"status":0,"msg":err.Error()}    }    return back}// Login method func (rule *LoginRule) Login() Response{    var user User    // Encrypted password     md5Pwd := md5.Sum([]byte(rule.Password+"12345"))    newPwd := fmt.Sprintf("%x",md5Pwd)    // Query the user     mysql := GetMysql()    defer mysql.Close()    if err := mysql.Where("phone = ? AND password = ?",rule.Phone,newPwd).First(&user).Error;err == nil{        back = gin.H{"status":1,"msg":" Login successful ","data":user}    }else{        back = gin.H{"status":0,"msg":err.Error()}    }    return $back;}

Use models The method in

After defining the registration method , We are here api/user.go In file , Use models The method in , as follows

import(    ...    "project1/models")// Registration method func Register(c *gin.Context){    ...    // Perform verification reception     if err := c.ShouldBind(&registerRule);err == nil {        // Data validation succeeded , Call the registration method         res := registerRule.Register()        if res.status == 1{            c.JSON(200,res)        }else{            c.JSON(402,res)        }    }else{        c.JSON(402,err.Error())    }}// Login method // according to Register technological process , Try to establish a login method func Login(c *gin.Context){    // First in api/user.go  Define login parameter validation structure LoginRule    // Then execute in this method ShouldBind Method , Verify and get parameters     // After successful verification , call LoginRule Binding method , Method defined in models/user.go in     // According to the return status , Determine whether the login is successful and other subsequent operations }

author ：whynogome

Game programming , A game development favorite ~

If the picture is not displayed for a long time , Please use Chrome Kernel browser .