Is it possible to support sql.QueryRow function. about ora HOT 4 CLOSED

stmt.QryRow, stmt.PrepAndQryRow, returning the rset.Row ([]interface{}) and error?

Please create a PR!

from ora.

@tgulacsi I assumed that QueryRow wasn't working since it was written as such in the README. But while I was checking the database/sql code it seems that QueryRow isn't a function dependent on the driver so I tested the QueryRow function in my own apps. Everything is working as expected. Please correct me if I am wrong. This is the implementation of QueryRow in database/sql package

func (db *DB) QueryRow(query string, args ...interface{}) *Row {
        rows, err := db.Query(query, args...)
        return &Row{rows: rows, err: err}
}

And the statement code is similar. So this looks like a utility function around Query. Am I missing something ?

from ora.

No, this is a general function - just as everything in database/sql.
I've thought you want a similar utility funtion for the ora-specific
ora.Stmt type.

Be warned though that QueryRow closes the query on return - usually not a
problem, except when it is: when you want to use the returned handler, such
asa LOB handler - in that case, use Query, and close by han d.

omerkirk [email protected] ezt írta (időpont: 2016. febr. 23., K,
17:07):

@tgulacsi https://github.com/tgulacsi I assumed that QueryRow wasn't
working since it was written as such in the README. But while I was
checking the database/sql code it seems that QueryRow isn't a function
dependent on the driver. Please correct me if I am wrong. This is the
implementation:

func (db *DB) QueryRow(query string, args ...interface{}) *Row {
rows, err := db.Query(query, args...)
return &Row{rows: rows, err: err}
}

And the statement code is similar. So this looks like a utility function
around Query. Am I missing something ?

—
Reply to this email directly or view it on GitHub
#63 (comment).

from ora.

I assumed QueryRow is an optional interface function that the drivers can choose to implement since it is allowed to not support it. Sorry for that. I'll close this issue.

from ora.