| 53 | } |
| 54 | |
| 55 | func TestBadType(t *testing.T) { |
| 56 | // invalid storage |
| 57 | invalidString1 := "file:test.db?p1" |
| 58 | |
| 59 | st, err := New(invalidString1) |
| 60 | if err == nil { |
| 61 | defer st.Close() |
| 62 | t.Fatalf("should occurred error: %v", st) |
| 63 | } |
| 64 | |
| 65 | st = &Storage{ |
| 66 | dsn: invalidString1, |
| 67 | db: nil, |
| 68 | } |
| 69 | err = st.Close() |
| 70 | if err == nil { |
| 71 | t.Fatalf("should occurred error: %v", st) |
| 72 | } |
| 73 | |
| 74 | // valid storage |
| 75 | st, err = New("file::memory:") |
| 76 | defer st.Close() |
| 77 | |
| 78 | if err != nil { |
| 79 | t.Fatalf("error occurred: %v", err) |
| 80 | } |
| 81 | |
| 82 | if err = st.Prepare(context.Background(), struct{}{}); err == nil { |
| 83 | t.Fatal("unexpected result: returned nil while expecting an error") |
| 84 | } else { |
| 85 | t.Logf("Error occurred as expected: %v", err) |
| 86 | } |
| 87 | |
| 88 | if _, err = st.Commit(context.Background(), struct{}{}); err == nil { |
| 89 | t.Fatal("unexpected result: returned nil while expecting an error") |
| 90 | } else { |
| 91 | t.Logf("Error occurred as expected: %v", err) |
| 92 | } |
| 93 | |
| 94 | if err = st.Rollback(context.Background(), struct{}{}); err == nil { |
| 95 | t.Fatal("unexpected result: returned nil while expecting an error") |
| 96 | } else { |
| 97 | t.Logf("Error occurred as expected: %v", err) |
| 98 | } |
| 99 | |
| 100 | // empty query |
| 101 | _, _, _, err = st.Query(context.Background(), []Query{}) |
| 102 | if err != nil { |
| 103 | t.Fatal("empty query should be successed") |
| 104 | } |
| 105 | _, err = st.Exec(context.Background(), []Query{}) |
| 106 | if err != nil { |
| 107 | t.Fatal("empty exec should be successed") |
| 108 | } |
| 109 | } |
| 110 | |
| 111 | func TestStorage(t *testing.T) { |
| 112 | fl, err := ioutil.TempFile("", "sqlite3-") |