Something went wrong. Try again.
What happens if I push all of nixpkgs
Something went wrong. Try again.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330{ lib, python3, fetchFromGitHub, zlib, nixosTests, postgresqlTestHook, postgresql, yarn-berry_4, nodejs, autoconf, automake, libtool, libpng, nasm, cmake, pkg-config, stdenv, srcOnly, server-mode ? true,}:
let pname = "pgadmin"; version = "9.5"; yarnHash = "sha256-i3WCEpcZepB7K0A4QgjoLfkO7icew/8usJCo4DkWT6I=";
src = fetchFromGitHub { owner = "pgadmin-org"; repo = "pgadmin4"; rev = "REL-${lib.versions.major version}_${lib.versions.minor version}"; hash = "sha256-5FwYkdhpg/2Cidi2qiFhhsQYbIwsp80K3MNxw5rp4ww="; };
mozjpeg-bin = fetchFromGitHub { owner = "imagemin"; repo = "mozjpeg-bin"; rev = "c0587fbc00b21ed8cad8bae499a0827baeaf7ffa"; hash = "sha256-D/pXQBlIIyk7KAgxJ1gKqxYxtlfBbLzUSmYZbH659cA="; };
# keep the scope, as it is used throughout the derivation and tests # this also makes potential future overrides easier pythonPackages = python3.pkgs.overrideScope (final: prev: { });
# don't bother to test kerberos authentication # skip tests on macOS which fail due to an error in keyring, see https://github.com/NixOS/nixpkgs/issues/281214 skippedTests = builtins.concatStringsSep "," ( [ "browser.tests.test_kerberos_with_mocking" ] ++ lib.optionals stdenv.hostPlatform.isDarwin [ "browser.server_groups.servers.tests.test_all_server_get" "browser.server_groups.servers.tests.test_check_connect" "browser.server_groups.servers.tests.test_check_ssh_mock_connect" "browser.server_groups.servers.tests.test_is_password_saved" ] );in
pythonPackages.buildPythonApplication rec { inherit pname version src;
offlineCache = yarn-berry_4.fetchYarnBerryDeps { # mozjpeg fails to build on darwin due to a hardocded path # this has been fixed upstream on master but no new version # has been released. We therefore point yarn to upstream # see https://github.com/imagemin/mozjpeg-bin/issues/64 # and https://github.com/imagemin/mozjpeg-bin/issues/81 patches = [ ./mozjpeg.patch ]; src = src + "/web"; hash = yarnHash; };
# from Dockerfile CPPFLAGS = "-DPNG_ARM_NEON_OPT=0";
format = "setuptools";
patches = [ # Expose setup.py for later use ./expose-setup.py.patch # check for permission of /etc/pgadmin/config_system and don't fail ./check-system-config-dir.patch ];
postPatch = '' # the patch needs to be executed inside the /web subfolder # therefore it is included here and not in `patches` cd web patch -u yarn.lock ${./mozjpeg.patch} cd .. # patching Makefile, so it doesn't try to build sphinx documentation here # (will do so later) substituteInPlace Makefile \ --replace-fail 'LC_ALL=en_US.UTF-8 LANG=en_US.UTF-8 $(MAKE) -C docs/en_US -f Makefile.sphinx html' "true"
# fix document which refers a non-existing document and fails substituteInPlace docs/en_US/contributions.rst \ --replace-fail "code_snippets" "" # relax dependencies sed 's|==|>=|g' -i requirements.txt # fix extra_require error with "*" in match sed 's|*|0|g' -i requirements.txt substituteInPlace pkg/pip/setup_pip.py \ --replace-fail "req = req.replace('psycopg[c]', 'psycopg[binary]')" "req = req" ${lib.optionalString (!server-mode) '' substituteInPlace web/config.py \ --replace-fail "SERVER_MODE = True" "SERVER_MODE = False" ''} '';
dontYarnBerryInstallDeps = true; env.YARN_ENABLE_SCRIPTS = "0"; dontUseCmakeConfigure = true;
preBuild = '' # Adapted from pkg/pip/build.sh echo Creating required directories... mkdir -p pip-build/pgadmin4/docs
echo Building the documentation cd docs/en_US sphinx-build -W -b html -d _build/doctrees . _build/html
# Build the clean tree cd .. cp -r * ../pip-build/pgadmin4/docs for DIR in `ls -d ??_??/` do if [ -d ''${DIR}_build/html ]; then mkdir -p ../pip-build/pgadmin4/docs/''${DIR}_build cp -R ''${DIR}_build/html ../pip-build/pgadmin4/docs/''${DIR}_build fi done cd ../
echo Building the web frontend... cd web ( export LD=$CC # https://github.com/imagemin/optipng-bin/issues/108 yarnBerryConfigHook ) # mozjpeg vendored source isn't included in the checkout for yarn. If we copy it before the # yarnConfigHook it will just get overwritten. So we first run the configHook without build, # then copy the vendored source and then build the dependencies # This has the disadvantage of repeating some of the yarnConfigHooks logic here mkdir -p node_modules/mozjpeg/vendor/source cp ${mozjpeg-bin}/vendor/source/mozjpeg.tar.gz node_modules/mozjpeg/vendor/source/ ( # https://github.com/mozilla/mozjpeg/issues/438 substituteInPlace node_modules/mozjpeg/lib/install.js --replace-fail "cmake -DCMAKE" "cmake -DENABLE_STATIC=FALSE -DCMAKE" substituteInPlace node_modules/mozjpeg/lib/install.js --replace-fail "cp cjpeg-static" "cp cjpeg" export LD=$CC export HOME=$(mktemp -d) export YARN_ENABLE_SCRIPTS=1 YARN_IGNORE_PATH=1 ${yarn-berry_4.yarn-berry-offline}/bin/yarn config set enableTelemetry false YARN_IGNORE_PATH=1 ${yarn-berry_4.yarn-berry-offline}/bin/yarn config set enableGlobalCache false export npm_config_nodedir="${srcOnly nodejs}" export npm_config_node_gyp="${nodejs}/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" YARN_IGNORE_PATH=1 ${yarn-berry_4.yarn-berry-offline}/bin/yarn install --inline-builds ) yarn webpacker cp -r * ../pip-build/pgadmin4 # save some disk space rm -rf ../pip-build/pgadmin4/node_modules
cd ..
echo Creating distro config... echo HELP_PATH = \'../../docs/en_US/_build/html/\' > pip-build/pgadmin4/config_distro.py echo MINIFY_HTML = False >> pip-build/pgadmin4/config_distro.py
echo Creating manifest... echo recursive-include pgadmin4 \* > pip-build/MANIFEST.in
echo Building wheel... cd pip-build # copy non-standard setup.py to local directory # so setuptools-build-hook can call it cp -v ../pkg/pip/setup_pip.py setup.py '';
nativeBuildInputs = with pythonPackages; [ cython pip sphinx yarn-berry_4 yarn-berry_4.yarnBerryConfigHook nodejs
# for building mozjpeg2 cmake autoconf automake libtool nasm pkg-config ];
buildInputs = [ zlib pythonPackages.wheel # for mozjpeg2 libpng ];
propagatedBuildInputs = with pythonPackages; [ flask flask-login flask-mail flask-migrate flask-sqlalchemy flask-wtf flask-compress passlib pytz simplejson sqlparse wtforms flask-paranoid psutil psycopg python-dateutil sqlalchemy itsdangerous flask-security bcrypt cryptography sshtunnel ldap3 flask-babel gssapi flask-socketio eventlet user-agents wheel authlib qrcode pillow pyotp botocore boto3 azure-mgmt-subscription azure-mgmt-rdbms azure-mgmt-resource azure-identity sphinxcontrib-youtube dnspython google-auth-oauthlib google-api-python-client keyring typer rich jsonformatter libgravatar setuptools ];
passthru.tests = { inherit (nixosTests) pgadmin4; };
nativeCheckInputs = [ postgresqlTestHook postgresql pythonPackages.testscenarios pythonPackages.selenium ];
# sandboxing issues on aarch64-darwin, see https://github.com/NixOS/nixpkgs/issues/198495 doCheck = !postgresqlTestHook.meta.broken;
checkPhase = '' runHook preCheck
## Setup ##
# pgadmin needs a home directory to save the configuration export HOME=$TMPDIR cd pgadmin4
# set configuration for postgresql test # also ensure Server Mode is set to false. If not, the tests will fail, since pgadmin expects read/write permissions # in /var/lib/pgadmin and /var/log/pgadmin # see https://github.com/pgadmin-org/pgadmin4/blob/fd1c26408bbf154fa455a49ee5c12895933833a3/web/regression/runtests.py#L217-L226 cp -v regression/test_config.json.in regression/test_config.json substituteInPlace regression/test_config.json --replace-fail "localhost" "$PGHOST" substituteInPlace regression/runtests.py --replace-fail "builtins.SERVER_MODE = None" "builtins.SERVER_MODE = False"
## Browser test ## python regression/runtests.py --pkg browser --exclude ${skippedTests}
## Reverse engineered SQL test ## python regression/runtests.py --pkg resql
runHook postCheck '';
meta = { description = "Administration and development platform for PostgreSQL${ lib.optionalString (!server-mode) ". Desktop Mode" }"; longDescription = '' pgAdmin 4 is designed to meet the needs of both novice and experienced Postgres users alike, providing a powerful graphical interface that simplifies the creation, maintenance and use of database objects. ${ if server-mode then '' This version is build with SERVER_MODE set to True (the default). It will require access to `/var/lib/pgadmin` and `/var/log/pgadmin`. This is the default version for the NixOS module `services.pgadmin`. This should NOT be used in combination with the `pgadmin4-desktopmode` package as they will interfere. '' else '' This version is build with SERVER_MODE set to False. It will require access to `~/.pgadmin/`. This version is suitable for single-user deployment or where access to `/var/lib/pgadmin` cannot be granted or the NixOS module cannot be used (e.g. on MacOS). This should NOT be used in combination with the NixOS module `pgadmin` as they will interfere. '' } ''; homepage = "https://www.pgadmin.org/"; license = lib.licenses.mit; changelog = "https://www.pgadmin.org/docs/pgadmin4/latest/release_notes_${lib.versions.major version}_${lib.versions.minor version}.html"; maintainers = with lib.maintainers; [ gador ]; mainProgram = "pgadmin4"; platforms = lib.platforms.unix; };}