sql

May 25, 2024

Changes in this version

type IConvectiveOutlookTableV2

+ SelectAllLatest func() (map[golang.ConvectiveOutlookType][]data_structures.ConvectiveOutlookV2, error)

+ SelectAllLatestByLocation func(point geojson_v2.Point) ([]data_structures.ConvectiveOutlookV2, error)

type IMesoscaleDiscussionV2Table

+ SelectLatest func() ([]data_structures.MesoscaleDiscussionV2, error)

+ SelectLatestByLocation func(point geojson_v2.Point) ([]data_structures.MesoscaleDiscussionV2, error)

type PostgresConvectiveOutlookTableV2

+ func (p *PostgresConvectiveOutlookTableV2) SelectAllLatest() (map[golang.ConvectiveOutlookType][]data_structures.ConvectiveOutlookV2, error)

+ func (p *PostgresConvectiveOutlookTableV2) SelectAllLatestByLocation(point geojson_v2.Point) ([]data_structures.ConvectiveOutlookV2, error)

type PostgresMesoscaleDiscussionV2Table

+ func (p *PostgresMesoscaleDiscussionV2Table) SelectLatest() ([]data_structures.MesoscaleDiscussionV2, error)

+ func (p *PostgresMesoscaleDiscussionV2Table) SelectLatestByLocation(point geojson_v2.Point) ([]data_structures.MesoscaleDiscussionV2, error)

May 10, 2024

Changes in this version

+ type AlertNotification struct

+ Device data_structures.Device

+ LocationName string

+ type ConvectiveOutlookNotification struct

+ ConvectiveOutlookLabel string

+ Device data_structures.Device

+ LocationName string

+ type IAlertV2Table interface

+ Exists func(id string) (bool, error)

+ SelectByLocation func(codes []string, point geojson_v2.Point) ([]data_structures.AlertV2, error)

+ type IConvectiveOutlookTableV2 interface

+ Insert func(outlooks []data_structures.ConvectiveOutlookV2) error

+ Select func(publishedTime time.Time, outlookType golang.ConvectiveOutlookType) ([]data_structures.ConvectiveOutlookV2, error)

+ SelectById func(id string) ([]data_structures.ConvectiveOutlookV2, error)

+ SelectLatest func(outlookType golang.ConvectiveOutlookType) ([]data_structures.ConvectiveOutlookV2, error)

+ type IMesoscaleDiscussionV2Table interface

+ Delete func(year, mdNumber int) error

+ Insert func(md data_structures.MesoscaleDiscussionV2) error

+ Select func(mdNumber int, year int) (*data_structures.MesoscaleDiscussionV2, error)

+ SelectById func(id string) (*data_structures.MesoscaleDiscussionV2, error)

+ SelectMDNotInTable func(year int, mdsToCheck map[int]bool) ([]int, error)

+ type INotificationQueries interface

+ GetDevicesForAlertId func(alertId string) ([]AlertNotification, error)

+ GetDevicesForConvectiveOutlookId func(convectiveOutlookId string) ([]ConvectiveOutlookNotification, error)

+ GetDevicesForMesoscaleDiscussion func(mesoscaleDiscussionId string) ([]MesoscaleDiscussionNotification, error)

+ type MesoscaleDiscussionNotification struct

+ Device data_structures.Device

+ LocationName string

+ type PostgresAlertV2Table struct

+ func NewPostgresAlertV2Table(db *sql.DB) PostgresAlertV2Table

+ func (p *PostgresAlertV2Table) Delete(id string) error

+ func (p *PostgresAlertV2Table) Exists(id string) (bool, error)

+ func (p *PostgresAlertV2Table) Insert(alert data_structures.AlertV2) error

+ func (p *PostgresAlertV2Table) Select(id string) (*data_structures.AlertV2, error)

+ func (p *PostgresAlertV2Table) SelectByLocation(codes []string, point geojson_v2.Point) ([]data_structures.AlertV2, error)

