opentrials / api

94%

master: 92%

LAST BUILD ON BRANCH fixes-to-fda-data

branch: fixes-to-fda-data

CHANGE BRANCH

x

Reset

• fixes-to-fda-data
• 17-setup-docker
• 23-automatic-deployment-to-staging
• add-documents-files
• add-install-instructions
• add-location
• add-on-delete-cascade
• add-results-document
• add-sources-terms-and-conditions
• add-url-to-entities
• add_csr_synopsis
• adjust-garbage-collector
• all-identifiers-are-the-same
• api-docs
• arthurSena/feature/661-audit-log-for-trial-deduplication
• bug/173-fix-age-range
• bug/429-fix-documents
• bug/457-fix-python-bravado
• bug/529-fix-running-linter
• bug/542-fix-swagger-docs-over-https
• bug/543-fix-trials.sources
• bug/555-handle-files-without-pages
• bug/725-fix-null-array-study-phases
• bug/add-correct-completion-date-mapping
• bug/add-e2e-sources-test
• bug/fix-document-categories-migration
• bug/fix-documents-uniqueness-constraints
• bug/fix-intervention-types
• bug/fix-issues-with-499
• bug/limit-reindexing-memory-usage
• bug/migration-race-condition
• bug/records-source-id
• bug/records-unique-constraint
• bug/remove-nil-values-from-document-json-summary
• bug/throw-crash
• bug/trial-all-sources
• bug/trial-sources-with-risks-of-bias
• configure-aws-elasticsearch
• data-discrepancies
• downgrading-elasticsearch-to-1.5.2
• enable-cors
• fda-show-reviews-first
• fda_approval_history_collector
• feature/173-extract-age-range
• feature/187-disable-seeds-in-production
• feature/353-study-phase-as-array
• feature/426-setup-sentry
• feature/433-print-errors
• feature/500-search-endpoint-for-fda
• feature/501-add-fda-search-ui
• feature/507-trials-n-to-n-documents
• feature/557-reindex-one-page-at-a-time
• feature/647-strict-elasticsearch-mapping
• feature/651-disable-autocomplete-except-on-locations
• feature/653-add-unkown-status
• feature/708-change-pubmed-type
• feature/709-expose-phase-data
• feature/758-eliminate-trial-is-registered-property
• feature/add-fields-to-trial-index
• feature/add_is_primary_to_record
• feature/add_last_verified_to_record
• feature/add_results_exemption_date_to_trial
• feature/allow-running-individual-indexers
• feature/default-operator-should-be-and
• feature/diffs-table
• feature/document_categories_endpoint
• feature/elasticsearch-aliases
• feature/expose-all-entities-in-endpoints
• feature/expose-trialrecords
• feature/file-pages-preview
• feature/ignore-ictrp-discrepancies
• feature/migration-for-mapper
• feature/natural-source-id
• feature/performance-improvements
• feature/remove-source-data-from-records
• feature/replace-doc-type-with-category
• feature/sort-fda-docs-by-application-and-date
• feature/sort-trials-by-registration-date
• feature/source-url-nullable
• feature/trial-registered-boolean
• feature/unique_constraint_records_source
• feature/update-timestamps-in-postgres
• feature/updated-database-docs
• feature/updated-database-for-processors
• feature/updated-publications
• fix-api-spec
• fix-seeds
• fix-shrinkwrap
• fix-stats-trials-per-year-empty-registration-date
• fix/646-stop-reindex-at-es-error
• fix/757-is_primary-should-not-be-none
• fixing-e2e-tests
• hotfix/693-more-reindexing-issues
• hotfix/693-reindexing-issues
• hotfix/dates-without-offset
• ignore-euctr-records-when-calculating-discrepancies
• ignore-migrations-and-seeds-for-coverage
• ignore-undefined-fields-for-discrepancy
• ignore-whitespace-and-punctuation-for-discrepancies
• import-schema
• improve-reindexing-performance
• improve-swagger-documentation
• improvements-to-discrepancies
• make-trials-recruitment-status-enumerable
• master
• reducing-memory-usage
• refactor-our-reindexing-scripts
• remove-locations-endpoint
• remove-locations-url
• remove-trials-trialrecords-table
• remove-unused-documents-columns
• remove-unused-fields
• remove_stats_endpoint
• rename-problems-to-conditions
• rename-trialrecords-to-records
• search-endpoint
• search-filters
• split_recruitment_status_into_status
• temp/deployment-example
• testing-heroku-review-apps
• trials-documents
• trials-remove-not-null
• trying-swagger-hapi
• update-fields-used-to-calculate-discrepancies
• updating-dependencies
• upgrade-elasticsearch-2.3.5
• upgrade-node-6
• v1.0.0
• v1.1.0
• v1.1.1

Build # 403

Build Type

push

travis-ci

Committed by vitorbaptista

Commit Message

[#361] Add fda_applications and its references

We now have a new "fda_applications" table which will contain metadata for
every FDA application. The "interventions" and "fda_approvals" tables now
references it through their "fda_application_id" columns.

The complexity of this migration is to maintain the existing relationships.
For this reason, I had to set all "fda_applications" columns as nullable, even
though they shouldn't be null. This way, I can create the rows just needing the
IDs (i.e. the FDA application numbers), which we already have in the DB.

When this migration is applied and we have all data in the DB, we should add
the "NOT NULL" constraints.

opentrials/opentrials#361

Run Details

318 of 340 relevant lines covered (93.53%)

31.03 hits per line