queries

Documentation

Index

• type IncidentQueries
  • func (q *IncidentQueries) CreateNewIncident(incident *models.Incident) error
  • func (q *IncidentQueries) CreateNewIncidentTimeline(incidentTimeline models.IncidentTimeline) error
  • func (q *IncidentQueries) GetRecentIncidentWithSpecifyTypeAndStatus(httpMonitorID string, incidentType models.IncidentType, ...) (*models.Incident, error)
  • func (q *IncidentQueries) GetRecentUnsloveIncidents(httpMonitorID string, incidentStatus models.IncidentStatus) ([]models.Incident, error)
  • func (q *IncidentQueries) UpdateIncident(incident *models.Incident) error
  • func (q *IncidentQueries) UpdateIncidentConfirmLocation(incidentID string, confirmLocation pq.StringArray) error
• type MonitorQueries
  • func (q *MonitorQueries) CreateNewHttpMonitor(httpMonitor *models.HttpMonitor) error
  • func (q *MonitorQueries) DeleteHttpMonitor(httpMonitorID string) error
  • func (q *MonitorQueries) GetAllHttpMonitors() ([]models.HttpMonitor, error)
  • func (q *MonitorQueries) GetAllTeamHttpMonitors(teamID string) ([]models.HttpMonitor, error)
  • func (q *MonitorQueries) GetHttpMonitorByID(httpMonitorID string) (*models.HttpMonitor, error)
• type NoRowsAffectedError
  • func (e *NoRowsAffectedError) Error() string
• type NotificationQueries
  • func (q *NotificationQueries) CreateNewHttpMonitorNotification(notification *models.HttpMonitorNotification) error
  • func (q *NotificationQueries) CreateNewNotification(notification *models.Notification) error
  • func (q *NotificationQueries) GetAllMatchIDNotifications(notificationIDs []string) ([]models.Notification, error)
  • func (q *NotificationQueries) GetHttpMonitorNotifications(httpMonitorID string) ([]models.HttpMonitorNotification, error)
  • func (q *NotificationQueries) GetNotificationByID(notificationID string) (*models.Notification, error)
  • func (q *NotificationQueries) GetNotificationsByTeamID(teamID int64) ([]models.Notification, error)
  • func (q *NotificationQueries) GetNotificationsByUserID(userID int64) ([]models.Notification, error)
• type PingDataQueries
  • func (q *PingDataQueries) CreatePingData(data *models.PingData) error
• type ServerQueries
  • func (q *ServerQueries) CreateNewServerLocation(serverLocation *models.ServerLocation) error
  • func (q *ServerQueries) GetServerLocation(serverID string) (*models.ServerLocation, error)
  • func (q *ServerQueries) ServerLocationExists(serverID string) (bool, error)
• type SessionQueries
  • func (q *SessionQueries) CreateNewSession(session *models.Session) error
  • func (q *SessionQueries) DeleteSession(userID string, session string) error
  • func (q *SessionQueries) RotateSession(userID, oldSession string) (string, error)
  • func (q *SessionQueries) UpdateSession(userID string, oldSession string, newSession string, expriceTime time.Time) error
• type TeamQueries
  • func (q *TeamQueries) CreateNewMember(teamMember *models.TeamMember) error
  • func (q *TeamQueries) CreateNewTeam(team *models.Team) error
  • func (q *TeamQueries) CreateNewTeamInvite(teamMember *models.TeamInvite) error
  • func (q *TeamQueries) DeleteTeamInviteByID(inviteID string) error
  • func (q *TeamQueries) GetAllTeamMembersWithDetails(teamID string) ([]models.TeamMemberWithDetails, error)
  • func (q *TeamQueries) GetTeamInvite(userID, inviteID string) (models.TeamInvite, error)
  • func (q *TeamQueries) GetTeamInviteByUserIDAndTeamID(teamID, userID string) (models.TeamInvite, error)
  • func (q *TeamQueries) GetTeamMember(memberID, teamID string) (models.TeamMember, error)
  • func (q *TeamQueries) GetUserAllTeams(userID string) ([]models.UserTeams, error)
