Hello community, here is the log from the commit of package pgadmin4 for openSUSE:Factory checked in at 2020-03-17 13:09:44 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/pgadmin4 (Old) and /work/SRC/openSUSE:Factory/.pgadmin4.new.3160 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "pgadmin4" Tue Mar 17 13:09:44 2020 rev:9 rq:785631 version:4.19 Changes: -------- --- /work/SRC/openSUSE:Factory/pgadmin4/pgadmin4.changes 2019-10-22 15:46:49.253814220 +0200 +++ /work/SRC/openSUSE:Factory/.pgadmin4.new.3160/pgadmin4.changes 2020-03-17 13:09:55.129788531 +0100 @@ -1,0 +2,270 @@ +Mon Mar 16 10:34:00 UTC 2020 - Antonio Larrosa <[email protected]> + +- Update to 4.19 (boo#1166681) + - New features + * Added accessibility support in AlertifyJS. + * Added Czech language support. + * Added Python 3.8 support. + - Housekeeping + * Improve code coverage and API test cases for the Event Trigger module. + * Improvements in the UI for both default and dark themes. + * Enhance logging by tracking stdout and stderr of subprocess when + log level set to DEBUG. + * Added option to override the class name of a label tag for select2 + control. + - Bug fixes + * Changed the color of selected and hovered item for Select2 dropdown. + * Improve the style of the highlighted code after query execution for + Dark mode. + * Ensure that AlertifyJS should not be visible as a title for alert + dialog. + * Changed background pattern for geometry viewer to use #fff for all + themes. + * Fix an issue where debugger not showing all arguments anymore after + hitting SQL error while debugging. + * Set proper focus on tab navigation for file manager dialog. + * Fix an issue where command and statements were parsed incorrectly + for Rules. + * Ensure that all the transactions should be canceled before closing + the connections when a server is disconnected using pgAdmin. + * Fixed Firefox monospaced issue by updating the font to the latest + version. + * Update Flask-SQLAlchemy and SQLAlchemy package which is not working + on Windows with Python 3.8. + * Fix syntax error when changing the event type for the existing rule. + +- Update to 4.18 + - New features + * Added support for a multi-level partitioned table. + * Added a Schema Diff tool to compare two schemas and generate a diff + script. + * Allow screen-reader to read label & description of non-textable + elements. + * Allow screen-reader to identify the alert errors. + * Added labels and titles after parsing and validating all the pgAdmin4 + web pages for accessibility. + * Set input controls as read-only instead of disabled will allow tab + navigation in the properties tab and also allow screen readers to + read it. + - Housekeeping + * Improve code coverage and API test cases for the CAST module. + * Improve code coverage and API test cases for the LANGUAGE module. + * Improve the test framework to run for multiple classes defined in a + single file. + * Updated wcDocker package which includes aria-label accessibility + improvements. + * Replace node-sass with sass for SCSS compilation. + - Bug fixes + * Ensure that path file name should not disappear when changing ext from + the dropdown in file explorer dialog. + * Fixed an issue while editing char[] or character varying[] column from + View/Edit data throwing an error. + * Fixed an issue where Grant wizard unable to handle multiple objects when + the query string parameter exceeds its limit. + * Added tab navigation on close buttons for all the panels and + create/properties dialog. + * Fix column resizable issue in the file explorer dialog. + * Logout the pgAdmin session when no user activity of mouse move, click + or keypress. + * Fix an issue where setting STORAGE_DIR to empty should show all + the volumes on Windows in server mode. + * Updated the incorrect icon used for the cast node on refresh. + * Fix an issue where refreshing a package results in the change in + the object completely. + * Fix an issue where select, insert and update scripts on tables throwing + an error. + * Ensure Postfix starts in the container, now it runs as non-root + by default. + * Fixed an issue where Save Password control disappears after clicking + on it while creating a server. + +- Update to 4.17 + - New features + * Allow screen-reader to read relationship attributes in nested elements. + * Ensure all binaries are securely signed and linked with the hardened + runtime in the macOS bundle + - Housekeeping + * Refactored SQL of Table’s and it’s child nodes. + * Refactored SQL of Views and Materialized Views. + * Refactored SQL of Functions and Procedures. + * Added support for on-demand loading of items in Select2. + * Added code coverage tool for pgAdmin. + - Bug fixes + * Fix syntax highlighting in code mirror for backslash and escape constant. + * Fix an issue where clicking on an empty textbox like fill factor or + comments, considers it as change and enabled the save button. + * Added support to view multilevel partitioned tables. + * Ensure that constraints, indexes, rules, triggers, and compound triggers + should be created on partitions. + * Added more information to the ‘Database connected/disconnected’ message. + * Ensure that the user should be able to select/modify tablespace for the + partitioned table on v12 and above. + * Rename some internal environment variables that could conflict with + Kubernetes. + * Fix vulnerability issues reported by ‘yarn audit’. Replace the + deprecated uglifyjs-webpack-plugin with a terser-webpack-plugin. + * Ensure that the error message should not be displayed if Tablespace is + not selected while creating the index. + * Fix an issue where operator, access method and operator class is + not visible for exclusion constraints. + * Add a note to the documentation about the use of non-privileged ports + on filesystems that don’t support extended attributes when running + the container. + * Added tab navigation for tabs under explain panel in query tool. + * Fix an issue where the table is not created with autovacuum_enabled + and toast.autovacuum_enabled for PG/EPAS 12. + +- Update to 4.16 + - New features + * Warn the user on changing the definition of Materialized View about + the loss of data and its dependent objects. + * Allow drag and drop functionality for all the nodes under the database + node, excluding collection nodes. + * Use a ‘play’ icon for the Execute Query button in the Query Tool for + greater consistency with other applications. + * Added aria-label to provide an invisible label where a visible label + cannot be used. + * Added role=”status” attribute to all the status messages for + accessibility. + * Run pgAdmin in the container as a non-root user (pgadmin, UID: 5050) + * Allow Gunicorn logs in the container to be directed to a file specified + through GUNICORN_ACCESS_LOGFILE. + * Changed the open query tool and data filter icons. + - Housekeeping + * Add Reverse Engineered and Modified SQL tests for Materialized Views. + * Refactored code of table and it’s child nodes. + * Refactored code of columns node. + - Bug fixes + * Fix issue where the Reset button does not get enabled till all + the mandatory fields are provided in the dialog. + * Fix scrolling issue in ‘Users’ dialog. + * Remove the sorting of table headers with no labels. + * Updated documentation for default privileges to clarify more on the + grantor. + * Fix query tool launch error if user name contains HTML characters. + It’s a regression. + * Fix network disconnect issue while establishing the connection via + SSH Tunnel and it impossible to expand the Servers node. + * Fix an issue where the wrong type is displayed when changing the + datatype from timestamp with time zone to timestamp without time zone. + * Ensure that the superuser should be able to create database, as the + superuser overrides all the access restrictions. + * Fix server connection drops out issue in query tool. + * Updated the json file name from ‘servers.json’ to + ‘pgadmin4/servers.json’ in the container deployment section of + the documentation. + * Ensure that the superuser should be able to create role, as the + superuser overrides all the access restrictions. + * Fix reverse engineering SQL issue for partitions when specifying + digits as comments. + * Enhance the logic to change the label from ‘Delete/Drop’ to + ‘Remove’ for the server and server group node. + * Shown some text on process watcher till the initial logs are loaded. + * Fix VPN network disconnect issue where pgAdmin4 hangs on expanding + the Servers node. + * Fix main window tab navigation accessibility issue. + * Ensure that the Servers collection node should expand independently + of server connections. + * Fix the help button link on the User Management dialog. + * Fix accessibility issues. + * Fix XSS issue in explain and explain analyze for table and type which + contain HTML. + * Fix an issue of retrieving properties for Compound Triggers. + It’s a regression. + * Fix an issue where pgAdmin4 unable to retrieve table node if the + trigger is already disabled and the user clicks on Enable All. + * Fix reverse engineering SQL issue for triggers when passed a single + argument to trigger function. + * Fix an issue where length and precision are not removed from + table/column dialog. + * Fix an issue where the Interval data type is not displayed in the + properties dialog of table/column. + * Fix ‘Could not find the object on the server.’ error while + refreshing the check constraint. + * Fix issue where the user can not switch the UI language. It’s a + regression. + * Fix reverse engineering SQL issue where when clause is not visible + for PG/EPAS 12. + * Fix pgAdmin4 failed to start issue after upgrading to version 4.15. + * Added statistics and storage information in reverse engineering SQL + of table/column. + * Fix an issue where the inherited table name with quotes did not escape + correctly. + * Fix an issue where context menu is open along with submenu and + the focus is not on context menu or submenu. + +- Update to 4.15 + - New features ++++ 73 more lines (skipped) ++++ between /work/SRC/openSUSE:Factory/pgadmin4/pgadmin4.changes ++++ and /work/SRC/openSUSE:Factory/.pgadmin4.new.3160/pgadmin4.changes Old: ---- pgadmin4-4.14.tar.gz New: ---- fix-python-lib.patch pgadmin4-4.19.tar.gz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ pgadmin4.spec ++++++ --- /var/tmp/diff_new_pack.9RfUrl/_old 2020-03-17 13:09:58.001790737 +0100 +++ /var/tmp/diff_new_pack.9RfUrl/_new 2020-03-17 13:09:58.001790737 +0100 @@ -1,7 +1,7 @@ # # spec file for package pgadmin4 # -# Copyright (c) 2019 SUSE LINUX GmbH, Nuernberg, Germany. +# Copyright (c) 2020 SUSE LLC # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed @@ -18,7 +18,7 @@ %global pgadmin4instdir %{_libdir}/pgadmin4-%{version} Name: pgadmin4 -Version: 4.14 +Version: 4.19 Release: 0 Summary: Management tool for PostgreSQL License: PostgreSQL @@ -34,6 +34,7 @@ Source7: README.SUSE Patch0: use-os-makedirs.patch Patch1: fix-python3-crypto-call.patch +Patch2: fix-python-lib.patch BuildRequires: Mesa-libGL-devel BuildRequires: fdupes BuildRequires: gcc-c++ @@ -127,6 +128,9 @@ %setup -q %patch0 -p1 %patch1 -p1 +%if %{?pkg_vcmp:%{pkg_vcmp python3-devel >= 3.8}}%{!?pkg_vcmp:0} +%patch2 -p1 +%endif cp %{S:7} . # rpmlint chmod -x docs/en_US/theme/pgadmin4/static/style.css @@ -135,6 +139,7 @@ %build cd runtime export PYTHON_CONFIG=%{_bindir}/python3-config +export PYTHON_VERSION=%{python3_version} export CFLAGS=%{RPM_OPT_FLAGS} qmake-qt5 -o Makefile pgAdmin4.pro make %{?_smp_mflags} VERBOSE=1 @@ -199,6 +204,7 @@ %service_del_postun %{name}.service %files +%defattr(-,root,root,-) %doc README README.SUSE %license LICENSE %{_bindir}/pgAdmin4 @@ -207,6 +213,7 @@ %config %{_sysconfdir}/xdg/pgadmin/pgadmin4.conf %files web +%defattr(-,root,root,-) %dir %{python3_sitelib}/%{name}-web/ %{python3_sitelib}/%{name}-web/* %dir %{_sysconfdir}/apache2 @@ -218,6 +225,7 @@ %ghost %dir %{_rundir}/%{name} %files doc +%defattr(-,root,root,-) %dir %{_docdir}/%{name}-docs %doc %{_docdir}/%{name}-docs/* ++++++ fix-python-lib.patch ++++++ From: Antonio Larrosa <[email protected]> Subject: Fix a linking to the python library Python 3.8's python3-config doesn't seem to include the python3.8 library anymore, so we have to add it ourselves. Use an environment variable (just as in the Windows case) to find out the library version to link to. Index: pgadmin4-4.19/runtime/pgAdmin4.pro =================================================================== --- pgadmin4-4.19.orig/runtime/pgAdmin4.pro +++ pgadmin4-4.19/runtime/pgAdmin4.pro @@ -55,6 +55,7 @@ else { # Find and configure Python # Environment setting PYTHON_CONFIG = $$(PYTHON_CONFIG) + PYTHON_VERSION = $$(PYTHON_VERSION) # Python 2? isEmpty(PYTHON_CONFIG) { @@ -71,11 +72,15 @@ else { error(The python-config executable could not be found. Ensure Python is installed and in the system path.) } + isEmpty(PYTHON_VERSION) { + error(Please set the PYTHON_VERSION environment variable to the version of python to link to.) + } + message(Using $$PYTHON_CONFIG) QMAKE_CXXFLAGS += $$system($$PYTHON_CONFIG --includes) QMAKE_LFLAGS += $$system($$PYTHON_CONFIG --ldflags) - LIBS += $$system($$PYTHON_CONFIG --libs) + LIBS += $$system($$PYTHON_CONFIG --libs) -lpython$$PYTHON_VERSION contains( LIBS, -lpython2.* ) { DEFINES += PYTHON2 ++++++ pgadmin4-4.14.tar.gz -> pgadmin4-4.19.tar.gz ++++++ /work/SRC/openSUSE:Factory/pgadmin4/pgadmin4-4.14.tar.gz /work/SRC/openSUSE:Factory/.pgadmin4.new.3160/pgadmin4-4.19.tar.gz differ: char 5, line 1 ++++++ use-os-makedirs.patch ++++++ --- /var/tmp/diff_new_pack.9RfUrl/_old 2020-03-17 13:09:58.113790822 +0100 +++ /var/tmp/diff_new_pack.9RfUrl/_new 2020-03-17 13:09:58.113790822 +0100 @@ -3,14 +3,14 @@ So parent directories are created if needed -Index: pgadmin4-3.3/web/pgadmin/setup/data_directory.py +Index: pgadmin4-4.19/web/pgadmin/setup/data_directory.py =================================================================== ---- pgadmin4-3.3.orig/web/pgadmin/setup/data_directory.py -+++ pgadmin4-3.3/web/pgadmin/setup/data_directory.py -@@ -12,7 +12,7 @@ import os +--- pgadmin4-4.19.orig/web/pgadmin/setup/data_directory.py ++++ pgadmin4-4.19/web/pgadmin/setup/data_directory.py +@@ -13,7 +13,7 @@ from flask import current_app def _create_directory_if_not_exists(_path): - if not os.path.exists(_path): + if _path and not os.path.exists(_path): - os.mkdir(_path) + os.makedirs(_path)
