postgresql_errors.hpp

Go to the documentation of this file.

#pragma once
 
#include <string>
#include <unordered_map>
 
namespace relx::connection {
 
enum class PostgreSQLErrorCode {
  // Connection errors
  ConnectionFailed = 1000,
  ConnectionClosed = 1001,
  ConnectionTimeout = 1002,
 
  // Transaction errors
  TransactionError = 2000,
  NoActiveTransaction = 2001,
  TransactionAlreadyActive = 2002,
 
  // Query errors
  QueryFailed = 3000,
  InvalidParameters = 3001,
  EmptyResult = 3002,
 
  // SQLSTATE errors
  DuplicateKey = 23505,              // unique_violation
  ForeignKeyViolation = 23503,       // foreign_key_violation
  CheckConstraintViolation = 23514,  // check_violation
  NotNullViolation = 23502,          // not_null_violation
 
  // Generic errors
  Unknown = 9999
};
 
struct PostgreSQLError {
  std::string message;
  PostgreSQLErrorCode error_code = PostgreSQLErrorCode::Unknown;
  std::string sql_state;
  std::string constraint_name;
  std::string table_name;
  std::string column_name;
  std::string detail;
  std::string hint;
 
  static PostgreSQLError from_libpq(int pg_error_code, std::string_view error_msg);
 
  static PostgreSQLError from_sql_state(std::string_view sql_state, std::string_view error_msg);
 
  std::string formatted_message() const;
 
  bool is_duplicate_key_error() const { return error_code == PostgreSQLErrorCode::DuplicateKey; }
 
  bool is_foreign_key_violation() const {
    return error_code == PostgreSQLErrorCode::ForeignKeyViolation;
  }
 
  bool is_check_constraint_violation() const {
    return error_code == PostgreSQLErrorCode::CheckConstraintViolation;
  }
 
  bool is_not_null_violation() const { return error_code == PostgreSQLErrorCode::NotNullViolation; }
};
 
inline const std::unordered_map<std::string, PostgreSQLErrorCode> sql_state_map = {
    // Class 23 — Integrity Constraint Violation
    {"23505", PostgreSQLErrorCode::DuplicateKey},
    {"23503", PostgreSQLErrorCode::ForeignKeyViolation},
    {"23514", PostgreSQLErrorCode::CheckConstraintViolation},
    {"23502", PostgreSQLErrorCode::NotNullViolation},
 
    // Add more mappings as needed
};
 
}  // namespace relx::connection