sheetsync

Documentation

Index

• Variables
• func AddManualVerification(svc *sheets.Service, sheetID, handle, userID, proof string, plan int, ...) (string, error)
• func DoGetCurrentPage(svc *sheets.Service, sheetID string) (*sheets.Sheet, time.Time, time.Time, time.Time, string, error)
• func DoSyncGuild(svc *sheets.Service, guildID string, sheetID string, page *sheets.Sheet, ...)
• func DoSyncGuildV2(svc *sheets.Service, guildID string, sheetID string, page *sheets.Sheet, ...)
• func GetCurrentPage(svc *sheets.Service, sheetID string) (*sheets.Sheet, string, bool, error)
• func GetService() (*sheets.Service, error)
• func HasAccess(sheetID string) bool
• func HasRole(member *discordgo.Member, roleID string) bool
• func Init(session *discordgo.Session)
• func MapRows(rows []RoleRow) map[string]RoleRow
• func ParseDiscordHandle(handle string) (string, string)
• func SafeAccessor(values [][]interface{}) func(int, int) string
• func Scan()
• func Sweeper()
• func SyncGuild(svc *sheets.Service, guildID string)
• func UpdateFormatting(svc *sheets.Service, sheetID string, reqs []*sheets.Request) error
• func UpdateHandle(svc *sheets.Service, sheetID string, page *sheets.Sheet, row RoleRow, ...) error
• type RoleRow
  • func ReadAllAutomatic(svc *sheets.Service, sheetID string, sheet *sheets.Sheet) ([]RoleRow, error)
  • func ReadAllExclude(svc *sheets.Service, sheetID string, sheet *sheets.Sheet) ([]RoleRow, error)
  • func ReadAllManual(svc *sheets.Service, sheetID string, sheet *sheets.Sheet) ([]RoleRow, error)
  • func (r *RoleRow) ColorRequest(color sheets.Color) *sheets.Request
  • func (r *RoleRow) Handle() string
• type RowRange

Variables

var BlueHighlight = sheets.Color{
	Red:   0.624,
	Green: 0.773,
	Blue:  0.91,
	Alpha: 1.0,
}

var GOOGLE_CLIENT_ID string

var GOOGLE_SECRET string

var GreenHighlight = sheets.Color{
	Red:   0.714,
	Green: 0.843,
	Blue:  0.659,
	Alpha: 1.0,
}

var RedHighlight = sheets.Color{
	Red:   0.918,
	Green: 0.6,
	Blue:  0.6,
	Alpha: 1.0,
}

var Session *discordgo.Session

var YellowHighlight = sheets.Color{
	Red:   1,
	Green: 0.898,
	Blue:  0.6,
	Alpha: 1.0,
}

Functions

func AddManualVerification

func AddManualVerification(svc *sheets.Service, sheetID, handle, userID, proof string, plan int, verifiedBy string) (string, error)

func DoGetCurrentPage

func DoGetCurrentPage(svc *sheets.Service, sheetID string) (*sheets.Sheet, time.Time, time.Time, time.Time, string, error)

func DoSyncGuild

func DoSyncGuild(svc *sheets.Service, guildID string, sheetID string, page *sheets.Sheet,
	ensureAlpha func(*discordgo.Member, RoleRow, *[]RoleRow, *bool, *bool),
	ensureSpecial func(*discordgo.Member, RoleRow, *[]RoleRow, *bool, *bool),
	ensureWhale func(*discordgo.Member, RoleRow, *[]RoleRow, *bool, *bool),
	ensureFanbox func(*discordgo.Member, RoleRow, *[]RoleRow, *bool, *bool),
	ensureNoAlpha func(*discordgo.Member, RoleRow, *[]RoleRow, *bool, *bool),
	ensureNoSpecial func(*discordgo.Member, RoleRow, *[]RoleRow, *bool, *bool),
	ensureNoWhale func(*discordgo.Member, RoleRow, *[]RoleRow, *bool, *bool),
	ensureNoFanbox func(*discordgo.Member, RoleRow, *[]RoleRow, *bool, *bool),
	report func([]RoleRow, []RoleRow, []RoleRow, []RoleRow, []RoleRow, []RoleRow, []RoleRow), doFormat bool)

func DoSyncGuildV2

func DoSyncGuildV2(svc *sheets.Service, guildID string, sheetID string, page *sheets.Sheet,
	ensureAlpha func(*discordgo.Member, RoleRow, *[]RoleRow, *bool, *bool),
	ensureSpecial func(*discordgo.Member, RoleRow, *[]RoleRow, *bool, *bool),
	ensureWhale func(*discordgo.Member, RoleRow, *[]RoleRow, *bool, *bool),
	ensureFanbox func(*discordgo.Member, RoleRow, *[]RoleRow, *bool, *bool),
	ensureNoAlpha func(*discordgo.Member, RoleRow, *[]RoleRow, *bool, *bool),
	ensureNoSpecial func(*discordgo.Member, RoleRow, *[]RoleRow, *bool, *bool),
	ensureNoWhale func(*discordgo.Member, RoleRow, *[]RoleRow, *bool, *bool),
	ensureNoFanbox func(*discordgo.Member, RoleRow, *[]RoleRow, *bool, *bool),
	report func([]RoleRow, []RoleRow, []RoleRow, []RoleRow, []RoleRow, []RoleRow, []RoleRow), doFormat bool)

func GetCurrentPage

func GetCurrentPage(svc *sheets.Service, sheetID string) (*sheets.Sheet, string, bool, error)

func GetService

func GetService() (*sheets.Service, error)

func HasAccess

func HasAccess(sheetID string) bool

func HasRole

func HasRole(member *discordgo.Member, roleID string) bool

func Init

func Init(session *discordgo.Session)

func MapRows

func MapRows(rows []RoleRow) map[string]RoleRow

func ParseDiscordHandle

func ParseDiscordHandle(handle string) (string, string)

func SafeAccessor

func SafeAccessor(values [][]interface{}) func(int, int) string

SafeAccessor Provides a function to safely extract string values from the given Values object (which is not necessarily padded for the full range)

func Scan

func Scan()

func Sweeper

func Sweeper()

func SyncGuild

func SyncGuild(svc *sheets.Service, guildID string)

func UpdateFormatting

func UpdateFormatting(svc *sheets.Service, sheetID string, reqs []*sheets.Request) error

func UpdateHandle

func UpdateHandle(svc *sheets.Service, sheetID string, page *sheets.Sheet, row RoleRow, newHandle string) error

Types

type RoleRow

type RoleRow struct {
	Row           int
	Range         RowRange
	Username      string
	Discriminator string
	UserID        string
	TimeStr       string
	Plan          int
}

func ReadAllAutomatic

func ReadAllAutomatic(svc *sheets.Service, sheetID string, sheet *sheets.Sheet) ([]RoleRow, error)

func ReadAllExclude

func ReadAllExclude(svc *sheets.Service, sheetID string, sheet *sheets.Sheet) ([]RoleRow, error)

func ReadAllManual

func ReadAllManual(svc *sheets.Service, sheetID string, sheet *sheets.Sheet) ([]RoleRow, error)

func (*RoleRow) ColorRequest

func (r *RoleRow) ColorRequest(color sheets.Color) *sheets.Request

func (*RoleRow) Handle

func (r *RoleRow) Handle() string

type RowRange

type RowRange struct {
	PageID   int64
	RowStart int64
	RowEnd   int64
	ColStart int64
	ColEnd   int64
}