gitlab.com/CoiaPrant/sqlite3@v1.19.1/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  }