• type UserQueries
  • func (q *UserQueries) CreateNewUser(u *models.User) error
  • func (q *UserQueries) GetSession(userID, userSession string) (models.Session, error)
  • func (q *UserQueries) GetUserByEmail(email string) (models.User, error)
  • func (q *UserQueries) IsEmailUsed(email string) (bool, error)
  • func (q *UserQueries) IsOwnerAccountCreated() (bool, error)

Types

type IncidentQueries

type IncidentQueries struct {
	*sqlx.DB
}

func (*IncidentQueries) CreateNewIncident

func (q *IncidentQueries) CreateNewIncident(incident *models.Incident) error

CreateNewIncident creates a new incident in the database

func (*IncidentQueries) CreateNewIncidentTimeline

func (q *IncidentQueries) CreateNewIncidentTimeline(incidentTimeline models.IncidentTimeline) error

CreateNewIncidentTimeline creates a new incident timeline entry in the database

func (*IncidentQueries) GetRecentIncidentWithSpecifyTypeAndStatus

func (q *IncidentQueries) GetRecentIncidentWithSpecifyTypeAndStatus(httpMonitorID string, incidentType models.IncidentType, incidentStatus models.IncidentStatus) (*models.Incident, error)

GetRecentIncident retrieves the most recent incident for a given http_monitor_id and incident_type

func (*IncidentQueries) GetRecentUnsloveIncidents

func (q *IncidentQueries) GetRecentUnsloveIncidents(httpMonitorID string, incidentStatus models.IncidentStatus) ([]models.Incident, error)

GetRecentIncidents retrieves the most recent incidents for a given http_monitor_id and multiple incident_types

func (*IncidentQueries) UpdateIncident

func (q *IncidentQueries) UpdateIncident(incident *models.Incident) error

UpdateIncident updates an existing incident in the database

func (*IncidentQueries) UpdateIncidentConfirmLocation

func (q *IncidentQueries) UpdateIncidentConfirmLocation(incidentID string, confirmLocation pq.StringArray) error

UpdateConfirmLocation updates the ConfirmLocation of an incident in the database

type MonitorQueries

type MonitorQueries struct {
	*sqlx.DB
}

func (*MonitorQueries) CreateNewHttpMonitor

func (q *MonitorQueries) CreateNewHttpMonitor(httpMonitor *models.HttpMonitor) error

func (*MonitorQueries) DeleteHttpMonitor

func (q *MonitorQueries) DeleteHttpMonitor(httpMonitorID string) error

func (*MonitorQueries) GetAllHttpMonitors

func (q *MonitorQueries) GetAllHttpMonitors() ([]models.HttpMonitor, error)

func (*MonitorQueries) GetAllTeamHttpMonitors

func (q *MonitorQueries) GetAllTeamHttpMonitors(teamID string) ([]models.HttpMonitor, error)

func (*MonitorQueries) GetHttpMonitorByID

func (q *MonitorQueries) GetHttpMonitorByID(httpMonitorID string) (*models.HttpMonitor, error)

type NoRowsAffectedError

type NoRowsAffectedError struct {
	Message string
}

func (*NoRowsAffectedError) Error

func (e *NoRowsAffectedError) Error() string

type NotificationQueries

type NotificationQueries struct {
	*sqlx.DB
}

func (*NotificationQueries) CreateNewHttpMonitorNotification

func (q *NotificationQueries) CreateNewHttpMonitorNotification(notification *models.HttpMonitorNotification) error

func (*NotificationQueries) CreateNewNotification

func (q *NotificationQueries) CreateNewNotification(notification *models.Notification) error

func (*NotificationQueries) GetAllMatchIDNotifications

func (q *NotificationQueries) GetAllMatchIDNotifications(notificationIDs []string) ([]models.Notification, error)

func (*NotificationQueries) GetHttpMonitorNotifications

