pgcli 4.0.0 fails to install from source code

[sryze]

Output of brew config

HOMEBREW_VERSION: 4.1.17
ORIGIN: https://github.com/Homebrew/brew
HEAD: 35746e0a6ba6c3c5cfe56d99f79d9ec9f52ee15f
Last commit: 6 days ago
Core tap origin: https://github.com/Homebrew/homebrew-core
Core tap HEAD: 8db584c0595cdf666f7f9a828e5c00c42ae5ab5e
Core tap last commit: 3 weeks ago
Core tap branch: master
Core tap JSON: 28 Oct 18:00 UTC
HOMEBREW_PREFIX: /usr/local
HOMEBREW_CASK_OPTS: []
HOMEBREW_DISPLAY: /private/tmp/com.apple.launchd.xGPrX6gsLP/org.xquartz:0
HOMEBREW_EDITOR: vim
HOMEBREW_MAKE_JOBS: 4
Homebrew Ruby: 2.6.10 => /usr/local/Homebrew/Library/Homebrew/vendor/portable-ruby/2.6.10_1/bin/ruby
CPU: quad-core 64-bit skylake
Clang: 12.0.0 build 1200
Git: 2.42.0 => /usr/local/bin/git
Curl: 7.64.1 => /usr/bin/curl
macOS: 10.15.7-x86_64
CLT: 12.0.0.32.28
Xcode: 12.4

Output of brew doctor

Please note that these warnings are just used to help the Homebrew maintainers
with debugging if you file an issue. If everything you use Homebrew for is
working fine: please don't worry or file an issue; just ignore this. Thanks!

Warning: A newer Command Line Tools release is available.
Update them from Software Update in System Preferences.

If that doesn't show you any updates, run:
  sudo rm -rf /Library/Developer/CommandLineTools
  sudo xcode-select --install

Alternatively, manually download them from:
  https://developer.apple.com/download/all/.
You should download the Command Line Tools for Xcode 12.4.


Warning: Some installed kegs have no formulae!
This means they were either deleted or installed manually.
You should find replacements for the following formulae:
  python@2
  go@1.13
  node@10

Warning: Some installed formulae are deprecated or disabled.
You should find replacements for the following formulae:
  libgit2@1.5
  node@10
  node@14
  openssl@1.1

Warning: Unbrewed '.pc' files were found in /usr/local/lib/pkgconfig.
If you didn't put them there on purpose they could cause problems when
building Homebrew formulae, and may need to be deleted.

Unexpected '.pc' files:
  /usr/local/lib/pkgconfig/blkid.pc
  /usr/local/lib/pkgconfig/com_err.pc
  /usr/local/lib/pkgconfig/e2p.pc
  /usr/local/lib/pkgconfig/ext2fs.pc
  /usr/local/lib/pkgconfig/fuse-ext2.pc
  /usr/local/lib/pkgconfig/ss.pc
  /usr/local/lib/pkgconfig/uuid.pc

Warning: You have unlinked kegs in your Cellar.
Leaving kegs unlinked can lead to build-trouble and cause formulae that depend on
those kegs to fail to run properly once built. Run `brew link` on these:
  python@2
  go@1.13
  pgcli

Warning: You have an unnecessary local Cask tap.
This can cause problems installing up-to-date casks.
Please remove it by running:
  brew untap homebrew/cask

Warning: You have an unnecessary local Core tap!
This can cause problems installing up-to-date formulae.
Please remove it by running:
 brew untap homebrew/core

Warning: Some installed formulae are not readable:
  go@1.13: missing keyword: because

Warning: You are using macOS 10.15.
We (and Apple) do not provide support for this old version.
It is expected behaviour that some formulae will fail to build in this old version.
It is expected behaviour that Homebrew will be buggy and slow.
Do not create any issues about this on Homebrew's GitHub repositories.
Do not create any issues even if you think this message is unrelated.
Any opened issues will be immediately closed without response.
Do not ask for help from Homebrew or its maintainers on social media.
You may ask for help in Homebrew's discussions but are unlikely to receive a response.
Try to figure out the problem yourself and submit a fix as a pull request.
We will review it but may or may not accept it.


Warning: Homebrew's "sbin" was not found in your PATH but you have installed
formulae that put executables in /usr/local/sbin.
Consider setting your PATH for example like so:
  echo 'export PATH="/usr/local/sbin:$PATH"' >> ~/.zshrc

Description of issue

It can't find the tabulate module, even though it's installed

$ brew install pgcli
...
Successfully built pgcli
Installing collected packages: pgcli
  changing mode of /usr/local/Cellar/pgcli/4.0.0/libexec/bin/pgcli to 755
Successfully installed pgcli-4.0.0

