LibPQ is a library for importing Power Query M language source files from local and/or web storage. The project follows semantic versioning specification.
This document describes the changes between releases of LibPQ. Keeping a changelog is important!
Plans and ideas for future versions can be found in the roadmap.
This release accumulates a number of small changes over the past two years and highlights a significant improvement in LibPQ development: now we have a CI pipeline!
- Table.MoveColumnsToBeginning, Table.MoveColumnsToEnd - Reorder columns by moving some of them to the beginning/end of the table (#21, thanks to @ckp95)
- Web.CbrCurrencyRates - Fetch currency rates published by The Central Bank of Russian Federation
- Unit tests are now automatically executed after each push to this repo thanks to PowerQueryNet and GitHub Actions
- New Assert function: InvokeRaises (#19, thanks to @estuelke)
- Improved error reporting and error handling in LibPQ loader and in UnitTest discovery tools (#18)
This release adds a few minor improvements regarding the unit testing framework.
The library has been in regular use for more than a year already and has proven to be very stable and had required very little maintenance. Author recommends it for use in any suitable task.
- Support for fact based unit tests
- Support unlimited number of test runners for different test suite types with
UnitTest.Discover. Runner is determined
based on the value of
LibPQ.TestSuitemeta field. Test runners have to be API compatible with the reference implementation (UnitTest.Run)
- Test code was moved into a separate directory (#15)
This release adds a few minor features.
The library has been around for half a year already. The author has been using it regularly to create new reports and refresh existing ones, no significant issues had arisen. The project is considered suitable for daily use.
- New assertion function
NotEqualin UnitTest.Assert - VBA helper module that simplifies access to the metadata about the current workbook
- Function.Chain - Apply a sequence of operations to the input value
This is the first release of LibPQ. The library and the loader are considered feature full and stable.
Most of the features are described in the README and in documentation. Introductory overview is available at author's blog.
- Import source code from plain text files located on disk or on the web
- Unlimited number of import locations ordered by priority
- Unit testing framework
- Show docstrings in Power Query user interface
- A collection of general purpose functions and queries
- Compatibility with @tycho01's library