def filter_buildQuery(self): #Build query set and return results columnList = ",".join(self.rptFields) filterStmnt = self.txtSqlParser.toPlainText() #Check if sorting has been defined stLen,stSQL = self.sorting_compileSort() #Check if grouping has been defined gpLen,gpQuery = self.grouping_orderQuery() sortStmnt='' if gpLen > 0: sortStmnt = gpQuery if stLen>0: stSQL = stSQL.replace(" ORDER BY","") sortStmnt = sortStmnt+"," + stSQL else: if stLen>0: sortStmnt = stSQL results=None try: results = process_report_filter(self.tabName,columnList,filterStmnt,sortStmnt) except sqlalchemy.exc.ProgrammingError,sqlalchemy.exc.DataError: self.ErrorInfoMessage(QApplication.translate("ReportBuilder","The SQL statement is invalid!"))
def filter_buildQuery(self): #Build query set and return results queryCols = self.selectedColumns() if self.geomColumn != "": queryCols.append("ST_AsText(%s)"%(self.geomColumn)) columnList = ",".join(queryCols) whereStmnt = self.txtWhereQuery.toPlainText() sortStmnt='' results=None try: results = process_report_filter(self.srcTab,columnList,whereStmnt,sortStmnt) except sqlalchemy.exc.DataError,e: if e is None: errMessage = "Database Error Message - NOT AVAILABLE" else: errMessage = e.message self.ErrorInfoMessage("The SQL statement is invalid!\n" + errMessage)