Golang : GORM create record or insert new record into database example
Continuing from previous tutorial on how to read record from database with GORM. This time we learn how to create or insert new record into a database.
In this example, we will insert one record with GORM and also learn how to mitigate SQL table field name with underscore.
Here you go !
package main
import (
"fmt"
_ "github.com/go-sql-driver/mysql"
"github.com/jinzhu/gorm"
"time"
)
// Activities table SQL :
// id bigint(20) AUTO_INCREMENT
// username varchar(50)
// created_on timestamp
// action char(1)
// description varchar(300)
// visibility char(1)
// NOTE : In the struct, CreatedOn will be translated into created_on in sql level
type Activities struct {
Id int `sql:"AUTO_INCREMENT"`
Username string `sql:"varchar(50);unique"`
CreatedOn time.Time `sql:"timestamp"`
Action string `sql:"type:char(1)"`
Description string `sql:"type:varchar(300)"`
Visibility string `sql:"type:char(1)"`
}
func main() {
dbConn, err := gorm.Open("mysql", "Username:Password@tcp(xxx.xxx.xxx.xxx:3306)/databasename?charset=utf8&parseTime=true")
if err != nil {
fmt.Println(err)
}
dbConn.DB()
dbConn.DB().Ping()
dbConn.DB().SetMaxIdleConns(10)
dbConn.DB().SetMaxOpenConns(100)
// omit/skip field with auto increment and those with blank/nil/empty data
activity := Activities{
Username: "testuser",
CreatedOn: time.Now().Local(),
Description: "Testing",
Visibility: "S",
}
dbConn.Create(&activity)
// Get the last record
dbConn.Last(&activity)
fmt.Println(activity)
}
NOTE : Without the &parseTime=true
parameter in the dbConn configuration. The GORM driver will have problem reading(scanning) and translating the SQL timestamp.
References :
See also : Golang : GORM read from database example
By Adam Ng
IF you gain some knowledge or the information here solved your programming problem. Please consider donating to the less fortunate or some charities that you like. Apart from donation, planting trees, volunteering or reducing your carbon footprint will be great too.
Advertisement
Tutorials
+9.5k Golang : Fix - does not implement sort.Interface (missing Len method)
+7.3k Golang : On lambda, anonymous, inline functions and function literals
+6.6k Golang : How to execute code at certain day, hour and minute?
+29.6k Golang : Convert an image file to []byte
+4.8k PHP : How to handle URI or URL with non-ASCII characters such as Chinese/Japanese/Korean(CJK) ?
+13.8k Golang : How to login and logout with JWT example
+9.3k Golang : Generate random integer or float number
+7.5k Golang : Gaussian blur on image and camera video feed examples
+50.4k Golang : How to get time in milliseconds?
+7.3k Golang : Add text to image and get OpenCV's X, Y co-ordinates example
+10.6k Golang : Pagination with go-paginator configuration example
+8.1k Golang : does not implement flag.Value (missing Set method)