Connect to mongoDB and display data in table

praneshpk

Hi everyone,
I am creating an application that connects to MongoDB and displays the data in table view/ table widget. I am able to get the data and convert it to a dataframe using a pushbutton. but not able to view the data. here is my code,

    self.retranslateUi(MainWindow)
    QtCore.QMetaObject.connectSlotsByName(MainWindow)
    self.pushButton.clicked.connect(self.button_click)
    self.table.clicked.connect(self.returndata)

def retranslateUi(self, MainWindow):
    _translate = QtCore.QCoreApplication.translate
    MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow"))
    self.pushButton.setText(_translate("MainWindow", "PushButton"))


@pyqtSlot( )
def button_click(self):
    client = MongoClient("mongodb://localhost:27017/", username="sunadmin", password="sunpassword")
    db = client['mail_test']
    test = db.mail_test
    test = pd,DataFrame(list(test.find()))
    print(test)

@pyqtSlot( )
def returndata(self):
    test = self.table.text()

jsulm

@praneshpk said in Connect to mongoDB and display data in table:

not able to view the data

What does that mean? Where are you showing the data?

praneshpk

I need to show data in tablewidget, for which the function is table

JonB

@praneshpk
So if you want to use a QTableWidget you would need to copy the returned data into the appropriate items.

Usually a QTableView is a better choice if you have your own data model. QTableWidget has its own internal model which you cannot change.

test = pd,DataFrame(list(test.find()))

~~I am not familiar that Python has this syntax?~~ [I thought the parentheses for tuples were mandatory.] And what is pd anyway since it's not declared? [This may not matter now.]

praneshpk

python is fine. What I am asking is how to display some text in tableview when button is pressed

JonB

@praneshpk
Look at QTableView Class and (particularly) Model/View Programming for your choices and examples.

Only you know how the data/model returned by, say, DataFrame(list(test.find())) looks.

praneshpk

It is working. Thanks.
Now I'm able to get data from MongoDB and display it in table view. But the size is not adjusted.
I have attached the code and screenshot. I have tried resizing. It is not working

    self.tableView.setSizeAdjustPolicy(QtWidgets.QAbstractScrollArea.AdjustToContents)
    self.tableView.resizeRowsToContents()
    self.tableView.resizeColumnsToContents()

JonB

@praneshpk
I don't know about setSizeAdjustPolicy(QtWidgets.QAbstractScrollArea.AdjustToContents), that is to do with the tableview as a whole. I don't think I have ever used that. resizeColumnsToContents() ought work. But when do you call it? Must be after the table data is shown. I assume your whole table has enough room, and you're just trying to resize a column within it; or does your whole table need expanding to fit that column?

praneshpk

Whole table has fixed size and contents are not visible, I need to resize so that I can see the contents easily.

SGaist

Hi,

Is your table view inside a layout ?

praneshpk

No, it is inside stacked pages widget

praneshpk

I'm getting contents in a fixed size, I need this to be changed manually or dynamically.

def button_click(self):
    client = MongoClient("mongodb://localhost:27017/", username="sunadmin", password="sunpassword")
    db = client['mail_test']
    collection = db.mail_test
    df = pd.DataFrame(list(collection.find()))
    df = df.filter(["sub_body"])
    print(df)

    model = PandasModel(df)
    self.tableView.setModel(model)

and the model file is ,

from PyQt5 import QtCore
import pandas as pd

class PandasModel(QtCore.QAbstractTableModel): 
    def __init__(self, df = pd.DataFrame(), parent=None): 
        QtCore.QAbstractTableModel.__init__(self, parent=parent)
        self._df = df

    def headerData(self, section, orientation, role=QtCore.Qt.DisplayRole):
        if role != QtCore.Qt.DisplayRole:
            return QtCore.QVariant()

        if orientation == QtCore.Qt.Horizontal:
            try:
                return self._df.columns.tolist()[section]
            except (IndexError, ):
                return QtCore.QVariant()
        elif orientation == QtCore.Qt.Vertical:
            try:
                # return self.df.index.tolist()
                return self._df.index.tolist()[section]
            except (IndexError, ):
                return QtCore.QVariant()

    def data(self, index, role=QtCore.Qt.DisplayRole):
        if role != QtCore.Qt.DisplayRole:
            return QtCore.QVariant()

        if not index.isValid():
            return QtCore.QVariant()

        return QtCore.QVariant(str(self._df.iloc[index.row(), index.column()]))

    def setData(self, index, value, role):
        row = self._df.index[index.row()]
        col = self._df.columns[index.column()]
        if hasattr(value, 'toPyObject'):
            # PyQt4 gets a QVariant
            value = value.toPyObject()
        else:
            # PySide gets an unicode
            dtype = self._df[col].dtype
            if dtype != object:
                value = None if value == '' else dtype.type(value)
        self._df.set_value(row, col, value)
        return True

    def rowCount(self, parent=QtCore.QModelIndex()): 
        return len(self._df.index)

    def columnCount(self, parent=QtCore.QModelIndex()): 
        return len(self._df.columns)

    def sort(self, column, order):
        colname = self._df.columns.tolist()[column]
        self.layoutAboutToBeChanged.emit()
        self._df.sort_values(colname, ascending= order == QtCore.Qt.AscendingOrder, inplace=True)
        self._df.reset_index(inplace=True, drop=True)
        self.layoutChanged.emit()

JonB

@praneshpk said in Connect to mongoDB and display data in table:

I'm getting contents in a fixed size, I need this to be changed manually or dynamically.

All of the stuff you show is for the model. Sizing is dealt with by the view. Whatever you want/need to do about that should be in the QTableView.

praneshpk

This post is deleted!