diff options
Diffstat (limited to 'dependencies/pkg/mod/github.com/lib/pq@v1.10.7/notice_example_test.go')
-rw-r--r-- | dependencies/pkg/mod/github.com/lib/pq@v1.10.7/notice_example_test.go | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/dependencies/pkg/mod/github.com/lib/pq@v1.10.7/notice_example_test.go b/dependencies/pkg/mod/github.com/lib/pq@v1.10.7/notice_example_test.go new file mode 100644 index 0000000..04bcb1d --- /dev/null +++ b/dependencies/pkg/mod/github.com/lib/pq@v1.10.7/notice_example_test.go @@ -0,0 +1,34 @@ +//go:build go1.10 +// +build go1.10 + +package pq_test + +import ( + "database/sql" + "fmt" + "log" + + "github.com/lib/pq" +) + +func ExampleConnectorWithNoticeHandler() { + name := "" + // Base connector to wrap + base, err := pq.NewConnector(name) + if err != nil { + log.Fatal(err) + } + // Wrap the connector to simply print out the message + connector := pq.ConnectorWithNoticeHandler(base, func(notice *pq.Error) { + fmt.Println("Notice sent: " + notice.Message) + }) + db := sql.OpenDB(connector) + defer db.Close() + // Raise a notice + sql := "DO language plpgsql $$ BEGIN RAISE NOTICE 'test notice'; END $$" + if _, err := db.Exec(sql); err != nil { + log.Fatal(err) + } + // Output: + // Notice sent: test notice +} |