Function openSQLiteDatabaseOnce

internal/store/sqlite.go:84–114

(
	ctx context.Context,
	path string,
	initialize func(context.Context, *sql.DB) error,
	extraPragmas ...string,
)

}

func openSQLiteDatabaseOnce(
	ctx context.Context,
	path string,
	initialize func(context.Context, *sql.DB) error,
	extraPragmas ...string,
) (*sql.DB, error) {
	db, err := sql.Open(sqliteDriverName, sqliteDSN(path, extraPragmas...))
	if err != nil {
		return nil, fmt.Errorf("store: open sqlite database %q: %w", path, err)
	}

	db.SetMaxOpenConns(defaultMaxOpenConns)
	db.SetMaxIdleConns(defaultMaxIdleConns)

	if err := db.PingContext(ctx); err != nil {
		closeQuietly(db)
		return nil, fmt.Errorf("store: ping sqlite database %q: %w", path, err)
	}
	if err := configureSQLite(ctx, db); err != nil {
		closeQuietly(db)
		return nil, fmt.Errorf("store: configure sqlite database %q: %w", path, err)
	}
	if initialize != nil {
		if err := initialize(ctx, db); err != nil {
			closeQuietly(db)
			return nil, fmt.Errorf("store: initialize sqlite database %q: %w", path, err)
		}
	}

	return db, nil
}

func sqliteDSN(path string, extraPragmas ...string) string {
	u := url.URL{