This is an automated email from the ASF dual-hosted git repository.

johnbodley pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-superset.git


The following commit(s) were added to refs/heads/master by this push:
     new 513bf10  chore: Leverage SQLALchemy ping rather than explicit SELECT 1 
for testconn (#11223)
513bf10 is described below

commit 513bf10a38e10f5dc69f1a93fe28478df4f0b32d
Author: John Bodley <[email protected]>
AuthorDate: Sun Oct 11 12:44:15 2020 -0700

    chore: Leverage SQLALchemy ping rather than explicit SELECT 1 for testconn 
(#11223)
---
 superset/views/core.py | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/superset/views/core.py b/superset/views/core.py
index d2aad59..92e72ea 100755
--- a/superset/views/core.py
+++ b/superset/views/core.py
@@ -33,7 +33,7 @@ from flask_appbuilder.security.decorators import has_access, 
has_access_api
 from flask_appbuilder.security.sqla import models as ab_models
 from flask_babel import gettext as __, lazy_gettext as _
 from jinja2.exceptions import TemplateError
-from sqlalchemy import and_, or_, select
+from sqlalchemy import and_, or_
 from sqlalchemy.engine.url import make_url
 from sqlalchemy.exc import (
     ArgumentError,
@@ -1129,8 +1129,8 @@ class Superset(BaseSupersetView):  # pylint: 
disable=too-many-public-methods
             username = g.user.username if g.user is not None else None
             engine = database.get_sqla_engine(user_name=username)
 
-            with closing(engine.connect()) as conn:
-                conn.scalar(select([1]))
+            with closing(engine.raw_connection()) as conn:
+                engine.dialect.do_ping(conn)
                 return json_success('"OK"')
         except CertificateException as ex:
             logger.info("Certificate exception")

Reply via email to