Postgres 错误代码

Postgres 为NodeJS绘制错误代码映射.

安装

npm i @drdgvhbh/postgres-error-codes

使用量

每个条件从 PG 文档 可在模块中找到。 为了获得状态代码,使用前缀的大写条件名:

unique_violation => PG_UNIQUE_VIOLATION

not_null_violation => PG_NOT_NULL_VIOLATION

const { PG_UNIQUE_VIOLATION, PG_NOT_NULL_VIOLATION } = require('postgres-error-codes')

async function createUserMethod(req, res, next) {
    try {
        // Run insert user SQL
    } catch (err) {
        // If user with same email already exists
        if (err.code === PG_UNIQUE_VIOLATION) {
            return next('Email already exists!')
        }

        // Param should not be null
        if (err.code === PG_NOT_NULL_VIOLATION) {
            return next('Email required!')
        }

        next(err)
    }
}

相关

• PostgreSQL 错误代码文档