Dicky arya Kesuma dickyaryag6
dickyaryag6
/ spreadsheet_clearrow.go
Last active
August 21, 2021 07:48
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| func ClearRow(srv *sheets.Service) { | |
| cvr := &sheets.ClearValuesRequest{} | |
| _, err := srv.Spreadsheets.Values.Clear(spreadsheetId, "Sheet1!A7:E7", cvr).Do() | |
| if err != nil { | |
| log.Fatalf("Unable to clear data from sheet: %v", err) | |
| } | |
| } |
dickyaryag6
/ spreadsheet_update.go
Last active
August 21, 2021 07:38
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| func Update(srv *sheets.Service) { | |
| values := &sheets.ValueRange{ | |
| Values: [][]interface{}{{ | |
| "Japan", | |
| "Software Engineer Lead", | |
| }}, | |
| } | |
| _, err := srv.Spreadsheets.Values.Update(spreadsheetId, "Sheet1!B2:C2", values).ValueInputOption("USER_ENTERED").Do() |
dickyaryag6
/ spreadsheet_get.go
Created
July 6, 2021 00:05
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| func GetCellValue(srv *sheets.Service) { | |
| values, err := srv.Spreadsheets.Values.Get(spreadsheetId, "Sheet1!A6:E7").Do() | |
| if err != nil { | |
| log.Fatalf("Unable to Get data from sheet: %v", err) | |
| } | |
| fmt.Println(values.Values) | |
| } |
dickyaryag6
/ spreadsheet_append.go
Last active
August 21, 2021 11:56
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| func AppendRow(srv *sheets.Service) { | |
| values := &sheets.ValueRange{ | |
| Values: [][]interface{}{{ | |
| "Timmy", | |
| "Malaysia", | |
| "Software Engineer", | |
| 23, | |
| "05/07/1998", | |
| }}, |
dickyaryag6
/ spreadsheet_value.go
Last active
August 21, 2021 08:13
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| values := &sheets.ValueRange{ | |
| Values: [][]interface{}{{ | |
| "Timmy", | |
| "Malaysia", | |
| "Software Engineer", | |
| 23, | |
| "05/07/1998", | |
| }}, | |
| } |
dickyaryag6
/ main.go
Created
July 6, 2021 00:03
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| func main() { | |
| srv := getSheetConfig() | |
| // APPEND ROW | |
| AppendRow(srv) | |
| // GET VALUES | |
| GetCellValue(srv) |
dickyaryag6
/ spreadsheet_config.go
Created
July 6, 2021 00:00
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| func getSheetConfig() *sheets.Service { | |
| credential, err := json.Marshal(sheetKey) | |
| if err != nil { | |
| log.Fatalf("Failed to get key: %v", err) | |
| } | |
| srv, err := sheets.NewService(context.Background(), option.WithCredentialsJSON(credential)) | |
| if err != nil { | |
| log.Fatalf("Unable to retrieve Sheets client: %v", err) | |
| } |
dickyaryag6
/ spreadsheet_keys.go
Last active
August 21, 2021 08:23
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| var ( | |
| spreadsheetId string = "17_V0gRP4z4VE5dHT2u5m44QBCIAUD_ov2i" | |
| sheetKey Key = Key{ | |
| Type: "service_account", | |
| ProjectID: "sheet-projec", | |
| PrivateKeyID: "xxxxx", | |
| PrivateKey: "-----BEGIN PRIVATE KEY-----\xxxxx=\n-----END PRIVATE KEY-----\n", | |
| ClientEmail: "sheet-service-account@xxxxx.iam.gserviceaccount.com", | |
| ClientID: "xxxxx", |
dickyaryag6
/ redis.go
Created
September 13, 2020 17:15
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package sessions | |
| import ( | |
| "encoding/json" | |
| "fmt" | |
| "github.com/go-redis/redis" | |
| "log" | |
| "time" | |
| ) |
dickyaryag6
/ main.go
Last active
September 13, 2020 17:32
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| func main() { | |
| e := echo.New() | |
| //sessions.SessionsStore = NewMemoryStore() | |
| sessions.SessionsStore = sessions.NewRedisStore() | |
| e.GET("/login", authentication.Login) | |
| g := e.Group("/hello") | |
| //Use Middleware to verify JWT Token |