#2447·mysql

Check Mysql Error

Author: gavin-c-tcgCreated Dec 30, 2020Updated Mar 7, 2022
Labelsfeature

Maybe can add some utility to check mysql Error

javascript
import * as MysqlErrorCode from 'mysql/lib/protocol/constants/errors';

/**
 * MysqlErrorCode like {
 *  "163": "HA_ERR_FOREIGN_DUPLICATE_KEY",
 *  "HA_ERR_FOREIGN_DUPLICATE_KEY": 163,
 * }
 */
export const isMySQLErrorCode = (code: string) => {
    return typeof code === 'string' && typeof MysqlErrorCode?.[code] === 'number';
};
javascript
class MySQLError extends Error{ }
javascript
error.isMySqlError = true