go - 如何在循环中为每次迭代重复调用一个函数，获取其结果然后将结果附加到一个 slice 中(Golang？

Question

我有 ff:

func getSlice(distinctSymbols []string) []symbols {
    // Prepare connection
    stmt1, err := db.Prepare("Select count(*) from stockticker_daily where symbol = $1;")
    checkError(err)
    defer stmt1.Close()
    stmt2, err := db.Prepare("Select date from stockticker_daily where symbol = $1 order by date asc limit 1;")
    checkError(err)
    defer stmt2.Close()
    var symbolsSlice []symbols
    c := make(chan symbols)
    for _, symbol := range distinctSymbols {
        go worker(symbol, stmt1, stmt2, c)
        **symbolsFromChannel := <-c**
        **symbolsSlice = append(symbolsSlice, symbolsFromChannel})**
    }
    return symbolsSlice
}

func worker(symbol string, stmt1 *sql.Stmt, stmt2 *sql.Stmt, symbolsChan chan symbols) {
    var countdp int
    var earliestdate string
    row := stmt1.QueryRow(symbol)
    if err := row.Scan(&countdp); err != nil {
        log.Fatal(err)
    }
    row = stmt2.QueryRow(symbol)
    if err := row.Scan(&earliestdate); err != nil {
        log.Fatal(err)
    }
    symbolsChan <- symbols{symbol, countdp, earliestdate}
}

请看一下第一个函数，我知道它不会像我预期的那样工作，因为行 symbolsFromChannel := <-c将阻塞直到它从 channel 接收，因此 goroutine 上的迭代 go worker除非删除 block ，否则不会继续。最好或正确的方法是什么？

Answer 1

只需执行两次循环，例如

for _, symbol := range distinctSymbols {
        go worker(symbol, stmt1, stmt2, c)
}
for range distinctSymbols {
        symbolsSlice = append(symbolsSlice, <-c)
}