github.com/glebarez/go-sqlite@v1.21.1/sqlite_version_test.go (about)

     1  package sqlite
     2  
     3  import (
     4  	"database/sql"
     5  	"log"
     6  	"testing"
     7  	"time"
     8  )
     9  
    10  func TestSQLiteVersion(t *testing.T) {
    11  
    12  	db, err := sql.Open(driverName, ":memory:")
    13  	if err != nil {
    14  		log.Fatal(err)
    15  	}
    16  	var (
    17  		version  string
    18  		sourceID string
    19  	)
    20  
    21  	row := db.QueryRow("select sqlite_version(), sqlite_source_id()")
    22  	if row.Scan(&version, &sourceID) != nil {
    23  		log.Fatal(err)
    24  	}
    25  
    26  	releaseDate, err := time.Parse(`2006-01-02`, sourceID[:10])
    27  	if err != nil {
    28  		t.Fatal(err)
    29  	}
    30  
    31  	t.Logf("%s (%s)\n", version, releaseDate.Format(`02/Jan/2006`))
    32  }