Arquivo da categoria: PostgreSQL

Gerar coluna de transporte

SELECT
        '[DataColum(ColumnName = "' || COLUMN_NAME || '")]' || chr(13) ||
        'public ' ||
        CASE DATA_TYPE
            WHEN 'uuid' THEN 'Nullable<Guid>'
            WHEN 'character varying' THEN 'string'
            WHEN 'boolean' THEN 'Nullable<bool>'
            WHEN 'timestamp without time zone' THEN 'Nullable<DateTimeOffset>'
            WHEN 'timestamp' THEN 'Nullable<DateTime>'
            WHEN 'integer' THEN 'Nullable<int>'
            WHEN 'smallint' THEN 'Nullable<short>'
            WHEN 'date' THEN 'Nullable<DateTime>'
            WHEN 'money' THEN 'Nullable<decimal>'
            ELSE 'Nullable<>'
        END
        ||' ' || REPLACE(COLUMN_NAME,'_','') || ' { get; set; }' || chr(13) || chr(13)
FROM
        information_schema.columns
WHERE
        TABLE_NAME='Fluxo_Caixa'
ORDER BY
        ordinal_position;