db

package

v0.0.0-...-77c539c Latest Latest Go to latest Published: Oct 4, 2021 License: MIT Imports: 8 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

This section is empty.

This section is empty.

func Init() error

Init is used to initialize the SQL Database

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

Database is a wrapper around the SQL database to allow addition of methods

func New() *Database

New returns an instance of Database Use this when you don't want to clear the DB

func (DB *Database) AddEvents(events *ctftime.Events) error

AddEvents adds a slice of Events in the database

func (DB *Database) Close()

Close closes the connetion to the database, can call this with defer in main

func (DB *Database) DeleteEventByID(eventID int) error

DeleteEventByID deletes the event with ID eventID

func (DB *Database) GetEvents() (ctftime.Events, error)

GetEvents returns Events from the database

func (DB *Database) GetEventsByStatus(status utils.Status) (ctftime.Events, error)

GetEventsByStatus returns events depending upon the Status attribute

func (DB *Database) GetRegisteredChannels() ([]string, error)

GetRegisteredChannels returns all ChannelIDs from the notify table

func (DB *Database) ModifyEventStatus(eventID int, status utils.Status) error

ModifyEventStatus modifies the status of the event identified by the eventID

func (DB *Database) Ping()

Ping allows you to ping the database and check if connection is possible

func (DB *Database) RegisterForNotifs(ChannelID string) error

RegisterForNotifs adds a Channel to the notify table