Models.cs

// auto-generated by sqlc - do not edit
using NodaTime;
using NodaTime.Extensions;
using System;
using System.Collections.Generic;
using System.Data.Common;
using System.Linq;
using System.Text.Json;

namespace MySqlConnectorExampleGen;
public readonly record struct Author(long Id, string Name, string? Bio);
public readonly record struct Book(long Id, string Name, long AuthorId, string? Description);
public readonly record struct MysqlNumericType(bool? CBool, bool? CBoolean, short? CTinyint, short? CSmallint, int? CMediumint, int? CInt, int? CInteger, long? CBigint, double? CFloat, decimal? CDecimal, decimal? CDec, decimal? CNumeric, decimal? CFixed, double? CDouble, double? CDoublePrecision);
public readonly record struct MysqlStringType(string? CChar, string? CNchar, string? CNationalChar, string? CVarchar, string? CTinytext, string? CMediumtext, string? CText, string? CLongtext, JsonElement? CJson, JsonElement? CJsonStringOverride, MysqlStringTypesCEnum? CEnum, HashSet<MysqlStringTypesCSet>? CSet);
public readonly record struct MysqlDatetimeType(short? CYear, DateTime? CDate, DateTime? CDatetime, DateTime? CTimestamp, TimeSpan? CTime, DateTime? CTimestampNodaInstantOverride);
public readonly record struct MysqlBinaryType(byte? CBit, byte[]? CBinary, byte[]? CVarbinary, byte[]? CTinyblob, byte[]? CBlob, byte[]? CMediumblob, byte[]? CLongblob);
public readonly record struct ExtendedBio(string? AuthorName, string? Name, BiosBioType? BioType, HashSet<BiosAuthorType>? AuthorType);
public enum BiosBioType
{
    Invalid = 0, // reserved for invalid enum value
    Autobiography = 1,
    Biography = 2,
    Memoir = 3
}

public static class BiosBioTypeExtensions
{
    private static readonly Dictionary<string, BiosBioType> StringToEnum = new Dictionary<string, BiosBioType>()
    {
        [string.Empty] = BiosBioType.Invalid,
        ["Autobiography"] = BiosBioType.Autobiography,
        ["Biography"] = BiosBioType.Biography,
        ["Memoir"] = BiosBioType.Memoir
    };
    public static BiosBioType ToBiosBioType(this string me)
    {
        return StringToEnum[me];
    }

    public static HashSet<BiosBioType> ToBiosBioTypeSet(this string me)
    {
        return new HashSet<BiosBioType>(me.Split(',').ToList().Select(v => StringToEnum[v]));
    }
}

public enum BiosAuthorType
{
    Invalid = 0, // reserved for invalid enum value
    Author = 1,
    Editor = 2,
    Translator = 3
}

public static class BiosAuthorTypeExtensions
{
    private static readonly Dictionary<string, BiosAuthorType> StringToEnum = new Dictionary<string, BiosAuthorType>()
    {
        [string.Empty] = BiosAuthorType.Invalid,
        ["Author"] = BiosAuthorType.Author,
        ["Editor"] = BiosAuthorType.Editor,
        ["Translator"] = BiosAuthorType.Translator
    };
    public static BiosAuthorType ToBiosAuthorType(this string me)
    {
        return StringToEnum[me];
    }

    public static HashSet<BiosAuthorType> ToBiosAuthorTypeSet(this string me)
    {
        return new HashSet<BiosAuthorType>(me.Split(',').ToList().Select(v => StringToEnum[v]));
    }
}

public enum MysqlStringTypesCEnum
{
    Invalid = 0, // reserved for invalid enum value
    Small = 1,
    Medium = 2,
    Big = 3
}

public static class MysqlStringTypesCEnumExtensions
{
    private static readonly Dictionary<string, MysqlStringTypesCEnum> StringToEnum = new Dictionary<string, MysqlStringTypesCEnum>()
    {
        [string.Empty] = MysqlStringTypesCEnum.Invalid,
        ["small"] = MysqlStringTypesCEnum.Small,
        ["medium"] = MysqlStringTypesCEnum.Medium,
        ["big"] = MysqlStringTypesCEnum.Big
    };
    public static MysqlStringTypesCEnum ToMysqlStringTypesCEnum(this string me)
    {
        return StringToEnum[me];
    }

    public static HashSet<MysqlStringTypesCEnum> ToMysqlStringTypesCEnumSet(this string me)
    {
        return new HashSet<MysqlStringTypesCEnum>(me.Split(',').ToList().Select(v => StringToEnum[v]));
    }
}

public enum MysqlStringTypesCSet
{
    Invalid = 0, // reserved for invalid enum value
    Tea = 1,
    Coffee = 2,
    Milk = 3
}

public static class MysqlStringTypesCSetExtensions
{
    private static readonly Dictionary<string, MysqlStringTypesCSet> StringToEnum = new Dictionary<string, MysqlStringTypesCSet>()
    {
        [string.Empty] = MysqlStringTypesCSet.Invalid,
        ["tea"] = MysqlStringTypesCSet.Tea,
        ["coffee"] = MysqlStringTypesCSet.Coffee,
        ["milk"] = MysqlStringTypesCSet.Milk
    };
    public static MysqlStringTypesCSet ToMysqlStringTypesCSet(this string me)
    {
        return StringToEnum[me];
    }

    public static HashSet<MysqlStringTypesCSet> ToMysqlStringTypesCSetSet(this string me)
    {
        return new HashSet<MysqlStringTypesCSet>(me.Split(',').ToList().Select(v => StringToEnum[v]));
    }
}