Function queryDatabase

26 - Databases/data/main.go:17–33

(db *sql.DB)

}

func queryDatabase(db *sql.DB) (products []Product, err error) {
    rows, err := db.Query(`SELECT Products.Id, Products.Name, Products.Price, 
            Categories.Id as "Category.Id", Categories.Name as "Category.Name" 
            FROM Products, Categories 
            WHERE Products.Category = Categories.Id`)
    if (err != nil) {
        return
    } else {
        results, err := scanIntoStruct(rows, &Product{})
        if err == nil {
            products = (results).([]Product)
        } else {
            Printfln("Scanning error: %v", err)
        }
    }
    return
}

func main() {    
    db, err := openDatabase()