// ScheduleList returns a list of all saved schedules
func (d *SQLite) ScheduleList() ([]*spec.Schedule, error) {
rows, err := d.Connection.Query("SELECT * FROM "+schedulesTable, nil)
if err != nil {
return nil, err
}
defer rows.Close()
var ss []*spec.Schedule
for rows.Next() {
var id, backup int
var body []byte
err = rows.Scan(&id, &backup, &body)
if err != nil {
return nil, err
}
var s spec.Schedule
json.Unmarshal(body, &s)
s.Backup = backup
s.ID = id
ss = append(ss, &s)
}
return ss, nil
}
