Request support ENUM list for SQL Check function about enumer HOT 5 CLOSED

Hi! Thank you very much for filling the issue.
Just wanted to let you know that I've been very busy this year, but now I'm starting to have time again. So I expect to have time to review this soon 😉

from enumer.

from enumer.

I haven't had the time to check your master branch but, from the top of my mind, this is what I think:

• I would like to avoid adding things that are specific to certain projects or areas (other than "Enums"), as it would complicate a lot its maintenance and reusability.
• After reading your issue, I think that what you are looking for is something like the enum.values() method in Java which returns an array with all the values of the enum. I think this is a good addition, as it is general and tightly coupled with Enums (and nothing else).

So you could call the values() method and do what you want with the array of values, like converting them to strings and joining the values together as a comma-separated list.

Let's see if I can buy some extra time and add this method 😉

from enumer.

from enumer.

The new version of enumer has some additions that can be used to achieve this.
Your example would be like this (not checked):

// Assuming the enum is called UserTypes
func GetUser() interface{} {
    userTypesString := strings.Trim(strings.Replace(fmt.Sprint(UserTypesValues()), " ", "','", -1), "[]")
    return db.Exec(fmt.Sprintf(`
        SELECT * 
        FROM USERS 
        WHERE 
            USERNAME=$1 
        AND 
        TYPE IN ('%s')`, userTypesString), username)
}

Thanks for your feedback and code!

from enumer.