db

package

Go to main page

Versions in this module

v1

v1.0.1

Apr 12, 2026

v0

v0.1.8

Apr 22, 2026

v0.1.7

Apr 22, 2026

v0.1.6

Apr 22, 2026

v0.1.5

Apr 19, 2026

v0.1.4

Apr 19, 2026

v0.1.3

Apr 19, 2026

v0.1.2

Apr 19, 2026

Changes in this version

+ type CreateInvitationParams struct

+ Email string

+ ExpiresAt pgtype.Timestamptz

+ InvitedBy pgtype.UUID

+ Role string

+ Token string

type CreateUserParams

+ Role string

+ type DeleteMonitorParams struct

+ ID pgtype.UUID

+ UserID pgtype.UUID

+ type GetTeamRow struct

+ ID int32

+ Name string

type GetUserByEmailRow

+ IsActive bool

+ Role string

+ type InstanceSetting struct

+ ID int32

+ RegistrationsEnabled bool

+ type Invitation struct

+ AcceptedAt pgtype.Timestamptz

+ CreatedAt pgtype.Timestamptz

+ Email string

+ ExpiresAt pgtype.Timestamptz

+ ID pgtype.UUID

+ InvitedBy pgtype.UUID

+ Role string

+ Token string

+ type ListUsersRow struct

+ CreatedAt pgtype.Timestamptz

+ Email string

+ ID pgtype.UUID

+ IsActive bool

+ Name string

+ Role string

type Queries

+ func (q *Queries) AcceptInvitation(ctx context.Context, token string) error

+ func (q *Queries) CreateInvitation(ctx context.Context, arg CreateInvitationParams) (Invitation, error)

+ func (q *Queries) DecrementMonitorCount(ctx context.Context, id pgtype.UUID) error

+ func (q *Queries) DeleteInvitation(ctx context.Context, id pgtype.UUID) error

+ func (q *Queries) DeleteMonitor(ctx context.Context, arg DeleteMonitorParams) (int64, error)

+ func (q *Queries) GetInvitationByToken(ctx context.Context, token string) (Invitation, error)

+ func (q *Queries) GetRegistrationsEnabled(ctx context.Context) (bool, error)

+ func (q *Queries) GetTeam(ctx context.Context) (GetTeamRow, error)

+ func (q *Queries) GetUserActiveStatus(ctx context.Context, id pgtype.UUID) (bool, error)

+ func (q *Queries) GetUserPasswordHash(ctx context.Context, id pgtype.UUID) (string, error)

+ func (q *Queries) HasUsers(ctx context.Context) (bool, error)

+ func (q *Queries) ListInvitations(ctx context.Context) ([]Invitation, error)

+ func (q *Queries) ListUsers(ctx context.Context) ([]ListUsersRow, error)

+ func (q *Queries) SetRegistrationsEnabled(ctx context.Context, registrationsEnabled bool) error

+ func (q *Queries) SetUserActive(ctx context.Context, arg SetUserActiveParams) error

+ func (q *Queries) UpdateTeamName(ctx context.Context, name string) error

+ func (q *Queries) UpdateUserName(ctx context.Context, arg UpdateUserNameParams) error

+ func (q *Queries) UpdateUserPassword(ctx context.Context, arg UpdateUserPasswordParams) error

+ type SetUserActiveParams struct

+ ID pgtype.UUID

+ IsActive bool

+ type Team struct

+ CreatedAt pgtype.Timestamptz

+ ID int32

+ Name string

+ type UpdateUserNameParams struct

+ ID pgtype.UUID

+ Name string

+ type UpdateUserPasswordParams struct

+ ID pgtype.UUID

+ PasswordHash string

type User

+ IsActive bool

v0.1.1

Apr 18, 2026

v0.1.0

Apr 18, 2026

Changes in this version

+ func ConnectToDB(ctx context.Context, DBCfg *config.DBConfig, log *zerolog.Logger) (*pgxpool.Pool, error)

+ type Alert struct

+ AlertEmail string

+ CreatedAt pgtype.Timestamptz

+ ID pgtype.UUID

+ IncidentID pgtype.UUID

