Skip to content

Instantly share code, notes, and snippets.

@hkakutalua
Created July 19, 2020 10:26
Show Gist options
  • Save hkakutalua/be54c0867a0d284cf5be7e06936d3d52 to your computer and use it in GitHub Desktop.
Save hkakutalua/be54c0867a0d284cf5be7e06936d3d52 to your computer and use it in GitHub Desktop.
PostgresDbCleanerExtension loadTablesToClean
@Throws(SQLException::class)
private fun loadTablesToClean(connection: Connection): List<TableData> {
val databaseMetaData = connection.metaData
val resultSet = databaseMetaData.getTables(
connection.catalog, null, null, arrayOf("TABLE"))
val tablesToClean = mutableListOf<TableData>()
while (resultSet.next()) {
val table = TableData(
schema = resultSet.getString("TABLE_SCHEM"),
name = resultSet.getString("TABLE_NAME")
)
if (!TABLES_TO_IGNORE.contains(table)) {
tablesToClean.add(table)
}
}
return tablesToClean
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment