Appending an image to itemList of QFormLayout widgets

CEO.

I have finally resolved the issue:

I decided to make the retrieved data display in the qtablewidget with the image displaying inside the qtablewidget (as a png, or jpg file) as it is retrieved from the database, so the varbinary texts no longer displays in the qtablewidget.

Then I use the .loadData() method in displaying it there. I was able to resolve the appendSelection function and get the displayed image of the qtablewidget to display also in the qlabel qpixmap reserved for it in the qformlayout. This resolved the appending issue for me:

                                              if (col == 2) and itemArray:
                              
                                                  img = itemArray.data(QTableWidgetItem.UserType)
                              
                                                  pixmap = QPixmap()
                              
                                                  pixmap.loadFromData(img, 'jpg')
                              
                                                  itemList[2].setPixmap(pixmap)

mrjj

@CEO

Super.
So it helped not to store it in Linedit first but in a user role and
hence it was not broken and could convert to image ?

CEO.

@mrjj yes and I was so happy and exclaimed EUREKA! immediately it worked fine. I now understand the joy Archimedes felt when the idea of upthrust struck him while bathing to the extent he had to run out of his bathroom naked. lol

mrjj

@CEO

hehe well good :)
thx for the feedback. I learn by knowing what was wrong so it was as i
guessed at. the binary stream didn't like to be in lineedit first.

CEO.

@mrjj

.

I wanna update the retrieved image which is displayed in jpg format. How do I go about it plz?

The image label (i.e the qpixmap label) is self.passlb

 if (col == 2) and itemArray:
                    img = itemArray.data(QTableWidgetItem.UserType)
                    pixmap = QPixmap()
                    pixmap.loadFromData(img, 'jpg')
                    itemList[2].setPixmap((pixmap).scaled(250,250))

So in my sql update statement, I tried:

             values(self.fullname.text(),
             self.passlb.pixmap()
...)```

It didn't work.

Do you think it should be:

       img.pixmap() or img.text() or img.read()
Any clue about the method I should use in updating a qpixmap label?

mrjj

Hi
You mean save an actual pixmap back to the database ?`

But what is the type of field in the db and how did you get the other images in there ?

Its clear we need to convert it to a binary stream and we can use QBuffer for that

(c++, could not find python example)

    QPixmap inPixmap =self.passlb.pixmap(); 
    QByteArray inByteArray;
    QBuffer inBuffer( &inByteArray );
    inBuffer.open( QIODevice::WriteOnly );
    inPixmap.save( &inBuffer, "PNG" ); // write inPixmap into inByteArray in PNG format

inBuffer can now be saved in DB.

But I wonder if there is the reverse of io.BytesIO ? we should rather use ?

CEO.

@mrjj sorry,

See this function, it's for uploading images in the form for update:

def openfile(self):
    try:
        fname, _ = QFileDialog.getOpenFileName(self, 'Open', 'c:\\', "image Files (*.jpg *.png)")
        self.passlb.setPixmap(QPixmap(fname).scaled(250, 250))
        self.img = open(fname, 'rb')
        self.psptpath.setText(fname)
        # self.pixL.setText(strfn)
        print(self.pixlb.setText(''))

This function is for appending the jpg to the qlabel self.passlb from the qtable after it's been retrieved from the database:

       if (col ==2):
       img = itemArray.data(QTableWidgetItem.UserType)
                               pixmap = QPixmap()
                               pixmap.loadFromData(img, 'jpg')
                               itemList[2].setPixmap((pixmap).scaled(250,250))

Then here is my sql statement updating the image:
(The usual update statement is here)
values (self.fullname.text(),
self.img.read()
)

This is saying my program objects has no attribute 'img'

mrjj

@CEO
ah well its better with such logical bug than something that just don't work :)

CEO.

@mrjj please see this.

CEO.

@CEO said in Appending an image to itemList of QFormLayout widgets:

@mrjj sorry,

See this function, it's for uploading images in the form for update:
def openfile(self):
    try:
        fname, _ = QFileDialog.getOpenFileName(self, 'Open', 'c:\\', "image Files (*.jpg *.png)")
        self.passlb.setPixmap(QPixmap(fname).scaled(250, 250))
        self.img = open(fname, 'rb')
        self.psptpath.setText(fname)
        # self.pixL.setText(strfn)
        print(self.pixlb.setText(''))
This function is for appending the jpg to the qlabel self.passlb from the qtable after it's been retrieved from the database:
       if (col ==2):
       img = itemArray.data(QTableWidgetItem.UserType)
                               pixmap = QPixmap()
                               pixmap.loadFromData(img, 'jpg')
                               itemList[2].setPixmap((pixmap).scaled(250,250))
Then here is my sql statement updating the image:
(The usual update statement is here)
values (self.fullname.text(),
self.img.read()
)

This is saying my program objects has no attribute 'img'

@mrjj

CEO.

@mrjj I did some testing and discovered it works fine only when I update the photo. Updating any other column without updating the image (photo) produces an error saying no object found for the image column.

mrjj

@CEO
But does it says that self.img don't exists ?

but in def openfile(self):

self.img = open(fname, 'rb')

works

so is the function that uses the SQL, also part of the same class ?

CEO.

@mrjj the function that uses the SQL is part of the class. It works fine when in my update I upload a photo but comes up with that error "object has no attribute 'img' " if I don't upload a photo (i.e when I leave the photo retrieved from the database). Meaning even if I upload the same photo there, it will work. It just wants the upload to be done in that pixmap field

mrjj

So when loading from db, you need to both set the UserRole and the pixmap field
it sounds like even the error "object has no attribute 'img' " is very confusing
if it is indeed a class member.