v0.8.1

What's Changed

Implement CSV export/download functionality, in which statements can be downloaded in CSV format. The CSV column headers are paths to statement properties, which can be selected in the UI; for example, if the user wants to download statements' ID and verb ID, the file will look like this:

id,verb_id
fdfb9f6d-123f-4851-9763-520a1ea0f182,http://example.org/verb/1
72f3c1b3-6129-4ed8-9e97-ccc8753d906a,http://example.org/verb/2

• Add two GET endpoints: /admin/csv and /admin/csv/auth
  • /admin/csv/auth returns a one-time JWT for use with /admin/csv. This is important because the latter endpoint is used as a download attribute for HTML anchor tags in the UI, which cannot accept headers.
  • /admin/csv downloads statements in the LRS as a CSV filestream. This endpoint accepts the statement query parameters defined in the xAPI spec, but allows two additional parameters: the one-time JWT token string and the URL-encoded property-path vector strings, which define the CSV column headers.
• Add new config variable: LRSQL_STMT_GET_MAX_CSV, which defines the maximum number of statements that can be included in a CSV download. If this is negative (e.g. the default value of -1), then it is ignored and all statements in the LRS are downloaded (subject to query filters).

Pull Requests

• [SQL-283] Authentication for CSV export by @kelvinqian00 in #467
• [SQL-281] CSV export by @kelvinqian00 in #464

Full Changelog: v0.8.0...v0.8.1