func getMoves(moveId int) []*Move {
fmt.Println("getting move %d", moveId)
db := arena.GetConnection()
// XXX do a join here to get player name
query := "SELECT fourup_column, player, played FROM fourup_moves WHERE match_id = $1"
rows, err := db.Query(query, moveId)
checkError(err)
var moves []*Move
for rows.Next() {
var m Move
var pId int
err = rows.Scan(&m.Column, &pId, &m.Played)
checkError(err)
player, err := arena.GetPlayerById(pId)
checkError(err)
player.SetHref()
m.Player = player.Href
moves = append(moves, &m)
}
return moves
}
func moves(ctx *web.Context, matchId string) []byte {
db := arena.GetConnection()
// XXX do a join here to get player name
query := "SELECT fourup_column, player, played FROM fourup_moves WHERE match_id = $1"
rows, err := db.Query(query, matchId)
checkError(err)
var moves []*Move
for rows.Next() {
var m Move
var pId int
err = rows.Scan(&m.Column, &pId, &m.Played)
checkError(err)
player, err := arena.GetPlayerById(pId)
checkError(err)
player.SetHref()
m.Player = player.Href
moves = append(moves, &m)
}
jsonMoves, err := json.Marshal(moves)
checkError(err)
return jsonMoves
}