func (q *NotificationQueries) GetHttpMonitorNotifications(httpMonitorID string) ([]models.HttpMonitorNotification, error)

func (*NotificationQueries) GetNotificationByID

func (q *NotificationQueries) GetNotificationByID(notificationID string) (*models.Notification, error)

func (*NotificationQueries) GetNotificationsByTeamID

func (q *NotificationQueries) GetNotificationsByTeamID(teamID int64) ([]models.Notification, error)

func (*NotificationQueries) GetNotificationsByUserID

func (q *NotificationQueries) GetNotificationsByUserID(userID int64) ([]models.Notification, error)

type PingDataQueries

type PingDataQueries struct {
	*sqlx.DB
}

func (*PingDataQueries) CreatePingData

func (q *PingDataQueries) CreatePingData(data *models.PingData) error

type ServerQueries

type ServerQueries struct {
	*sqlx.DB
}

func (*ServerQueries) CreateNewServerLocation

func (q *ServerQueries) CreateNewServerLocation(serverLocation *models.ServerLocation) error

func (*ServerQueries) GetServerLocation

func (q *ServerQueries) GetServerLocation(serverID string) (*models.ServerLocation, error)

func (*ServerQueries) ServerLocationExists

func (q *ServerQueries) ServerLocationExists(serverID string) (bool, error)

type SessionQueries

type SessionQueries struct {
	*sqlx.DB
}

func (*SessionQueries) CreateNewSession

func (q *SessionQueries) CreateNewSession(session *models.Session) error

func (*SessionQueries) DeleteSession

func (q *SessionQueries) DeleteSession(userID string, session string) error

func (*SessionQueries) RotateSession

func (q *SessionQueries) RotateSession(userID, oldSession string) (string, error)

func (*SessionQueries) UpdateSession

func (q *SessionQueries) UpdateSession(userID string, oldSession string, newSession string, expriceTime time.Time) error

type TeamQueries

type TeamQueries struct {
	*sqlx.DB
}

func (*TeamQueries) CreateNewMember

func (q *TeamQueries) CreateNewMember(teamMember *models.TeamMember) error

func (*TeamQueries) CreateNewTeam

func (q *TeamQueries) CreateNewTeam(team *models.Team) error

func (*TeamQueries) CreateNewTeamInvite

func (q *TeamQueries) CreateNewTeamInvite(teamMember *models.TeamInvite) error

func (*TeamQueries) DeleteTeamInviteByID

func (q *TeamQueries) DeleteTeamInviteByID(inviteID string) error

func (*TeamQueries) GetAllTeamMembersWithDetails

func (q *TeamQueries) GetAllTeamMembersWithDetails(teamID string) ([]models.TeamMemberWithDetails, error)

func (*TeamQueries) GetTeamInvite

func (q *TeamQueries) GetTeamInvite(userID, inviteID string) (models.TeamInvite, error)

func (*TeamQueries) GetTeamInviteByUserIDAndTeamID

func (q *TeamQueries) GetTeamInviteByUserIDAndTeamID(teamID, userID string) (models.TeamInvite, error)

func (*TeamQueries) GetTeamMember

func (q *TeamQueries) GetTeamMember(memberID, teamID string) (models.TeamMember, error)

func (*TeamQueries) GetUserAllTeams

func (q *TeamQueries) GetUserAllTeams(userID string) ([]models.UserTeams, error)

type UserQueries

type UserQueries struct {
	*sqlx.DB
}

func (*UserQueries) CreateNewUser

func (q *UserQueries) CreateNewUser(u *models.User) error

func (*UserQueries) GetSession

func (q *UserQueries) GetSession(userID, userSession string) (models.Session, error)

func (*UserQueries) GetUserByEmail

func (q *UserQueries) GetUserByEmail(email string) (models.User, error)

func (*UserQueries) IsEmailUsed

func (q *UserQueries) IsEmailUsed(email string) (bool, error)

func (*UserQueries) IsOwnerAccountCreated

func (q *UserQueries) IsOwnerAccountCreated() (bool, error)