+ SentAt pgtype.Timestamptz

+ Status string

+ type CloseMonitorIncidentParams struct

+ EndTime pgtype.Timestamptz

+ MonitorID pgtype.UUID

+ type CreateAlertParams struct

+ AlertEmail string

+ IncidentID pgtype.UUID

+ type CreateMonitorIncidentParams struct

+ Alerted bool

+ HttpStatus int32

+ LatencyMs int32

+ MonitorID pgtype.UUID

+ StartTime pgtype.Timestamptz

+ type CreateMonitorParams struct

+ AlertEmail pgtype.Text

+ ExpectedStatus pgtype.Int4

+ IntervalSec int32

+ LatencyThresholdMs pgtype.Int4

+ TimeoutSec int32

+ Url string

+ UserID pgtype.UUID

+ type CreateUserParams struct

+ Email string

+ Name string

+ PasswordHash string

+ type DBTX interface

+ Exec func(context.Context, string, ...interface{}) (pgconn.CommandTag, error)

+ Query func(context.Context, string, ...interface{}) (pgx.Rows, error)

+ QueryRow func(context.Context, string, ...interface{}) pgx.Row

+ type GetAllMonitorByUserIDParams struct

+ Limit int32

+ Offset int32

+ UserID pgtype.UUID

+ type GetIncidentByIDAndUserIDParams struct

+ ID pgtype.UUID

+ UserID pgtype.UUID

+ type GetIncidentByIDAndUserIDRow struct

+ AlertEmail string

+ AlertSentAt pgtype.Timestamptz

+ AlertStatus string

+ Alerted bool

+ CreatedAt pgtype.Timestamptz

+ DurationSec int64

+ EndTime pgtype.Timestamptz

+ HttpStatus int32

+ ID pgtype.UUID

+ IsActive bool

+ LatencyMs int32

+ MonitorID pgtype.UUID

+ MonitorUrl string

+ StartTime pgtype.Timestamptz

+ type GetMonitorByIDRow struct

+ AlertEmail pgtype.Text

+ Enabled bool

+ ExpectedStatus pgtype.Int4

+ ID pgtype.UUID

+ IntervalSec int32

+ LatencyThresholdMs pgtype.Int4

+ TimeoutSec int32

+ Url string

+ UserID pgtype.UUID

+ type GetMonitorParams struct

+ ID pgtype.UUID

+ UserID pgtype.UUID

+ type GetMonitorRow struct

+ AlertEmail pgtype.Text

+ Enabled bool

+ ExpectedStatus pgtype.Int4

+ ID pgtype.UUID

+ IntervalSec int32

+ LatencyThresholdMs pgtype.Int4

+ TimeoutSec int32

+ Url string

+ UserID pgtype.UUID

+ type GetUserByEmailRow struct

+ Email string

+ ID pgtype.UUID

+ Name string

+ PasswordHash string

+ type GetUserByIDRow struct

+ Email string

+ ID pgtype.UUID

+ MonitorsCount pgtype.Int4

+ Name string

+ PasswordHash string

+ type ListIncidentsByUserCursorParams struct

+ Column2 string

+ Column3 pgtype.Timestamptz

+ Column4 pgtype.Timestamptz

+ Column5 string

+ Column6 pgtype.UUID

+ Column7 pgtype.Timestamptz

+ Column8 pgtype.UUID

+ Limit int32

+ UserID pgtype.UUID

+ type ListIncidentsByUserCursorRow struct

+ AlertEmail string

+ AlertSentAt pgtype.Timestamptz

+ AlertStatus string

+ Alerted bool

+ CreatedAt pgtype.Timestamptz

+ DurationSec int64

+ EndTime pgtype.Timestamptz

+ HttpStatus int32

+ ID pgtype.UUID

+ IsActive bool

+ LatencyMs int32

+ MonitorID pgtype.UUID

+ MonitorUrl string

+ StartTime pgtype.Timestamptz

+ type ListIncidentsByUserIDParams struct

+ Limit int32

+ Offset int32

+ UserID pgtype.UUID

+ type ListIncidentsByUserIDRow struct

+ AlertEmail string

+ AlertSentAt pgtype.Timestamptz

