sqlscript

Documentation

Overview

Package sqlscript executes a multi-statement SQL script one statement at a time.

Executing a whole script in a single Exec is a convenience of some SQLite drivers only. The cgosqlite backend selected for TinyGo builds runs the first statement and silently ignores the rest, so every caller must split first.

Index

• func Exec(ctx context.Context, executor Executor, script string) error
• func Split(script string) []string
• type Executor

Functions

func Exec

func Exec(ctx context.Context, executor Executor, script string) error

Exec runs every statement in script in order.

func Split

func Split(script string) []string

Split divides a SQL script into individual statements. Semicolons inside string literals, quoted identifiers, comments, and CREATE TRIGGER bodies do not terminate a statement.

Types

type Executor

type Executor interface {
	ExecContext(ctx context.Context, query string, args ...any) (sql.Result, error)
}

Executor is the subset of *sql.DB and *sql.Tx used to run a script.