Method _select

database/SQliteDB.py:45–66

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

        self._conn.close()
    
    def _select(self, sentence: str, values=None, showColumns = False):
        cursor = self._get_cursor()
        rows=[]
        if values is not None:
            cursor.execute(sentence, values)
        else:
            cursor.execute(sentence)
        results = cursor.fetchall()

        if showColumns:
            column_names = [desc[0] for desc in cursor.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)
        
        self._conn.close()
        return rows

    def _get_columns(self, tablename:str):
        return self._get_columns_from_table(tablename)