install issues about qframe HOT 12 CLOSED

package main

import (
	"database/sql"
	"fmt"

	_ "github.com/go-sql-driver/mysql"
	"github.com/tobgu/qframe"
	qsql "github.com/tobgu/qframe/config/sql"
)

func main() {
	db, _ := sql.Open("mysql", "root:qframe_test@/mysql")
	db.Exec(`
	CREATE TABLE test (
		COL1 INT,
		COL2 REAL,
		COL3 TEXT,
		COL4 BOOL
	);`)
	qf := qframe.New(map[string]interface{}{
		"COL1": []int{1, 2, 3},
		"COL2": []float64{1.1, 2.2, 3.3},
		"COL3": []string{"one", "two", "three"},
		"COL4": []bool{true, true, true},
	})
	fmt.Println(qf)
	tx, _ := db.Begin()
	qf.ToSQL(
		tx,
		qsql.Table("test"),
		qsql.MySQL(),
	)
	newQf := qframe.ReadSQL(
		tx,
		qsql.Query("SELECT * FROM test"),
		qsql.Coerce(
			qsql.CoercePair{Column: "COL4", Type: qsql.Int64ToBool},
		),
		qsql.MySQL(),
	)
	fmt.Println(newQf)
	fmt.Println(newQf.Equals(qf))
	tx.Commit() // save your changes to the db
}

package main

// - Single import statement with ordered list of imports
import (
	"fmt"
	"github.com/tobgu/qframe"
	"github.com/tobgu/qframe/config/groupby"
	"math"
	"net/url"
)

// - Use camel case variable and function names, start with lower case if not intended to be public.
// - In general avoid suffixing or prefixing variable names with the type name (list in this example, which 
//   is really a slice). That may be used in dynamic langs such as Python but is given by the static type in Go.
// - I've removed a bunch of temporary/intermediate variables that I did not think contributed to clarity but
//   only to line count. This is a matter of taste though.
// - Always run "go fmt" on your code to make the formatting consistent. Also consider adding something like
//   https://github.com/golangci/golangci-lint to your builds as that will produce results that you can learn from.
func intMax(x, y int) int {
	if x > y {
		return x
	}
	return y
}

func getPosts(profileName string, done chan string) {
	api := connect()
	
	// - Always check for errors in production code.
	v, _ := url.ParseQuery("screen_name=" + profileName + "&count=5&include_rts=False&tweet_mode=extended")
	searchResult, _ := api.GetUserTimeline(v)
	
	// - Consider replacing the below declarations with something like:
	//       ids := make([]string, 0, len(searchResults))
	//   That will preallocate the underlying array of the slice to be of the correct length
	ids := []string{}
	dates := []string{}
	favs := []int{}
	rts := []int{}
	ages := []float64{}
	hours := []string{}
	days := []string{}
	handles := []string{}
	interactions := []int{}
	randomId := []int{}
	media := []int{}
	totalRetweets, totalFavourites, maxRt, maxFav := 0, 0, 0, 0
	for _, value := range searchResult {
		ids = append(ids, value.IdStr)
		dates = append(dates, cleanDate(value.CreatedAt))
		favs = append(favs, value.FavoriteCount)
		rts = append(rts, value.RetweetCount)
		roundedAge := math.Floor(calcAge(value.CreatedAt)*100) / 100
		ages = append(ages, roundedAge)
		hours = append(hours, extractHour(createdAt))
		days = append(days, extractDay(createdAt))
		handles = append(handles, profileName)
		interactions = append(interactions, value.FavoriteCount + value.RetweetCount)
		randomId = append(randomId, 1)
		media = append(media, len(value.ExtendedEntities.Media))
		totalFavourites += value.FavoriteCount
		totalRetweets += value.RetweetCount
		maxFav = intMax(maxFav, value.FavouriteCount)
		maxRt = intMax(maxRt, value.RetweetCount)
	}

	fmt.Println(totalFavourites)
	fmt.Println(totalRetweets)
	fmt.Println(maxFav)
	fmt.Println(maxRt)
	
	// Load data into qframe
	f := qframe.New(map[string]interface{}{
		"mediaIncluded":    media,
		"tweetID":          ids,
		"randomId":         randomId,
		"handle":           handles,
		"createdAt":        dates,
		"age":              ages,
		"favoriteCount":    favs,
		"retweetCount":     rts,
		"interactionCount": interactions,
		"hour":             hours,
		"day":              days,
	})
	
	// - Replace explicit loops with "in-frame" operations to tag max favourites and retweets
	isEqual := func(expectedVal int) func(int) string {
		return func(val int) string {
			if expectedVal == val {
				return "YES"
			}
			return "NO"
		}
	}
	f = f.Apply(
		qframe.Instruction{Fn: isEqual(maxFav), DstCol: "favouriteMax", SrcCol1: "favoriteCount"},
		qframe.Instruction{Fn: isEqual(maxRt), DstCol: "retweetMax", SrcCol1: "retweetCount"})
	
	fmt.Println(f)
	
	// aggregate for each date, sum favorites, retweets and total interactions
	// - Replace custom sum function with QFrame built in "sum"
	g := f.GroupBy(groupby.Columns("createdAt")).Aggregate(
		qframe.Aggregation{Fn: "sum", Column: "interactionCount"},
		qframe.Aggregation{Fn: "sum", Column: "retweetCount"},
		qframe.Aggregation{Fn: "sum", Column: "favoriteCount"},
		qframe.Aggregation{Fn: "sum", Column: "randomId"})
	fmt.Println(g)

	done <- "Detailed Profile Complete"
}