sql

package
v3.6.1 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Mar 16, 2024 License: MIT Imports: 13 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type IAlertTable 

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 

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 

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 

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)

	Update(id string, userNotification data_structures.UserNotification) error
}

type PostgresAlertTable 

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

func NewPostgresAlertTable 

func NewPostgresAlertTable(db *sql.DB) PostgresAlertTable

func (*PostgresAlertTable) Create deprecated 

func (p *PostgresAlertTable) Create(alert *data_structures.Alert) error

Deprecated: use Insert

func (*PostgresAlertTable) Delete 

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

func (*PostgresAlertTable) DeleteExpiredAlerts 

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

func (*PostgresAlertTable) Exists 

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

func (*PostgresAlertTable) Find deprecated 

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

Deprecated: use Select

func (*PostgresAlertTable) FindAlertsByCode deprecated 

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

Deprecated: use SelectAlertsByCode

func (*PostgresAlertTable) Init deprecated 

func (p *PostgresAlertTable) Init() error

Deprecated: use the weather-db-migrator docker images for setup

func (*PostgresAlertTable) Insert 

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

func (*PostgresAlertTable) Select 

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

func (*PostgresAlertTable) SelectAlertsByCode 

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

type PostgresConvectiveOutlookTable 

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

func NewPostgresConvectiveOutlookTable 

func NewPostgresConvectiveOutlookTable(db *sql.DB) PostgresConvectiveOutlookTable

func (*PostgresConvectiveOutlookTable) Create deprecated 

func (p *PostgresConvectiveOutlookTable) Create(outlook *data_structures.ConvectiveOutlook) error

Deprecated: use Insert

func (*PostgresConvectiveOutlookTable) Find deprecated 

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

Deprecated: use Select

func (*PostgresConvectiveOutlookTable) FindLatest deprecated 

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

Deprecated: use SelectLatest

func (*PostgresConvectiveOutlookTable) Init deprecated 

func (p *PostgresConvectiveOutlookTable) Init() error

Deprecated: use the weather-db-migrator docker images for setup

func (*PostgresConvectiveOutlookTable) Insert 

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

func (*PostgresConvectiveOutlookTable) Select 

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

func (*PostgresConvectiveOutlookTable) SelectLatest 

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

type PostgresMesoscaleDiscussionTable 

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

func NewPostgresMesoscaleDicussionTable 

func NewPostgresMesoscaleDicussionTable(db *sql.DB) PostgresMesoscaleDiscussionTable

func (*PostgresMesoscaleDiscussionTable) Delete 

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

func (*PostgresMesoscaleDiscussionTable) Insert 

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

func (*PostgresMesoscaleDiscussionTable) Select 

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

func (*PostgresMesoscaleDiscussionTable) SelectMDNotInTable 

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

type PostgresUserNotificationTable 

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

func NewPostgresUserNotificationTable 

func NewPostgresUserNotificationTable(db *sql.DB) PostgresUserNotificationTable

func (*PostgresUserNotificationTable) Create deprecated 

func (p *PostgresUserNotificationTable) Create(userNotification data_structures.UserNotification) error

Deprecated: use Insert

func (*PostgresUserNotificationTable) Delete 

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

func (*PostgresUserNotificationTable) Get deprecated 

func (p *PostgresUserNotificationTable) Get(notificationId string) (*data_structures.UserNotification, error)

Deprecated: use Select

func (*PostgresUserNotificationTable) GetAll deprecated 

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

Deprecated: use SelectAll

func (*PostgresUserNotificationTable) GetByCodes deprecated 

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

Deprecated: use SelectByCodes

func (*PostgresUserNotificationTable) GetByUserId deprecated 

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

Deprecated: use SelectByUserId

func (*PostgresUserNotificationTable) GetNotificationsWithConvectiveOutlookOptions deprecated 

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

Deprecated: use SelectNotificationsWithConvectiveOutlook

func (*PostgresUserNotificationTable) Init deprecated 

func (p *PostgresUserNotificationTable) Init() error

Deprecated: use the weather-db-migrator docker images for setup

func (*PostgresUserNotificationTable) Insert 

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

func (*PostgresUserNotificationTable) Select 

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

func (*PostgresUserNotificationTable) SelectAll 

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

func (*PostgresUserNotificationTable) SelectByCodes 

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

func (*PostgresUserNotificationTable) SelectByUserId 

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

func (*PostgresUserNotificationTable) SelectNotificationsWithConvectiveOutlook 

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

func (*PostgresUserNotificationTable) SelectNotificationsWithMDNotifications 

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

SelectNotificationsWithMDNotifications Selects all of the notifications that want mesoscale discussion notifications. Note this does not fill out AlertOptions or SPCOptions in the returned UserNotifications struct

func (*PostgresUserNotificationTable) Update added in v3.6.0 

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

Source Files

View all Source files

Directories

Path Synopsis
common_tables

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.