Changelog#

0.3.13 (2023-10-27)#

Fixed#

  • Restore support for Jupyter Notebook 6.

0.3.12 (2023-10-23)#

Changed#

  • Update dependencies to match Google Colaboratory.

0.3.11 (2023-07-04)#

Added#

0.3.10 (2023-02-03)#

Fixed#

  • Pin to SQLAlchemy 1.x.

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.

    You must run %load_ext sql first, and %config SqlMagic.autopandas = True to get a pandas DataFrame.

    • Remove functions that can be replaced by ipython-sql magics in the notebook.

      • create_connection: Use an ipython-sql connection string, e.g. %sql postgresql://user:pass@host/db

      • execute_statement, get_dataframe_from_cursor, get_dataframe_from_query: Use ipython-sql’s %sql magic, e.g. %sql SELECT a FROM b

    • Replace SQL calls with ipython-sql calls in remaining functions.

    There’s a shared (but not public) colab notebook of examples run against 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.