Hello community, here is the log from the commit of package openQA for openSUSE:Factory checked in at 2018-01-09 14:50:10 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/openQA (Old) and /work/SRC/openSUSE:Factory/.openQA.new (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "openQA" Tue Jan 9 14:50:10 2018 rev:6 rq:561981 version:4.5.1513750232.be133588 Changes: -------- --- /work/SRC/openSUSE:Factory/openQA/openQA.changes 2017-11-29 10:54:11.617311728 +0100 +++ /work/SRC/openSUSE:Factory/.openQA.new/openQA.changes 2018-01-09 14:50:48.102529293 +0100 @@ -1,0 +2,100 @@ +Thu Dec 21 19:36:32 UTC 2017 - co...@suse.com + +- Update to version 4.5.1513750232.be133588: + * Add basic setup of multi-machine worker (#1544) + * Allow deleting assets via web UI (#1551) + * Deal properly with environment variables that can change logging (#1537) + * Fix deletion of jobs referenced as last use of asset (#1549) + * Show assets by job group + * selenium test: Allow configuring mojo port + * Split asset tables in used and untracked assets + * Refactor data size rendering in JS and reduce precision + * Set App mode in WebSocket server (#1548) + * Fix repos gone too early: assign REPO_10 to jobs as well (#1547) + * Retidy - Perl::Tidy 20171214 has different formatting (#1546) + * Update installation steps for postgresql (#1538) + * branding: openSUSE: Add Kubic (#1539) + * Change the logs timestamp to ISO8601 (#1542) + * Add documentation for postgresql migration (#1530) + * Fully fix asset caching without test caching (POO #29208) + * Fix job group update issue (#1533) + * Hide worker properties if no login (#1534) + * Switch to fontawesome 5 (#1531) + * `limit_assets`: remove asset that breaks limit, not next one (#1536) + * Remove all assets from DB that are gone (#1535) + * Allow to query live data from api, adapt tests + * Display additional information in the worker's table + * Add panel and popover to show job detail + * Make searchable field and fix DataTable loading + * Add openqa-setup-db service that will create postgresql database (#1528) + * Retrieve worker stats data + * Do not query by default websocket server to display worker informations + * Fix tests to expect new columns + * Show size of assets exclusively kept by a group + * Accumulate size of assets exclusively kept by a group + * Document fast initialization of local tests (#1527) + * Add column to groups with size of exclusively used assets + * Also store if the asset is fixed in the DB + * limit_assets: Use DBD::Pg directly for querying job asset + * Check all columns in test for asset table + * Show last use of asset in assets table + * Ignore chromedriver logs + * Show asset size + * Write info about assets kept during cleanup to db + * Improve comments in limit_assets + * Fix PRJDIR error + * Add support for colons on worker class + * Add WORKER_CLASS to job_list filter + * Fix caching of assets without caching of tests (#1521) + * Accept a lower coverage - we removed code + * Move worker log test to 24-worker.t + * Schema.pm: Remove unused functions (increase coverage) + * Remove SQL files for SQlite and for 2016 + * Have our services require postgresql server to be up + * Adopt generate-packaged-asset to use postgresql + * Import log_error in OpenQA::IPC + * Test: increment unstable_worker ticks and wait for each one to be ready + * Remove more traces of Sqlite support + * Provide t/test_postgresql to setup a temporary postgresql + * Fix more test cases + * Prepare a proper DB for the scheduler full test + * Fix t/ui/22-job_group_order.t by providing sort_order in fixtures + * t/ui/13-admin.t: Postgresql sorts RAID at the end + * Sort table settings by key to have reliable tests + * t/api/02-iso.t: Do not rely on hardcoded job number + * Give WebSockets server its assets + * Sort the previous jobs in worker table by ids + * Skip all tests requiring a database + * Test fixtures: restart the postgresql sequence + * Fix t/17-build_tagging.t not to depend on Sqlite specifics + * ui/04-api_keys.t: Don't rely on ids in fixtures + * 14-grutasks: don't rely on DB sort order + * Drop sqlite3 support + * branding: Update SLE staging links (#1523) + * Use log_info for worker activities (#1519) + * branding: openSUSE: Add caasp (different bugzilla naming variant) (#1522) + * Tidy the sources + * Do not cast to int worker_status timer + * Propagate error on IPC dispatch call + * Use WORKERS_CHECKER_THRESHOLD to detect dead workers as well + * Remove printing to debug the result of safe_call + * Reduce OpenQA tests verbosity + * limit_assets: don't wipe assets for PENDING jobs (#1518) + * Allow same group name within different parent groups (#1507) + * Apply log level correctly (#1516) + * Check if job is valid before starting working on it. + * Upload workers log to the webUI (#1502) + * Only test basic tests on perl 5.26 (#1512) + * Remove IDs from fixtures if they are in sequence (#1513) + * Move the $shared_dir to setup_share_dir + * Print project directory upon worker's init failure + * Fix documentation generation script + * Avoid warnings during test runs (#1511) + +------------------------------------------------------------------- +Wed Dec 6 15:48:20 UTC 2017 - co...@suse.com + +- Add local-db subpackage to create local postgresql database for + ease of use + +------------------------------------------------------------------- Old: ---- openQA-4.5.1511814842.53907890.tar.xz New: ---- openQA-4.5.1513750232.be133588.tar.xz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ openQA.spec ++++++ --- /var/tmp/diff_new_pack.Ij8ypz/_old 2018-01-09 14:50:49.062484287 +0100 +++ /var/tmp/diff_new_pack.Ij8ypz/_new 2018-01-09 14:50:49.062484287 +0100 @@ -1,7 +1,7 @@ # # spec file for package openQA # -# Copyright (c) 2017 SUSE LINUX GmbH, Nuernberg, Germany. +# Copyright (c) 2018 SUSE LINUX GmbH, Nuernberg, Germany. # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed @@ -24,7 +24,7 @@ %{_bindir}/systemd-tmpfiles --create %{?*} || : \ %{nil} %endif -%if 0%{?suse_version} >= 1730 +%if 0%{?suse_version} >= 1500 %ifarch x86_64 %bcond_without tests %else @@ -34,9 +34,9 @@ %bcond_with tests %endif # runtime requirements that also the testsuite needs -%define t_requires perl(DBD::SQLite) perl(DBIx::Class) perl(Config::IniFiles) perl(SQL::Translator) perl(Date::Format) perl(File::Copy::Recursive) perl(DateTime::Format::SQLite) perl(Net::OpenID::Consumer) perl(Mojolicious::Plugin::RenderFile) perl(Mojolicious::Plugin::AssetPack) perl(aliased) perl(Config::Tiny) perl(DBIx::Class::DynamicDefault) perl(DBIx::Class::Schema::Config) perl(DBIx::Class::Storage::Statistics) perl(IO::Socket::SSL) perl(Data::Dump) perl(DBIx::Class::OptimisticLocking) perl(Text::Markdown) perl(Net::DBus) perl(IPC::Run) perl(Archive::Extract) perl(CSS::Minifier::XS) perl(JavaScript::Minifier::XS) perl(Time::ParseDate) perl(Sort::Versions) perl(Mojo::RabbitMQ::Client) perl(BSD::Resource) perl(Cpanel::JSON::XS) +%define t_requires perl(DBD::Pg) perl(DBIx::Class) perl(Config::IniFiles) perl(SQL::Translator) perl(Date::Format) perl(File::Copy::Recursive) perl(DateTime::Format::Pg) perl(Net::OpenID::Consumer) perl(Mojolicious::Plugin::RenderFile) perl(Mojolicious::Plugin::AssetPack) perl(aliased) perl(Config::Tiny) perl(DBIx::Class::DynamicDefault) perl(DBIx::Class::Schema::Config) perl(DBIx::Class::Storage::Statistics) perl(IO::Socket::SSL) perl(Data::Dump) perl(DBIx::Class::OptimisticLocking) perl(Text::Markdown) perl(Net::DBus) perl(IPC::Run) perl(Archive::Extract) perl(CSS::Minifier::XS) perl(JavaScript::Minifier::XS) perl(Time::ParseDate) perl(Sort::Versions) perl(Mojo::RabbitMQ::Client) perl(BSD::Resource) perl(Cpanel::JSON::XS) Name: openQA -Version: 4.5.1511814842.53907890 +Version: 4.5.1513750232.be133588 Release: 0 Summary: The openQA web-frontend, scheduler and tools License: GPL-2.0+ @@ -69,17 +69,15 @@ Requires: perl(URI) # we need to have the same sha1 as expected %requires_eq perl-Mojolicious-Plugin-AssetPack +Recommends: %{name}-local-db Requires(post): coreutils -Requires(post): sqlite3 Requires(post): perl(DBIx::Class::DeploymentHandler) Requires(post): perl(SQL::SplitStatement) Recommends: apache2 Recommends: apparmor-profiles Recommends: apparmor-utils Recommends: logrotate -Recommends: perl(DBD::Pg) -# for postgresql -Recommends: perl(DateTime::Format::Pg) +BuildRequires: postgresql-server BuildArch: noarch ExcludeArch: i586 %{?systemd_requires} @@ -87,6 +85,7 @@ BuildRequires: chromedriver BuildRequires: chromium BuildRequires: perl-App-cpanminus +BuildRequires: perl(DBD::SQLite) BuildRequires: perl(Mojo::RabbitMQ::Client) BuildRequires: perl(Perl::Critic) BuildRequires: perl(Perl::Tidy) @@ -133,6 +132,7 @@ Group: Development/Tools/Other Requires: openQA-client = %{version} Requires: os-autoinst < 5 +Requires: perl(DBD::SQLite) Requires: perl(SQL::SplitStatement) # FIXME: use proper Requires(pre/post/preun/...) PreReq: openQA-common = %{version} @@ -159,6 +159,17 @@ Tools and support files for openQA client script. Client script is a convenient helper for interacting with openQA webui REST API. +%package local-db +Summary: Helper package to ease setup of postgresql DB +Group: Development/Tools/Other +Requires: %name +Requires: postgresql-server +Supplements: packageand(%name:postgresql-server) + +%description local-db +You only need this package if you have a local postgresql server +next to the webui. + %package doc Summary: The openQA documentation Group: Development/Tools/Other @@ -184,7 +195,11 @@ %if %{with tests} #make test +rm -rf %{buildroot}/DB +#./t/test_postgresql %{buildroot}/DB +#export TEST_PG="DBI:Pg:dbname=openqa_test;host=%{buildroot}/DB" OBS_RUN=1 prove -r -j2 -v +#pg_ctl -D %{buildroot}/DB stop %endif %install @@ -285,6 +300,15 @@ %postun worker %service_del_postun %{openqa_worker_services} +%post local-db +%service_add_post openqa-setup-db.service + +%preun local-db +%service_del_preun openqa-setup-db.service + +%postun local-db +%service_del_postun openqa-setup-db.service + %files %doc README.asciidoc %{_sbindir}/rcopenqa-gru @@ -408,4 +432,7 @@ %files doc %doc docs/* +%files local-db +%{_unitdir}/openqa-setup-db.service + %changelog ++++++ cache.txz ++++++ Binary files /var/tmp/diff_new_pack.Ij8ypz/_old and /var/tmp/diff_new_pack.Ij8ypz/_new differ ++++++ openQA-4.5.1511814842.53907890.tar.xz -> openQA-4.5.1513750232.be133588.tar.xz ++++++ ++++ 69569 lines of diff (skipped)