Homebrew formula for sqlite-utils

[simonw]

I want to be able to install that via Homebrew too, mainly for ease of writing tutorials on using the two together.

[simonw]

I ran poet (after doing pip install homebrew-pypi-poet and got this:

$ poet sqlite-utils
/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.7/site-packages/poet/poet.py:97: PackageVersionNotFoundWarning: Could not find an exact version match for sqlite-utils version 2.14.1; using newest instead
  format(name, version), PackageVersionNotFoundWarning)
/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.7/site-packages/poet/poet.py:118: UserWarning: No sdist found for sqlite-utils
  warnings.warn("No sdist found for %s" % name)
  resource "click" do
    url "https://files.pythonhosted.org/packages/27/6f/be940c8b1f1d69daceeb0032fee6c34d7bd70e3e649ccac0951500b4720e/click-7.1.2.tar.gz"
    sha256 "d2b5255c7c6349bc1bd1e59e08cd12acbbd63ce649f2588755783aa94dfb6b1a"
  end

  resource "click-default-group" do
    url "https://files.pythonhosted.org/packages/22/3a/e9feb3435bd4b002d183fcb9ee08fb369a7e570831ab1407bc73f079948f/click-default-group-1.2.2.tar.gz"
    sha256 "d9560e8e8dfa44b3562fbc9425042a0fd6d21956fcc2db0077f63f34253ab904"
  end

  resource "sqlite-utils" do
    url ""
    sha256 ""
  end

  resource "tabulate" do
    url "https://files.pythonhosted.org/packages/57/6f/213d075ad03c84991d44e63b6516dd7d185091df5e1d02a660874f8f7e1e/tabulate-0.8.7.tar.gz"
    sha256 "db2723a20d04bcda8522165c73eea7c300eda74e0ce852d9022e0159d7895007"
  end

So I need to package up a sdist of sqlite-utils.

[simonw]

Released 2.15.1 as an sdist, and now:

% poet sqlite-utils                     
/Users/simon/.local/share/virtualenvs/sqlite-utils-C4Ilevlm/lib/python3.7/site-packages/poet/poet.py:97: PackageVersionNotFoundWarning: Could not find an exact version match for sqlite-utils version 2.14.1; using newest instead
  format(name, version), PackageVersionNotFoundWarning)
  resource "click" do
    url "https://files.pythonhosted.org/packages/27/6f/be940c8b1f1d69daceeb0032fee6c34d7bd70e3e649ccac0951500b4720e/click-7.1.2.tar.gz"
    sha256 "d2b5255c7c6349bc1bd1e59e08cd12acbbd63ce649f2588755783aa94dfb6b1a"
  end

  resource "click-default-group" do
    url "https://files.pythonhosted.org/packages/22/3a/e9feb3435bd4b002d183fcb9ee08fb369a7e570831ab1407bc73f079948f/click-default-group-1.2.2.tar.gz"
    sha256 "d9560e8e8dfa44b3562fbc9425042a0fd6d21956fcc2db0077f63f34253ab904"
  end

  resource "sqlite-utils" do
    url "https://files.pythonhosted.org/packages/91/c8/c9caccfb59f9deac5e160a2d7a9c15e631d455cf27c48165189de644a8e3/sqlite-utils-2.15.1.tar.gz"
    sha256 "ca71a92bb96304323edc5b0fd1130f93d0ffe5083cd5a99b67e596efafee7220"
  end

  resource "tabulate" do
    url "https://files.pythonhosted.org/packages/57/6f/213d075ad03c84991d44e63b6516dd7d185091df5e1d02a660874f8f7e1e/tabulate-0.8.7.tar.gz"
    sha256 "db2723a20d04bcda8522165c73eea7c300eda74e0ce852d9022e0159d7895007"
  end

[simonw]

Testing it like this:

brew install simonw/datasette/sqlite-utils

It works!

simon@Simons-MacBook-Pro ~ % sqlite-utils --version
zsh: command not found: sqlite-utils
simon@Simons-MacBook-Pro ~ % brew install simonw/datasette/sqlite-utils
Updating Homebrew...
==> Auto-updated Homebrew!
Updated 1 tap (homebrew/core).
==> Updated Formulae
Updated 4 formulae.

==> Tapping simonw/datasette
Cloning into '/usr/local/Homebrew/Library/Taps/simonw/homebrew-datasette'...
remote: Enumerating objects: 83, done.
remote: Counting objects: 100% (83/83), done.
remote: Compressing objects: 100% (66/66), done.
remote: Total 83 (delta 18), reused 6 (delta 0), pack-reused 0
Receiving objects: 100% (83/83), 19.05 KiB | 1.90 MiB/s, done.
Resolving deltas: 100% (18/18), done.
Tapped 2 formulae (28 files, 55KB).
==> Installing sqlite-utils from simonw/datasette
==> Downloading https://files.pythonhosted.org/packages/11/74/2c151a13ef41ab9fb4
Already downloaded: /Users/simon/Library/Caches/Homebrew/downloads/507d2087bf24df82641b681a5fe4da778ef50ebe819a86ea1b584f70788f0f63--virtualenv-16.7.4.tar.gz
==> Downloading https://files.pythonhosted.org/packages/27/6f/be940c8b1f1d69dace
Already downloaded: /Users/simon/Library/Caches/Homebrew/downloads/729f15182b3d73a61df6c5b70fb07736c3a57abd09b7fde46af074f5787e42dd--click-7.1.2.tar.gz
==> Downloading https://files.pythonhosted.org/packages/22/3a/e9feb3435bd4b002d1
Already downloaded: /Users/simon/Library/Caches/Homebrew/downloads/2b114fbe8ef2560b5f2f25ee0e33f9f18a87559b3635ba89466765edc6c919bb--click-default-group-1.2.2.tar.gz
==> Downloading https://files.pythonhosted.org/packages/57/6f/213d075ad03c84991d
######################################################################## 100.0%
==> Downloading https://files.pythonhosted.org/packages/91/c8/c9caccfb59f9deac5e
######################################################################## 100.0%
==> python3.8 -c import setuptools... --no-user-cfg install --prefix=/private/tm
==> python3.8 -s /private/tmp/sqlite-utils--homebrew-virtualenv-20200812-53590-1
==> /usr/local/Cellar/sqlite-utils/2.15.1/libexec/bin/pip install -v --no-deps -
==> /usr/local/Cellar/sqlite-utils/2.15.1/libexec/bin/pip install -v --no-deps -
==> /usr/local/Cellar/sqlite-utils/2.15.1/libexec/bin/pip install -v --no-deps -
==> /usr/local/Cellar/sqlite-utils/2.15.1/libexec/bin/pip install -v --no-deps -
🍺  /usr/local/Cellar/sqlite-utils/2.15.1: 1,271 files, 13MB, built in 20 seconds
simon@Simons-MacBook-Pro ~ % sqlite-utils --version
sqlite-utils, version 2.15.1

[simonw]

Submitted here: Homebrew/homebrew-core#59533