sqlite

package

v0.5.0 Latest Latest Go to latest Published: Apr 27, 2020 License: BSD-3-Clause Imports: 8 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/henderjon/dbconnect

Links

Open Source Insights

Documentation ¶

Index ¶

Constants
func MustConnect(dsn string, opts ...Option) *sql.DB
func ParseSQLiteDateTime(t string) time.Time
type Option

Constants ¶

View Source

const (
	FmtTimestampDay    = datetimes.FmtTimestampDay
	FmtTimestampHour   = datetimes.FmtTimestampHour
	FmtTimestampMinute = datetimes.FmtTimestampMinute
	FmtDateTime        = datetimes.FmtDateTime
	FmtDate            = datetimes.FmtDate
	FmtTime            = datetimes.FmtTime

	// SQLite datetime format strings
	SQLiteFmtDatetime = "%Y-%m-%d %H:%M:%S"
	SQLiteFmtMinute   = "%Y-%m-%d %H:%M"
	SQLiteFmtHour     = "%Y-%m-%d %H"
	SQLiteFmtDay      = "%Y-%m-%d"
)

View Source

const (
	ERR_UNDEFINED_DSN = "connection error: SQLite DSN '%s' is undefined\n"
)

Variables ¶

This section is empty.

Functions ¶

func MustConnect ¶

func MustConnect(dsn string, opts ...Option) *sql.DB

MustConnect returns a new DB connection

func ParseSQLiteDateTime ¶ added in v0.3.0

func ParseSQLiteDateTime(t string) time.Time

Types ¶

type Option ¶

type Option func(db *sql.DB) error

func BusyTimeout ¶ added in v0.4.0

func BusyTimeout(milliseconds int) Option

BusyTimeout 1000 milliseconds == 1 second

func CacheSize ¶

func CacheSize(cacheSize int) Option

CacheSize defaults to '-2000' which is 2.048MB

func Encoding ¶ added in v0.5.0

func Encoding(charset string) Option

Encoding set the encoding of the DB; should be "UTF-8"

func EncodingUTF8 ¶

func EncodingUTF8() Option

func Journal ¶ added in v0.5.0

func Journal(mode string) Option

func JournalWAL ¶

func JournalWAL() Option

func MaxOpenConnections ¶

func MaxOpenConnections(conns int) Option

func PageSize ¶

func PageSize(pageSize int) Option

PageSize the default is 4096 and is recommended

func Vacuum ¶

func Vacuum() Option

Vacuum rebuilds the DB file to keep it tidy

func WALCheckpoint ¶

func WALCheckpoint() Option

WalCheckpoint commits the WAL; DO NOT USE

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL