def openConnection(self,host,user,password,db):
if self._mysql and self._mysql.isOpen():
self.closeConnection()
self._mysql = MLAB.addSqlDatabase('Mysql')
self._mysql.setHostName(host)
self._mysql.setUserName(user)
self._mysql.setPassword(password)
self._mysql.setDatabaseName(db)
self._mysql.setPort(3306)
self._mysql.open()
valid = self._mysql.isOpen()
if not valid:
self.closeConnection()
def openConnection(self, host, user, password, db):
if self._mysql and self._mysql.isOpen():
self.closeConnection()
self._mysql = MLAB.addSqlDatabase('Mysql')
self._mysql.setHostName(host)
self._mysql.setUserName(user)
self._mysql.setPassword(password)
self._mysql.setDatabaseName(db)
self._mysql.setPort(3306)
self._mysql.open()
valid = self._mysql.isOpen()
if not valid:
self.closeConnection()
def openConnection(self,host,user,password,db):
if self._pgsql and self._pgsql.isOpen():
self.closeConnection()
self._pgsql = MLAB.addSqlDatabase('Postgres')
self._pgsql.setHostName(host)
self._pgsql.setUserName(user)
self._pgsql.setPassword(password)
self._pgsql.setDatabaseName(db)
self._pgsql.setPort(5432)
self._pgsql.open()
valid = self._pgsql.isOpen()
if not valid:
print("could not open")
self.closeConnection()
def openConnection(self, host, user, password, db):
if self._pgsql and self._pgsql.isOpen():
self.closeConnection()
self._pgsql = MLAB.addSqlDatabase('Postgres')
self._pgsql.setHostName(host)
self._pgsql.setUserName(user)
self._pgsql.setPassword(password)
self._pgsql.setDatabaseName(db)
self._pgsql.setPort(5432)
self._pgsql.open()
valid = self._pgsql.isOpen()
if not valid:
print("could not open")
self.closeConnection()
