Allow build with py-sqlparse 0.4.0

- Update WWW
- Bump PORTREVISION for package change

2 files changed, 30 insertions, 0 deletions

diff --git a/databases/py-mycli/files/patch-mycli-packages-completion_engine.py b/databases/py-mycli/files/patch-mycli-packages-completion_engine.py
new file mode 100644
index 000000000000..2c9cca4fe4b6
--- /dev/null
+++ b/databases/py-mycli/files/patch-mycli-packages-completion_engine.py
@@ -0,0 +1,19 @@
+--- mycli/packages/completion_engine.py.orig	2020-07-25 03:46:06 UTC
++++ mycli/packages/completion_engine.py
+@@ -2,7 +2,6 @@ import os
+ import sys
+ import sqlparse
+ from sqlparse.sql import Comparison, Identifier, Where
+-from sqlparse.compat import text_type
+ from .parseutils import last_word, extract_tables, find_prev_keyword
+ from .special import parse_special_command
+ 
+@@ -55,7 +54,7 @@ def suggest_type(full_text, text_before_cursor):
+         stmt_start, stmt_end = 0, 0
+ 
+         for statement in parsed:
+-            stmt_len = len(text_type(statement))
++            stmt_len = len(str(statement))
+             stmt_start, stmt_end = stmt_end, stmt_end + stmt_len
+ 
+             if stmt_end >= current_pos:
diff --git a/databases/py-mycli/files/patch-setup.py b/databases/py-mycli/files/patch-setup.py
new file mode 100644
index 000000000000..1ef14ba5b51b
--- /dev/null
+++ b/databases/py-mycli/files/patch-setup.py
@@ -0,0 +1,11 @@
+--- setup.py.orig	2020-07-25 03:46:06 UTC
++++ setup.py
+@@ -21,7 +21,7 @@ install_requirements = [
+     'Pygments >= 1.6',
+     'prompt_toolkit>=3.0.0,<4.0.0',
+     'PyMySQL >= 0.9.2',
+-    'sqlparse>=0.3.0,<0.4.0',
++    'sqlparse>=0.3.0',
+     'configobj >= 5.0.5',
+     'cryptography >= 1.0.0',
+     'cli_helpers[styles] > 1.1.0',