route.go

package main

import (
    "fmt"
	_ "github.com/go-sql-driver/mysql"
    "log"
)

type Route struct {
    id          int
    name        string
    code        string
    locations   []Location
    timeCreated string
}

func handleRequest(subRequest string) {
   if (subRequest == "list") {
       fmt.Println("list all routes now")
       getAllRoutes()
   } else {
       fmt.Println("Unknown request in route " + subRequest)
   }
}

func printRoute(route *Route) {
    fmt.Println("-------------------------")
    fmt.Println(fmt.Sprintf("%d %s %s %s",  route.id, route.name, route.code, route.timeCreated))
    fmt.Println("Points:")
    for i := range(route.locations) {
        location := route.locations[i]
        printLocation(&location)
    }
}

func getAllRoutes() {
    routes := readRoutesFromDatabase()
    fmt.Println("Number of routes found = ", len(routes))
    for i := range(routes) {
        route := routes[i]
        route.locations = getLocationsForRoute(route.id)
        printRoute(&route)
    }
}

func readRoutesFromDatabase() ([]Route) {

    // Prepare statement for reading data
    rows, err := db.Query("SELECT * FROM route")
    if err != nil {
        panic(err.Error()) // proper error handling instead of panic in your app
    }
    defer rows.Close()

    var routes []Route;
    for rows.Next() {
        route := Route{}
        err := rows.Scan(&route.id, &route.name, &route.code, &route.timeCreated)
        if err != nil {
            log.Fatal(err)
        }
        routes = append(routes, route)
    }
    err = rows.Err()
    if err != nil {
        log.Fatal(err)
    }
    return routes
}