sqlconv

README

sqlconv

sqlconv is a Go library converts between Go values and SQL values.

Installation

go get github.com/dochang/sqlconv

Usage

Currently, sqlconv provides a interface ScannerConverter, which is used to convert SQL values to Go values.

type ScannerConverter interface {
	ScanConvert(dest, src any) error
}

ScanConvert converts SQL value src to Go value, then writes the Go value into dest.

A predefined variable DefaultScannerConverter converts SQL values based on the rules defined by the function "database/sql".convertAssign.

Documentation

Overview

Package sqlconv converts between Go values and SQL values.

Currently, sqlconv provides a interface ScannerConverter, which is used to convert SQL values to Go values:

type ScannerConverter interface {
  ScanConvert(dest, src any) error
}

sqlconv.ScannerConverter.ScanConvert converts SQL value src to Go value, then writes the Go value into dest.

A predefined variable DefaultScannerConverter converts SQL values based on the rules defined by the function database/sql.convertAssign.

Index

• Variables
• type RawBytes
• type Rows
• type Scanner
• type ScannerConverter

Examples

• ScannerConverter

Variables

var DefaultScannerConverter defaultScannerConverter

DefaultScannerConverter is the default implementation of ScannerConverter.

DefaultScannerConverter converts value by calling convertAssign.

Types

type RawBytes

type RawBytes = sql.RawBytes

type Rows

type Rows = sql.Rows

type Scanner

type Scanner = sql.Scanner

type ScannerConverter

type ScannerConverter interface {
	// ScanConvert converts a SQL value src to a Go value dest.
	ScanConvert(dest, src any) error
}

ScannerConverter is the interface providing the ScanConvert method.

ScannerConverter converts SQL value to Go value.

Example

var deststr string
srctime := time.Unix(1, 0).UTC()
err := DefaultScannerConverter.ScanConvert(&deststr, srctime)
fmt.Println(err)
fmt.Println(deststr)

Output:

<nil>
1970-01-01T00:00:01Z