test_optlib_db.py

import oslo_db.sqlalchemy.engines as engines
import sqlalchemy
# change DBPASS and DBADDR suitable for your environment
url = sqlalchemy.engine.url.make_url('mysql+pymysql://keystone:DBPASS@DBADDR/keystone')
engine = sqlalchemy.create_engine(url)
con = engines._test_connection(engine, 10, 10)
rs = con.execute('show databases')
for row in rs:
  row 

rs = con.execute('show tables')
for row in rs:
  row 

con.close()