sqlitebuilder

Jun 26, 2024

Changes in this version

+ var RegCount = regexp.MustCompile("(?is)^(SELECT).*?(FROM)")

+ var RegLimit = regexp.MustCompile(`(?is)LIMIT\s+(\d+|\?)(?:\s*,\s*(\d+|\?))*\s*$`)

+ var RegOrderLimit = regexp.MustCompile(...)

+ func BuildDBDriver(opts *Options) string

+ type Count struct

+ Count int64

+ type DBConnect struct

+ ContextTx contextKey

+ Options *Options

+ func New(opts ...Option) (*DBConnect, error)

+ func (db *DBConnect) Exec(ctx context.Context, query string, args ...any) (lastInsertId, rowsAffected int64, err error)

+ func (db *DBConnect) Query(ctx context.Context, query string, args ...any) (results []map[string]any, count int64, err error)

+ func (db *DBConnect) Select(ctx context.Context, dest any, query string, args ...any) (count int64, err error)

+ func (db *DBConnect) SelectAll(ctx context.Context, dest any, query string, args ...any) (count int64, err error)

+ func (db *DBConnect) SelectMany(ctx context.Context, dest any, query string, args ...any) (count int64, err error)

+ func (db *DBConnect) SelectOne(ctx context.Context, dest any, query string, args ...any) (err error)

+ type MultiSelect func(ctx context.Context, dest any, query string, args ...any) (count int64, err error)

+ type Option func(opts *Options)

+ func WithCharset(charset string) Option

+ func WithDBFilePath(DBFilePath string) Option

+ func WithDBName(dbName string) Option

+ func WithHost(host string) Option

+ func WithLoc(loc string) Option

+ func WithPass(pass string) Option

+ func WithPoolSize(size int) Option

+ func WithPort(port int) Option

+ func WithUser(user string) Option

+ type Options struct

+ Charset string

+ DBFilePath string

+ DBName string

+ Host string

+ Loc string

+ Pass string

+ PoolSize int

+ Port int

+ User string