sql

type IAlertTable interface {
	common_tables.IIdTable[data_structures.Alert]

	// Deprecated: use Select
	Find(id string) (*data_structures.Alert, error)

	// Deprecated: use Insert
	Create(alert *data_structures.Alert) error

	// Deprecated: use SelectAlertsByCode
	FindAlertsByCode(codes []string) ([]data_structures.Alert, error)

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

	DeleteExpiredAlerts(id string) error

	Exists(id string) (bool, error)
}

type IConvectiveOutlookTable interface {
	// Deprecated: use the weather-db-migrator docker images for setup
	Init() error

	// Deprecated: use Insert
	Create(outlook *data_structures.ConvectiveOutlook) error

	Insert(outlook data_structures.ConvectiveOutlook) error

	// Deprecated: use Select
	Find(publishedTime time.Time, outlookType golang.ConvectiveOutlookType) (*data_structures.ConvectiveOutlook, error)

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

	// Deprecated: use SelectLatest
	FindLatest(outlookType golang.ConvectiveOutlookType) (*data_structures.ConvectiveOutlook, error)

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

type IPostgresMesoscaleDiscussionTable interface {
	Insert(md data_structures.MesoscaleDiscussion) error

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

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

type IUserNotificationTable interface {
	common_tables.IIdTable[data_structures.UserNotification]

	// Deprecated: use Insert
	Create(userNotification data_structures.UserNotification) error

	// Deprecated: use Select
	Get(notificationId string) (*data_structures.UserNotification, error)

	// Deprecated: use SelectAll
	GetAll() ([]data_structures.UserNotification, error)

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

	// Deprecated: use SelectByUserId
	GetByUserId(userId string) ([]data_structures.UserNotification, error)

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

	// Deprecated: use SelectByCodes
	GetByCodes(codes []string) ([]data_structures.UserNotification, error)

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

	// Deprecated: use SelectNotificationsWithConvectiveOutlook
	GetNotificationsWithConvectiveOutlookOptions() ([]data_structures.UserNotification, error)

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

	SelectNotificationsWithConvectiveOutlook() ([]data_structures.UserNotification, error)
}

type PostgresAlertTable struct {
	// contains filtered or unexported fields
}

type PostgresConvectiveOutlookTable struct {
	// contains filtered or unexported fields
}

type PostgresMesoscaleDiscussionTable struct {
	// contains filtered or unexported fields
}

type PostgresUserNotificationTable struct {
	// contains filtered or unexported fields
}