def assignRoles(self): if self.rbSchemaNew.isChecked(): roleP = RoleProvider() roles = roleP.GetSysRoles() for role in roles: roleSql=text("GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO %s;"%(role)) _execute(roleSql)
def createDbExtension(self): """ Create postgis extension in the new database :return: """ ext_name = dbExt%self.template try: if self.template is not None: ext_sql=ext_name else: ext_sql = ('CREATE EXTENSION postgis') _execute(ext_sql) except Exception as ex: QMessageBox.information(None, "Database Operation", str(ex.message))