Function getViews

backend/plugin/db/sqlite/sync.go:226–252

(txn *sql.Tx)

}

func getViews(txn *sql.Tx) ([]*storepb.ViewMetadata, error) {
	var views []*storepb.ViewMetadata

	query := `
		SELECT
			name, sql
		FROM sqlite_schema
		WHERE type ='view' AND name NOT LIKE 'sqlite_%'
		ORDER BY name;`
	rows, err := txn.Query(query)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	for rows.Next() {
		view := &storepb.ViewMetadata{}
		if err := rows.Scan(&view.Name, &view.Definition); err != nil {
			return nil, err
		}
		views = append(views, view)
	}
	if err := rows.Err(); err != nil {
		return nil, util.FormatErrorWithQuery(err, query)
	}

	return views, nil
}