func checkForReportSQL(dbhandle datastore.Dbhandle, runID string) (bool, error) {
var f int
var sqlStmt string
if config.Config.UseMySQL {
sqlStmt = "SELECT count(*) AS c FROM reports WHERE run_id = ?"
} else if config.Config.UsePostgreSQL {
sqlStmt = "SELECT count(*) AS c FROM goiardi.reports WHERE run_id = $1"
}
stmt, err := dbhandle.Prepare(sqlStmt)
if err != nil {
return false, err
}
defer stmt.Close()
err = stmt.QueryRow(runID).Scan(&f)
if err != nil {
if err == sql.ErrNoRows {
return false, nil
}
return false, err
}
if f > 0 {
return true, nil
}
return false, nil
}
