PostgresReadyChecker is missing

[aakavalevich]

I use this library to start an instance of PosgreSQL database.
It would be nice to add a ReadyChecker for Postgres.

[aakavalevich]

I have it like
`
class PostgresReadyChecker(container: DockerContainer) extends DockerReadyChecker {
val PostgresUser = "POSTGRES_USER="
val PostgresPassword = "POSTGRES_PASSWORD="
val PostgresDB = "POSTGRES_DB="
val maybePort = container.bindPorts.headOption.map(.1)
val maybeUser = container.env.find(.startsWith(PostgresUser)).map(.substring(PostgresUser.length))
val maybePassword = container.env.find(.startsWith(PostgresPassword)).map(.substring(PostgresPassword.length))
val maybeDB = container.env.find(.startsWith(PostgresDB)).map(.substring(PostgresDB.length))

override def apply(container: DockerContainerState)(implicit docker: DockerCommandExecutor, ec: ExecutionContext) =
container.getPorts().map(ports =>
Try {
Class.forName("org.postgresql.Driver")
val ip = DockerHelper.ip
val url = s"jdbc:postgresql://$ip:${maybePort.getOrElse(ports.values.head)}/"
Logger.info(s"Trying to obtain connection to $url with user $maybeUser, password = $maybePassword, and db = $maybeDB")
val maybeConnection =
for {
user <- maybeUser
password <- maybePassword
db <- maybeDB
} yield DriverManager.getConnection(url + db, user, password)
maybeConnection.map(_.close).isDefined
}.recover{
case e =>
Logger.info(e.getMessage)
false
}.getOrElse(false)
)
}
`

[aakavalevich]

I can make a pull request if this functionality is needed.

[viktortnk]

Please have a look at sample code https://github.com/whisklabs/docker-it-scala/blob/master/samples/src/main/scala/com/whisk/docker/DockerPostgresService.scala

[aakavalevich]

@viktortnk Thanks for your example, but is it included to the library? Can I reuse it without copying?

[viktortnk]

@aakavalevich No, it is not included. Specific implementations are not shipped with library. I'd recommend to just copy it

[aakavalevich]

Ok. I just thought, that Ready checker is similar to everyone and it would be nice to share it.