+ AlertStatus string

+ Alerted bool

+ CreatedAt pgtype.Timestamptz

+ DurationSec int64

+ EndTime pgtype.Timestamptz

+ HttpStatus int32

+ ID pgtype.UUID

+ IsActive bool

+ LatencyMs int32

+ MonitorID pgtype.UUID

+ MonitorUrl string

+ StartTime pgtype.Timestamptz

+ type Monitor struct

+ AlertEmail pgtype.Text

+ CreatedAt pgtype.Timestamptz

+ Enabled bool

+ ExpectedStatus pgtype.Int4

+ ID pgtype.UUID

+ IntervalSec int32

+ LatencyThresholdMs pgtype.Int4

+ TimeoutSec int32

+ UpdatedAt pgtype.Timestamptz

+ Url string

+ UserID pgtype.UUID

+ type MonitorIncident struct

+ Alerted bool

+ CreatedAt pgtype.Timestamptz

+ EndTime pgtype.Timestamptz

+ HttpStatus int32

+ ID pgtype.UUID

+ LatencyMs int32

+ MonitorID pgtype.UUID

+ StartTime pgtype.Timestamptz

+ type Queries struct

+ func New(db DBTX) *Queries

+ func (q *Queries) CloseMonitorIncident(ctx context.Context, arg CloseMonitorIncidentParams) (pgtype.UUID, error)

+ func (q *Queries) CountIncidentsByUserID(ctx context.Context, userID pgtype.UUID) (int64, error)

+ func (q *Queries) CreateAlert(ctx context.Context, arg CreateAlertParams) error

+ func (q *Queries) CreateMonitor(ctx context.Context, arg CreateMonitorParams) (pgtype.UUID, error)

+ func (q *Queries) CreateMonitorIncident(ctx context.Context, arg CreateMonitorIncidentParams) (pgtype.UUID, error)

+ func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (pgtype.UUID, error)

+ func (q *Queries) GetAllMonitorByUserID(ctx context.Context, arg GetAllMonitorByUserIDParams) ([]Monitor, error)

+ func (q *Queries) GetIncidentByIDAndUserID(ctx context.Context, arg GetIncidentByIDAndUserIDParams) (GetIncidentByIDAndUserIDRow, error)

+ func (q *Queries) GetMonitor(ctx context.Context, arg GetMonitorParams) (GetMonitorRow, error)

+ func (q *Queries) GetMonitorByID(ctx context.Context, id pgtype.UUID) (GetMonitorByIDRow, error)

+ func (q *Queries) GetMonitorIncidentByID(ctx context.Context, id pgtype.UUID) (MonitorIncident, error)

+ func (q *Queries) GetUserByEmail(ctx context.Context, email string) (GetUserByEmailRow, error)

+ func (q *Queries) GetUserByID(ctx context.Context, id pgtype.UUID) (GetUserByIDRow, error)

+ func (q *Queries) IncrementMonitorCount(ctx context.Context, id pgtype.UUID) (int64, error)

+ func (q *Queries) ListIncidentsByUserCursor(ctx context.Context, arg ListIncidentsByUserCursorParams) ([]ListIncidentsByUserCursorRow, error)

+ func (q *Queries) ListIncidentsByUserID(ctx context.Context, arg ListIncidentsByUserIDParams) ([]ListIncidentsByUserIDRow, error)

+ func (q *Queries) UpdateAlertStatus(ctx context.Context, arg UpdateAlertStatusParams) (int64, error)

+ func (q *Queries) UpdateMonitorStatus(ctx context.Context, arg UpdateMonitorStatusParams) (int64, error)

+ func (q *Queries) WithTx(tx pgx.Tx) *Queries

+ type UpdateAlertStatusParams struct

+ ID pgtype.UUID

+ Status string

+ type UpdateMonitorStatusParams struct

+ Enabled bool

+ ID pgtype.UUID

+ UserID pgtype.UUID

+ type User struct

+ CreatedAt pgtype.Timestamptz

+ Email string

+ ID pgtype.UUID

+ MonitorsCount pgtype.Int4

+ Name string

+ PasswordHash string

+ Role string

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL