postgres

Documentation

Index

• func OpenDB(cfg env.Config) (*sql.DB, error)
• type Postgres
• type Service
  • func NewService(db *sql.DB) *Service
  • func (f Service) AddUser(ctx context.Context, fullName string) (int, error)
  • func (f Service) Ping(ctx context.Context) error
  • func (f Service) UserFullName(ctx context.Context, id int) (string, error)

Functions

func OpenDB

func OpenDB(cfg env.Config) (*sql.DB, error)

OpenDB returns a new instance of DB associated with the given datasource name. caller should "defer db.Close()" after checking for error

Types

type Postgres

type Postgres interface {
	Ping(ctx context.Context) error
	AddUser(ctx context.Context, fullName string) (int, error)
	UserFullName(ctx context.Context, id int) (string, error)
}

Postgres holds the methods for the package

type Service

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

Service represents a service for managing records in the database

func NewService

func NewService(db *sql.DB) *Service

NewService creates a new Service

func (Service) AddUser

func (f Service) AddUser(ctx context.Context, fullName string) (int, error)

AddUser adds a new user

func (Service) Ping

func (f Service) Ping(ctx context.Context) error

Ping sends a SELECT 1 to the database as a connectivity test

func (Service) UserFullName

func (f Service) UserFullName(ctx context.Context, id int) (string, error)

UserFullName retrieves a user's FullName