Package: pwman3
Version: 0.0.7-2
Severity: normal
Tags: patch
filter command does not work when using the sqlite backend (which is the
default) because sqlite does not support OUTER JOIN
See it in action :
$ pwman3
Pwman3 0.0.7 (c) Ivan Kelly <pw...@bleurgh.com>
pwman> list
Current tags: None
Please enter your password:
1. u...@host1 host1, user
2. u...@host2 host2, user
3. r...@host2 host2, root
pwman> filter root
Current tags: root
pwman> list
Current tags: root
Error: SQLite: RIGHT and FULL OUTER JOINs are not currently supported
LEFT JOIN can be used instead (this is the case for mysql & postgresql backend)
in /usr/share/pyshared/pwman/data/drivers/sqlite.py
Here is the patch :
$ diff -u sqlite.py.dist sqlite.py.patched
--- sqlite.py.dist 2010-11-30 21:41:54.000000000 +0100
+++ sqlite.py.patched 2010-11-30 21:46:52.000000000 +0100
@@ -67,7 +67,7 @@
else:
first = False
- sql += ("SELECT NODE FROM LOOKUP OUTER JOIN TAGS ON TAG =
TAGS.ID "
+ sql += ("SELECT NODE FROM LOOKUP LEFT JOIN TAGS ON TAG =
TAGS.ID "
+ " WHERE TAGS.DATA = ?")
params.append(cPickle.dumps(t))
sql += ") EXCEPT SELECT DATA FROM TAGS WHERE "
@@ -164,7 +164,7 @@
sql += " INTERSECT "
else:
first = False
- sql += ("SELECT NODE FROM LOOKUP OUTER JOIN TAGS ON TAG =
TAGS.ID"
+ sql += ("SELECT NODE FROM LOOKUP LEFT JOIN TAGS ON TAG =
TAGS.ID"
+ " WHERE TAGS.DATA = ? ")
params.append(cPickle.dumps(t))
-G.-
-- System Information:
Debian Release: squeeze/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.32-5-openvz-686 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages pwman3 depends on:
ii python 2.6.6-3+squeeze1 interactive high-level object-orie
ii python-crypto 2.1.0-2 cryptographic algorithms and proto
ii python-support 1.0.10 automated rebuilding support for P
Versions of packages pwman3 recommends:
ii python-mysqldb 1.2.2-10+b1 A Python interface to MySQL
ii python-pygresql 1:4.0-2+b1 PostgreSQL module for Python
Versions of packages pwman3 suggests:
pn mysql-server | postgresql <none> (no description available)
-- no debconf information
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
