-
Somnath Ghorpade authored13d37c25
mysqlcrudoperations.go 2.30 KiB
package mysqlcrudoperation
import (
"golangtemplate/servers/app/models"
"corelab.mkcl.org/MKCLOS/coredevelopmentplatform/corepkgv2/dalmdl/mysql"
"github.com/gin-gonic/gin"
)
func ReadDataFromMySql(c *gin.Context) {
//get default connection
mysqlDAO := mysql.GetMySQLDAO()
//You can use also use below method for connection, if you want use database other than default db
// mysqlDAO := mysql.GetMySQLDAOWithHost("MySQLHostDummy")
employees, err := mysqlDAO.SelectQuery("select * from Employees")
if err != nil {
c.JSON(500, gin.H{
"error": err.Error(),
})
}
c.JSON(200, gin.H{
"employees": employees.Value(),
})
}
func WriteDataToMySql(c *gin.Context) {
var emp models.Employee
if err := c.Bind(&emp) != nil; err {
c.JSON(400, gin.H{
"error": err,
})
}
mysqlDAO := mysql.GetMySQLDAO()
_, err := mysqlDAO.ExecQuery("insert into Employees values (?,?)", emp.Name, emp.Location)
if err != nil {
c.JSON(500, gin.H{
"error": err.Error(),
})
}
employees, err := mysqlDAO.SelectQuery("select * from Employees")
if err != nil {
c.JSON(500, gin.H{
"error": err.Error(),
})
}
c.JSON(200, gin.H{
"status": "inserted",
"employees": employees.Value(),
})
}
func UpdateMySqlData(c *gin.Context) {
var emp models.Employee
if err := c.Bind(&emp) != nil; err {
c.JSON(400, gin.H{
"error": err,
})
}
mysqlDAO := mysql.GetMySQLDAO()
_, err := mysqlDAO.ExecQuery("update Employees set location=? where name=?", emp.Location, emp.Name)
if err != nil {
c.JSON(500, gin.H{
"error": err.Error(),
})
}
7172737475767778798081828384858687888990919293949596979899100101102103104105106107108
employees, err := mysqlDAO.SelectQuery("select * from Employees")
if err != nil {
c.JSON(500, gin.H{
"error": err.Error(),
})
}
c.JSON(200, gin.H{
"status": "Updated",
"employees": employees.Value(),
})
}
func DeleteDataFromMySql(c *gin.Context) {
var emp models.Employee
if err := c.Bind(&emp) != nil; err {
c.JSON(400, gin.H{
"error": err,
})
}
mysqlDAO := mysql.GetMySQLDAO()
_, err := mysqlDAO.ExecQuery("delete from Employees where name=?", emp.Name)
if err != nil {
c.JSON(500, gin.H{
"error": err.Error(),
})
}
employees, err := mysqlDAO.SelectQuery("select * from Employees")
if err != nil {
c.JSON(500, gin.H{
"error": err.Error(),
})
}
c.JSON(200, gin.H{
"status": "DELETED",
"employees": employees.Value(),
})
}