如何在GoLang中的结构数组中分配一组行（从数据库中检索）？

Question

I am trying to retrieve a set of rows from postgresql and trying to assign it in an array of structure. My code goes like this :

var test []Demo
    err := sqlx.Get(db,&test, `
                    select *
                    from demo
                    where id = $1`,
                    5,
            )
            if err != nil {
                    fmt.Println("Error",err)
                    fmt.Println("DatabaseExtraction Error")
                    return nil, errors.Wrap(err, "select error")
            } else {
                    fmt.Println("No Extraction Error")
            }

I have a structure like this :

type Demo struct {
        ID         int64         `db:"id"`
        Name       string        `db:"name"`
}

But I am getting an error like this Error scannable dest type slice with >1 columns (2) in result (code: 2) Also I don't get any error if I replace var test []Demo with var test Demo.

Answer 1

If you call Get it expects only one row to be returned. If you want to select multiple rows, use Select and pass a pointer to your slice. For example:

var rows []Demo
err := sqlx.Select(&rows, `SELECT * FROM "demo"`)
// ...