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