How can i get mask from Inet field type

[RrredHead]

I have a project with table configured like that

generator client {
    provider        = "prisma-client-js"
    previewFeatures = ["metrics"]
}

datasource db {
    provider = "postgresql"
    url      = env("DATABASE_URL")
}

// ...

model IP {
    id          Int      @id @default(autoincrement())
    address     String   @unique @db.Inet
    description String   @default("")
    updatedAt   DateTime @updatedAt
}

Which gives me table as I expected (DDL as example):

CREATE TABLE public."IP" (
	id serial4 NOT NULL,
	description text NOT NULL DEFAULT ''::text,
	"updatedAt" timestamp(3) NOT NULL,
	address inet NOT NULL,
	CONSTRAINT "IP_pkey" PRIMARY KEY (id)
);
CREATE UNIQUE INDEX "IP_address_key" ON public."IP" USING btree (address);

In this table I have only one record (for test purposes):

Also I have a route, which should just return every records stored in IP table

const ips = await prisma.iP.findMany();
return ips;

As a result it gives:

[
  {
    "id": 2,
    "description": "Localhost",
    "updatedAt": "2023-02-13T14:05:04.121Z",
    "address": "127.0.0.0"
  }
]

Everything is nearly correct, but there is no mask in address field. In this case I'm expecting "address": "127.0.0.0/16" as it stored in Data Base. How can i achieve the expected behavior?

[ludralph]

Hi @RrredHead 👋

This looks like the default behavior of the database. You can see a reference here

If you want to include the mask, you might want to consider using the net functions, but then you would need to utilize raw queries within Prisma.

[RrredHead]

Hi @ludralph!

Here are some quotes from this section of reference

If the netmask is 32 and the address is IPv4, then the value does not indicate a subnet, only a single host.

and

On display, the /y portion is suppressed if the netmask specifies a single host.

But as you can see in my example, the netmask is /16, so it should be in the output, if no functions applied to address field.

Actually it looks like function host applied under the hood of prisma (look at Table 9-32 here in reference).

[RrredHead]

OK, I've found one workaround:

async function findIPs() {
    const result = await prisma.$queryRaw<
        IP[]
    >`SELECT id, description, "updatedAt", text(address) as address FROM public."IP"`;
    return result;
}

// ... later in route handler

const ips = await findIPs();
return ips;

This gives me output as I expected:

[
  {
    "id": 2,
    "description": "Localhost",
    "updatedAt": "2023-02-13T14:05:04.121Z",
    "address": "127.0.0.0/16"
  }
]

But I'm quite sure that function text have to be applied when casting postgres INET datatype to JS String by default 🤔

[ludralph]

I do not know the implementation details, but it looks like the host was used under the hood. So the workaround you've provided looks good.

[RrredHead]

I've created an issue from this discussions: #17929

[ludralph]

Thank you for creating an issue. A member of the engineering team will take a look at it.