database

Documentation

Index

• type DB
  • func New() (*DB, error)
  • func (db *DB) CreateKey(name string) (string, error)
  • func (db *DB) GetKeys() ([]Key, error)
  • func (db *DB) RemoveKey(id int) error
• type Key

Types

type DB

type DB struct {
	*sqlx.DB
}

func New

func New() (*DB, error)

New connects to the postgres database and returns the database instance.

func (*DB) CreateKey

func (db *DB) CreateKey(name string) (string, error)

CreateKey takes a name and creates for it a new row in the keys table.

func (*DB) GetKeys

func (db *DB) GetKeys() ([]Key, error)

GetKeys returns all the keys from the keys table.

func (*DB) RemoveKey

func (db *DB) RemoveKey(id int) error

RemoveKey takes an id and remove the row associated to it in the keys table.

type Key

type Key struct {
	Id        int       `db:"id" json:"id"`
	CreatedAt time.Time `db:"created_at" json:"created_at"`
	UpdatedAt time.Time `db:"updated_at" json:"updated_at"`
	Name      string    `db:"name" json:"name"`
	Key       string    `db:"key" json:"key"`
}