CHANGES

Changelog for CPAN-Testers-Schema

{{ $NEXT }}

0.027     2024-04-27 09:49:52+01:00 Europe/Lisbon

  - Fixed relationship between dists and stat rows
  - Added unique constraint on cpan uploads table
  - Added provisional uploads records when missing while processing
    report

0.026     2024-04-25 15:15:16+01:00 Europe/Lisbon

  [Added]

  - Added method to get latest versions of dists
  - Added relationship to get stat rows for dists
  - Combined, I can now get stat rows for latest versions of dists!

0.025     2020-01-13 21:13:16-05:00 America/New_York

    [Added]

    - Added full report fetching to the fetch command. Now you can
      populate an entire local database using the API!
    - Added a resultset method to get recent uploads to CPAN.
    - Added a relationship from a CPAN release to its report metrics
      (pass/fail/na/unknown counts) to make fetching those metrics easy.
    - Added a method to total up all release metrics by dist/version. We
      store metrics based on other criteria (stable/dev perl, for
      example), so we need to be able to collate them.
    - Added accessor methods for common parts of the test report to both
      the TestReport and Stats objects. These two objects have the same
      API now, so one can be substituted for the other with little
      difference (except the Stats object lacks the full text of the
      report).

    [Fixed]

    - Fixed cpantesters-schema command for the initial deploy. The
      workaround for the primary database is no longer necessary.
    - Fixed the "fetch" command script's options parsing and added
      better error checking from the API.
    - Fixed duplicate test summaries being created for the same report.

0.024     2019-04-27 15:58:52+01:00 Europe/London

    [Added]

    - Added 'cpantesters-schema fetch' command to download data from the
      public API to populate a local database. This can be used for
      testing purposes, but also to get a local copy of data for
      reporting purposes.

    [Fixed]

    - 'cpantesters-schema upgrade' command will now try to install the
      database if it is not already installed. This makes it suitable
      for use in an auto-deploy script.

