Dynamically generate struct fields from SQL QueryRow result

Question

I want to retrieve all fields of the row and than render them to html. I know how to do it and here is a code for a row with 3 fields:

type View struct {
    Id         int
    Name_and_requisits string
    Reg_Date  string
}
func getViewById(id int) (*View, error){
    var vie View
    row := db.QueryRow("select id, name_and_requisits, reg_date from book where id = ?;", id)
    err := row.Scan(&vie.Id, &vie.Name_and_requisites, &vie.Reg_Date)
    if err != nil {
        return nil, err
    }

    return &vie, nil
}

But in my table one row includes about 20 columns and i need all of them with their names but i dont want to create a nasted hardcoded struct. I have an idea like to generate struct fields dynamically, from names of columns, and than use row.Scan on it. Any ideas? Maybe map is better for this situation?

Thanks!

kylewbanks.com/blog/query-result-to-map-in-golang

Stephane Martin
– Stephane Martin

2017-09-16 17:34:45 +00:00
Commented Sep 16, 2017 at 17:34 — Stephane Martin
– Stephane Martin, Commented Sep 16, 2017 at 17:34
@StephaneMartin thanks, your answer helped me!

rocco
– rocco

2017-09-17 07:39:43 +00:00
Commented Sep 17, 2017 at 7:39 — rocco
– rocco, Commented Sep 17, 2017 at 7:39

Volker · Accepted Answer · 2017-09-16 20:50:54Z

3

generate struct fields dynamically

https://golang.org/pkg/reflect/#StructOf

But please: Don't do it.

answered Sep 16, 2017 at 20:50

Volker

42.6k8 gold badges86 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

RayfenWindspear Over a year ago

"Don't do it". Hah, no kidding. People always come from Python and want crazy weird flexibility without realizing that Go is a statically typed language, and that it's a good thing.

Mike Mackintosh Over a year ago

your guidance is worthy of a +1

rocco Over a year ago

@RayfenWindspear you right, Python is my background:) And less flexibility is a good thing in Go, i agree. It's like crazy flexibility of Joomla with crazy hangs vs self-maded CMS

Collectives™ on Stack Overflow

Dynamically generate struct fields from SQL QueryRow result

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related