summaryrefslogtreecommitdiff
path: root/model/db.go
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--model/db.go13
1 files changed, 7 insertions, 6 deletions
diff --git a/model/db.go b/model/db.go
index 2e42192..5b6feb0 100644
--- a/model/db.go
+++ b/model/db.go
@@ -6,14 +6,15 @@ package model
import (
"context"
- "database/sql"
+
+ "github.com/jackc/pgx/v5"
+ "github.com/jackc/pgx/v5/pgconn"
)
type DBTX interface {
- ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
- PrepareContext(context.Context, string) (*sql.Stmt, error)
- QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
- QueryRowContext(context.Context, string, ...interface{}) *sql.Row
+ Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
+ Query(context.Context, string, ...interface{}) (pgx.Rows, error)
+ QueryRow(context.Context, string, ...interface{}) pgx.Row
}
func New(db DBTX) *Queries {
@@ -24,7 +25,7 @@ type Queries struct {
db DBTX
}
-func (q *Queries) WithTx(tx *sql.Tx) *Queries {
+func (q *Queries) WithTx(tx pgx.Tx) *Queries {
return &Queries{
db: tx,
}