跳到主内容
版本:valkey_v0.x.x

MSSQL

Release Discord Test Security Linter

一个使用 microsoft/go-mssqldb 的 MSSQL 存储驱动程序。

注意:需要 Go 1.19 及以上版本

目录

签名

func New(config ...Config) Storage
func (s *Storage) Get(key string) ([]byte, error)
func (s *Storage) Set(key string, val []byte, exp time.Duration) error
func (s *Storage) Delete(key string) error
func (s *Storage) Reset() error
func (s *Storage) Close() error
func (s *Storage) Conn() *sql.DB

安装

MSSQL 在支持模块的最近 2 个 Go 版本上进行了测试。因此,如果你还没做,请务必先初始化一个

go mod init github.com/<user>/<repo>

然后安装 mssql 实现

go get github.com/gofiber/storage/mssql/v2

示例

导入存储包。

import "github.com/gofiber/storage/mssql/v2"

你可以使用以下方式创建一个存储

// Initialize default config
store := mssql.New()

// Initialize custom config
store := mssql.New(mssql.Config{
Host: "127.0.0.1",
Port: 1433,
Database: "fiber",
Table: "fiber_storage",
Reset: false,
GCInterval: 10 * time.Second,
SslMode: "disable",
})

// Initialize custom config using connection string
store := mssql.New(mssql.Config{
ConnectionURI: "sqlserver://user:password@localhost:1433?database=fiber"
Reset: false,
GCInterval: 10 * time.Second,
})

配置

// Config defines the config for storage.
type Config struct {
// Connection string to use for DB. Will override all other authentication values if used
//
// Optional. Default is ""
ConnectionURI string

// Host name where the DB is hosted
//
// Optional. Default is "127.0.0.1"
Host string

// Port where the DB is listening on
//
// Optional. Default is 1433
Port int

// Server username
//
// Optional. Default is ""
Username string

// Server password
//
// Optional. Default is ""
Password string

// Instance name
//
// Optional. Default is ""
Instance string

// Database name
//
// Optional. Default is "fiber"
Database string

// Table name
//
// Optional. Default is "fiber_storage"
Table string

// Reset clears any existing keys in existing Table
//
// Optional. Default is false
Reset bool

// Time before deleting expired keys
//
// Optional. Default is 10 * time.Second
GCInterval time.Duration

// The SSL mode for the connection
//
// Optional. Default is "disable"
SslMode string
}

默认配置

var ConfigDefault = Config{
ConnectionURI: "",
Host: "127.0.0.1",
Port: 1433,
Database: "fiber",
Table: "fiber_storage",
Reset: false,
GCInterval: 10 * time.Second,
SslMode: "disable",
}