SHA256
1
0
forked from pool/pgadmin4
Files
pgadmin4/pgadmin4.spec

472 lines
20 KiB
RPMSpec
Raw Permalink Normal View History

#
# spec file for package pgadmin4
#
2024-01-15 11:11:25 +00:00
# Copyright (c) 2024 SUSE LLC
#
# All modifications and additions to the file contributed by third parties
# remain the property of their copyright owners, unless otherwise agreed
# upon. The license for this file, and modifications and additions to the
# file, is the same license as for the pristine package itself (unless the
# license for the pristine package is not an Open Source License, in which
# case the license is the MIT License). An "Open Source License" is a
# license that conforms to the Open Source Definition (Version 1.9)
# published by the Open Source Initiative.
Accepting request 704370 from home:ecsos:server - Update to pgadmin4 4.6 - Features * Feature #4165 - Depend on psycopg2-binary in the Python wheel, rather than psycopg2. - Bug fixes * Ensure that on clicking Delete button should not delete rows immediately from the database server, it should be deleted when Save button will be clicked. * Ensure that newly added row in backgrid should be visible. * Ensure that JSON strings as comments should be added properly for all the objects. * Fix an issue where Deleting N number of rows makes first N number of rows disable. * Added support for Default Partition. * Fix an issue where ‘GRANT UPDATE’ sql should be displayed for default sequence privileges. * Ensure that confirmation dialog should be popped up before reload of query tool or debugger if it is opened in a new browser tab. * Ensure that record should be add/edited for root partition table with primary keys. * Fixed alignment issue of columns in definition section of Index node. * Fixed ‘Location cannot be empty’ error when open Tablespace properties. * Fix an issue where the dropdown becomes misaligned/displaced. * Ensure the treeview shows all sequences except those used to implement IDENTITY columns (which can be edited as part of the column). Show all if Show System Objects is enabled. * Fixed ‘Increment value cannot be empty’ error for existing tables. * Ensure that parameters of procedures for EPAS server 10 and below should be set/reset properly. * Prevent duplicate columns being included in reverse engineered SQL for tables. * Ensure sanity of the permissions on the storage and session directories and the config database. OBS-URL: https://build.opensuse.org/request/show/704370 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=13
2019-05-22 08:35:19 +00:00
# Please submit bugfixes or comments via https://bugs.opensuse.org/
#
2024-01-15 11:11:25 +00:00
%{?sle15_python_module_pythons}
%if 0%{?suse_version} > 1500
%global pythons %primary_python
%endif
%global python3_authlib_min_version 1.3.0
%global python3_azure_identity_min_version 1.15
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
%global python3_azure_mgmt_rdbms_min_version 10.1
%global python3_azure_mgmt_resource_min_version 23.0.1
%global python3_azure_mgmt_subscription_min_version 3.1.1
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
%global python3_bcrypt_min_version 4.0
%global python3_boto3_min_version 1.33
%global python3_cryptography_min_version 42.0
%global python3_eventlet_min_version 0.33.3
%global python3_flask_babel_min_version 4.0.0
%global python3_flask_compress_min_version 1.4.0
%global python3_flask_gravatar_min_version 0.5.0
%global python3_flask_login_min_version 0.4.1
%global python3_flask_mail_min_version 0.9.1
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
%global python3_flask_migrate_min_version 4.0
%global python3_flask_min_version 3.0
%global python3_flask_paranoid_min_version 0.2.0
%global python3_flask_security_too_min_version 5.4.0
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
%global python3_flask_socketio_min_version 5.3.0
%global python3_flask_sqlalchemy_min_version 3.1
%global python3_flask_wtf_min_version 1.2
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
%global python3_httpagentparser_min_version 1.9
%global python3_jsonformatter_min_version 0.3.2
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
%global python3_google_api_python_client_min_version 2.0
%global python3_google_auth_oauthlib_min_version 1.2.0
%global python3_ldap3_min_version 2.5.1
%global python3_libgravatar_min_version 1.0.0
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
%global python3_pillow_min_version 9.0
%global python3_pyotp_min_version 2.0
%global python3_keyring_min_version 24.0
%global python3_passlib_min_version 1.7.2
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
%global python3_psutil_min_version 5.9.0
%global python3_psycopg_min_version 3.1.12
%global python3_python_dateutil_min_version 2.8.0
%global python3_pytz_min_version 2024.0
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
%global python3_qrcode_min_version 7.0
%global python3_sqlalchemy_min_version 2.0
%global python3_sqlparse_min_version 0.3.0
%global python3_sshtunnel_min_version 0.1.5
%global python3_typer_min_version 0.12.0
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
%global python3_user_agents_min_version 2.2
%global python3_werkzeug_min_version 3.0
%global python3_wtforms_min_version 3.1
%global pgadmin4instdir %{_libdir}/pgadmin4-%{version}
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
%global pgadmin4homedir %{_localstatedir}/lib/pgadmin
%global user_group_name pgadmin
Name: pgadmin4
Version: 8.8
Release: 0
Summary: Management tool for PostgreSQL
License: PostgreSQL
Group: Productivity/Databases/Tools
URL: http://www.pgadmin.org
Source0: https://download.postgresql.org/pub/pgadmin/%{name}/v%{version}/source/%{name}-%{version}.tar.gz
Source1: %{name}.conf.in
Source2: %{name}.service.in
Source3: %{name}.tmpfiles.d
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
Source4: %{name}.desktop
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
Source5: pgadmin-user.conf
Source7: %{name}.uwsgi.in
Source8: README.SUSE
Source9: README.SUSE.uwsgi.in
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
Source10: https://download.postgresql.org/pub/pgadmin/%{name}/v%{version}/source/%{name}-%{version}.tar.gz.asc
# https://www.pgadmin.org/download/pgadmin-4-source-code/
Source11: %{name}.keyring
Source13: %{name}-desktop
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
Source14: optipng
Source20: package-lock.json
Source99: update-vendor.sh
Source100: node_modules.spec.inc
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
%include %{_sourcedir}/node_modules.spec.inc
Patch0: use-os-makedirs.patch
Patch1: fix-python3-crypto-call.patch
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
Patch2: support-new-azure-mgmt-rdbms.patch
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
Patch5: fix-eventlet-select_epoll.patch
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
Patch6: make-cloud-packages-optional.patch
Patch10: package_deps.patch
Patch1000: package_git_local.patch
2024-01-15 11:11:25 +00:00
BuildRequires: %{python_module Authlib >= %{python3_authlib_min_version}}
BuildRequires: %{python_module Flask >= %{python3_flask_min_version}}
BuildRequires: %{python_module Flask-Babel >= %{python3_flask_babel_min_version}}
BuildRequires: %{python_module Flask-Compress >= %{python3_flask_compress_min_version}}
BuildRequires: %{python_module Flask-Login >= %{python3_flask_login_min_version}}
BuildRequires: %{python_module Flask-Mail >= %{python3_flask_mail_min_version}}
BuildRequires: %{python_module Flask-Migrate >= %{python3_flask_migrate_min_version}}
BuildRequires: %{python_module Flask-Paranoid >= %{python3_flask_paranoid_min_version}}
BuildRequires: %{python_module Flask-SQLAlchemy >= %{python3_flask_sqlalchemy_min_version}}
BuildRequires: %{python_module Flask-Security-Too >= %{python3_flask_security_too_min_version}}
BuildRequires: %{python_module Flask-SocketIO >= %{python3_flask_socketio_min_version}}
BuildRequires: %{python_module Flask-WTF >= %{python3_flask_wtf_min_version}}
BuildRequires: %{python_module SQLAlchemy >= %{python3_sqlalchemy_min_version}}
BuildRequires: %{python_module WTForms >= %{python3_wtforms_min_version}}
BuildRequires: %{python_module Werkzeug >= %{python3_werkzeug_min_version}}
BuildRequires: %{python_module bcrypt >= %{python3_bcrypt_min_version}}
BuildRequires: %{python_module cryptography >= %{python3_cryptography_min_version}}
BuildRequires: %{python_module eventlet >= %{python3_eventlet_min_version}}
BuildRequires: %{python_module httpagentparser >= %{python3_httpagentparser_min_version}}
BuildRequires: %{python_module jsonformatter >= %{python3_jsonformatter_min_version}}
2024-01-15 11:11:25 +00:00
BuildRequires: %{python_module keyring >= %{python3_keyring_min_version}}
BuildRequires: %{python_module ldap3 >= %{python3_ldap3_min_version}}
BuildRequires: %{python_module libgravatar >= %{python3_libgravatar_min_version}}
2024-01-15 11:11:25 +00:00
BuildRequires: %{python_module passlib >= %{python3_passlib_min_version}}
BuildRequires: %{python_module pip}
BuildRequires: %{python_module psutil >= %{python3_psutil_min_version}}
BuildRequires: %{python_module psycopg >= %{python3_psycopg_min_version}}
BuildRequires: %{python_module pyotp >= %{python3_pyotp_min_version}}
BuildRequires: %{python_module python-dateutil >= %{python3_python_dateutil_min_version}}
BuildRequires: %{python_module pytz >= %{python3_pytz_min_version}}
BuildRequires: %{python_module qrcode >= %{python3_qrcode_min_version}}
BuildRequires: %{python_module sqlparse >= %{python3_sqlparse_min_version}}
BuildRequires: %{python_module sshtunnel >= %{python3_sshtunnel_min_version}}
BuildRequires: %{python_module testscenarios}
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
BuildRequires: %{python_module typer >= %{python3_typer_min_version}}
2024-01-15 11:11:25 +00:00
BuildRequires: %{python_module urllib3 < 2}
BuildRequires: %{python_module user-agents >= %{python3_user_agents_min_version}}
BuildRequires: %{python_module wheel}
BuildRequires: fdupes
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
BuildRequires: hicolor-icon-theme
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
BuildRequires: local-npm-registry
BuildRequires: pngcrush
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
BuildRequires: python-rpm-macros
BuildRequires: systemd-rpm-macros
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
BuildRequires: sysuser-tools
2024-01-15 11:11:25 +00:00
Requires: %{python_module Authlib >= %{python3_authlib_min_version}}
Requires: %{python_module Flask >= %{python3_flask_min_version}}
Requires: %{python_module Flask-Babel >= %{python3_flask_babel_min_version}}
Requires: %{python_module Flask-Compress >= %{python3_flask_compress_min_version}}
Requires: %{python_module Flask-Login >= %{python3_flask_login_min_version}}
Requires: %{python_module Flask-Mail >= %{python3_flask_mail_min_version}}
Requires: %{python_module Flask-Migrate >= %{python3_flask_migrate_min_version}}
Requires: %{python_module Flask-Paranoid >= %{python3_flask_paranoid_min_version}}
Requires: %{python_module Flask-SQLAlchemy >= %{python3_flask_sqlalchemy_min_version}}
Requires: %{python_module Flask-Security-Too >= %{python3_flask_security_too_min_version}}
Requires: %{python_module Flask-SocketIO >= %{python3_flask_socketio_min_version}}
Requires: %{python_module Flask-WTF >= %{python3_flask_wtf_min_version}}
Requires: %{python_module SQLAlchemy >= %{python3_sqlalchemy_min_version}}
Requires: %{python_module WTForms >= %{python3_wtforms_min_version}}
Requires: %{python_module Werkzeug >= %{python3_werkzeug_min_version}}
Requires: %{python_module bcrypt >= %{python3_bcrypt_min_version}}
Requires: %{python_module cryptography >= %{python3_cryptography_min_version}}
Requires: %{python_module eventlet >= %{python3_eventlet_min_version}}
Requires: %{python_module httpagentparser >= %{python3_httpagentparser_min_version}}
Requires: %{python_module jsonformatter >= %{python3_jsonformatter_min_version}}
2024-01-15 11:11:25 +00:00
Requires: %{python_module keyring >= %{python3_keyring_min_version}}
Requires: %{python_module ldap3 >= %{python3_ldap3_min_version}}
Requires: %{python_module libgravatar >= %{python3_libgravatar_min_version}}
2024-01-15 11:11:25 +00:00
Requires: %{python_module passlib >= %{python3_passlib_min_version}}
Requires: %{python_module psutil >= %{python3_psutil_min_version}}
Requires: %{python_module psycopg >= %{python3_psycopg_min_version}}
Requires: %{python_module pyotp >= %{python3_pyotp_min_version}}
Requires: %{python_module python-dateutil >= %{python3_python_dateutil_min_version}}
Requires: %{python_module pytz >= %{python3_pytz_min_version}}
Requires: %{python_module qrcode >= %{python3_qrcode_min_version}}
Requires: %{python_module sqlparse >= %{python3_sqlparse_min_version}}
Requires: %{python_module sshtunnel >= %{python3_sshtunnel_min_version}}
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
Requires: %{python_module typer >= %{python3_typer_min_version}}
2024-01-15 11:11:25 +00:00
Requires: %{python_module urllib3 < 2}
Requires: %{python_module user-agents >= %{python3_user_agents_min_version}}
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
Requires: system-user-pgadmin
Requires(postun): system-user-pgadmin
2024-01-15 11:11:25 +00:00
Suggests: %{python_module mod_wsgi}
Accepting request 666302 from home:alarrosa:branches:server:database:postgresql - Update to pgadmin4 4.1 - Bug fixes * Fix SQL generated for tables with inherited columns. * Ensure the context menu works after a server is renamed. * Fix ordering of VACUUM options which changed in PG11. * Don’t show system catalogs in the schemas property list unless show system objects is enabled. * Fix help for the backup/restore dialogues. * Ensure that last row of table data should be visible and user will be able to add new row. * Make the browser more robust in the face of multibyte characters in SQL_ASCII databases. - Update to pgadmin4 4.0 - Features * Allow query plans to be downloaded as an SVG file. * New UI design. * Allow servers to be pre-loaded into container deployments. - Bug fixes * Increase the size of the resize handle of the edit grid text pop-out. * Fix handling of array types as inputs to the debugger. * Fix an issue that could cause the Query Tool to fail to render. * Display event trigger functions correctly on EPAS. * Further improvements to treeview restoration. * Run Postfix in the container build so passwords can be reset etc. * Add titles to the code areas of the Query Tool and Debugger to ensure that panels can be re-docked within them. * Fix a webpack issue that could cause the Query Tool to fail to render. * Ensure we display the relation name (and not the OID) in the OBS-URL: https://build.opensuse.org/request/show/666302 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=6
2019-01-16 13:48:17 +00:00
Suggests: %{name}-doc
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
Recommends: %{name}-cloud
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
Recommends: %{name}-desktop
Obsoletes: %{name}-web < %{version}
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
%{?systemd_requires}
ExcludeArch: s390x
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
BuildArch: noarch
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
%description
pgAdmin 4 is a rewrite of the pgAdmin3 management tool for the
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
PostgreSQL database. It is written as a web application in Python,
using jQuery and Bootstrap for the client side processing and UI. On
the server side, Flask is being utilised.
This package contains the required files to run pgAdmin4 as a web application
%package doc
Summary: Documentation for pgAdmin4
Group: Documentation/HTML
%description doc
pgAdmin 4 is a rewrite of the pgAdmin3 management tool for the
PostgreSQL database.
This package contains the documentation for pgadmin4.
%package web-uwsgi
Summary: Pgamdin4 - uwsgi configuration
Group: Productivity/Networking/Web/Utilities
Requires: pgadmin4
Requires: uwsgi
%description web-uwsgi
pgadmin4 is a management tool for PostgreSQL.
This package holds the uwsgi configuration.
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
%package desktop
Summary: Desktop application for pgAdmin4
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
Group: Productivity/Networking/Web/Utilities
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
Requires: %{name}
2024-01-15 11:11:25 +00:00
Requires: %{python_module qt5}
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
%description desktop
pgAdmin 4 is a rewrite of the pgAdmin3 management tool for the
PostgreSQL database.
This package provides a small python script that can be used
to start pgAdmin4 as a regular user and provides a simple ui
as a system tray icon to open more windows or quit.
Note that his script is not related to the official pgAdmin4
runtime application and is NOT supported by the pgAdmin project
but only provided for convenience.
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
%package -n system-user-pgadmin
Summary: System user for pgadmin
Group: System/Base
BuildArch: noarch
%sysusers_requires
%description -n system-user-pgadmin
System user for pgadmin.
%package cloud
Summary: Cloud support for pgAdmin4
Group: Productivity/Networking/Web/Utilities
%if 0%{suse_version} > 1550
BuildRequires: %{python_module azure-identity >= %{python3_azure_identity_min_version}}
BuildRequires: %{python_module azure-mgmt-rdbms >= %{python3_azure_mgmt_rdbms_min_version}}
BuildRequires: %{python_module azure-mgmt-resource >= %{python3_azure_mgmt_resource_min_version}}
BuildRequires: %{python_module azure-mgmt-subscription >= %{python3_azure_mgmt_subscription_min_version}}
BuildRequires: %{python_module boto3 >= %{python3_boto3_min_version}}
BuildRequires: %{python_module google-api-python-client >= %{python3_google_api_python_client_min_version}}
BuildRequires: %{python_module google-auth-oauthlib >= %{python3_google_auth_oauthlib_min_version}}
%endif
Requires: %{name}
Requires: %{python_module azure-identity >= %{python3_azure_identity_min_version}}
Requires: %{python_module azure-mgmt-rdbms >= %{python3_azure_mgmt_rdbms_min_version}}
Requires: %{python_module azure-mgmt-resource >= %{python3_azure_mgmt_resource_min_version}}
Requires: %{python_module azure-mgmt-subscription >= %{python3_azure_mgmt_subscription_min_version}}
Requires: %{python_module boto3 >= %{python3_boto3_min_version}}
Requires: %{python_module google-api-python-client >= %{python3_google_api_python_client_min_version}}
Requires: %{python_module google-auth-oauthlib >= %{python3_google_auth_oauthlib_min_version}}
%description cloud
pgAdmin 4 is a rewrite of the pgAdmin3 management tool for the
PostgreSQL database.
This package adds the package requirements neccesary to have cloud
(azure/google) support in pgadmin4.
%prep
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
%autosetup -p1
2024-01-15 11:11:25 +00:00
sed -e 's@PYTHONSITELIB@%{python_sitelib}@g' <%{SOURCE1} > %{name}.conf
%{python_expand #
sed -e 's@PYTHONDIR@%{expand:%__%{expand:$python}}@g' -e 's@PYTHONSITELIB@%{python_sitelib}@g' < %{SOURCE2} > %{name}.service
}
sed -e 's@PYTHONSITELIB@%{python_sitelib}@g' <%{SOURCE7} > %{name}.uwsgi
sed -e 's@PYTHONSITELIB@%{python_sitelib}@g' <%{SOURCE9} > README.SUSE.uwsgi
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
# speaklater isn't really used
sed -i -e 's/^speaklater.*//' requirements.txt
# The bumped requirement for cryptography 42.0.* isn't real and 41.0.* (which is what we have in SLE) should be enough
sed -i -e 's/^cryptography==42\.0\.\*/cryptography==41.0.*/' requirements.txt
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
2024-01-15 11:11:25 +00:00
# Remove dependency on yarn version for which there's not an available package
sed -i -z -e 's/,\n *"packageManager": "yarn@3.6.4"//' web/package.json
cp %{SOURCE8} .
cp %{SOURCE9} .
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
# rpmlint
chmod -x docs/en_US/theme/pgadmin4/static/style.css
chmod -x docs/en_US/theme/pgadmin4/theme.conf
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
# This package is run using the interpreter so it doesn't need the executable bit set
chmod -x web/pgadmin/misc/bgprocess/process_executor.py
chmod -x web/pgadmin/static/fonts/*.ttf
rm web/regression/.gitignore
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
pushd web
local-npm-registry %{_sourcedir} install --legacy-peer-deps --ignore-scripts
popd
# Use the system optipng, not the one built when creating the vendor package in the developer workstation
#mkdir -p web/node_modules/optipng-bin/vendor/
#cp %%{SOURCE14} web/node_modules/optipng-bin/vendor/optipng
%build
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
pushd web
NODE_ENV=production NODE_OPTIONS=--max-old-space-size=2048 npx eslint --no-eslintrc -c .eslintrc.js --ext .js --ext .jsx --ext .ts --ext .tsx . && npx webpack --config webpack.config.js --progress
rm -Rf node_modules package-lock.json yarn.lock
popd
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
export EVENTLET_NO_GREENDNS='yes'
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
mkdir -p pip-build/pgadmin4
cp -a web/* pip-build/pgadmin4
echo recursive-include pgadmin4 \* > pip-build/MANIFEST.in
find pip-build -name '.gitignore' -o -name '.coverage*' -delete
cat << EOF > pip-build/pgadmin4/config_distro.py
# SERVER_MODE = True
MINIFY_HTML = False
HTML_HELP = '%{_datadir}/doc/%{name}-docs/en_US/html/'
UPGRADE_CHECK_ENABLED = False
DEFAULT_BINARY_PATHS = {
"pg": "%{_bindir}"
}
EOF
pushd pip-build
2024-01-15 11:11:25 +00:00
%python_exec ../pkg/pip/setup_pip.py bdist_wheel
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
popd
mv -v pip-build/dist/*.whl .
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
%sysusers_generate_pre %{SOURCE5} pgadmin pgadmin-user.conf
%install
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
%pyproject_install
mkdir -p %{buildroot}%{_docdir}/%{name}
cp README.md %{buildroot}%{_docdir}/%{name}
install -d -m 755 %{buildroot}%{_docdir}/%{name}-docs/
cp -pr docs/* %{buildroot}%{_docdir}/%{name}-docs
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
find %{buildroot}%{_docdir}/%{name}-docs -name '.gitignore' -delete
install -d %{buildroot}%{_sysconfdir}/apache2/conf.d/
install -m 0644 -p %{name}.conf %{buildroot}%{_sysconfdir}/apache2/conf.d/%{name}.conf
# Install desktop file
install -d %{buildroot}%{_datadir}/applications/
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
install -m 0644 -p %{SOURCE4} %{buildroot}%{_datadir}/applications/%{name}.desktop
# Install config system for webapp
install -d -m 0755 %{buildroot}%{_sysconfdir}/pgadmin/
echo "# SERVER_MODE = True" > %{buildroot}%{_sysconfdir}/pgadmin/config_system.py
# Install unit file/init script
# This is only for systemd supported distros:
install -d %{buildroot}%{_unitdir}
install -m 0644 -p %{name}.service %{buildroot}%{_unitdir}/%{name}.service
# ... and make a tmpfiles script to recreate it at reboot.
mkdir -p %{buildroot}/%{_tmpfilesdir}
install -m 0644 %{SOURCE3} %{buildroot}/%{_tmpfilesdir}/%{name}.conf
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
mkdir -p %{buildroot}/%{_sysusersdir}
install -m 0644 %{SOURCE5} %{buildroot}/%{_sysusersdir}/pgadmin-user.conf
chmod -x %{buildroot}%{_docdir}/%{name}-docs/en_US/images/*
mkdir -p %{buildroot}%{_sbindir}
ln -s %{_sbindir}/service %{buildroot}%{_sbindir}/rcpgadmin4
install -d -m 0755 %{buildroot}%{pgadmin4homedir}
install -d -m 0755 %{buildroot}%{pgadmin4homedir}/storage
install -d -m 0700 %{buildroot}%{pgadmin4homedir}/sessions
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
install -d -m 0755 %{buildroot}%{_localstatedir}/log/pgadmin
install -d -m 0755 %{buildroot}%{_sysconfdir}/uwsgi/vassals
install -m 0644 %{name}.uwsgi %{buildroot}%{_sysconfdir}/uwsgi/vassals/pgadmin4.ini
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
install -d -m 0755 %{buildroot}%{_datadir}/icons/hicolor/256x256/apps
install -m 0644 web/pgadmin/static/img/logo-256.png %{buildroot}%{_datadir}/icons/hicolor/256x256/apps/pgadmin4.png
2024-01-15 11:11:25 +00:00
install -d -m 0755 %{buildroot}%{python_sitelib}/%{name}/assets
install -m 0644 ./runtime/assets/welcome_logo.svg %{buildroot}%{python_sitelib}/%{name}/assets/welcome_logo.svg
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
install -m 0755 %{SOURCE13} %{buildroot}%{_bindir}
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
%{python_expand # Fix shebang path for pgadmin4-desktop
sed -i "1s|#\!.*python.*|#\!/usr/bin/$python|" %{buildroot}%{_bindir}/pgadmin4-desktop
}
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
2024-01-15 11:11:25 +00:00
%fdupes %{buildroot}%{python_sitelib}
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
##%% check
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
## Requires Postgres running
2024-01-15 11:11:25 +00:00
##PYTHONPATH=%%{buildroot}%%{python_sitelib} python3 -B web/regression/runtests.py --exclude feature_tests
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
%pre
%service_add_pre %{name}.service
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
%post
%service_add_post %{name}.service
%tmpfiles_create %{_tmpfilesdir}/%{name}.conf
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
%preun
%service_del_preun %{name}.service
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
%postun
%service_del_postun %{name}.service
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
%pre -n system-user-pgadmin -f pgadmin.pre
%files
%defattr(-,root,root,-)
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
%doc README.md README.SUSE
%license LICENSE
Accepting request 1101479 from home:StevenK:branches:server:database:postgresql - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * Added '--replace' option in Import server to replace the list of servers with the newly imported one. * Added zoom scaling options with keyboard shortcuts in runtime. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * Added support to set auto width of columns by content size in the data output window. * Added support to connect PostgreSQL servers via Kerberos authentication. * Added "IF NOT EXISTS" clause while creating tables and partition tables which is convenient while using the ERD tool. * Added browse button to select the binary path in the Preferences. * Added Grant Wizard option under Package node. * Added support to launch PSQL for the connected database server. * Added window maximize/restore functionality for properties dialog. * Added support to set the binary path for the different database server versions. * Added OS, Browser, Configuration details in the About dialog. * Added support for rotating the pgAdmin log file on the basis of size OBS-URL: https://build.opensuse.org/request/show/1101479 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
2023-08-04 09:49:01 +00:00
%{_bindir}/pgadmin4
2024-01-15 11:11:25 +00:00
%{_bindir}/pgadmin4-cli
%dir %{_sysconfdir}/apache2
%dir %{_sysconfdir}/apache2/conf.d
%config(noreplace) %{_sysconfdir}/apache2/conf.d/%{name}.conf
2024-01-15 11:11:25 +00:00
%{python_sitelib}/%{name}
%{python_sitelib}/%{name}-%{version}.dist-info
%{_unitdir}/%{name}.service
%{_tmpfilesdir}/%{name}.conf
%{_sbindir}/rcpgadmin4
%defattr(-,root,%{user_group_name})
%dir %{_sysconfdir}/pgadmin
%config(noreplace) %{_sysconfdir}/pgadmin/config_system.py
%defattr(-,%{user_group_name},%{user_group_name})
%ghost %dir %{_rundir}/%{name}
%dir %{pgadmin4homedir}/storage
%attr(700,%{user_group_name},%{user_group_name}) %dir %{pgadmin4homedir}/sessions
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
%dir %{_localstatedir}/log/pgadmin
%files doc
%defattr(-,root,root,-)
%dir %{_docdir}/%{name}-docs
%doc %{_docdir}/%{name}-docs/*
%files web-uwsgi
%defattr(-,root,root,-)
%doc README.SUSE.uwsgi
%dir %{_sysconfdir}/uwsgi
%dir %{_sysconfdir}/uwsgi/vassals
%config (noreplace) %{_sysconfdir}/uwsgi/vassals/pgadmin4.ini
Accepting request 1120781 from home:alarrosa:branches:server:database:postgresql - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 OBS-URL: https://build.opensuse.org/request/show/1120781 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
2023-10-27 13:08:10 +00:00
%files desktop
%defattr(-,root,root,-)
%{_bindir}/pgadmin4-desktop
%{_datadir}/applications/%{name}.desktop
%{_datadir}/icons/hicolor/256x256/apps/pgadmin4.png
Accepting request 1145351 from home:alarrosa:branches:server:database:postgresql - Fix shebang of pgadmin4-desktop to use python3.11 - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. OBS-URL: https://build.opensuse.org/request/show/1145351 OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
2024-02-09 06:41:39 +00:00
%files -n system-user-pgadmin
%defattr(-,root,root,-)
%dir %attr(0755,%{user_group_name},%{user_group_name}) %{pgadmin4homedir}
%_sysusersdir/pgadmin-user.conf
%files cloud
%changelog