database

Documentation

Index

• func ConnectToDatabase() (*sql.DB, error)
• func IsDuplicateError(err error) *string
• func Transaction(database *sql.DB, operation TransactionFunction) (err error)
• type TransactionFunction

Functions

func ConnectToDatabase

func ConnectToDatabase() (*sql.DB, error)

ConnectToDatabase establishes a connection to a PostgreSQL database. Configures connection pooling and verifies connectivity. Returns the database handle or an error if the connection fails.

func IsDuplicateError

func IsDuplicateError(err error) *string

IsDuplicateError checks if the error is a Postgres duplicate entry error (unique_violation). Returns the constraint/field name if duplicate, otherwise nil.

func Transaction

func Transaction(database *sql.DB, operation TransactionFunction) (err error)

Transaction executes a database transaction with robust panic handling, consistent timestamps, and enhanced logging for debugging. It returns an error if the transaction fails or panics.

Types

type TransactionFunction

type TransactionFunction func(transaction *sql.Tx) error

TransactionFunction defines the signature for the transactional operation. It accepts a transaction and returns an error if the operation fails.