sqlkv

package

v0.0.0-...-45da7de Latest Latest Go to latest Published: Mar 25, 2024 License: MIT Imports: 8 Imported by: 1

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

Repository

github.com/bingoohuang/gg

Links

Open Source Insights

README ¶

create table kv
(
    k       varchar(100) not null primary key,
    v       text,
    state   tinyint      not null default 1,
    updated datetime,
    created datetime     not null
)

Documentation ¶

Index ¶

Constants
func Default(s, defaultValue string) string
func DefaultDuration(s, defaultValue time.Duration) time.Duration
type Client
- func NewClient(c Config) (*Client, error)
type Config

Constants ¶

View Source

const (
	DefaultAllSQL    = `select k,v from kv where state = 1`
	DefaultGetSQL    = `select v from kv where k = :k and state = 1`
	DefaultInsertSQL = `insert into kv(k, v, state, created) values(:k, :v, 1, :time)`
	DefaultUpdateSQL = `update kv set v = :v, updated = :time, state = 1 where k = :k`
	DefaultDelSQL    = `update kv set state = 0  where k = :k`
)

Variables ¶

This section is empty.

Functions ¶

func Default ¶

func Default(s, defaultValue string) string

func DefaultDuration ¶

func DefaultDuration(s, defaultValue time.Duration) time.Duration

Types ¶

type Client ¶

type Client struct {
	Config
	// contains filtered or unexported fields
}

Client is a gokv.Store implementation for SQL databases.

func NewClient ¶

func NewClient(c Config) (*Client, error)

func (*Client) All ¶

func (c *Client) All() (kvs map[string]string, er error)

All list the keys in the store.

func (*Client) Del ¶

func (c *Client) Del(k string) (er error)

Del deletes the stored value for the given key. Deleting a non-existing key-value pair does NOT lead to an error. The key must not be "".

func (*Client) Get ¶

func (c *Client) Get(k string) (found bool, v string, er error)

Get retrieves the stored value for the given key. You need to pass a pointer to the value, so in case of a struct the automatic unmarshalling can populate the fields of the object that v points to with the values of the retrieved object's values. If no value is found it returns (false, nil).

func (*Client) Set ¶

func (c *Client) Set(k, v string) (er error)

Set stores the given value for the given key. Values are automatically marshalled to JSON or gob (depending on the configuration). The key must not be "" and the value must not be nil.

type Config ¶

type Config struct {
	DriverName     string
	DataSourceName string

	AllSQL    string
	GetSQL    string
	UpdateSQL string
	InsertSQL string
	DelSQL    string

	// RefreshInterval will Refresh the key values from the database in every Refresh interval.
	RefreshInterval time.Duration
}

Source Files ¶

View all Source files

sqlkv.go

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