package main

type Item struct{
    ID string
    CourseID string
    PiLoc string
    FileExists bool
}

func db(itemID string) (*Item, error) {
    var item Item
    err := db.Query("SELECT * FROM TopicItems WHERE item_id = ? and item_type_id=1 order by item_order", itemID).Scan(&item)
    if err != nil {
        return nil, err
    }

    p := filepath.Join("..", "CourseResource", item.CourseID, "videos", itemID, item.PiLoc)
    _, err = os.Stat(p)
    item.FileExists = err == nil || !os.IsNotExist(err)

    return item, nil
}

func Handler() {
    res, err := db(itemID)
    if err != nil {
        json.Unmarshal(w, map[string]interface{}{
            "status": false,
            "err": err.Error(),
        })
        return
    }
    json.Unmarshal(w, map[string]interface{}{
        "status": true,
        "response": res,
    })
}