database

Documentation

Index

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

Functions

func ConnectToDatabase

func ConnectToDatabase(databaseURI string) (*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 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.