database/gdb: How to set the isolation level for the current transaction

[LanceAdd]

Is your feature request related to a problem?

Option Yes

Describe the solution you'd like

current Transaction

Transaction(ctx context.Context, f func(ctx context.Context, tx TX) error) error

and

Begin(ctx context.Context) (TX, error) 

target Transaction

Transaction(ctx context.Context, f func(ctx context.Context, tx TX) error, opts ...*TxOptions) error

Begin(ctx context.Context, opts ...*TxOptions) (TX, error) 

Describe alternatives you've considered

I can set the transaction isolation level in "database/sql", but I can't find the corresponding entry in the goframe

import (
    "database/sql"
)

txOptions := &sql.TxOptions{
    Isolation: sql.LevelRepeatableRead,
    ReadOnly:  true,
}

tx, err := db.BeginTx(ctx, txOptions)
if err != nil {
    // todo
}
defer tx.Rollback()

err = tx.Commit()
if err != nil {
      // todo
}

Additional

No response

[gqcn]

@LanceAdd Hi, I'm planning adding such feature recently.