Skip to main content

Connexions Database Library

Project description

Connexions Database Library

https://travis-ci.org/Connexions/cnx-db.svg https://img.shields.io/codecov/c/github/Connexions/cnx-db.svg https://badge.fury.io/py/cnx-db.svg

View the documentation on the Read the Docs site.

License

This software is subject to the provisions of the GNU Affero General Public License Version 3.0 (AGPL). See license.txt for details. Copyright (c) 2016 Rice University

Change Log

0.11.0

  • In book search to provide query_type parameterization for AND vs OR queries (#87)

  • Fix number of migrations to rollback in ci_test_migrations.sh

  • get only the highest version for each book a page is in, return full ident_hash, as well as authors. Put same-as-page-authors first, since this is likely to be the orginal book the page was published in. Returned as list of hashes in page content-extras

  • Correct project testing requirements to also use main.txt (#85)

  • Fix update latest trigger not adding new modules

  • make in book search OR terms, rather than AND them

  • do not use timestamps to determine latest content (#75)

  • Add migration for print_style_recipes (#80)

  • Make lexeme removal migration idempotent (#82)

  • Fix print_style_recipe trigger definition to align with the migration (#81)

  • Provide book full text search (#78)

0.10.4

  • Revert changes to triggers for derived content

    • Remove fix for derived_book_ruleset sql function by returning a value (#67)

    • Remove addition of trigger for duplicating rulset.css for derived copies (#56)

0.10.3

  • Fix to ignore stateid when copying subcollections to avoid adding subcollections to the post-publication queue (#73)

0.10.2

  • Use postgres super user in migrations that require it (#71)

  • Correct errors in subcol uuid migration associated with an empty batch (#70)

0.10.1

  • Fix in-collated-book page search sql query (#68)

  • Add a matching migration for the double-trigger-when-rebaking fix (#69)

  • Fix derived_book_ruleset sql function by returning a value (#67 #66)

0.10.0

  • Add query to get latest version of the content (#64)

  • Use super user to replace plpythonu function in migration (#62)

  • Add migration to transform cnxml->html (#59)

  • Add delete cascade and indexes for foreign keys (#58)

  • Add data migration to update index.cnxml (#61)

  • Add trigger for duplicating rulset.css for derived copies (#56)

  • Add subcollection uuid data migration (#54)

  • Fix minor versions and current_modules view (#49)

  • Add xpath queries (#40)

0.9.0

  • Add AS_VENV_IMPORTABLE env variable to the pytest db_init fixture.

  • Fix load session_exec.so in init_venv before using it.

  • Fix order of dependency installation to account for the current circular dependence with cnx-archive.

  • Fix quoting within the container’s initdb script

  • Add docker entrypoint script to load database dump.

  • Fix Dockerfile initdb.d COPY command.

  • Fix requirements filename change in Dockerfile

  • Fix rebake trigger to do nothing when the content is already in a bakable state.

  • Lock latest_modules when running update_latest where two or more inserts may happen at the same time.

  • Fix update_latest trigger to account for multiple minor versions where one or more may have failed during baking.

  • Add sql queries for getting books containing a page.

0.8.0

  • Add tables and triggers to store recipes associated with print-styles.

0.7.0

  • Add association table for celery results to documents.

0.6.0

  • Share this project’s pytest fixtures for use in dependent projects.

  • Create the cnxdb.contrib package.

  • Fix to exclude subcollections from the search query.

0.5.4

  • Fix to only create the moduletags index when it does not exist.

0.5.3

  • Add an index for moduletags to improve search.

0.5.2

  • Fix to speedup in-book search for baked content.

0.5.1

  • Include a migration for the post_publication channel payload change.

0.5.0

  • Add a payload to the post_publication channel notification.

  • Fix tests by explicitly including cnx-archive.

  • Fix tests to only run trigger tests within Python 2.7.

0.4.0

  • Add a Make recipe for building and serving this project/component.

  • Correct styling, documentation and test running code.

  • Add the Make interface for common developer tasks.

  • Install versioneer for version management via git.

  • Add SQL function and trigger to rebake on baking recipe insert or update.

  • Update SQL manifest to add subcollection uuid SQL functions.

0.3.0

  • Adjust SQL functions declarations to idempotent declarations.

  • Add SQL functions and indexes for the content ident-hash.

0.2.7

  • Fix a relative path within the sub-collection uuid migration.

0.2.6

  • Update SQL to include sub-collection uuid schema changes from cnx-archive.

0.2.5

  • Make the project db-migrator aware.

0.2.4

  • Update SQL to include collated schema changes from cnx-archive.

0.2.3

  • Remove localhost venv initialization constraint.

0.2.2

  • Update SQL to account for changes in the cnx-publishing project.

0.2.1

  • Update SQL to account for changes in the cnx-publishing and cnx-archive projects.

  • Fix to include schema files in the distribution.

0.2.0

  • Add a commandline interface for initializing the database.

  • Add a commandline interface for initializing or re-initializing the virtualenv within the database.

0.1.1

  • Update SQL to account for changes made in the cnx-publishing and cnx-archive projects.

0.1.0

  • Add functions for initializing the database.

  • Merge database schemata from the cnx-publishing and cnx-archive projects.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

cnx-db-0.11.0.tar.gz (108.5 kB view details)

Uploaded Source

Built Distribution

cnx_db-0.11.0-py2-none-any.whl (147.1 kB view details)

Uploaded Python 2

File details

Details for the file cnx-db-0.11.0.tar.gz.

File metadata

  • Download URL: cnx-db-0.11.0.tar.gz
  • Upload date:
  • Size: 108.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for cnx-db-0.11.0.tar.gz
Algorithm Hash digest
SHA256 7e6400f61458580de143a786a90bd68f489a4b0180e6b1f501cdd10d9916ce65
MD5 d17c8cee812224c08859aea92b5be209
BLAKE2b-256 280fc652a2b974b1442552a963d459491424f2ec43f9dfc75f76b37eec067adb

See more details on using hashes here.

Provenance

File details

Details for the file cnx_db-0.11.0-py2-none-any.whl.

File metadata

File hashes

Hashes for cnx_db-0.11.0-py2-none-any.whl
Algorithm Hash digest
SHA256 3e0e0fa7ef79e136272525494f57a5b197ca93e04cd9908301ab6513027ca673
MD5 21022f4a785e590c796d1188aec46764
BLAKE2b-256 63bc56721ba36f27bbcfae1d3c7e1db2f03cf6e45c6fc3a5175fd70ee14f0a13

See more details on using hashes here.

Provenance

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page