gotokatsuya / bigquery

bigquery is easy for go developers to use BigQuery API

bigquery

Written in go.

This is inspired by Nice BigQuery Project.

Install

go get github.com/gotokatsuya/bigquery

How to use it

const (
	email      = "[email protected]"
	pemKeyPath = "project-name.pem"

	projectID = "project-name"
	datasetID = "dataset-name"
	tableID   = "table-name"
)

// Count ...
func Count() (int, error) {
	client, err := bigquery.NewClient(email, pemKeyPath)
	if err != nil {
		return 0, err
	}
	composer := bigquery.NewDefaultComposer(projectID, datasetID)
	count, err := composer.Count(client, tableID)
	if err != nil {
		return 0, err
	}
	return count, nil
}

// GetOneRecord ...
func GetOneRecord() ([][]interface{}, error) {
	client, err := bigquery.NewClient(email, pemKeyPath)
	if err != nil {
		return nil, err
	}
	composer := bigquery.NewDefaultComposer(projectID, datasetID)
	rows, err := composer.Query(client, fmt.Sprintf("SELECT * FROM [%s.%s] LIMIT 1;", datasetID, tableID))
	if err != nil {
		return nil, err
	}
	
	// rows[ number of row ][ number of column ]
	// For example, When a table has 'id' as first column, table_id := rows[0][0].(string)
	
	return rows, nil
}