Modify address check query to obtain well-defined result
The way in which UNION does not yield the desired result, because (a) UNION
merges results and (b) the result order is undefined. This patch changes the
query to select the counts as columns and hence provides a well-defined order.
#!/usr/bin/env python# -*- coding: utf-8 -*-# Copyright 2007 - 2011, Pascal Volk# See COPYING for distribution information.importosfromdistutils.coreimportsetupfromdistutils.distimportDistributionMetadataVERSION='0.5.2'descr='Tool to manage mail domains/accounts/aliases for Dovecot and Postfix'long_description="""vmm, a virtual mail manager, is a command line tool foradministrators/postmasters to manage (alias-)domains, accounts,aliases and relocated users.It is designed for Dovecot and Postfix with a PostgreSQL backend."""packages=['VirtualMailManager','VirtualMailManager.cli','VirtualMailManager.ext','VirtualMailManager.pycompat',]# http://pypi.python.org/pypi?%3Aaction=list_classifiersclassifiers=['Development Status :: 5 - Production/Stable','Environment :: Console','Intended Audience :: System Administrators','License :: OSI Approved :: BSD License','Natural Language :: Dutch','Natural Language :: English','Natural Language :: French','Natural Language :: German','Operating System :: POSIX','Operating System :: POSIX :: BSD','Operating System :: POSIX :: Linux','Operating System :: POSIX :: Other','Programming Language :: Python','Programming Language :: Python :: 2','Topic :: Communications :: Email','Topic :: System :: Systems Administration','Topic :: Utilities']# sucessfuly tested on:platforms=['freebsd7','linux2','openbsd4']# remove existing MANIFESTifos.path.exists('MANIFEST'):os.remove('MANIFEST')setup_args={'name':'VirtualMailManager','version':VERSION,'description':descr,'long_description':long_description,'packages':packages,'author':'Pascal Volk','author_email':'user+vmm@localhost.localdomain.org','license':'BSD License','url':'http://vmm.localdomain.org/','download_url':'http://sf.net/projects/vmm/files/','platforms':platforms,'classifiers':classifiers}if'requires'inDistributionMetadata._METHOD_BASENAMES:setup_args['requires']=['psycopg2 (>=2.0)','pyPgSQL (>=2.5.1)']setup(**setup_args)