Index: head/databases/py-mycli/files/patch-setup.py
===================================================================
--- head/databases/py-mycli/files/patch-setup.py	(revision 436519)
+++ head/databases/py-mycli/files/patch-setup.py	(nonexistent)
@@ -1,13 +0,0 @@
-Obtained from:	https://github.com/dbcli/mycli/commit/63a6339e451dfe537f1b7cf43758409abea52342
-
---- setup.py.orig	2016-09-20 16:46:21 UTC
-+++ setup.py
-@@ -16,7 +16,7 @@ install_requirements = [
-     'Pygments >= 2.0',  # Pygments has to be Capitalcased. WTF?
-     'prompt_toolkit>=1.0.0,<1.1.0',
-     'PyMySQL >= 0.6.2',
--    'sqlparse>=0.2.0,<0.2.2',
-+    'sqlparse>=0.2.2,<0.3.0',
-     'configobj >= 5.0.6',
- ]
- 

Property changes on: head/databases/py-mycli/files/patch-setup.py
___________________________________________________________________
Deleted: fbsd:nokeywords
## -1 +0,0 ##
-yes
\ No newline at end of property
Deleted: svn:eol-style
## -1 +0,0 ##
-native
\ No newline at end of property
Deleted: svn:mime-type
## -1 +0,0 ##
-text/plain
\ No newline at end of property
Index: head/databases/py-mycli/files/patch-mycli-packages-parseutils.py
===================================================================
--- head/databases/py-mycli/files/patch-mycli-packages-parseutils.py	(revision 436519)
+++ head/databases/py-mycli/files/patch-mycli-packages-parseutils.py	(nonexistent)
@@ -1,13 +0,0 @@
-Obtained from:	https://github.com/dbcli/mycli/commit/63a6339e451dfe537f1b7cf43758409abea52342
-
---- mycli/packages/parseutils.py.orig	2015-10-16 13:27:27 UTC
-+++ mycli/packages/parseutils.py
-@@ -64,7 +64,7 @@ def last_word(text, include='alphanum_un
- # This code is borrowed from sqlparse example script.
- # <url>
- def is_subselect(parsed):
--    if not parsed.is_group():
-+    if not parsed.is_group:
-         return False
-     for item in parsed.tokens:
-         if item.ttype is DML and item.value.upper() in ('SELECT', 'INSERT',

Property changes on: head/databases/py-mycli/files/patch-mycli-packages-parseutils.py
___________________________________________________________________
Deleted: fbsd:nokeywords
## -1 +0,0 ##
-yes
\ No newline at end of property
Deleted: svn:eol-style
## -1 +0,0 ##
-native
\ No newline at end of property
Deleted: svn:mime-type
## -1 +0,0 ##
-text/plain
\ No newline at end of property
Index: head/databases/py-mycli/files/patch-mycli-packages-completion_engine.py
===================================================================
--- head/databases/py-mycli/files/patch-mycli-packages-completion_engine.py	(revision 436519)
+++ head/databases/py-mycli/files/patch-mycli-packages-completion_engine.py	(nonexistent)
@@ -1,14 +0,0 @@
-Obtained from:	https://github.com/dbcli/mycli/commit/63a6339e451dfe537f1b7cf43758409abea52342
-
---- mycli/packages/completion_engine.py.orig	2016-09-18 04:19:04 UTC
-+++ mycli/packages/completion_engine.py
-@@ -197,6 +197,9 @@ def suggest_based_on_last_token(token, t
-         return [{'type': 'column', 'tables': extract_tables(full_text)}]
-     elif token_v in ('set', 'by', 'distinct'):
-         return [{'type': 'column', 'tables': extract_tables(full_text)}]
-+    elif token_v == 'as':
-+        # Don't suggest anything for an alias
-+        return []
-     elif token_v in ('show'):
-         return [{'type': 'show'}]
-     elif token_v in ('to',):

Property changes on: head/databases/py-mycli/files/patch-mycli-packages-completion_engine.py
___________________________________________________________________
Deleted: fbsd:nokeywords
## -1 +0,0 ##
-yes
\ No newline at end of property
Deleted: svn:eol-style
## -1 +0,0 ##
-native
\ No newline at end of property
Deleted: svn:mime-type
## -1 +0,0 ##
-text/plain
\ No newline at end of property
Index: head/databases/py-mycli/Makefile
===================================================================
--- head/databases/py-mycli/Makefile	(revision 436519)
+++ head/databases/py-mycli/Makefile	(revision 436520)
@@ -1,29 +1,28 @@
 # Created by: Sunpoet Po-Chuan Hsieh <sunpoet@FreeBSD.org>
 # $FreeBSD$
 
 PORTNAME=	mycli
-PORTVERSION=	1.8.1
-PORTREVISION=	2
+PORTVERSION=	1.9.0
 CATEGORIES=	databases python
 MASTER_SITES=	CHEESESHOP
 PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
 
 MAINTAINER=	sunpoet@FreeBSD.org
 COMMENT=	CLI for MySQL Database with auto-completion and syntax highlighting
 
 LICENSE=	BSD3CLAUSE
 LICENSE_FILE=	${WRKSRC}/LICENSE.txt
 
 RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}click>=4.1:devel/py-click \
 		${PYTHON_PKGNAMEPREFIX}configobj>=5.0.6:devel/py-configobj \
 		${PYTHON_PKGNAMEPREFIX}prompt_toolkit>=1.0.0:devel/py-prompt_toolkit \
-		${PYTHON_PKGNAMEPREFIX}pycrypto>=2.6.1:security/py-pycrypto \
+		${PYTHON_PKGNAMEPREFIX}pycryptodome>=0:security/py-pycryptodome \
 		${PYTHON_PKGNAMEPREFIX}pygments>=2.0:textproc/py-pygments \
 		${PYTHON_PKGNAMEPREFIX}pymysql>=0.6.2:databases/py-pymysql \
 		${PYTHON_PKGNAMEPREFIX}sqlparse>=0.2.2:databases/py-sqlparse
 
 NO_ARCH=	yes
 USE_PYTHON=	autoplist concurrent distutils
 USES=		mysql python
 
 .include <bsd.port.mk>
Index: head/databases/py-mycli/distinfo
===================================================================
--- head/databases/py-mycli/distinfo	(revision 436519)
+++ head/databases/py-mycli/distinfo	(revision 436520)
@@ -1,3 +1,3 @@
-TIMESTAMP = 1477748738
-SHA256 (mycli-1.8.1.tar.gz) = 5514ec779a211acb2d2776561b17f5bdb2583e333cc05e1b219865985faa799c
-SIZE (mycli-1.8.1.tar.gz) = 57858
+TIMESTAMP = 1489943856
+SHA256 (mycli-1.9.0.tar.gz) = 70ccf669db7949fe0f97695c82665e0fb737356f2e1d7f227f4eeda29f3311b2
+SIZE (mycli-1.9.0.tar.gz) = 55893