Models.cs

// auto-generated by sqlc - do not edit
namespace NpgsqlDapperLegacyExampleGen
{
    using NodaTime;
    using NodaTime.Extensions;
    using NpgsqlTypes;
    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Net;
    using System.Net.NetworkInformation;
    using System.Text.Json;
    using System.Xml;

    public class Author
    {
        public long Id { get; set; }
        public string Name { get; set; }
        public string Bio { get; set; }
    };
    public class Book
    {
        public Guid Id { get; set; }
        public string Name { get; set; }
        public long AuthorId { get; set; }
        public string Description { get; set; }
    };
    public class PostgresNumericType
    {
        public bool? CBoolean { get; set; }
        public byte[] CBit { get; set; }
        public short? CSmallint { get; set; }
        public int? CInteger { get; set; }
        public long? CBigint { get; set; }
        public decimal? CDecimal { get; set; }
        public decimal? CNumeric { get; set; }
        public float? CReal { get; set; }
        public double? CDoublePrecision { get; set; }
        public decimal? CMoney { get; set; }
    };
    public class PostgresStringType
    {
        public string CChar { get; set; }
        public string CVarchar { get; set; }
        public string CCharacterVarying { get; set; }
        public string CBpchar { get; set; }
        public string CText { get; set; }
    };
    public class PostgresDatetimeType
    {
        public DateTime? CDate { get; set; }
        public TimeSpan? CTime { get; set; }
        public DateTime? CTimestamp { get; set; }
        public DateTime? CTimestampWithTz { get; set; }
        public TimeSpan? CInterval { get; set; }
        public DateTime? CTimestampNodaInstantOverride { get; set; }
    };
    public class PostgresNetworkType
    {
        public NpgsqlCidr? CCidr { get; set; }
        public IPAddress CInet { get; set; }
        public PhysicalAddress CMacaddr { get; set; }
        public string CMacaddr8 { get; set; }
    };
    public class PostgresArrayType
    {
        public byte[] CBytea { get; set; }
        public bool[] CBooleanArray { get; set; }
        public string[] CTextArray { get; set; }
        public int[] CIntegerArray { get; set; }
        public decimal[] CDecimalArray { get; set; }
        public DateTime[] CDateArray { get; set; }
        public DateTime[] CTimestampArray { get; set; }
    };
    public class PostgresGeometricType
    {
        public NpgsqlPoint? CPoint { get; set; }
        public NpgsqlLine? CLine { get; set; }
        public NpgsqlLSeg? CLseg { get; set; }
        public NpgsqlBox? CBox { get; set; }
        public NpgsqlPath? CPath { get; set; }
        public NpgsqlPolygon? CPolygon { get; set; }
        public NpgsqlCircle? CCircle { get; set; }
    };
    public class PostgresSpecialType
    {
        public Guid? CUuid { get; set; }
        public CEnum? CEnum { get; set; }
        public CEnum? CQualifiedEnum { get; set; }
        public JsonElement? CJson { get; set; }
        public JsonElement? CJsonStringOverride { get; set; }
        public JsonElement? CJsonb { get; set; }
        public string CJsonpath { get; set; }
        public XmlDocument CXml { get; set; }
        public XmlDocument CXmlStringOverride { get; set; }
    };
    public class PostgresNotNullType
    {
        public CEnum CEnumNotNull { get; set; }
    };
    public class ExtendedBio
    {
        public string AuthorName { get; set; }
        public string Name { get; set; }
        public ExtendedBioType? BioType { get; set; }
    };
    public enum CEnum
    {
        Invalid = 0, // reserved for invalid enum value
        Small = 1,
        Medium = 2,
        Big = 3
    }

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

    public enum ExtendedBioType
    {
        Invalid = 0, // reserved for invalid enum value
        Autobiography = 1,
        Biography = 2,
        Memoir = 3
    }

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