Auto-conform your enums types that you want to store in MySQL to `MySQLDataConvertible` and `ReflectionDecodable`. Avoids a lot of boilerplate!

1-MySQLDataConvertibleEnum.swift

/* NOTE: check out 3-MySQLDataConvertibleEnum_Better_Version.swift. */

import Fluent
import FluentMySQL
import Vapor

protocol MySQLDataConvertibleEnum: MySQLDataConvertible, ReflectionDecodable, CaseIterable { }

extension MySQLDataConvertibleEnum where Self: RawRepresentable, Self.RawValue == String {
    func convertToMySQLData() -> MySQLData {
        return MySQLData(string: self.rawValue)
    }

    static func convertFromMySQLData(_ mysqlData: MySQLData) throws -> Self {
        guard let val = Self(rawValue: mysqlData.string()) else {
            throw Abort(.internalServerError, reason: "Could not convert MySQLData to `\(String(reflecting: type(of: self)))`")
        }
        return val
    }
}

extension MySQLDataConvertibleEnum where Self: RawRepresentable, Self: CaseIterable, Self.RawValue == String {
    static func reflectDecoded() throws -> (Self, Self) {
        let cases = Array(Self.allCases)
        assert(cases.count >= 2, "[MySQLDataConvertibleEnum] In order to use the default extensions, your enum `\(String(reflecting: type(of: self)))` has to have at least two cases!")
        return (cases[0], cases[1])
    }
}

extension RawRepresentable {
    init?(rawValue: RawValue?) {
        guard
            let rawValue = rawValue,
            let val = Self.init(rawValue: rawValue)
        else {
            return nil
        }
        self = val
    }
}

2-Example.swift

enum ArticleStatus: String, Content, CaseIterable {
  case published
  case scheduled
  case unpublished
}

extension ArticleStatus: MySQLDataConvertibleEnum {} // <- This is all you need

3-MySQLDataConvertibleEnum_Better_Version.swift

import Fluent
import FluentMySQL
import Vapor

protocol MySQLDataConvertibleEnum: MySQLEnumType, CaseIterable { }

extension MySQLDataConvertibleEnum where Self: RawRepresentable, Self: CaseIterable, Self.RawValue == String {
    static func reflectDecoded() throws -> (Self, Self) {
        let cases = Array(Self.allCases)
        assert(cases.count >= 2, "[MySQLDataConvertibleEnum] In order to use the default extensions, your enum `\(String(reflecting: type(of: self)))` has to have at least two cases!")
        return (cases[0], cases[1])
    }
}