Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
package mssqlservercrudoperations
import (
"golangtemplate/servers/app/models"
"corelab.mkcl.org/MKCLOS/coredevelopmentplatform/corepkgv2/dalmdl/sqlserver"
"github.com/gin-gonic/gin"
)
func ReadDataFromMSSQLServer(c *gin.Context) {
//get default connection
sqlServerDAO := sqlserver.GetSQLServerDAO()
//You can use also use below method for connection, if you want use database other than default db
// sqlServerDAO := sqlserver.GetSQLServerDAOWithHost("SQLServerHostDummy")
employees, err := sqlServerDAO.SelectQuery("select * from Employees")
if err != nil {
c.JSON(500, gin.H{
"error": err.Error(),
})
}
c.JSON(200, gin.H{
"employees": employees.Value(),
})
}
func WriteDataToMSSQLServer(c *gin.Context) {
var emp models.Employee
if err := c.Bind(&emp) != nil; err {
c.JSON(400, gin.H{
"error": err,
})
}
sqlServerDAO := sqlserver.GetSQLServerDAO()
_, err := sqlServerDAO.ExecQuery("insert into Employees values (?,?)", emp.Name, emp.Location)
if err != nil {
c.JSON(500, gin.H{
"error": err.Error(),
})
}
employees, err := sqlServerDAO.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 UpdateMSSQLServerData(c *gin.Context) {
var emp models.Employee
if err := c.Bind(&emp) != nil; err {
c.JSON(400, gin.H{
"error": err,
})
}
sqlServerDAO := sqlserver.GetSQLServerDAO()
_, err := sqlServerDAO.ExecQuery("update Employees set location=? where name=?", emp.Location, emp.Name)
if err != nil {
c.JSON(500, gin.H{
"error": err.Error(),
})
}
employees, err := sqlServerDAO.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 DeleteDataFromMSSQLServer(c *gin.Context) {
var emp models.Employee
if err := c.Bind(&emp) != nil; err {
c.JSON(400, gin.H{
"error": err,
})
}
sqlServerDAO := sqlserver.GetSQLServerDAO()
_, err := sqlServerDAO.ExecQuery("delete from Employees where name=?", emp.Name)
if err != nil {
c.JSON(500, gin.H{
"error": err.Error(),
})
}
employees, err := sqlServerDAO.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(),
})
}