123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120 |
- package database
- /*
- ArOZ Online Database Access Module
- author: tobychui
- This is an improved Object oriented base solution to the original
- aroz online database script.
- */
- import (
- "sync"
- )
- type Database struct {
- Db interface{} //This will be nil on openwrt and *bolt.DB in the rest of the systems
- Tables sync.Map
- ReadOnly bool
- }
- func NewDatabase(dbfile string, readOnlyMode bool) (*Database, error) {
- return newDatabase(dbfile, readOnlyMode)
- }
- /*
- Create / Drop a table
- Usage:
- err := sysdb.NewTable("MyTable")
- err := sysdb.DropTable("MyTable")
- */
- func (d *Database) UpdateReadWriteMode(readOnly bool) {
- d.ReadOnly = readOnly
- }
- //Dump the whole db into a log file
- func (d *Database) Dump(filename string) ([]string, error) {
- return d.dump(filename)
- }
- //Create a new table
- func (d *Database) NewTable(tableName string) error {
- return d.newTable(tableName)
- }
- //Check is table exists
- func (d *Database) TableExists(tableName string) bool {
- return d.tableExists(tableName)
- }
- //Drop the given table
- func (d *Database) DropTable(tableName string) error {
- return d.dropTable(tableName)
- }
- /*
- Write to database with given tablename and key. Example Usage:
- type demo struct{
- content string
- }
- thisDemo := demo{
- content: "Hello World",
- }
- err := sysdb.Write("MyTable", "username/message",thisDemo);
- */
- func (d *Database) Write(tableName string, key string, value interface{}) error {
- return d.write(tableName, key, value)
- }
- /*
- Read from database and assign the content to a given datatype. Example Usage:
- type demo struct{
- content string
- }
- thisDemo := new(demo)
- err := sysdb.Read("MyTable", "username/message",&thisDemo);
- */
- func (d *Database) Read(tableName string, key string, assignee interface{}) error {
- return d.read(tableName, key, assignee)
- }
- func (d *Database) KeyExists(tableName string, key string) bool {
- return d.keyExists(tableName, key)
- }
- /*
- Delete a value from the database table given tablename and key
- err := sysdb.Delete("MyTable", "username/message");
- */
- func (d *Database) Delete(tableName string, key string) error {
- return d.delete(tableName, key)
- }
- /*
- //List table example usage
- //Assume the value is stored as a struct named "groupstruct"
- entries, err := sysdb.ListTable("test")
- if err != nil {
- panic(err)
- }
- for _, keypairs := range entries{
- log.Println(string(keypairs[0]))
- group := new(groupstruct)
- json.Unmarshal(keypairs[1], &group)
- log.Println(group);
- }
- */
- func (d *Database) ListTable(tableName string) ([][][]byte, error) {
- return d.listTable(tableName)
- }
- func (d *Database) Close() {
- d.close()
- }
|