+ type PostgresConvectiveOutlookTableV2 struct

+ func NewPostgresConvectiveOutlookTableV2(db *sql.DB) PostgresConvectiveOutlookTableV2

+ func (p *PostgresConvectiveOutlookTableV2) Insert(outlooks []data_structures.ConvectiveOutlookV2) error

+ func (p *PostgresConvectiveOutlookTableV2) Select(issuedTime time.Time, outlookType golang.ConvectiveOutlookType) ([]data_structures.ConvectiveOutlookV2, error)

+ func (p *PostgresConvectiveOutlookTableV2) SelectById(id string) ([]data_structures.ConvectiveOutlookV2, error)

+ func (p *PostgresConvectiveOutlookTableV2) SelectLatest(outlookType golang.ConvectiveOutlookType) ([]data_structures.ConvectiveOutlookV2, error)

+ type PostgresMesoscaleDiscussionV2Table struct

+ func NewPostgresMesoscaleDiscussionV2Table(db *sql.DB) PostgresMesoscaleDiscussionV2Table

+ func (p *PostgresMesoscaleDiscussionV2Table) Delete(year, mdNumber int) error

+ func (p *PostgresMesoscaleDiscussionV2Table) Insert(md data_structures.MesoscaleDiscussionV2) error

+ func (p *PostgresMesoscaleDiscussionV2Table) Select(year, mdNumber int) (*data_structures.MesoscaleDiscussionV2, error)

+ func (p *PostgresMesoscaleDiscussionV2Table) SelectById(id string) (*data_structures.MesoscaleDiscussionV2, error)

+ func (p *PostgresMesoscaleDiscussionV2Table) SelectMDNotInTable(year int, mdsToCheck map[int]bool) ([]int, error)

+ type PostgresNotificationQueries struct

+ func NewNotificationQueries(db *sql.DB) PostgresNotificationQueries

+ func (n *PostgresNotificationQueries) GetDevicesForAlertId(alertId string) ([]AlertNotification, error)

+ func (n *PostgresNotificationQueries) GetDevicesForConvectiveOutlookId(convectiveOutlookId string) ([]ConvectiveOutlookNotification, error)

+ func (n *PostgresNotificationQueries) GetDevicesForMesoscaleDiscussion(mesoscaleDiscussionId string) ([]MesoscaleDiscussionNotification, error)

Apr 2, 2024

Changes in this version

+ type IDeviceTable interface

+ SelectByUser func(userId string) ([]data_structures.Device, error)

+ UpdateApnsToken func(id, apnsToken string) error

+ type PostgresDeviceTable struct

+ func NewPostgresDeviceTable(db *sql.DB) PostgresDeviceTable

+ func (p PostgresDeviceTable) Delete(id string) error

+ func (p PostgresDeviceTable) Insert(device data_structures.Device) error

+ func (p PostgresDeviceTable) Select(id string) (*data_structures.Device, error)

+ func (p PostgresDeviceTable) SelectByUser(userId string) ([]data_structures.Device, error)

+ func (p PostgresDeviceTable) UpdateApnsToken(id, apnsToken string) error

Mar 16, 2024

Changes in this version

+ type IAlertTable interface

+ DeleteExpiredAlerts func(id string) error

+ Exists func(id string) (bool, error)

+ SelectAlertsByCode func(codes []string) ([]data_structures.Alert, error)

+ type IConvectiveOutlookTable interface

+ Insert func(outlook data_structures.ConvectiveOutlook) error

+ Select func(publishedTime time.Time, outlookType golang.ConvectiveOutlookType) (*data_structures.ConvectiveOutlook, error)

+ SelectLatest func(outlookType golang.ConvectiveOutlookType) (*data_structures.ConvectiveOutlook, error)

+ type IPostgresMesoscaleDiscussionTable interface

+ Insert func(md data_structures.MesoscaleDiscussion) error

