Golang : GORM create record or insert new record into database example



Tags : golang insert-create-record gorm mysql mariadb

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 :

https://github.com/jinzhu/gorm#create-record

  See also : Golang : GORM read from database example



Tags : golang insert-create-record gorm mysql mariadb

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