database

package

v0.0.0-...-721f978 Latest Latest Go to latest Published: Aug 22, 2017 License: MIT Imports: 5 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

Package database defines method for interacting with PostgreSQL for persistent data.

This section is empty.

This section is empty.

This section is empty.

type DB struct {
	*sql.DB
}

DB is a type used by external packages to implement database operations. DB should be initialized via DBConn function.

func DBConn(dbType, host, user, password string) (DB, error)

DBConn returns a new DB, initialized to connect to the database

func (db DB) DeleteReadings(core string, start, end time.Time) error

DeleteReadings deletes readings within a specified time span from the database

func (db DB) GetLatestReadings(userEmail string) ([]models.Reading, error)

GetLatestReadings retrieves the latest readings for a particular user from the database.

func (db DB) GetReadings(core string, start, end time.Time) ([]models.Reading, error)

GetReadings gets readings within a specified time span from the database

func (db DB) GetSecret(userEmail string) (secret models.Secret, err error)

GetSecret retreives the secret from the database for the specified user.

func (db DB) GetUser(email string) (models.User, error)

GetUser gets information from the database pertaining to the specified user.

func (db DB) StoreReading(reading models.Reading) error

StoreReading stores a new reading in the database

func (db DB) StoreSecret(userEmail string, secret models.Secret) error

StoreSecret updates the specified user's secret in the database

func (db DB) StoreUser(user models.User) error

StoreUser inserts the specified user's information in the database.