github.com/jdgcs/sqlite3@v1.12.1-0.20210908114423-bc5f96e4dd51/null_test.go (about) 1 package sqlite 2 3 import ( 4 "database/sql" 5 "testing" 6 ) 7 8 func TestNullBinding(t *testing.T) { 9 db, err := sql.Open("sqlite", "file::memory:") 10 if err != nil { 11 t.Errorf("cannot open: %v", err) 12 return 13 } 14 _, err = db.Exec(` 15 CREATE TABLE table1 (field1 varchar NULL); 16 INSERT INTO table1 (field1) VALUES (?); 17 `, sql.NullString{}) 18 if err != nil { 19 t.Errorf("Error binding null: %v", err) 20 } 21 err = db.Close() 22 if err != nil { 23 t.Errorf("cannot close: %v", err) 24 return 25 } 26 }