diff options
author | mattn <mattn.jp@gmail.com> | 2017-11-14 17:56:34 +0900 |
---|---|---|
committer | GitHub <noreply@github.com> | 2017-11-14 17:56:34 +0900 |
commit | ed69081a91fd053f17672236b0dd52ba7485e1a3 (patch) | |
tree | a0d6f8aa25ac60f78f4914b7cd0194eb18311524 /sqlite3_trace_test.go | |
parent | Merge pull request #440 from t2y/add-sqlite3-limit (diff) | |
parent | Move RegisterAggregator implementation (diff) | |
download | golite-ed69081a91fd053f17672236b0dd52ba7485e1a3.tar.gz golite-ed69081a91fd053f17672236b0dd52ba7485e1a3.tar.xz |
Merge pull request #479 from kenshaw/move-registeraggregator
Move RegisterAggregator implementation
Diffstat (limited to 'sqlite3_trace_test.go')
-rw-r--r-- | sqlite3_trace_test.go | 72 |
1 files changed, 0 insertions, 72 deletions
diff --git a/sqlite3_trace_test.go b/sqlite3_trace_test.go deleted file mode 100644 index 57a6757..0000000 --- a/sqlite3_trace_test.go +++ /dev/null @@ -1,72 +0,0 @@ -// Copyright (C) 2016 Yasuhiro Matsumoto <mattn.jp@gmail.com>. -// -// Use of this source code is governed by an MIT-style -// license that can be found in the LICENSE file. -// +build trace - -package sqlite3 - -import ( - "database/sql" - "testing" -) - -type sumAggregator int64 - -func (s *sumAggregator) Step(x int64) { - *s += sumAggregator(x) -} - -func (s *sumAggregator) Done() int64 { - return int64(*s) -} - -func TestAggregatorRegistration(t *testing.T) { - customSum := func() *sumAggregator { - var ret sumAggregator - return &ret - } - - sql.Register("sqlite3_AggregatorRegistration", &SQLiteDriver{ - ConnectHook: func(conn *SQLiteConn) error { - if err := conn.RegisterAggregator("customSum", customSum, true); err != nil { - return err - } - return nil - }, - }) - db, err := sql.Open("sqlite3_AggregatorRegistration", ":memory:") - if err != nil { - t.Fatal("Failed to open database:", err) - } - defer db.Close() - - _, err = db.Exec("create table foo (department integer, profits integer)") - if err != nil { - // trace feature is not implemented - t.Skip("Failed to create table:", err) - } - - _, err = db.Exec("insert into foo values (1, 10), (1, 20), (2, 42)") - if err != nil { - t.Fatal("Failed to insert records:", err) - } - - tests := []struct { - dept, sum int64 - }{ - {1, 30}, - {2, 42}, - } - - for _, test := range tests { - var ret int64 - err = db.QueryRow("select customSum(profits) from foo where department = $1 group by department", test.dept).Scan(&ret) - if err != nil { - t.Fatal("Query failed:", err) - } - if ret != test.sum { - t.Fatalf("Custom sum returned wrong value, got %d, want %d", ret, test.sum) - } - } -} |