search

fknx / linqpad-postgresql-driver

LINQPad PostgreSQL Driver
MIT License
43 stars 17 forks source link

ENUM Types not supported #28

Open DigitalZilla opened 6 years ago

DigitalZilla commented 6 years ago

Our pgSQL DB is using ENUM types but those are showing up as unsupported which prevents us from querying against them.

I'm not sure if this is a Linqpad issue, or an issue with this driver, but if it is an issue with the driver, is there any chance of this feature being added/supported?

CREATE TYPE IntakeType AS ENUM ('Floor', 'Exchange', 'Own Switch', 'Opponent Switch', 'Power Cube Zone', 'Portal', 'Preload')
CREATE TYPE OuttakeType AS ENUM ('Floor', 'Exchange', 'Own Switch', 'Opponent Switch', 'Scale')
CREATE TYPE CubeManipulationQuality AS ENUM ('Poor', 'Average', 'Excellent')

...

CREATE TABLE Cubes (
    ID serial PRIMARY KEY,
    teamMatchID serial NOT NULL REFERENCES TeamMatches,

    durringAuto boolean NOT null,
    index integer NOT NULL,

    intakeTimestamp timestamp NOT NULL,
    intakeType IntakeType NOT NULL,
    intakeQuality CubeManipulationQuality NOT NULL,

    outtakeTimestamp timestamp NOT NULL,
    outtakeType OuttakeType NOT NULL,
    outtakeQuality CubeManipulationQuality NOT NULL,
    outtakeSuccess boolean NULL -- Floor-False == dropped cube
);

image