[notice] A new release of pip is available: 23.2.1 -> 23.3.1
[notice] To update, run: python -m pip install --upgrade pip
/usr/local/Cellar/pgcli/4.0.0/libexec/lib/python3.12/site-packages/pgspecial/main.py:237: SyntaxWarning: invalid escape sequence '\w'
  """
Traceback (most recent call last):
  File "/usr/local/Cellar/pgcli/4.0.0/bin/pgcli", line 5, in <module>
    from pgcli.main import cli
  File "/usr/local/Cellar/pgcli/4.0.0/libexec/lib/python3.12/site-packages/pgcli/main.py", line 21, in <module>
    from cli_helpers.tabular_output import TabularOutputFormatter
  File "/usr/local/Cellar/pgcli/4.0.0/libexec/lib/python3.12/site-packages/cli_helpers/tabular_output/__init__.py", line 11, in <module>
    from .output_formatter import format_output, TabularOutputFormatter
  File "/usr/local/Cellar/pgcli/4.0.0/libexec/lib/python3.12/site-packages/cli_helpers/tabular_output/output_formatter.py", line 15, in <module>
    from . import (
  File "/usr/local/Cellar/pgcli/4.0.0/libexec/lib/python3.12/site-packages/cli_helpers/tabular_output/tabulate_adapter.py", line 17, in <module>
    import tabulate
ModuleNotFoundError: No module named 'tabulate'
/usr/local/Homebrew/Library/Homebrew/ignorable.rb:29:in `block in raise'
ErrorDuringExecution: Failure while executing; `\{\"SHELL\"=\>\"fish\",\ \"_PGCLI_COMPLETE\"=\>\"fish_source\"\} /usr/local/Cellar/pgcli/4.0.0/bin/pgcli` exited with 1. Here's the output:

$ brew install python-tabulate
Warning: python-tabulate 0.9.0 is already installed and up-to-date.
To reinstall 0.9.0, run:
  brew reinstall python-tabulate

[sryze]

Never mind, it turns out python-tabulate was installed only for Python 3.10 and 3.11, but not for 3.12, hence the error. BTW python-tabulate install fails if there is no wheel installed, so I had to manually install it via python3.12 -m pip install wheel - not sure if this is supposed to be like that.

[janderland]

This still seems like a problem to me. Why must we install these python libraries ourselves now? Historically, brew took care of installing these dependencies to the proper location.

[kamusis]

Same error.

❯ pgcli
Traceback (most recent call last):
  File "/opt/homebrew/bin/pgcli", line 5, in <module>
    from pgcli.main import cli
  File "/opt/homebrew/Cellar/pgcli/4.0.0/libexec/lib/python3.12/site-packages/pgcli/main.py", line 21, in <module>
    from cli_helpers.tabular_output import TabularOutputFormatter
  File "/opt/homebrew/Cellar/pgcli/4.0.0/libexec/lib/python3.12/site-packages/cli_helpers/tabular_output/__init__.py", line 11, in <module>
    from .output_formatter import format_output, TabularOutputFormatter
  File "/opt/homebrew/Cellar/pgcli/4.0.0/libexec/lib/python3.12/site-packages/cli_helpers/tabular_output/output_formatter.py", line 15, in <module>
    from . import (
  File "/opt/homebrew/Cellar/pgcli/4.0.0/libexec/lib/python3.12/site-packages/cli_helpers/tabular_output/tabulate_adapter.py", line 17, in <module>
    import tabulate
ModuleNotFoundError: No module named 'tabulate'
❯ pip install tabulate
Requirement already satisfied: tabulate in /opt/homebrew/lib/python3.11/site-packages (0.0.0)

[notice] A new release of pip is available: 23.2.1 -> 23.3.1
[notice] To update, run: python3.11 -m pip install --upgrade pip

export PYTHONPATH=/opt/homebrew/lib/python3.11/site-packages can resolve the issue, but why brew didn't take care of the dependencies?

[samuelhwilliams]

Same (new) issue trying to run pgcli (re)installed via homebrew :(

Traceback (most recent call last):
  File "/opt/homebrew/bin/pgcli", line 5, in <module>
    from pgcli.main import cli
  File "/opt/homebrew/Cellar/pgcli/4.0.1/libexec/lib/python3.12/site-packages/pgcli/main.py", line 21, in <module>
    from cli_helpers.tabular_output import TabularOutputFormatter
  File "/opt/homebrew/Cellar/pgcli/4.0.1/libexec/lib/python3.12/site-packages/cli_helpers/tabular_output/__init__.py", line 11, in <module>
    from .output_formatter import format_output, TabularOutputFormatter
  File "/opt/homebrew/Cellar/pgcli/4.0.1/libexec/lib/python3.12/site-packages/cli_helpers/tabular_output/output_formatter.py", line 15, in <module>
    from . import (
  File "/opt/homebrew/Cellar/pgcli/4.0.1/libexec/lib/python3.12/site-packages/cli_helpers/tabular_output/tabulate_adapter.py", line 17, in <module>
    import tabulate
ModuleNotFoundError: No module named 'tabulate'

And then after doing brew reinstall python-tabulate:

$ pgcli
Traceback (most recent call last):
  File "/opt/homebrew/bin/pgcli", line 5, in <module>
    from pgcli.main import cli
  File "/opt/homebrew/Cellar/pgcli/4.0.1/libexec/lib/python3.12/site-packages/pgcli/main.py", line 45, in <module>
    from pygments.lexers.sql import PostgresLexer
ModuleNotFoundError: No module named 'pygments'

🙃 something very broken, and this is the second package that I've had trouble with in the last week - maybe since python 3.12? At least they all seem related to that. The other one was pre-commit