+ Select func(mdNumber int, year int) (*data_structures.MesoscaleDiscussion, error)

+ SelectMDNotInTable func(year int, mdsToCheck map[int]bool) ([]int, error)

+ type IUserNotificationTable interface

+ SelectAll func() ([]data_structures.UserNotification, error)

+ SelectByCodes func(codes []string) ([]data_structures.UserNotification, error)

+ SelectByUserId func(userId string) ([]data_structures.UserNotification, error)

+ SelectNotificationsWithConvectiveOutlook func() ([]data_structures.UserNotification, error)

+ SelectNotificationsWithMDNotifications func() ([]data_structures.UserNotification, error)

+ Update func(id string, userNotification data_structures.UserNotification) error

+ type PostgresAlertTable struct

+ func NewPostgresAlertTable(db *sql.DB) PostgresAlertTable

+ func (p *PostgresAlertTable) Delete(id string) error

+ func (p *PostgresAlertTable) DeleteExpiredAlerts(id string) error

+ func (p *PostgresAlertTable) Exists(id string) (bool, error)

+ func (p *PostgresAlertTable) Insert(alert data_structures.Alert) error

+ func (p *PostgresAlertTable) Select(id string) (*data_structures.Alert, error)

+ func (p *PostgresAlertTable) SelectAlertsByCode(codes []string) ([]data_structures.Alert, error)

+ type PostgresConvectiveOutlookTable struct

+ func NewPostgresConvectiveOutlookTable(db *sql.DB) PostgresConvectiveOutlookTable

+ func (p *PostgresConvectiveOutlookTable) Insert(outlook data_structures.ConvectiveOutlook) error

+ func (p *PostgresConvectiveOutlookTable) Select(publishedTime time.Time, outlookType golang.ConvectiveOutlookType) (*data_structures.ConvectiveOutlook, error)

+ func (p *PostgresConvectiveOutlookTable) SelectLatest(outlookType golang.ConvectiveOutlookType) (*data_structures.ConvectiveOutlook, error)

+ type PostgresMesoscaleDiscussionTable struct

+ func NewPostgresMesoscaleDicussionTable(db *sql.DB) PostgresMesoscaleDiscussionTable

+ func (p *PostgresMesoscaleDiscussionTable) Delete(year, mdNumber int) error

+ func (p *PostgresMesoscaleDiscussionTable) Insert(md data_structures.MesoscaleDiscussion) error

+ func (p *PostgresMesoscaleDiscussionTable) Select(year, mdNumber int) (*data_structures.MesoscaleDiscussion, error)

+ func (p *PostgresMesoscaleDiscussionTable) SelectMDNotInTable(year int, mdsToCheck map[int]bool) ([]int, error)

+ type PostgresUserNotificationTable struct

+ func NewPostgresUserNotificationTable(db *sql.DB) PostgresUserNotificationTable

+ func (p *PostgresUserNotificationTable) Delete(notificationId string) error

+ func (p *PostgresUserNotificationTable) Insert(userNotification data_structures.UserNotification) error

+ func (p *PostgresUserNotificationTable) Select(id string) (*data_structures.UserNotification, error)

+ func (p *PostgresUserNotificationTable) SelectAll() ([]data_structures.UserNotification, error)

+ func (p *PostgresUserNotificationTable) SelectByCodes(codes []string) ([]data_structures.UserNotification, error)

+ func (p *PostgresUserNotificationTable) SelectByUserId(userId string) ([]data_structures.UserNotification, error)

+ func (p *PostgresUserNotificationTable) SelectNotificationsWithConvectiveOutlook() ([]data_structures.UserNotification, error)

+ func (p *PostgresUserNotificationTable) SelectNotificationsWithMDNotifications() ([]data_structures.UserNotification, error)

+ func (p *PostgresUserNotificationTable) Update(id string, userNotification data_structures.UserNotification) error