README
¶
sqljsondb 
a key-value json document DB but use MySQL as storage
Usage
db := sqljsondb.New("user:pass@tcp(127.0.0.1:3306)/dbname", "")
db.Write("people", "1", "Alice")
db.Write("people", "2", "Bob")
var name string
db.Read("people", "2", name)
fmt.Println(name) /// Bob
fmt.Println(db.Keys("people")) /// {"1", "2"}
db.WriteIgnore("people", "2", "Bob") /// Does nothing because document "2" is already "Bob"
db.WriteIgnore("people", "2", "Evil") /// Document "2" updated to "Evil"
For more usage check doc
Documentation
¶
Index ¶
- func DeepEqualRaw(a, b []byte) bool
- type Driver
- func (t *Driver) DB() gorose.IOrm
- func (t *Driver) Keys(col string) ([]string, error)
- func (t *Driver) KeysWhereSQL(col string, WhereSQL string) ([]string, error)
- func (t *Driver) Read(col string, key string, v interface{}) error
- func (t *Driver) ReadRaw(col string, key string) ([]byte, error)
- func (t *Driver) ReadWithJsoniter(col string, key string, v interface{}) error
- func (t *Driver) TableName(col string) string
- func (t *Driver) TryCreateTable(col string) error
- func (t *Driver) Write(col string, key string, i interface{}) error
- func (t *Driver) WriteIgnore(col string, key string, i interface{}) error
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
func DeepEqualRaw ¶
/ Compare if two JSON string is equal in object level.
Types ¶
type Driver ¶
type Driver struct {
DSN string
DBEngine *gorose.Engin
TablePrefix string
ExistsCol sync.Map
AfterUpdateFunc func(col string, key string, i interface{})
// contains filtered or unexported fields
}
func (*Driver) KeysWhereSQL ¶
/ Get all keys of a collection with customize SQL WHERE condition. / Warning: You have to make sure there is no SQL injection vulnerability in WhereSQL string.
func (*Driver) ReadWithJsoniter ¶
/ Read the object and unmarshal it to v, but with jsoniter encoder, this may speed up a little.
func (*Driver) TryCreateTable ¶
/ Try to create table for the collection
Source Files
Click to show internal directories.
Click to hide internal directories.