dbutil

func EnhanceFilterQueryError ¶

func EnhanceFilterQueryError(err error, filterQuery string) error

EnhanceFilterQueryError provides user-friendly error messages for common filter query parsing mistakes. Should be called when filter query parsing fails to give users helpful hints.

func IsDatabaseTypeConversionError ¶

func IsDatabaseTypeConversionError(err error) bool

IsDatabaseTypeConversionError checks if a database error is caused by type conversion issues (e.g., trying to convert string "x" to a number) that should return 400 Bad Request instead of 500

func IsDuplicateKeyError ¶

func IsDuplicateKeyError(err error) bool

IsDuplicateKeyError checks if a database error is caused by a unique constraint violation. Uses database-specific error codes for reliable detection across versions and locales. Returns true for both MySQL and PostgreSQL unique constraint errors.

Error codes used:

• PostgreSQL: 23505 (unique_violation)
• MySQL: 1062 (ER_DUP_ENTRY - duplicate entry for key)

References:

• PostgreSQL: https://www.postgresql.org/docs/current/errcodes-appendix.html
• MySQL: https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference.html
• pgx: https://github.com/jackc/pgx/wiki/Error-Handling

func QuoteTableName ¶

func QuoteTableName(db *gorm.DB, tableName string) string

QuoteTableName quotes a table name based on database dialect to prevent SQL injection and handle reserved keywords properly.

func SanitizeDatabaseError ¶

func SanitizeDatabaseError(err error) error

SanitizeDatabaseError checks if a database error is a type conversion error and converts it to a BadRequest error. Otherwise returns the original error. This prevents exposing internal database error details to users. Should be called after query execution to sanitize errors.