I use https://github.com/jmoiron/sqlx to make queries to Postgres. Is it possible to get back the whole row data when inserting a new row? Here is the query I run: result, err := Db.Exec("INSERT...

Question When dealing with a one-to-many or many-to-many SQL relationship in Golang, what is the best (efficient, recommended, "Go-like") way of mapping the rows to a struct? Taking the example s...

I have difficulty querieing for users, which is defined as: type User struct { ID int `db:"id" json:"id"` UserName string `db:"username" json:"username"` Email string `db:"email" json:"email"...

I have below golang code which is working fine when there is no null value in the table. But in my table some column called "MIDDLE_NAME" has null value and hence I am getting error Scan...

Let's assume that I have two models, type Customer struct { Id int `json:"id" db:"id"` Name string `json:"name" db:"name"` Address Address `json:"ad...

I'am trying to make a bulk insert with sqlx and golang : for _, result := range results { queryInsert := `INSERT INTO "DataCom_travel" (com1,com2,path,time) VALUES ($1,$2,$3,$4)` db.MustExec(q...

I have error when use sqlx with postgresql : "missing destination name rec_created_by" type Client struct { ClientID string `json:"client_id" db:"id"` Name string `json:"name" db:"name"` Versio...

After a period of inactivity, my go web service is getting a net.OpError with message read tcp x.x.x.x:52086->x.x.x.x:24414: read: connection reset by peer when executing the first postgres sql ...

I have a model like this: type Course struct { Name string `db:"course_name"` } type Group struct { Course *Course } type Groups []Group And when i try to do sqlx.Select for Groups with a que...

I'm using sqlx with mysql database and want to query author table for names which start with certain letters. Here is the query: sqlx.DB.Select(&authors, "SELECT * FROM author WHERE first_name...

I want to query a table in mysql database for values IN a slice: var qids []int //fill qids dynamically err = database.SQL.Select(&quotes, "SELECT * FROM quote WHERE qid IN $1", qids) if err ...

I have searched the error and I have find two questions: This one, but my question is not duplicate of it And this one, but there is no answer in this question. Here is my code: package main ...

I use jmoiron/sqlx library for communicating with my PostgreSql server in my Go apps. Somewhere on my apps i have this following code: sqlQuery := ` INSERT INTO table_to_insert ( code, status,...

I have a struct with a property time: type Basket struct { ... Created_at time.Time `db:"created_at"` } with the time saved as: basket.Created_at = time.Now().UTC() If I save it using Ins...

I'm using a non-framework Go stack with sqlx, and MySQL for a web project. I would like to log all outgoing SQL statements for debugging. Is it possible to do this? Hopefully looking to get outpu...