AUR (en) - litecli

Git Clone URL:	https://aur.archlinux.org/litecli.git (read-only, click to copy)
Package Base:	litecli
Description:	A command-line client for SQLite databases that has auto-completion and syntax highlighting.
Upstream URL:	https://github.com/dbcli/litecli
Keywords:	litecli sql sqlite
Licenses:	BSD
Conflicts:	litecli-git
Provides:	litecli
Submitter:	andrejr
Maintainer:	andrejr
Last Packager:	andrejr
Votes:	9
Popularity:	0.159777
First Submitted:	2018-12-20 10:29 (UTC)
Last Updated:	2024-11-18 17:53 (UTC)

Latest Comments

sorcix commented on 2024-08-27 09:55 (UTC)

I had to add python-setuptools to makedepends to build this in a clean chroot.

andrejr commented on 2021-01-02 18:01 (UTC)

Updated, sorry for the delay.

txtsd commented on 2021-01-01 04:45 (UTC)

Thanks. If @andrejr can't update this themselves, they needs to add maintainers.

snowball commented on 2020-12-31 21:25 (UTC)

@txtsd: There was a new release earlier this month that includes the fix for the sqlparse issue:

diff --git a/PKGBUILD b/PKGBUILD
index 69467ec..39c1354 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -4 +4 @@ pkgname=litecli
-pkgver=1.3.2
+pkgver=1.5.0
@@ -26 +26 @@ conflicts=('litecli-git')
-md5sums=('dd19a67302b6108fdb17c3af5bbdac9b')
+md5sums=('0ff999a63dc9d0d44efe3c1e3ac96a85')

txtsd commented on 2020-12-27 12:19 (UTC)

@andrejr Can you apply the fix submitted below?

snowball commented on 2020-10-31 04:57 (UTC)

python-sqlparse 0.4.x was released earlier this month, which broke litecli:

$ litecli test.db
...
ModuleNotFoundError: No module named 'sqlparse.compat'

Here's an updated PKGBUILD that applies the fix from upstream master:

# Maintainer: Andrej Radović <r.andrej@gmail.com>

pkgname=litecli
pkgver=1.3.2
pkgrel=2
pkgdesc="A command-line client for SQLite databases that has auto-completion "\
"and syntax highlighting."
url="https://github.com/dbcli/litecli"
arch=(any)
license=('BSD')
depends=(
  'python'
  'python-click'
  'python-pygments'
  'python-prompt_toolkit'
  'python-sqlparse'
  'python-configobj'
  'python-cli_helpers'
)
makedepends=('python-distribute')
source=(
  $pkgname-$pkgver.zip::https://github.com/dbcli/litecli/archive/v$pkgver.zip
  https://github.com/dbcli/litecli/commit/37957e401d22f88800bbdec2c690e731f2cc13bd.diff
)
provides=('litecli')
conflicts=('litecli-git')
md5sums=('dd19a67302b6108fdb17c3af5bbdac9b'
         'fe4fdbd8b712c71b8ac5dc9403f8a384')

prepare() {
  cd "$srcdir/${pkgname}-${pkgver}"

  # Fix compatibility with sqlparse >= 0.4.0
  # https://github.com/dbcli/litecli/pull/102
  patch -N -p1 -i "$srcdir/37957e401d22f88800bbdec2c690e731f2cc13bd.diff"
}

package() {
  cd "$srcdir/${pkgname}-${pkgver}"
  sed -i "s/cli_helpers\[styles\] >= 1.0.1/cli_helpers >= 1.1.0/g" \
    setup.py
  python setup.py install --root="$pkgdir/" --optimize=1
  install -D "LICENSE" "$pkgdir/usr/share/licenses/$pkgname/LICENSE"
}