import grails.util.Holders import org.hibernate.SessionFactory import org.apache.commons.lang.StringUtils def dataSource SessionFactory sessionFactory String connectionURL = dataSource.targetDataSource.targetDataSource.poolProperties.url connectionURL = StringUtils.substringAfterLast(connectionURL, '/') connectionURL = StringUtils.substringBefore(connectionURL, '?') println(connectionURL) String databaseName = sessionFactory.currentSession.createSQLQuery("SELECT DATABASE()") .setReadOnly(true).setCacheable(false).list().first() println(databaseName) String query = "SELECT table_name FROM information_schema.tables WHERE table_schema='$databaseName'".toString() List list = sessionFactory.currentSession.createSQLQuery(query) .setReadOnly(true).setCacheable(false).list() println(list.size()) println(list)
Showing posts with label mysql-tables. Show all posts
Showing posts with label mysql-tables. Show all posts
Tuesday, December 19, 2017
Grails on Groovy: Get Retrieve MySQL Database name from DataSource | Get List of MySQL Tables | Execute MySQL Raw Query
Subscribe to:
Posts (Atom)