Changelog#

0.3.9 (2022-06-30)#

Changed#

Fixed#

  • calculate_coverage(): Use the correct parent table if scope is not set. Previously, Kingfisher Colab would not use: a7c0936

    • award_documents

    • award_items

    • award_suppliers

    • contract_documents

    • contract_items

    • contract_milestones

    • contract_implementation_documents

    • contract_implementation_milestones

    • contract_implementation_transactions

  • calculate_coverage(): Construct correct conditions and warnings if a field is within nested arrays. 3dced1a

  • calculate_coverage(): Use the relatedprocesses_summary table for fields starting with relatedProcesses/, where appropriate. 9e6cdb7

  • calculate_coverage(): Prefix all_ to the column if "ALL " is prefixed to the field, to avoid duplicate columns. e9427b2

  • calculate_coverage(): No longer warn about address fields. e2b8d72

0.3.8 (2022-04-27)#

Changed#

0.3.7 (2022-03-11)#

Added#

0.3.6 (2021-09-15)#

Changed#

  • list_collections(): source_id is now an optional argument. If omitted, all collections are returned.

0.3.5 (2021-08-09)#

Added#

0.3.4 (2021-04-16)#

Fixed#

0.3.3 (2021-04-10)#

Added#

  • Add Python wheels distribution.

0.3.2 (2021-02-16)#

Fixed#

  • Set the minimum version of ipython-sql.

0.3.1 (2021-02-16)#

Fixed#

  • Fixed dependencies to install cleanly both locally and on Google Colaboratory.

0.3.0 (2020-12-15)#

Changed#

  • Refactor to build upon ipython-sql. Removes several functions that can be replaced with direct usage of ipython-sql magics in the notebook, and replace all remaining sql calls with calls to ipython-sql.

    Replacements (must run %load_ext sql first, and %config SqlMagic.autopandas = True to get a pandas DataFrame):

    • ocdskingfishercolab.create_connection — replaced by using an ipython-sql connection string, e.g. %sql postgresql://user:pass@host/db

    • ocdskingfishercolab.execute_statement, ocdskingfishercolab.get_dataframe_from_cursor and ocdskingfishercolab.get_dataframe_from_query — replaced by ipython-sql’s %sql magic, e.g. %sql SELECT a FROM b

    • ocdskingfishercolab.get_list_from_query — replaced by ocdskingfishercolab.get_ipython_sql_resultset_from_query(). This returns an ipython-sql ResultSet, the type returned by the %sql% magic when autopandas is off. It behaves like a list, but with extra methods.

    • ocdskingfishercolab.download_package_from_query() no longer takes a params argument, and instead uses variables from the local scope, to be consisent with the ipython-sql’s %sql magic.

    There’s a shared (but not public) colab notebook of examples run against live kingfisher.

  • create_connection() creates a new connection if the current connection is closed.

  • download_package_from_ocid() orders packaged releases in reverse date order.

  • Remove reset_connection().

Fixed#

0.2.2 (2020-04-22)#

Added#

Fixed#

  • execute_statement() no longer has a mutable default argument value.

0.2.1 (2020-04-21)#

Fixed#

  • execute_statement() no longer errors if given a psycopg2.sql.Composable.

0.2.0 (2020-04-21)#

Upgrade instructions:

  • Upgrade to 0.1.x if you have not already, and address any deprecation warnings. Then, upgrade to 0.2.x.

  • Install alembic and SQLAlchemy separately, if used in the notebook.

Added#

Changed#

  • Backwards-incompatible: The methods deprecated in 0.1.x are removed.

  • Backwards-incompatible: alembic and SQLAlchemy are no longer installed.

Fixed#

0.1.1 (2020-04-20)#

Fixed#

  • The deprecated methods output_notebook and get_results return values again.

0.1.0 (2020-04-20)#

Upgrade instructions:

  • Use pip install 'ocdskingfishercolab<0.2' instead of any previous pip install command.

  • Import ocdskingfishercolab instead of kingfishercolab.

Added#

Changed#

0.0.1 (2020-04-20)#

Initial release.