Guest User

Untitled

a guest
Jan 22nd, 2018
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.31 KB | None | 0 0
  1. type MyStruct struct {
  2. ColumnA string `json:"columnA,omitempty"`
  3. ColumnB string `json:"columnB,omitempty"`
  4. ColumnC string `json:"columnC,omitempty"`
  5. }
  6.  
  7. var res MyStruct
  8. var Db *sqlx.DB = getDb()
  9. query := `
  10. SELECT
  11. columnB,
  12. columnA
  13. FROM
  14. myTable
  15. WHERE
  16. local_id = $1
  17. `
  18.  
  19. err = cfg.Db.Get(&res, query, 3)
  20.  
  21. func doSelect(string query) {
  22. args := map[string]interface{}{
  23. "local_id": 3,
  24. }
  25. //ignore error for question
  26. rows, err := db.NamedQuery(query, args)
  27. for rows.Next() {
  28. var res MyStruct
  29. //scan into res somehow
  30. }
  31. }
  32.  
  33. query1 := `
  34. SELECT
  35. columnB,
  36. columnA
  37. FROM
  38. myTable
  39. WHERE
  40. local_id = :local_id
  41. query2 := `
  42. SELECT
  43. columnC,
  44. columnA
  45. FROM
  46. myTable
  47. WHERE
  48. local_id = :local_id
  49. query3 := `
  50. SELECT
  51. columnC,
  52. columnA,
  53. columnB
  54. FROM
  55. myTable
  56. WHERE
  57. local_id = :local_id
  58.  
  59. doSelect(query1)
  60. doSelect(query2)
  61. doSelect(query3)
Add Comment
Please, Sign In to add comment