Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.01 KB | None | 0 0
  1. func query(sqlQuery string) {
  2. psqlInfo := fmt.Sprintf("host=%s port=%d user=%s "+
  3. "password=%s dbname=%s sslmode=disable",
  4. host, port, user, password, dbname)
  5.  
  6. // Validate database params
  7. db, err := sql.Open(driver, psqlInfo)
  8.  
  9. // If returned any error
  10. if err != nil {
  11. panic(err)
  12. }
  13.  
  14. // Validate connection with database
  15. err = db.Ping()
  16. if err != nil {
  17. panic(err)
  18. }
  19.  
  20. // Execute query
  21. rows, err := db.Query(sqlQuery)
  22.  
  23. // Get all name of columns returned of query
  24. columns, _ := rows.Columns()
  25. // Save number of columns returned of query
  26. countColumns := len(columns)
  27.  
  28. var allRows []interface{}
  29.  
  30. for rows.Next() {
  31. values := make([]interface{}, countColumns)
  32. valuesPointers := make([]interface{}, countColumns)
  33.  
  34. for i := range columns {
  35. valuesPointers[i] = &values[i]
  36. }
  37.  
  38. if err := rows.Scan(valuesPointers...); err != nil {
  39. log.Fatal(err)
  40. }
  41.  
  42. allRows = append(allRows, values)
  43. }
  44.  
  45. fmt.Println(allRows)
  46. }
  47.  
  48. [871 AA 333 AA 3333 MERCEDES BENZ AGUM TESTETESTE 873 270 true 1980-01-01 00:00:00 +0000 +0000 4X2 ParanΓ‘ [115 49 48] [123 34 116 114 117 99 107 34 58 32 110 117 108 108 44 32 34 116 114 97 105 108 101 114 34 58 32 123 34 100 97 116 97 34 58 32 123 34 99 97 112 97 99 105 116 121 34 58 32 34 54 48 48 34 44 32 34 103 114 111 117 112 105 110 103 34 58 32 34 97 97 97 97 97 97 97 97 97 97 97 97 97 97 97 97 34 44 32 34 105 115 84 114 97 105 108 101 114 34 58 32 34 111 110 34 44 32 34 99 108 97 115 115 105 102 105 99 97 116 105 111 110 34 58 32 34 98 98 98 98 98 98 98 98 98 98 98 98 98 98 34 125 44 32 34 112 114 111 102 105 108 101 34 58 32 123 34 107 109 112 114 105 99 101 34 58 32 110 117 108 108 44 32 34 103 112 115 111 114 99 97 110 34 58 32 34 103 112 115 34 44 32 34 109 97 120 115 112 101 101 100 34 58 32 110 117 108 108 44 32 34 109 97 120 97 99 99 101 108 101 114 97 116 105 111 110 34 58 32 110 117 108 108 44 32 34 109 97 120 116 105 109 101 105 100 108 101 115 116 111 112 34 58 32 110 117 108 108 44 32 34 105 110 105 116 111 100 111 109 101 116 101 114 100 97 116 101 34 58 32 102 97 108 115 101 44 32 34 105 110 105 116 111 100 111 109 101 116 101 114 118 97 108 117 101 34 58 32 110 117 108 108 125 125 44 32 34 118 101 104 105 99 108 101 34 58 32 123 34 105 100 34 58 32 34 34 44 32 34 110 97 109 101 34 58 32 34 65 65 32 51 51 51 34 44 32 34 98 114 97 110 100 34 58 32 34 77 69 82 67 69 68 69 83 32 66 69 78 90 34 44 32 34 99 108 97 115 115 34 58 32 34 52 88 50 34 44 32 34 109 111 100 101 108 34 58 32 34 65 71 85 77 34 44 32 34 112 108 97 116 101 34 58 32 34 65 65 32 51 51 51 51 34 44 32 34 114 101 103 105 111 110 34 58 32 34 80 97 114 97 110 195 161 34 44 32 34 99 111 109 109 101 110 116 115 34 58 32 34 34 44 32 34 102 117 101 108 116 121 112 101 34 58 32 34 115 49 48 34 44 32 34 111 112 101 114 97 116 105 111 110 34 58 32 34 84 69 83 84 69 84 69 83 84 69 34 44 32 34 99 117 115 116 111 109 101 114 105 100 34 58 32 34 50 55 48 34 125 125]]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement