sqln

const (
	ErrDatabaseNotInitialized string = "database connection not initialized"
	ErrMsgFailedConnect       string = "failed to connect to PostgreSQL: %w"
	ErrMsgFailedConnectionPig string = "failed to connect to PostgreSQL ping: %w"
	ErrMsgMigration           string = "an error occurred when validate database migrations: %v"

	ErrMsgQueryIsEmpty string = "query is empty"
	ErrPageIsEmpty     string = "page is empty, please create a pageable query"
	ErrMsgStmClose     string = "failed to close statement: %v\n"
)

const (
	MAX_OPEN_CONNS     = 10              // Número máximo de conexões abertas
	MAX_IDLE_CONNS     = 5               // Número máximo de conexões inativas no pool
	MAX_CONN_LIFE_TIME = time.Minute * 5 // Tempo máximo de vida de uma conexão no pool
)

const (
	ErrMsgInvalidLogialOp      = "invalid logical operator: %s"
	ErrMsgInvalidField         = "invalid field: %s"
	ErrMsgInvalidCondition     = "invalid condition: %s"
	ErrMsgUnsupportedTypeField = "unsupported value type for field"
	ErrMsgActionNotAllowed     = "action not allowed, invalid value for a filter: %s"
	ErrMsgInvalidSortingField  = "invalid sorting field: %s"
)

const (
	Eq             = "="
	LessOrEqual    = "<="
	GreaterOrEqual = ">="
	NotEqual       = "!="
	In             = "IN"
	Contains       = "LIKE"
	Between        = "BETWEEN"
)

const (
	Or  = "OR"
	And = "AND"
)

const (
	ErrMsgCouldNotConnectDB           string = "could not connect to database for migration %v"
	ErrMsgMigrationExecutionWithError string = "an error occurred during migration execution: %v"
	ErrMsgCreateMigrateInstance       string = "failed to create migrate instance"
)

const (
	DefaultPage          = uint16(0)
	DefaultLimit         = uint16(15)
	DefaultSortField     = "id"
	DefaultSortDirection = string(ASC)
)

const (
	SqlTxContextKey contextKey = "sqlTxContext"

	MsgTransactionIsolationIgnored = "transaction isolation only uses the first parameter, others are ignored"
	ErrExecuteTransaction          = "error when executing transaction error: %w"
	ErrTransactionRollback         = "error when executing transaction rollback: %v, original error: %w"
	ErrTransactionCommit           = "could not commit transaction: %w"
	ErrTransactionStart            = "could not start database transaction: %v"
)