Using ENUM type

[volatiletech]

Using ENUM type

[aarondl]

Hey there,

So first off let me explain that we don't have proper enum support currently. The next thing to say is that you can still use sqlboiler and enums as strings, since this is how the driver works internally anyway, the only problem is that you can't run the compatibility tests since the randomize package doesn't understand the valid values for your enum type.

What we're going to do is the following:

• Support enum types in the bdb/drivers package by encoding enums like so: enum('val1','val2')
• Generate constants (if all enum values conform to a Go identifier-safe regex) in the model that:
  • For postgresql will look like: DatatypeValue (eg. WorkdayMonday)
  • For mysql will look like: TablenameColumnnameValue (eg. EventDayMonday)
  • Will be camelcased if and only if the value is all lowercase in the database, otherwise casing is untouched
• Support enum types in the randomize package by choosing a random value from the above encoding

If this sounds okay to you then we can start work on this.

One more thing, the TestUpsert is failing in a way I don't expect, is it possible that you can run that test in isolation along with debug mode? We may have a bug here.

go test -v -run 'TestUpsert/Events' ./models -test.debug

[aarondl]

https://github.com/vattle/sqlboiler/releases/tag/v2.1.0

[aarondl]

Check docs for more information on this new feature.