def server_view_users(host):
sorted_by_drivers = {}
users = {}
headers = {}
_BINDS = BindContainer.get_all()
for _driver in SUPPORTED_DRIVERS:
sorted_by_drivers[_driver] = (DatabaseContainer.get_databases(
host=host, drivername=_driver))
for drivername, databases in sorted_by_drivers.items():
for database in databases:
for shortname, db_properties in database.items():
if shortname in _BINDS:
connection = _BINDS[shortname][0] #connection
stmt = StatementsChooser.for_[
drivername].get_server_users()
result = connection.execute(stmt)
headers[drivername] = result.keys()
users[drivername] = result.fetchall()
break
else:
continue
break
return make_response(
render_template('server/users.html',
host=host,
headers=headers,
users=users), 200)
def binds():
binds = BindContainer.get_all()
return dict(binds=binds)
