Untitled

mail@pastecode.io avatar
unknown
plain_text
2 years ago
985 B
3
Indexable
fun tryTenant(instanceId: String) {
    try {
        val response1 = SsmClientHelper.sendCommand(this.ssmClient, instanceId, "sudo su - hdbadm -c \"hdbsql -u SYSTEM -p HelixPW1 -d SystemDB -i 00\"")
        val response2 = SsmClientHelper.sendCommand(this.ssmClient, instanceId, "sudo su - hdbadm -c \"hdbsql CREATE DATABASE MAPLE SYSTEM USER PASSWORD HelixPW1;\"")
        val response3 = SsmClientHelper.sendCommand(this.ssmClient, instanceId, "sudo su - hdbadm -c \"hdbsql ALTER SYSTEM START DATABASE MAPLE;\"")
        val response4 = SsmClientHelper.sendCommand(this.ssmClient, instanceId, "sudo su - hdbadm -c \"hdbsql select active_status from m_databases where database_name='MAPLE';\"")
        LOG.info("response1: " + response1)
        LOG.info("response2: " + response2)
        LOG.info("response3: " + response3)
        LOG.info("response4: " + response4)
    } catch (e: Exception) {
        LOG.info("Not worked for tryTenant")
        LOG.info(e.toString())
    }
}