Method _select

database/PostgreSQL.py:69–89

(self, sentence: str, values=None, showColumns = False)

    def _select(self, sentence: str, values=None, showColumns = False):
        rows = []
        cur = self._get_cursor()
        cur.execute(sentence, values)
        results = cur.fetchall()
        cur.close()
        if showColumns:
            column_names = [desc[0] for desc in cur.description]
            for row in results:
                row_with_column_names = {}
                for idx, value in enumerate(row):
                    row_with_column_names[column_names[idx]] = value
                rows.append(row_with_column_names)
        else:
            for row in results:
                rows.append(row)

        if len(rows)>0:
          return rows
        
        return None

    def _check_exists_db(self, name:str) -> bool:
        sentence = """