all: remove explicit versions in USES=python for "3.x+"

The logic in USES=python will automatically convert this to 3.8+ by
itself.

Adjust two ports that only had Python 3.7 mentioned but build fine
on Python 3.8 too.

finance/quickfix: mark BROKEN with PYTHON

libtool: compile:  c++ -DHAVE_CONFIG_H -I. -I../.. -I -I. -I.. -I../.. -I../C++
-DLIBICONV_PLUG -DPYTHON_MAJOR_VERSION=3 -Wno-unused-variable
-Wno-maybe-uninitialized -O2 -pipe -DLIBICONV_PLUG -fstack-protector-strong
-fno-strict-aliasing -DLIBICONV_PLUG -Wall -ansi
-Wno-unused-command-line-argument -Wpointer-arith -Wwrite-strings
-Wno-overloaded-virtual -Wno-deprecated-declarations -Wno-deprecated -std=c++0x
-MT _quickfix_la-QuickfixPython.lo -MD -MP -MF
.deps/_quickfix_la-QuickfixPython.Tpo -c QuickfixPython.cpp  -fPIC -DPIC -o
.libs/_quickfix_la-QuickfixPython.o
warning: unknown warning option '-Wno-maybe-uninitialized'; did you mean
'-Wno-uninitialized'? [-Wunknown-warning-option]
QuickfixPython.cpp:175:11: fatal error: 'Python.h' file not found
          ^~~~~~~~~~
1 warning and 1 error generated.

Reviewed by:	portmgr, vishwin, yuri
Differential Revision:	<https://reviews.freebsd.org/D40568>

*/*: rename CHEESESHOP to PYPI in MASTER_SITES

PR:			267994
Differential revision:	D37518
Approved by:		bapt

Remove WWW entries moved into port Makefiles

Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.

This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.

Approved by:		portmgr (tcberner)

Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.

databases: remove 'Created by' lines

A big Thank You to the original contributors of these ports:

  *  "Choe, Cheng-Dae" whitekid
  *  "Mahdi Mokhtari <mokhi64@gmail.com>"
  *  "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de>
  *  <hvo.pm@xs4all.nl>
  *  <jsmith@resonatingmedia.com>
  *  <ports@c0decafe.net>
  *  Aaron Dalton <aaron@FreeBSD.org>
  *  Adam Weinberger <adamw@FreeBSD.org>
  *  Ade Lovett <ade@FreeBSD.org>
  *  Akinori MUSHA aka knu <knu@idaemons.org>
  *  Alan Snelson <Alan@Wave2.org>

Fix CONFLICTS_INSTALL in the databases category

Approved by:	portmgr (implicit)

databases/py-sqlalchemy10: Add CPE information

Approved by:	portmgr (blanket)

Remove # $FreeBSD$ from Makefiles.

Remove logic for Python < 3.6 for ports using Python 3.6+

Drop python 2.7 support from a few ports

With hat:	portmgr

py-sqlobject,py-sqlalchemy*: remove optional expired dependency on SYBASE

databases/py-sqlalchemy10: Drop nop MYSQL option

It never did anything.  Prepare for D19553: Options helpers set
after bsd.port.options.mk are ineffective.

Use PY_FLAVOR for dependencies.

FLAVOR is the current port's flavor, it should not be used outside of
this scope.

Sponsored by:	Absolight

Update CONFLICTS_INSTALL

Approved by:	portmgr (blanket)

Convert Python ports to FLAVORS.

  Ports using USE_PYTHON=distutils are now flavored.  They will
  automatically get flavors (py27, py34, py35, py36) depending on what
  versions they support.

  There is also a USE_PYTHON=flavors for ports that do not use distutils
  but need FLAVORS to be set.  A USE_PYTHON=noflavors can be set if
  using distutils but flavors are not wanted.

  A new USE_PYTHON=optsuffix that will add PYTHON_PKGNAMESUFFIX has been
  added to cope with Python ports that did not have the Python
  PKGNAMEPREFIX but are flavored.

  USES=python now also exports a PY_FLAVOR variable that contains the

Update RUN_DEPENDS of MSSQL option

- Bump PORTREVISION for dependency change

PR:		221381
Submitted by:	David Wahlund <david@dafnet.se>
Approved by:	maintainer (timeout, 14 days)
MFH:		2017Q3

databases/py-sqlalchemy10: 1.0.13 -> 1.0.14

PR:		212063
Changes:	http://docs.sqlalchemy.org/en/latest/changelog/changelog_10.html#change-1.0.14
Approved by:	m.tsatsenko@gmail.com (maintainer)

Invoke pytest from within desired python version

When testing a port for a non-default python py.test may fail to find
dependencies for default version because they weren't built e.g.,

$ make test PYTHON_VERSION=python3.5 -C devel/py-apscheduler
[...]
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
  File "/usr/local/lib/python3.5/site-packages/_pytest/config.py", line 319, in
_importconftest
    mod = conftestpath.pyimport()
  File "/usr/local/lib/python3.5/site-packages/py/_path/local.py", line 650, in
pyimport
    __import__(modname)
  File
"/usr/ports/devel/py-apscheduler/work/APScheduler-3.2.0/tests/conftest.py", line
8, in <module>
    from apscheduler.job import Job
  File
"/usr/ports/devel/py-apscheduler/work/APScheduler-3.2.0/apscheduler/job.py",
line 4, in <module>
    import six
ImportError: No module named 'six'
ERROR: could not load
/usr/ports/devel/py-apscheduler/work/APScheduler-3.2.0/tests/conftest.py

Approved by:	portmgr blanket

Reorganise and modernise the py-sqlalchemy ports.

 - Introduce new ports for the sqlalchemy 0.9 and 1.0 release branches.
 - Deprecate the ports for the 0.6 and 0.7 release branches, as these
   have been declared EoL and are no longer supported by upstream.
 - Update to the latest available version in each branch.

In detail:

   Port                 Version Maintainer
   ----------------------------------------------
   py-sqlalchemy06      0.6.9   nivit@FreeBSD.org (Deprecate 2016-08-20) [1]
   py-sqlalchemy07      0.7.10  nivit@FreeBSD.org (renamed py-sqlalchemy,
Deprecate 2016-08-20) [1]
   py-sqlalchemy08      0.8.7   nivit@FreeBSD.org (renamed py-sqlalchemy-devel)
[1]
   py-sqlalchemy09      0.9.10  m.tsatsenko@gmail.com (new, repocopy from
py-sqlalchemy-devel) [2]