Skip to main content

Prepare

Exec Statements

A statment is created with bob.Prepare().

ctx := context.Background()
db, err := bob.Open("postgres", "...")
if err != nil {
// ...
}

q := psql.Update(...)

// Pepare the statement
stmt, err := bob.Prepare(ctx, db, q)
if err != nil {
// ...
}

Prepared statments can then be reused as many times as we want.

// Use our prepared statment
_, err := stmt.Exec(ctx)
if err != nil {
// ...
}

Query Statements

Statements that are expected to return rows, are instead prepared with bob.PrepareQuery or bob.PrepareQueryx.

In addition to Exec, this statmeenet also has One, All and Cursor methods.

q := psql.Select(...)

// Pepare the statement
stmt, err := bob.PrepareQuery(ctx, db, q, scan.StructMapper[userObj]())
if err != nil {
// ...
}

// Use our prepared statment
users, err := stmt.All(ctx)
if err != nil {
// ...
}