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
+6.8k Golang : Use modern ciphers only in secure connection
+7k Golang : Not able to grep log.Println() output
+11.9k Golang : Flush and close file created by os.Create and bufio.NewWriter example
+9.8k Golang : Get login name from environment and prompt for password
+13.9k Golang : How to pass map to html template and access the map's elements
+21.6k Golang : Join arrays or slices example
+10.2k Golang : Allow Cross-Origin Resource Sharing request
+10.7k Golang : Read until certain character to break for loop
+8.7k Golang : Capture text return from exec function example
+21.2k Golang : Convert string slice to struct and access with reflect example
+9.9k Golang : Print how to use flag for your application example
+5.7k Golang : Function as an argument type example