driver

package

v0.3.2 Latest Latest Go to latest Published: Aug 20, 2025 License: MIT Imports: 7 Imported by: 7

Details

This section is empty.

This section is empty.

This section is empty.

type Dialect interface {
	Placeholder(n int) string
	QuoteIdent(ident string) string
}

Dialect defines the SQL dialect abstraction.

type Driver struct {
	DB      *sql.DB
	Dialect Dialect
}

Driver wraps sql.DB with a dialect.

func Open(driverName, dsn string, maxOpen, maxIdle int, lifetime time.Duration) (*Driver, error)

Open initializes the DB connection with pooling configuration.

func (d *Driver) Begin() (Tx, error)

Begin starts a transaction and returns the Tx.

func (d *Driver) BeginTx(ctx context.Context, opts *sql.TxOptions) (Tx, error)

BeginTx starts a transaction with ctx and returns the Tx.

func (d *Driver) Close() error

Close closes the underlying DB.

func (d *Driver) Transaction(fn func(Tx) error) error

Transaction executes fn within a transaction.

func (d *Driver) TransactionContext(ctx context.Context, fn func(Tx) error) error

TransactionContext executes fn within a transaction using ctx.

type MySQLDialect struct{}

MySQLDialect implements Dialect for MySQL.

func (d MySQLDialect) Placeholder(_ int) string

func (d MySQLDialect) QuoteIdent(ident string) string

type PostgresDialect struct{}

PostgresDialect implements Dialect for PostgreSQL.

func (d PostgresDialect) Placeholder(n int) string

func (d PostgresDialect) QuoteIdent(ident string) string

type Tx struct{ *sql.Tx }

Tx wraps sql.Tx for transaction handling.