arrayRowMode returns a function for the column type about node-mssql HOT 6 CLOSED

The right way to do it is to have a transformer that will map the internal DB type to a type that is useful in your frontend. You don't want this to be coupled in this way at all.

If I wanted to do this (which isn't how I'd approach it, I'd just use the native JS types in the frontend, no need for the backend to dictate types), I'd use a translation layer to map the internal DB types to a type the frontend will understand (ie: your API schema). A simple switch statement would do.

const colTypes = result.columns[0].map((col) => {
  switch (col.type) {
    case sql.Text:
      return 'string';
    default:
      return 'unknown';
  }
});

from node-mssql.

The undefined fields probably shouldn't be getting returned either.
All part of the same problem, I expect.

from node-mssql.

This is all working as intended.

Do you have any specific questions as I'm not really sure what solution you're looking for here?

from node-mssql.

Displaying my lack of expertise with JS I expect.
However I was using res.send(JSON.stringify(result)) to send this back to the client, which does not stringify the type field.
My workround was to replace the type value with the type.declaration value which gives me the JS type.
Not sure how I would get the '[sql.VarChar]' value though.

from node-mssql.

The result certainly is not intended to be exposed to a front end in that way. The object doesn't implement a toJSON() method and it could contain all sorts of things that you wouldn't want exposed publicly.

It's never good practice just to dump backend data to the frontend without first sanitising it first. You'd want to whitelist and format the data in a predictable way for the frontend otherwise you aren't in control of your API contract and you're delegating that responsibility to this library instead.

from node-mssql.

I'm writing a generic read-only data viewer which will build the table based on column info, rows (returned and calculated). It will need the datatype to allow column searches to be smart.
I will limit what is sent eventually, but I'm in dev mode at the moment 😁
Am I right in thinking that I need

result.columns[0][0].type[Symbol.for('nodejs.util.inspect.custom')]()

to get the '[sql.VarChar]' info out of the type?

from node-mssql.