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()