func main() {
var (
id int
name string
)
db = database.CreateConnection()
rows := readRows()
defer rows.Close()
for rows.Next() {
err := rows.Scan(&id, &name)
helper.CheckError(err)
fmt.Println(id, name)
}
name, num := readJson()
fmt.Println(name, num)
db.Close()
}
func readJson() (string, int) {
var data = []byte(`{"mahesh" :{"a":12, "b1":{"as":123}}}`)
/*var result map[string]map[string]interface{}
if err := json.Unmarshal(data, &result); err != nil {
fmt.Println("error", err)
}
fmt.Println("status value: \a", result["mahesh"]["a"])
*/
/*var parsed interface{}
err := json.Unmarshal(data, &parsed)
helper.CheckError(err)
fmt.Println(parsed[:mahesh])
*/
var mahi Mahesh1
err := json.Unmarshal(data, &mahi)
helper.CheckError(err)
fmt.Println(mahi.Mahesh.B1)
readDir()
return "m123", 10
}
func readRows() *sql.Rows {
rows, err := db.Query("SELECT id, name from user_details where id=$1", 1)
helper.CheckError(err)
return rows
}