go-redash-query

go-redash-query is a simple library to get structed data from redash query sources

Example

Source table

id	name	email
1	Dannyhann	rhrnak0501@gmail.com
2	foo	foo@example.com
3	bar	bar@example.com

Source query

SELECT id, name, email 
FROM test_user 
WHERE id > {{id}}
ORDER BY id ASC 
LIMIT {{size}}

Usage

package main

import (
	"fmt"
	"go-redash-query"
	"log"
)

var (
	redashQueryId = 1 // Redash QueryId
	redashApiUrl  = ""
	redashAPiKey  = ""
)

type TestUserData struct {
	Id    int    `json:"id" mapstructure:"id"`
	Name  string `json:"name" mapstructure:"name"`
	Email string `json:"email" mapstructure:"email"`
}

func main() {

	client := go_redash_query.CreateClient(redashApiUrl, redashAPiKey)

	queryData := go_redash_query.QueryData{
		MaxAge: 10,
		Parameters: go_redash_query.P{
			"id":   1,
			"size": 20,
		},
	}

	job, err := client.CreateJobWithQuery(redashQueryId, queryData)
	if err != nil {
		log.Fatalf("CreateJobWithQuery %s", err)
	}

	fetchedData, err := client.Fetch(job)
	if err != nil {
		log.Fatalf("Fetch %s", err)
	}

	users := make([]TestUserData, 0)

	err = fetchedData.GetDataWithStruct(&users)
	if err != nil {
		log.Fatal(err)
	}

	for _, user := range users {
		fmt.Printf("%d %s %s\n", user.Id, user.Name, user.Email)
	}
}