[Question]: How to get sql.Tx with orignal database/sql ?

[BeanWei]

I write a plugin for my project, but I don't want to rely on upper/db.

I need get the tx *sql.Tx from upper db db.Session. How can i do?

[gmhafiz]

For reference, code is in

db/session.go

Line 70 in cb7617e

// internalSQLDriver := sess.Driver().(*sql.DB)

To use

internalSQLDriver := sess.Driver().(*sql.DB)
tx, err := internalSQLDriver.BeginTx(ctx, &sql.TxOptions{
    Isolation: ...
    ReadOnly:  ...,
})