Named GET?

[tamis-laan]

How would I achieve the following, is there something like a NamedGET?

type RequestReport struct {
	Title       string `db:"title" json:"title"`
	Description string `db:"description" json:"description"`
}

type ResponseReport struct {
	Id          uuid.UUID `db:"id" json:"id"`
	Title       string    `db:"title" json:"title"`
	Description string    `db:"description" json:"description"`
}
// Construct the query
query := `
	INSERT INTO reports 
		(title, description) 
	VALUES 
		(:title, :description) 
	RETURNING *
`
err = db.Get(responseReport, query, requestReport)

[gab-aquino]

You can use db.NamedQuery to achieve that. Check this issue #83

Let me know if it works for you.

[tamis-laan]

@gab-aquino
I don't think that works, rows.Scan requires all separate arguments from the struct:

rows.Scan(&report.title, &report.description)

Instead of

rows.Scan(&report) 

This would make it cumbersome for larger structs.

[gab-aquino]

@tamis-laan

You can use rows.StructScan instead. https://jmoiron.github.io/sqlx/#advancedScanning

[tamis-laan]

@tamis-laan

You can use rows.StructScan instead. https://jmoiron.github.io/sqlx/#advancedScanning

Thnx for the tip, that would work:

type DB struct {
	*sqlx.DB
}

func (db DB) NamedGet(dest interface{}, query string, arg interface{}) error {

	// Execute the named query
	rows, err := db.NamedQuery(query, arg)

	// Error check
	if err != nil {
		return err
	}

	// Scan into struct
	if rows.Next() {
		err = rows.StructScan(&dest)
	}

	// Error check
	if err != nil {
		return err
	}

	// Success
	return nil
}