diff options
author | EuAndreh <eu@euandre.org> | 2024-10-18 17:54:26 -0300 |
---|---|---|
committer | EuAndreh <eu@euandre.org> | 2024-10-20 03:36:18 -0300 |
commit | f00c41fd4e6af8cd0db80c118a3bb4abef09604e (patch) | |
tree | 46ad14d55cfe591691cf214076e8aea81edbfe18 /tests/acudego.go | |
parent | .gitignore: Remove .so (diff) | |
download | golite-f00c41fd4e6af8cd0db80c118a3bb4abef09604e.tar.gz golite-f00c41fd4e6af8cd0db80c118a3bb4abef09604e.tar.xz |
Shoehorn project into default golang skeleton structure
Diffstat (limited to 'tests/acudego.go')
-rw-r--r-- | tests/acudego.go | 142 |
1 files changed, 60 insertions, 82 deletions
diff --git a/tests/acudego.go b/tests/acudego.go index cb9e672..de41ca9 100644 --- a/tests/acudego.go +++ b/tests/acudego.go @@ -406,7 +406,7 @@ func TestSimpleError(t *testing.T) { } func TestCorruptDbErrors(t *testing.T) { - dirName, err := ioutil.TempDir("", "acudego") + dirName, err := ioutil.TempDir("", "FIXME") if err != nil { t.Fatal(err) } @@ -420,7 +420,7 @@ func TestCorruptDbErrors(t *testing.T) { f.Write([]byte{1, 2, 3, 4, 5}) f.Close() - db, err := sql.Open("acudego", dbFileName) + db, err := sql.Open(DriverName, dbFileName) if err == nil { _, err = db.Exec("drop table foo") } @@ -436,13 +436,13 @@ func TestCorruptDbErrors(t *testing.T) { } func TestSqlLogicErrors(t *testing.T) { - dirName, err := ioutil.TempDir("", "acudego") + dirName, err := ioutil.TempDir("", "FIXME") if err != nil { t.Fatal(err) } defer os.RemoveAll(dirName) - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Error(err) } @@ -468,7 +468,7 @@ func TestExtendedErrorCodes_ForeignKey(t *testing.T) { } defer os.RemoveAll(dirName) - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Error(err) } @@ -508,7 +508,7 @@ func TestExtendedErrorCodes_NotNull(t *testing.T) { } defer os.RemoveAll(dirName) - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Error(err) } @@ -558,7 +558,7 @@ func TestExtendedErrorCodes_Unique(t *testing.T) { } defer os.RemoveAll(dirName) - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Error(err) } @@ -613,7 +613,7 @@ func TestError_SystemErrno(t *testing.T) { } // open a non-existent database in read-only mode so we get an IO error. - db, err := sql.Open("acudego", "file:nonexistent.db?mode=ro") + db, err := sql.Open(DriverName, "file:nonexistent.db?mode=ro") if err != nil { t.Fatal(err) } @@ -639,7 +639,7 @@ func TestError_SystemErrno(t *testing.T) { } func TestBeginTxCancel(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal(err) } @@ -698,7 +698,7 @@ func TestBeginTxCancel(t *testing.T) { } func TestStmtReadonly(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal(err) } @@ -739,7 +739,7 @@ func TestStmtReadonly(t *testing.T) { } func TestNamedParams(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -829,7 +829,7 @@ func initDatabase(t *testing.T, db *sql.DB, rowCount int64) { } func TestShortTimeout(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal(err) } @@ -851,7 +851,7 @@ func TestShortTimeout(t *testing.T) { } func TestExecContextCancel(t *testing.T) { - db, err := sql.Open("acudego", "file:exec?mode=memory&cache=shared") + db, err := sql.Open(DriverName, "file:exec?mode=memory&cache=shared") if err != nil { t.Fatal(err) } @@ -892,7 +892,7 @@ FROM test_table t1 LEFT OUTER JOIN test_table t2` func TestQueryRowContextCancel(t *testing.T) { // FIXME: too slow - db, err := sql.Open("acudego", "file:query?mode=memory&cache=shared") + db, err := sql.Open(DriverName, "file:query?mode=memory&cache=shared") if err != nil { t.Fatal(err) } @@ -924,7 +924,7 @@ func TestQueryRowContextCancel(t *testing.T) { func TestQueryRowContextCancelParallel(t *testing.T) { // FIXME: too slow - db, err := sql.Open("acudego", "file:parallel?mode=memory&cache=shared") + db, err := sql.Open(DriverName, "file:parallel?mode=memory&cache=shared") if err != nil { t.Fatal(err) } @@ -974,7 +974,7 @@ func TestQueryRowContextCancelParallel(t *testing.T) { } func TestExecCancel(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal(err) } @@ -995,7 +995,7 @@ func TestExecCancel(t *testing.T) { } func doTestOpenContext(t *testing.T, url string) (string, error) { - db, err := sql.Open("acudego", url) + db, err := sql.Open(DriverName, url) if err != nil { return "Failed to open database:", err } @@ -1032,7 +1032,7 @@ func TestFileCopyTruncate(t *testing.T) { tempFilename := TempFilename(t) defer os.Remove(tempFilename) - db, err := sql.Open("acudego", tempFilename) + db, err := sql.Open(DriverName, tempFilename) if err != nil { t.Fatal("open error:", err) } @@ -1125,7 +1125,7 @@ func TestFileCopyTruncate(t *testing.T) { } // test copied file - db, err = sql.Open("acudego", copyFilename) + db, err = sql.Open(DriverName, copyFilename) if err != nil { t.Fatal("open error:", err) } @@ -1188,7 +1188,7 @@ func TestColumnTableName(t *testing.T) { } func TestFTS5(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -1292,27 +1292,6 @@ func TestFTS5(t *testing.T) { } } -func TestMathFunctions(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") - if err != nil { - t.Fatal("Failed to open database:", err) - } - defer db.Close() - - queries := []string{ - `SELECT acos(1)`, - `SELECT log(10, 100)`, - `SELECT power(2, 2)`, - } - - for _, query := range queries { - var result float64 - if err := db.QueryRow(query).Scan(&result); err != nil { - t.Errorf("invoking math function query %q: %v", query, err) - } - } -} - type preUpdateHookDataForTest struct { databaseName string tableName string @@ -1324,7 +1303,7 @@ type preUpdateHookDataForTest struct { func TestSerializeDeserialize(t *testing.T) { // Connect to the source database. - srcDb, err := sql.Open(driverName, "file:src?mode=memory&cache=shared") + srcDb, err := sql.Open(DriverName, "file:src?mode=memory&cache=shared") if err != nil { t.Fatal("Failed to open the source database:", err) } @@ -1335,7 +1314,7 @@ func TestSerializeDeserialize(t *testing.T) { } // Connect to the destination database. - destDb, err := sql.Open(driverName, "file:dst?mode=memory&cache=shared") + destDb, err := sql.Open(DriverName, "file:dst?mode=memory&cache=shared") if err != nil { t.Fatal("Failed to open the destination database:", err) } @@ -1411,7 +1390,7 @@ func TestUnlockNotify(t *testing.T) { tempFilename := TempFilename(t) defer os.Remove(tempFilename) dsn := fmt.Sprintf("file:%s?cache=shared&mode=memory", tempFilename) - db, err := sql.Open("acudego", dsn) + db, err := sql.Open(DriverName, dsn) if err != nil { t.Fatal("Failed to open database:", err) } @@ -1471,7 +1450,7 @@ func TestUnlockNotifyMany(t *testing.T) { tempFilename := TempFilename(t) defer os.Remove(tempFilename) dsn := fmt.Sprintf("file:%s?cache=shared&mode=memory", tempFilename) - db, err := sql.Open("acudego", dsn) + db, err := sql.Open(DriverName, dsn) if err != nil { t.Fatal("Failed to open database:", err) } @@ -1537,7 +1516,7 @@ func TestUnlockNotifyDeadlock(t *testing.T) { tempFilename := TempFilename(t) defer os.Remove(tempFilename) dsn := fmt.Sprintf("file:%s?cache=shared&mode=memory", tempFilename) - db, err := sql.Open("acudego", dsn) + db, err := sql.Open(DriverName, dsn) if err != nil { t.Fatal("Failed to open database:", err) } @@ -1630,7 +1609,7 @@ func TempFilename(t testing.TB) string { } func doTestOpen(t *testing.T, url string) (string, error) { - db, err := sql.Open("acudego", url) + db, err := sql.Open(DriverName, url) if err != nil { return "Failed to open database:", err } @@ -1659,7 +1638,7 @@ func doTestOpen(t *testing.T, url string) (string, error) { func TestOpenWithVFS(t *testing.T) { { uri := fmt.Sprintf("file:%s?mode=memory&vfs=hello", t.Name()) - db, err := sql.Open("acudego", uri) + db, err := sql.Open(DriverName, uri) if err != nil { t.Fatal("Failed to open", err) } @@ -1672,7 +1651,7 @@ func TestOpenWithVFS(t *testing.T) { { uri := fmt.Sprintf("file:%s?mode=memory&vfs=unix-none", t.Name()) - db, err := sql.Open("acudego", uri) + db, err := sql.Open(DriverName, uri) if err != nil { t.Fatal("Failed to open", err) } @@ -1695,7 +1674,7 @@ func TestOpenNoCreate(t *testing.T) { // https://golang.org/pkg/database/sql/#Open // "Open may just validate its arguments without creating a connection // to the database. To verify that the data source name is valid, call Ping." - db, err := sql.Open("acudego", fmt.Sprintf("file:%s?mode=rw", filename)) + db, err := sql.Open(DriverName, fmt.Sprintf("file:%s?mode=rw", filename)) if err == nil { defer db.Close() @@ -1723,7 +1702,7 @@ func TestOpenNoCreate(t *testing.T) { } // verify that it works if the mode is "rwc" instead - db, err = sql.Open("acudego", fmt.Sprintf("file:%s?mode=rwc", filename)) + db, err = sql.Open(DriverName, fmt.Sprintf("file:%s?mode=rwc", filename)) if err != nil { t.Fatal(err) } @@ -1746,14 +1725,14 @@ func TestReadonly(t *testing.T) { tempFilename := TempFilename(t) defer os.Remove(tempFilename) - db1, err := sql.Open("acudego", "file:"+tempFilename) + db1, err := sql.Open(DriverName, "file:"+tempFilename) if err != nil { t.Fatal(err) } defer db1.Close() db1.Exec("CREATE TABLE test (x int, y float)") - db2, err := sql.Open("acudego", "file:"+tempFilename+"?mode=ro") + db2, err := sql.Open(DriverName, "file:"+tempFilename+"?mode=ro") if err != nil { t.Fatal(err) } @@ -1768,7 +1747,7 @@ func TestReadonly(t *testing.T) { func TestDeferredForeignKey(t *testing.T) { fname := TempFilename(t) uri := "file:" + fname + "?_foreign_keys=1&mode=memory" - db, err := sql.Open("acudego", uri) + db, err := sql.Open(DriverName, uri) if err != nil { os.Remove(fname) t.Errorf("sql.Open(\"sqlite3\", %q): %v", uri, err) @@ -1803,7 +1782,7 @@ func TestDeferredForeignKey(t *testing.T) { } func TestClose(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -1827,7 +1806,7 @@ func TestClose(t *testing.T) { } func TestInsert(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -1868,7 +1847,7 @@ func TestUpsert(t *testing.T) { if n < 3024000 { t.Skip("UPSERT requires sqlite3 >= 3.24.0") } - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -1911,7 +1890,7 @@ func TestUpsert(t *testing.T) { } func TestUpdate(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -1974,7 +1953,7 @@ func TestUpdate(t *testing.T) { } func TestDelete(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -2033,7 +2012,7 @@ func TestDelete(t *testing.T) { } func TestBooleanRoundtrip(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -2082,7 +2061,7 @@ func TestBooleanRoundtrip(t *testing.T) { func timezone(t time.Time) string { return t.Format("-07:00") } func TestTimestamp(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -2182,7 +2161,7 @@ func TestTimestamp(t *testing.T) { } func TestBoolean(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -2272,7 +2251,7 @@ func TestBoolean(t *testing.T) { } func TestFloat32(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -2307,7 +2286,7 @@ func TestFloat32(t *testing.T) { } func TestNull(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -2336,7 +2315,7 @@ func TestNull(t *testing.T) { } func TestTransaction(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -2393,7 +2372,7 @@ func TestTransaction(t *testing.T) { } func TestWAL(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -2433,7 +2412,7 @@ func TestWAL(t *testing.T) { func TestTimezoneConversion(t *testing.T) { zones := []string{"UTC", "US/Central", "US/Pacific", "Local"} for _, tz := range zones { - db, err := sql.Open("acudego", "file:tz?mode=memory&_loc="+url.QueryEscape(tz)) + db, err := sql.Open(DriverName, "file:tz?mode=memory&_loc="+url.QueryEscape(tz)) if err != nil { t.Fatal("Failed to open database:", err) } @@ -2527,7 +2506,7 @@ func TestTimezoneConversion(t *testing.T) { // TODO: Execer & Queryer currently disabled // https://github.com/mattn/go-sqlite3/issues/82 func TestExecer(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -2545,7 +2524,7 @@ func TestExecer(t *testing.T) { } func TestQueryer(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -2594,7 +2573,7 @@ func TestQueryer(t *testing.T) { } func TestStress(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -2629,7 +2608,7 @@ func TestDateTimeLocal(t *testing.T) { defer os.Remove(tempFilename) filename1 := tempFilename + "?mode=memory&cache=shared" filename2 := filename1 + "&_loc=" + zone - db1, err := sql.Open("acudego", filename2) + db1, err := sql.Open(DriverName, filename2) if err != nil { t.Fatal("Failed to open database:", err) } @@ -2647,7 +2626,7 @@ func TestDateTimeLocal(t *testing.T) { t.Fatal("Result should have timezone", d) } - db2, err := sql.Open("acudego", filename1) + db2, err := sql.Open(DriverName, filename1) if err != nil { t.Fatal("Failed to open database:", err) } @@ -2672,7 +2651,7 @@ func TestDateTimeLocal(t *testing.T) { } db2.Exec("INSERT INTO foo VALUES(?);", dt) - db3, err := sql.Open("acudego", filename2) + db3, err := sql.Open(DriverName, filename2) if err != nil { t.Fatal("Failed to open database:", err) } @@ -2696,7 +2675,7 @@ func TestVersion(t *testing.T) { } func TestStringContainingZero(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -2754,7 +2733,7 @@ func (t TimeStamp) Value() (driver.Value, error) { } func TestDateTimeNow(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -3038,7 +3017,7 @@ func TestDeclTypes(t *testing.T) { } func TestPinger(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal(err) } @@ -3149,7 +3128,7 @@ func TestSetFileControlInt(t *testing.T) { } func TestNonColumnString(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal(err) } @@ -3169,7 +3148,7 @@ func TestNonColumnString(t *testing.T) { } func TestNilAndEmptyBytes(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal(err) } @@ -3224,7 +3203,7 @@ func TestNilAndEmptyBytes(t *testing.T) { } func TestInsertNilByteSlice(t *testing.T) { - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal(err) } @@ -3245,7 +3224,7 @@ func TestInsertNilByteSlice(t *testing.T) { func TestNamedParam(t *testing.T) { tempFilename := TempFilename(t) defer os.Remove(tempFilename) - db, err := sql.Open("acudego", ":memory:") + db, err := sql.Open(DriverName, ":memory:") if err != nil { t.Fatal("Failed to open database:", err) } @@ -3304,7 +3283,7 @@ var tdb *TestDB func initializeTestDB(t testing.TB) { tempFilename := TempFilename(t) - d, err := sql.Open("acudego", tempFilename+"?mode=memory&cache=shared") + d, err := sql.Open(DriverName, tempFilename+"?mode=memory&cache=shared") if err != nil { os.Remove(tempFilename) t.Fatal(err) @@ -3625,7 +3604,6 @@ func MainTest() { { "TestFileCopyTruncate", TestFileCopyTruncate }, { "TestColumnTableName", TestColumnTableName }, { "TestFTS5", TestFTS5 }, - { "TestMathFunctions", TestMathFunctions }, { "TestSerializeDeserialize", TestSerializeDeserialize }, { "TestOpenWithVFS", TestOpenWithVFS }, { "TestOpenNoCreate", TestOpenNoCreate }, |