sheets

Documentation

Index

• func CreateGoogleSheetClient(serviceAccountJsonPath string) (*sheets.Service, error)
• type Columns
• type Record
• type Sheet
  • func GetSheet(srv *sheets.Service, cfg config.SpreadsheetRemote) (*Sheet, error)
  • func NewSheet(cfg config.SpreadsheetRemote) (*Sheet, error)
  • func (s *Sheet) AddRow(session models.Session) error
  • func (s *Sheet) ParseHeaders(row []interface{})
  • func (s *Sheet) ParseSheet(records *[]Record) error
  • func (s *Sheet) SessionFromRow(row []interface{}) (*models.Session, error)
  • func (s *Sheet) SessionToRow(session models.Session) []interface{}
  • func (s *Sheet) UpdateRow(record Record) error

Functions

func CreateGoogleSheetClient

func CreateGoogleSheetClient(serviceAccountJsonPath string) (*sheets.Service, error)

Types

type Columns

type Columns struct {
	ID        string
	Client    string
	Date      string
	StartTime string
	EndTime   string
	TotalTime string
	Note      string
}

type Record

type Record struct {
	Session models.Session
	Row     int
}

type Sheet

type Sheet struct {
	Service       *sheets.Service
	SpreadsheetId string
	SheetName     string
	Columns       Columns
}

func GetSheet

func GetSheet(srv *sheets.Service, cfg config.SpreadsheetRemote) (*Sheet, error)

func NewSheet

func NewSheet(cfg config.SpreadsheetRemote) (*Sheet, error)

func (*Sheet) AddRow

func (s *Sheet) AddRow(session models.Session) error

func (*Sheet) ParseHeaders

func (s *Sheet) ParseHeaders(row []interface{})

func (*Sheet) ParseSheet

func (s *Sheet) ParseSheet(records *[]Record) error

func (*Sheet) SessionFromRow

func (s *Sheet) SessionFromRow(row []interface{}) (*models.Session, error)

func (*Sheet) SessionToRow

func (s *Sheet) SessionToRow(session models.Session) []interface{}

func (*Sheet) UpdateRow

func (s *Sheet) UpdateRow(record Record) error