From dcd536348e52686758ec76f68dc0157804f763f9 Mon Sep 17 00:00:00 2001 From: EuAndreh Date: Sun, 20 Oct 2024 20:30:37 -0300 Subject: Revert c3a3cf9d7aed9b3c48acbe31fd48f2c27549a570 --- tests/functional/limit/acudego.go | 104 -------------------------------------- tests/functional/limit/golite.go | 104 ++++++++++++++++++++++++++++++++++++++ 2 files changed, 104 insertions(+), 104 deletions(-) delete mode 100644 tests/functional/limit/acudego.go create mode 100644 tests/functional/limit/golite.go (limited to 'tests/functional/limit') diff --git a/tests/functional/limit/acudego.go b/tests/functional/limit/acudego.go deleted file mode 100644 index d47dc27..0000000 --- a/tests/functional/limit/acudego.go +++ /dev/null @@ -1,104 +0,0 @@ -package acudego - -import ( - "database/sql" - "fmt" - "log" - "os" - "strings" -) - - - -func createBulkInsertQuery(n int, start int) (string, []any) { - values := make([]string, n) - args := make([]any, n*2) - pos := 0 - for i := 0; i < n; i++ { - values[i] = "(?, ?)" - args[pos] = start + i - args[pos+1] = fmt.Sprintf("こんにちは世界%03d", i) - pos += 2 - } - query := fmt.Sprintf( - "insert into mylimittable(id, name) values %s", - strings.Join(values, ", "), - ) - return query, args -} - -func bulkInsert(db *sql.DB, query string, args []any) error { - stmt, err := db.Prepare(query) - if err != nil { - return err - } - - _, err = stmt.Exec(args...) - return err -} - - - -func MainTest() { - const ( - num = 400 - smallLimit = 100 - bigLimit = 999999 - ) - - const SQL = ` - create table mylimittable (id integer not null primary key, name text); - delete from mylimittable; - ` - - var conn *SQLiteConn - sql.Register("sqlite3_with_limit", &SQLiteDriver{ - ConnectHook: func(c *SQLiteConn) error { - conn = c - return nil - }, - }) - - os.Remove("limit.db") - defer os.Remove("limit.db") - db, err := sql.Open("sqlite3_with_limit", "limit.db") - if err != nil { - log.Fatal(err) - } - defer db.Close() - - _, err = db.Exec(SQL) - if err != nil { - log.Fatal(err) - } - - if conn == nil { - log.Fatal("not set sqlite3 connection") - } - - { - query, args := createBulkInsertQuery(num, 0) - err := bulkInsert(db, query, args) - if err != nil { - log.Fatal(err) - } - } - - conn.SetLimit(SQLITE_LIMIT_VARIABLE_NUMBER, smallLimit) - { - query, args := createBulkInsertQuery(num, num) - err := bulkInsert(db, query, args) - if err == nil { - log.Fatal("expected failure didn't happen") - } - } - - conn.SetLimit(SQLITE_LIMIT_VARIABLE_NUMBER, bigLimit) - { - query, args := createBulkInsertQuery(500, num+num) - err := bulkInsert(db, query, args) - if err != nil { - log.Fatal(err) - } - } -} diff --git a/tests/functional/limit/golite.go b/tests/functional/limit/golite.go new file mode 100644 index 0000000..231e8c2 --- /dev/null +++ b/tests/functional/limit/golite.go @@ -0,0 +1,104 @@ +package golite + +import ( + "database/sql" + "fmt" + "log" + "os" + "strings" +) + + + +func createBulkInsertQuery(n int, start int) (string, []any) { + values := make([]string, n) + args := make([]any, n*2) + pos := 0 + for i := 0; i < n; i++ { + values[i] = "(?, ?)" + args[pos] = start + i + args[pos+1] = fmt.Sprintf("こんにちは世界%03d", i) + pos += 2 + } + query := fmt.Sprintf( + "insert into mylimittable(id, name) values %s", + strings.Join(values, ", "), + ) + return query, args +} + +func bulkInsert(db *sql.DB, query string, args []any) error { + stmt, err := db.Prepare(query) + if err != nil { + return err + } + + _, err = stmt.Exec(args...) + return err +} + + + +func MainTest() { + const ( + num = 400 + smallLimit = 100 + bigLimit = 999999 + ) + + const SQL = ` + create table mylimittable (id integer not null primary key, name text); + delete from mylimittable; + ` + + var conn *SQLiteConn + sql.Register("sqlite3_with_limit", &SQLiteDriver{ + ConnectHook: func(c *SQLiteConn) error { + conn = c + return nil + }, + }) + + os.Remove("limit.db") + defer os.Remove("limit.db") + db, err := sql.Open("sqlite3_with_limit", "limit.db") + if err != nil { + log.Fatal(err) + } + defer db.Close() + + _, err = db.Exec(SQL) + if err != nil { + log.Fatal(err) + } + + if conn == nil { + log.Fatal("not set sqlite3 connection") + } + + { + query, args := createBulkInsertQuery(num, 0) + err := bulkInsert(db, query, args) + if err != nil { + log.Fatal(err) + } + } + + conn.SetLimit(SQLITE_LIMIT_VARIABLE_NUMBER, smallLimit) + { + query, args := createBulkInsertQuery(num, num) + err := bulkInsert(db, query, args) + if err == nil { + log.Fatal("expected failure didn't happen") + } + } + + conn.SetLimit(SQLITE_LIMIT_VARIABLE_NUMBER, bigLimit) + { + query, args := createBulkInsertQuery(500, num+num) + err := bulkInsert(db, query, args) + if err != nil { + log.Fatal(err) + } + } +} -- cgit v1.2.3