db

package

v0.0.0-...-6c16969 Latest Latest Go to latest Published: Nov 29, 2020 License: GPL-3.0 Imports: 3 Imported by: 1

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 Connect() *sql.DB

func GetJobForPerson(db *sql.DB, personId int) (*[]Job, error)

func GetPersons(db *sql.DB) (*[]Person, error)

func InsertJob(db *sql.DB, job *Job) (int, error)

func InsertPerson(db *sql.DB, person *Person) (int, error)

type Job struct {
	Id       int    `json:"id"`
	JobName  string `json:"job_name"`
	PersonId int    `json:"personId"`
}

func GetJob(db *sql.DB, jobId int) (*Job, error)

type Person struct {
	Id       int    `json:"id"`
	Name     string `json:"name"`
	PersonId int    `json:"personId"`
	Admin    bool   `json:"admin"`
}

func GetPerson(db *sql.DB, personId int) (*Person, error)