github.com/code-to-go/safepool.lib@v0.0.0-20221205180519-ee25e63c226e/sql/sqlite_test.go (about)

     1  package sql
     2  
     3  import (
     4  	_ "embed"
     5  	"testing"
     6  
     7  	_ "github.com/mattn/go-sqlite3"
     8  )
     9  
    10  func TestDb(t *testing.T) {
    11  	// DbName = "safepool.test.db"
    12  	// DeleteDB()
    13  
    14  	// LoadSQLFromFile("sqlite.sql")
    15  	// err := OpenDB()
    16  	// assert.NoErrorf(t, err, "cannot open sqllite: %v", err)
    17  
    18  	// s, _, _, ok := GetConfig("", "identity.public")
    19  	// if !ok {
    20  	// 	err = SetConfig("", "identity.public", "test", 0, nil)
    21  	// 	assert.NoErrorf(t, err, "cannot set config: %v", err)
    22  	// 	s, _, _, ok = GetConfig("", "identity.public")
    23  	// }
    24  	// assert.Equal(t, "test", s, "cannot get config: %v", err)
    25  
    26  	// err = SetAccess(model.Transport{})
    27  	// assert.NoErrorf(t, err, "cannot add domain: %v", err)
    28  
    29  	// domains, err := GetDomains()
    30  	// assert.NoErrorf(t, err, "cannot list domains: %v", err)
    31  	// assert.Contains(t, domains, "public.safepool.zone", "cannot find expected domain")
    32  
    33  	// now := time.Unix(time.Now().Unix(), 0)
    34  	// err = SetFile(model.File{
    35  	// 	Domain:  "public.safepool.zone",
    36  	// 	Name:    "test.txt",
    37  	// 	Author:  security.Identity{},
    38  	// 	Hash:    []byte("hash"),
    39  	// 	ModTime: now,
    40  	// 	State:   model.LocalCreated,
    41  	// })
    42  	// assert.NoErrorf(t, err, "cannot set file: %v", err)
    43  
    44  	// f, err := GetFileByName("public.safepool.zone", "test.txt")
    45  	// assert.NoErrorf(t, err, "cannot get file: %v", err)
    46  	// assert.Equal(t, now, f.ModTime)
    47  
    48  	// err = SetEncKey("public.safepool.zone", 1, []byte("some key"))
    49  	// assert.NoErrorf(t, err, "cannot set key: %v", err)
    50  
    51  	// keys, err := GetEncKeys("public.safepool.zone")
    52  	// assert.NoErrorf(t, err, "cannot get keys: %v", err)
    53  	// assert.Len(t, keys, 1, "keys is not 1 size")
    54  	// assert.Equal(t, []byte("some key"), keys[1], "unexpected key value")
    55  
    56  	// err = CloseDB()
    57  	// assert.NoErrorf(t, err, "cannot close sqllite: %v", err)
    58  }