README
¶
Summary
SQLiter provides a simplified interface for storing flat structs to disk. It is meant to be easy to use and quick to get started but not to be particularly powerful.
The utility is in adding structored data persistence to a golang project in just a few lines of code.
Usage
Init
type MyStruct struct {
ID int64 `db:"id" attr:"PRIMARY KEY"`
Value string `db:"value"`
}
db, _ := sqliter.Open(dbName)
db.CreateTable(MyStruct{})
Insert
db.Insert(MyStruct{Value:"foo"})
Read
myStruct := &MyStruct{}
db.ReadOne(myStruct, "id = ?", 1)
Update
myStruct.Value = "bar"
db.Update(myStruct, "id = ?", 1)
Delete
db.Delete(MyStruct{}, "id = ?", 1)
Documentation
¶
Index ¶
- Constants
- type Sqliter
- func (s *Sqliter) Close()
- func (s *Sqliter) CreateTable(sample interface{}) error
- func (s *Sqliter) Delete(sample interface{}, where string, args ...interface{}) error
- func (s *Sqliter) DeleteFrom(table, where string, args ...interface{}) error
- func (s *Sqliter) Exec(q string, args ...interface{}) (sql.Result, error)
- func (s *Sqliter) Insert(obj interface{}) (int64, error)
- func (s *Sqliter) ReadMany(outPtr interface{}, where string, args ...interface{}) error
- func (s *Sqliter) ReadOne(outPtr interface{}, where string, args ...interface{}) error
- func (s *Sqliter) Update(obj interface{}, where string, args ...interface{}) error
- func (s *Sqliter) Upsert(obj interface{}, where string, args ...interface{}) (int64, error)
- type StructField
Constants ¶
View Source
const InMemory = ":memory:"
Variables ¶
This section is empty.
Functions ¶
This section is empty.
Types ¶
Source Files
Click to show internal directories.
Click to hide internal directories.