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
+3.2k Javascript : Empty an array example
+25.1k Golang : Encrypt and decrypt data with AES crypto
+18.2k Golang : Compare floating-point numbers
+12.9k Golang : Check if a file exist or not
+7.8k Golang : Get final balance from bit coin address example
+6.2k Golang : Process json data with Jason package
+5.1k Golang : Get missing location after unmarshal binary and gob decode time.
+3.7k Golang : How to pass data between controllers with JSON Web Token
+19k Golang : Secure(TLS) connection between server and client
+14.9k Golang : Get file permission
+11.6k Golang : Convert int(year) to time.Time type
+6.9k Golang : Handle Palindrome string with case sensitivity and unicode