Display All MySQL Hosts

The following example finds the ID of the MySQLDS data source and then uses that to get a list of all the hostnames associated with that data source in Lasso's internal databases.

Code

local(dr) = database_registry
#dr->doWithClose => {^
    with host in #dr->listDatasourceHosts(#dr->getDatasourceId('MySQLDS'))
    sum #host->find('name') + '\n'
^}

Result

localhost
example.com