How can I input data into a mysql model from an array in GO?

Question

So, I'm working on this mysql model Using GO and GORM where the user can input their data

`package table

import (
    //"gorm.io/driver/mysql"
    "gorm.io/gorm"
)

var Department = []string{"Computer Science", "Engineering", "Medical Science"}

type Account struct {
    gorm.Model
    Accountname  string `json:"name"`    //AccountName
    AccontNumber int64  ` json:"number"` //AccountNumber        Text(40)
   //need users to select one of the values from the Department Array
}`

I want my user to select a value from the ones provided in the Department array and store it in my table, how can I go about doing it?

you can try gorm:"type:enum('published', 'pending', 'deleted');default:'pending'" — Chandan
– Chandan, Commented May 17, 2022 at 13:50

aaronlukacs · Accepted Answer · 2022-05-19 07:03:00Z

2

You can define a custom string type for departments, but you still will have to explicitly check that the user provided string is correct:

type DepartmentName string

const (
    DepartmentComputerScience DepartmentName "Computer Science"
    DepartmentNameEngineering DepartmentName "Engineering"
    DepartmentNameMedicalScience DepartmentName "Medical Science"

)
var DepartmentsMap = map[DepartmentName]bool{
    DepartmentComputerScience: true, 
    DepartmentNameEngineering: true, 
    DepartmentNameMedicalScience: true,
}


type Account struct {
    gorm.Model
    Accountname  string         `json:"name"`    //AccountName
    AccontNumber int64          ` json:"number"` //AccountNumber        Text(40)
    Department   DepartmentName `json:"department"`
}

func (d DepartmentName) Valid() error {
    if _, ok := DepartmentsMap[d]; ok {
        return nil
    }
    return errors.New("invalid department")
}

edited May 19, 2022 at 7:03

answered May 17, 2022 at 9:03

aaronlukacs

4893 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

aaronlukacs Over a year ago

i made a syntax error, you should access the element from the map like DepartmentsMap[d] instead of the (). i edited my answer.

Collectives™ on Stack Overflow

How can I input data into a mysql model from an array in GO?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related