/
company.go
113 lines (96 loc) · 2.79 KB
/
company.go
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
108
109
110
111
112
113
package repository
import (
"fmt"
"github.com/hojabri/backend/models"
log "github.com/sirupsen/logrus"
"gorm.io/gorm"
"gorm.io/gorm/clause"
)
type CompanyRepository interface {
Save(company models.Company) (uint, error)
Update(models.Company) error
Delete(models.Company) error
FindAll() []*models.Company
FindByID(companyID uint) (*models.Company, error)
DeleteByID(companyID uint) error
FindByName(name string) (*models.Company, error)
FindByField(fieldName, fieldValue string) (*models.Company, error)
UpdateSingleField(company models.Company, fieldName, fieldValue string) error
}
type companyDatabase struct {
connection *gorm.DB
}
func NewCompanyRepository() CompanyRepository {
if DB == nil {
_, err = Connect()
if err != nil {
log.Error(err)
}
}
return &companyDatabase{
connection: DB,
}
}
func (db companyDatabase) DeleteByID(companyID uint) error {
company := models.Company{}
company.ID = companyID
result := db.connection.Delete(&company)
return result.Error
}
func (db companyDatabase) Save(company models.Company) (uint, error) {
result := db.connection.Create(&company)
if result.Error != nil {
return 0, result.Error
}
return company.ID, nil
}
func (db companyDatabase) Update(company models.Company) error {
result := db.connection.Save(&company)
return result.Error
}
func (db companyDatabase) Delete(company models.Company) error {
result := db.connection.Delete(&company)
return result.Error
}
func (db companyDatabase) FindAll() []*models.Company {
var companies []*models.Company
db.connection.Preload(clause.Associations).Find(&companies)
return companies
}
func (db companyDatabase) FindByID(companyID uint) (*models.Company, error) {
var company models.Company
result := db.connection.Preload(clause.Associations).Find(&company, "id = ?", companyID)
if result.Error!=nil {
return nil, result.Error
}
if result.RowsAffected > 0 {
return &company, nil
}
return nil, nil
}
func (db companyDatabase) FindByName(name string) (*models.Company, error) {
var company models.Company
result := db.connection.Preload(clause.Associations).Find(&company, "name = ?", name)
if result.Error!=nil {
return nil, result.Error
}
if result.RowsAffected > 0 {
return &company, nil
}
return nil, nil
}
func (db companyDatabase) FindByField(fieldName, fieldValue string) (*models.Company, error) {
var company models.Company
result := db.connection.Preload(clause.Associations).Find(&company, fmt.Sprintf("%s = ?", fieldName) ,fieldValue)
if result.Error!=nil {
return nil, result.Error
}
if result.RowsAffected > 0 {
return &company, nil
}
return nil, nil
}
func (db companyDatabase) UpdateSingleField(company models.Company, fieldName, fieldValue string) error {
result := db.connection.Model(&company).Update(fieldName, fieldValue)
return result.Error
}