dsc - SQL, NoSQL,结构化文件的数据存储连接
dsc - SQL, NoSQL,结构化文件的数据存储连接
Go 数据库工具/驱动
共20Star
详细介绍
Datastore Connectivity (dsc)
This library is compatible with Go 1.10+
Please refer to CHANGELOG.md
if you encounter breaking changes.
- Motivation
- Usage
- Prerequisites
- Installation
- API Documentaion
- Tests
- Examples
- License
- Credits and Acknowledgements
Motivation
This library was developed as part of dsunit (Datastore unit testibility library) to provide unified access to SQL, noSQL, or any other store that deals with structured data in SQL-ish way.
Usage:
The following is a very simple example of CRUD operations with dsc
package main
import (
)
func main() {
config := dsc.NewConfig("mysql", "[user]:[password]@[url]", "user:root,password:dev,url:tcp(127.0.0.1:3306)/mydb?parseTime=true")
factory := NewManagerFactory()
manager, err := factory.Create(config)
if err != nil {
panic(err.Error())
}
// manager := factory.CreateFromURL("file:///etc/myapp/datastore.json")
interest := Interest{}
success, err:= manager.ReadSingle(&interest, SELECT id, name, expiry, category FROM interests WHERE id = ?", []interface{}{id},nil)
if err != nil {
panic(err.Error())
}
var intersts = make([]Interest, 0)
err:= manager.ReadAll(&interests, SELECT id, name, expiry, category FROM interests", nil ,nil)
if err != nil {
panic(err.Error())
}
intersts := []Interest {
Interest{Name:"Abc", ExpiryTimeInSecond:3600, Category:"xyz"},
Interest{Name:"Def", ExpiryTimeInSecond:3600, Category:"xyz"},
Interest{Id:20, Name:"Ghi", ExpiryTimeInSecond:3600, Category:"xyz"},
}
inserted, updated, err:= manager.PersistAll(&intersts, "interests", nil)
if err != nil {
panic(err.Error())
}
deleted, err := manager.DeleteAll(&intersts, "intersts", nil)
if err != nil {
panic(err.Error())
}
fmt.Printf("Inserted %v, updated: %v\n", deleted)
}
More examples illustrating the use of the API are located in the examples
directory.
Details about the API are available in the docs
directory.
Prerequisites
Go version v1.5+ is required.
To install the latest stable version of Go, visit http://golang.org/dl/
Target
Installation:
- Install Go 1.5+ and setup your environment as Documented here.
- Get the client in your
GOPATH
:go get github.com/viant/dsc
- To update the client library:
go get -u github.com/viant/dsc
Some Hints:
- To run a go program directly:
go run <filename.go>
- to build:
go build -o <output> <filename.go>
API Documentation
API documentation is available in the docs
directory.
Tests
This library is packaged with a number of tests. Tests require Testify library.
Before running the tests, you need to update the dependencies:
$ go get .
To run all the test cases with race detection:
$ go test
Examples
A simple CRUD applications is provided in the examples
directory.
GoCover
License
The source code is made available under the terms of the Apache License, Version 2, as stated in the file LICENSE
.
Individual files may be made available under their own specific license, all compatible with Apache License, Version 2. Please see individual files for details.
Credits and Acknowledgements
Library Author: Adrian Witas
Contributors: Sudhakaran Dharmaraj