Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- type MyStruct struct {
- ColumnA string `json:"columnA,omitempty"`
- ColumnB string `json:"columnB,omitempty"`
- ColumnC string `json:"columnC,omitempty"`
- }
- var res MyStruct
- var Db *sqlx.DB = getDb()
- query := `
- SELECT
- columnB,
- columnA
- FROM
- myTable
- WHERE
- local_id = $1
- `
- err = cfg.Db.Get(&res, query, 3)
- func doSelect(string query) {
- args := map[string]interface{}{
- "local_id": 3,
- }
- //ignore error for question
- rows, err := db.NamedQuery(query, args)
- for rows.Next() {
- var res MyStruct
- //scan into res somehow
- }
- }
- query1 := `
- SELECT
- columnB,
- columnA
- FROM
- myTable
- WHERE
- local_id = :local_id
- query2 := `
- SELECT
- columnC,
- columnA
- FROM
- myTable
- WHERE
- local_id = :local_id
- query3 := `
- SELECT
- columnC,
- columnA,
- columnB
- FROM
- myTable
- WHERE
- local_id = :local_id
- doSelect(query1)
- doSelect(query2)
- doSelect(query3)
Add Comment
Please, Sign In to add comment