func (r *RoleMappingRepo) UpdateByID(id int, roleMapping *domain.RoleMapping,
context usecases.QueryContext) (*domain.RoleMapping, error) {
query, err := r.store.BuildQuery(context.Filter, context.OwnerRelations)
if err != nil {
return nil, internalerrors.DatabaseError
}
dbName := utils.ToDBName("roleMappings")
oldRoleMapping := &domain.RoleMapping{}
err = query.Where(dbName+".id = ?", id).First(oldRoleMapping).Error
if err != nil {
if strings.Contains(err.Error(), "record not found") {
return nil, internalerrors.NotFound
}
return nil, internalerrors.DatabaseError
}
roleMapping.ID = oldRoleMapping.ID
roleMapping.CreatedAt = oldRoleMapping.CreatedAt
err = r.store.GetDB().Save(&roleMapping).Error
if err != nil {
if strings.Contains(err.Error(), "constraint") {
return nil, internalerrors.NewViolatedConstraint(err.Error())
}
return nil, internalerrors.DatabaseError
}
return roleMapping, nil
}
func (r *AccountRepo) UpdateByID(id int, account *domain.Account,
context usecases.QueryContext) (*domain.Account, error) {
query, err := r.store.BuildQuery(context.Filter, context.OwnerRelations)
if err != nil {
return nil, internalerrors.DatabaseError
}
dbName := utils.ToDBName("accounts")
oldAccount := &domain.Account{}
err = query.Where(dbName+".id = ?", id).First(oldAccount).Error
if err != nil {
if strings.Contains(err.Error(), "record not found") {
return nil, internalerrors.NotFound
}
return nil, internalerrors.DatabaseError
}
account.ID = oldAccount.ID
account.CreatedAt = oldAccount.CreatedAt
err = r.store.GetDB().Save(&account).Error
if err != nil {
if strings.Contains(err.Error(), "constraint") {
return nil, internalerrors.NewViolatedConstraint(err.Error())
}
return nil, internalerrors.DatabaseError
}
return account, nil
}
func (r *UserRepo) UpdateAttributesByID(id int, attributes map[string]interface{},
context usecases.QueryContext) (*domain.User, error) {
query, err := r.store.BuildQuery(context.Filter, context.OwnerRelations)
if err != nil {
return nil, internalerrors.DatabaseError
}
dbName := utils.ToDBName("users")
user := &domain.User{}
err = query.Where(dbName+".id = ?", id).First(user).Error
if err != nil {
if strings.Contains(err.Error(), "record not found") {
return nil, internalerrors.NotFound
}
return nil, internalerrors.DatabaseError
}
err = r.store.GetDB().Model(&user).Updates(attributes).Error
if err != nil {
if strings.Contains(err.Error(), "constraint") {
return nil, internalerrors.NewViolatedConstraint(err.Error())
}
return nil, internalerrors.DatabaseError
}
return user, nil
}
func (r *SessionRepo) UpdateByID(id int, session *domain.Session,
context usecases.QueryContext) (*domain.Session, error) {
query, err := r.store.BuildQuery(context.Filter, context.OwnerRelations)
if err != nil {
return nil, internalerrors.DatabaseError
}
dbName := utils.ToDBName("sessions")
err = query.Where(dbName+".id = ?", id).First(&domain.Session{}).Error
if err != nil {
if strings.Contains(err.Error(), "record not found") {
return nil, internalerrors.NotFound
}
return nil, internalerrors.DatabaseError
}
err = r.store.GetDB().Where(dbName+".id = ?", id).Model(&domain.Session{}).Updates(&session).Error
if err != nil {
if strings.Contains(err.Error(), "constraint") {
return nil, internalerrors.NewViolatedConstraint(err.Error())
}
return nil, internalerrors.DatabaseError
}
return session, nil
}
func (r *AccountRepo) Raw(query string, values ...interface{}) (*sql.Rows, error) {
db := r.store.GetDB()
rows, err := db.Raw(query, values...).Rows()
if err != nil {
if strings.Contains(err.Error(), "constraint") {
return nil, internalerrors.NewViolatedConstraint(err.Error())
}
return nil, internalerrors.DatabaseError
}
return rows, nil
}
func (r *AccountRepo) Update(accounts []domain.Account, context usecases.QueryContext) ([]domain.Account, error) {
db := r.store.GetDB()
transaction := db.Begin()
query, err := r.store.BuildQuery(context.Filter, context.OwnerRelations)
if err != nil {
return nil, internalerrors.DatabaseError
}
for _, account := range accounts {
queryCopy := *query
dbName := utils.ToDBName("accounts")
oldAccount := &domain.Account{}
err = queryCopy.Where(dbName+".id = ?", account.ID).First(oldAccount).Error
if err != nil {
if strings.Contains(err.Error(), "record not found") {
return nil, internalerrors.NotFound
}
return nil, internalerrors.DatabaseError
}
account.ID = oldAccount.ID
account.CreatedAt = oldAccount.CreatedAt
err = r.store.GetDB().Save(&account).Error
if err != nil {
if strings.Contains(err.Error(), "constraint") {
return nil, internalerrors.NewViolatedConstraint(err.Error())
}
return nil, internalerrors.DatabaseError
}
}
transaction.Commit()
return accounts, nil
}
func (r *RoleMappingRepo) Update(roleMappings []domain.RoleMapping, context usecases.QueryContext) ([]domain.RoleMapping, error) {
db := r.store.GetDB()
transaction := db.Begin()
query, err := r.store.BuildQuery(context.Filter, context.OwnerRelations)
if err != nil {
return nil, internalerrors.DatabaseError
}
for _, roleMapping := range roleMappings {
queryCopy := *query
dbName := utils.ToDBName("roleMappings")
oldRoleMapping := &domain.RoleMapping{}
err = queryCopy.Where(dbName+".id = ?", roleMapping.ID).First(oldRoleMapping).Error
if err != nil {
if strings.Contains(err.Error(), "record not found") {
return nil, internalerrors.NotFound
}
return nil, internalerrors.DatabaseError
}
roleMapping.ID = oldRoleMapping.ID
roleMapping.CreatedAt = oldRoleMapping.CreatedAt
err = r.store.GetDB().Save(&roleMapping).Error
if err != nil {
if strings.Contains(err.Error(), "constraint") {
return nil, internalerrors.NewViolatedConstraint(err.Error())
}
return nil, internalerrors.DatabaseError
}
}
transaction.Commit()
return roleMappings, nil
}
func (r *AccountRepo) Create(accounts []domain.Account) ([]domain.Account, error) {
db := r.store.GetDB()
transaction := db.Begin()
for i, account := range accounts {
err := db.Create(&account).Error
if err != nil {
transaction.Rollback()
if strings.Contains(err.Error(), "constraint") {
return nil, internalerrors.NewViolatedConstraint(err.Error())
}
return nil, internalerrors.DatabaseError
}
accounts[i] = account
}
transaction.Commit()
return accounts, nil
}
func (r *UserRepo) Create(users []domain.User) ([]domain.User, error) {
db := r.store.GetDB()
transaction := db.Begin()
for i, user := range users {
err := db.Create(&user).Error
if err != nil {
transaction.Rollback()
if strings.Contains(err.Error(), "constraint") {
return nil, internalerrors.NewViolatedConstraint(err.Error())
}
return nil, internalerrors.DatabaseError
}
users[i] = user
}
transaction.Commit()
return users, nil
}
func (r *RoleRepo) Create(roles []domain.Role) ([]domain.Role, error) {
db := r.store.GetDB()
transaction := db.Begin()
for i, role := range roles {
err := db.Create(&role).Error
if err != nil {
transaction.Rollback()
if strings.Contains(err.Error(), "constraint") {
return nil, internalerrors.NewViolatedConstraint(err.Error())
}
return nil, internalerrors.DatabaseError
}
roles[i] = role
}
transaction.Commit()
return roles, nil
}
func (r *SessionRepo) Create(sessions []domain.Session) ([]domain.Session, error) {
db := r.store.GetDB()
transaction := db.Begin()
for i, session := range sessions {
err := db.Create(&session).Error
if err != nil {
transaction.Rollback()
if strings.Contains(err.Error(), "constraint") {
return nil, internalerrors.NewViolatedConstraint(err.Error())
}
return nil, internalerrors.DatabaseError
}
sessions[i] = session
}
transaction.Commit()
return sessions, nil
}
func (r *SessionRepo) Update(sessions []domain.Session, context usecases.QueryContext) ([]domain.Session, error) {
db := r.store.GetDB()
transaction := db.Begin()
query, err := r.store.BuildQuery(context.Filter, context.OwnerRelations)
if err != nil {
return nil, internalerrors.DatabaseError
}
for _, session := range sessions {
queryCopy := *query
dbName := utils.ToDBName("sessions")
err = queryCopy.Where(dbName+".id = ?", session.ID).First(&domain.Session{}).Error
if err != nil {
if strings.Contains(err.Error(), "record not found") {
return nil, internalerrors.NotFound
}
return nil, internalerrors.DatabaseError
}
err = r.store.GetDB().Where(dbName+".id = ?", session.ID).Model(&domain.Session{}).Updates(&session).Error
if err != nil {
if strings.Contains(err.Error(), "constraint") {
return nil, internalerrors.NewViolatedConstraint(err.Error())
}
return nil, internalerrors.DatabaseError
}
}
transaction.Commit()
return sessions, nil
}