0.023     2018-08-23 20:32:28-05:00 America/Chicago

    [Added]

    - Added a `version` argument to release resultsets to filter
      per-release summary data by dist _and_version.
    - Added classes for the Perl version metadata tables. These classes
      allow access to the `perl_version` table which stores metadata
      about known Perl 5 releases.
    - Added method to search for test summary rows by the Perl maturity

    [Fixed]

    - Fixed "patch" Perls to be considered "development" Perls. This is
      how the existing site and backend treats them, even though the two
      flags are different. "Patch" Perls are changed from the official
      P5P releases, and should therefore be treated differently.
    - Fixed Travis config to use MySQL 5.7. This MySQL version is
      required for the tests to run. Thanks @paultcochrane [Github #21]
    - Fixed "created" date in test reports being set to impossible
      values. We were allowing this to come from reporters, but we want
      this to be the time that we got the report. Later, if we want, we
      can add another field for when the reporter claims to have created
      the report. [Github #19]

0.022     2018-04-19 14:26:24+02:00 Europe/Oslo

    [Added]

    - Added support for `since` in Stats resultset

0.021     2017-11-28 13:43:34-06:00 America/Chicago

    - Implement support for `maturity` search param for Release queries.

0.020     2017-11-18 20:44:13-06:00 America/Chicago

    [Changed]

    - Added some additional logging to some resultset methods to try to
      track down some problems.

    [Fixed]

    - Fixed issue deserializing JSON from MySQL with illegal ASCII
      control characters inside.

0.019     2017-08-18 12:16:21-05:00 America/Chicago

    [Fixed]

    - Fix exception thrown when searching for the right test author
      details while inserting Metabase facts. SQLite supports `-col` to
      sort by `col` descending, but MySQL doesn't. DBIx::Class let
      `-col` through just fine though. Using the proper DBIx::Class
      syntax for descending order fixes the problem.

    - Allow updating test reports from Metabase facts. Metabase
      clients may submit a fact multiple times, so we need to update the
      test report if it already exists.

    - The test report JSON column is now safe for Latin-1-encoded
      tables. Any UTF-8 characters will be transformed into their
      `\u####` escape sequence. This is a stopgap until this data can be
      moved to a proper UTF-8-encoded table.

    - Metabase facts being translated to new test report format no
      longer allow "v" in front of the Perl version. It's not part of
      the Perl version number and all existing data lacks it.

0.018     2017-08-05 12:42:52-05:00 America/Chicago

    [Fixed]

    - Fixed name of "guid" unique constraint on Stats table. By default,
      DBIx::Class uses the name of the table (cpanstats) in the
      constraint name, but this makes it harder for that name to change
      in the future. Now the name of the constraint is just "guid".

    [Added]

    - Allow test reports to be re-processed. If a test report has
      already been processed (based on its guid), the Stats entry will
      be updated.

0.017     2017-08-04 14:06:17-05:00 America/Chicago

    [Fixed]

    - Fixed some POD formatting issues in the Stats result class. Thanks
      @manwar!

    - Added the correct dependency declaration for Data::UUID, which was
      causing Travis tests to fail. Thanks @manwar!

0.016     2017-08-03 21:38:38-05:00 America/Chicago

    [Fixed]

    - Fixed old schema version with incorrect size of field. Since these
      old tables aren't put through an ALTER TABLE process, we can edit
      the original versions without triggering an upgrade. This means we
      can do minor adjustments to match reality without major problems.

0.015     2017-07-08 12:07:35-05:00 America/Chicago

    [Fixed]

    - Fixed test that starts a MySQL server to run JSON pointer tests.
      JSON support was added in MySQL 5.7, and cannot run on any MySQL
      prior to that. Now the tests check that the MySQL is the right
      version before continuing.

0.014     2017-07-06 22:56:21-05:00 America/Chicago

    [Added]

    - Added method to search full test reports for language,
      distribution, and version

0.013     2017-05-26 22:48:55-05:00 America/Chicago

    [Added]

    - Added a method to get the CPAN upload from a test report

0.012     2017-05-14 15:56:39+02:00 Europe/Paris

    [Fixed]

    - Fixed upgrade for brand-new SQLite databases

    [Added]

    - Added a method to translate from test report JSON documents to the
      main Stats table. Thanks @jberger!

0.011     2017-05-14 15:50:18+02:00 Europe/Paris

    [Added]

    - Added cpantesters-schema install to custom DSN. This allows me to
      build a custom SQLite database for local testing.
    - Added a SQLite schema deployment strategy. This should make
      testing a bit easier.

0.010     2017-05-14 10:30:48+02:00 Europe/Paris

    [Fixed]

    - Fixed date/time format handling for TestReport created field. We
      need to make sure that the date/time is formatted correctly for
      the given database engine. The "created" date/time in the report
      is always a full ISO8601 date/time.

0.009     2017-05-13 14:42:38+02:00 Europe/Paris

    [Fixed]

    - Changed Metabase -> TestReport migration for new test report
      format, which moves the test result into a top-level "result" key.

0.008     2017-05-13 10:53:47+02:00 Europe/Paris

    [Fixed]

    - Updated metabase users table to add unique constraint to user
      GUID. The source table has multiple mappings for a single user,
      but as @bingos pointed out: This means that some e-mails for
      a user are completely inaccurate, bordering on malicious (since
      authors cannot get in touch with testers). The new table has only
      one mapping per GUID, and we can then update that mapping if
      a tester complains.

0.007     2017-05-12 17:52:23+02:00 Europe/Paris

    [Added]

    - Add a "created" field to the TestReport table to keep track of
      when the test report was created
    - Auto serialize the TestReport to/from JSON
    - Add the ID and created date/time to the JSON test report
    - Add a table to hold the old Metabase user information so we can
      find name/email for legacy clients
    - Add a conversion method from Metabase::Fact to the new test
      report. This allows legacy clients to send in Metabase reports and
      be updated to the new test report format.


0.006     2017-05-12 10:02:58+02:00 Europe/Paris

    [Added]

    - TestReport table for storing new test reports as JSON documents
    - cpantesters-schema script for deploying the new database schema
      [Github #2]
    - Add `updated` column to raw test reports to keep track of when
      they were updated

    [Fixed]

    - Fixed all the MySQL foreign key constraints. Foreign key columns
      need to be exactly the same column type as their foreign
      counterpart.

0.005     2016-12-11 00:36:54-06:00 America/Chicago

    [Fixed]

    - Fixed dependency declaration for DateTime and
      DateTime::Format::ISO8601

0.004     2016-12-10 02:45:36-06:00 America/Chicago

    [Fixed]

    - Properly inflate CPAN upload `released` column into a DateTime
      object. This makes for a better API so that we can, eventually,
      change the data type from epoch timestamp to ISO8601 date/time.

0.003     2016-12-09 19:55:09-06:00 America/Chicago

    [Added]

    - Added CPAN uploads data query module
      (CPAN::Testers::Schema::ResultSet::Upload) to query data from CPAN
      uploads.

    [Other]

    - Switched to DBIx::Class::Candy for cleaner result classes

0.002     2016-11-19 11:53:54-06:00 America/Chicago

    [Added]

    - Added relationship between report statistics and release
      summaries. This relationship can be used to see when the release
      summary was last updated.

    - Added release data query module
      (CPAN::Testers::Schema::ResultSet::Release) for easier querying of
      release data. This will be used to provide summary data for
      metacpan and various CPAN author dashboards.

    [Fixed]

    - Properly enabled all Perl 5.24 features. Since we're relying on
      it, we should be using it to the fullest!

0.001     2016-11-18 15:06:56-06:00 America/Chicago

 - This initial release contains a schema for some tables in the
   `cpanstats` database, with more tables to come later. This release is
   minimal to enable its use in the new CPAN Testers API, coming later.

   Hello from meta::hack 2016 in Chicago!