Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Appending an image to itemList of QFormLayout widgets
Forum Updated to NodeBB v4.3 + New Features

Appending an image to itemList of QFormLayout widgets

Scheduled Pinned Locked Moved Unsolved General and Desktop
51 Posts 4 Posters 5.2k Views 3 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • mrjjM mrjj

    Hi

    • it runs but with an error message: "a bytes-like object is required, not 'str' "

    for which line ?

    imgstrm = io.BytesIO(imgcon) ?

    in the original / first sample you get it from
    imgstrm = io.BytesIO(row[2])

    so is that the same data in your real app you give it ?

    C Offline
    C Offline
    CEO.
    wrote on last edited by
    #17

    @mrjj heeeeyyyyy you're here. From these lines:

                   imgcon = bytes(self.passlbbtx.text(), 'utf-8')
                    imgstrm = io.BytesIO(imgcon)
                    imgfile = Image.open(imgstrm)
    
    C 1 Reply Last reply
    0
    • mrjjM mrjj

      Hi

      • it runs but with an error message: "a bytes-like object is required, not 'str' "

      for which line ?

      imgstrm = io.BytesIO(imgcon) ?

      in the original / first sample you get it from
      imgstrm = io.BytesIO(row[2])

      so is that the same data in your real app you give it ?

      C Offline
      C Offline
      CEO.
      wrote on last edited by
      #18

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

      Hi

      • it runs but with an error message: "a bytes-like object is required, not 'str' "

      for which line ?

      imgstrm = io.BytesIO(imgcon) ?

      in the original / first sample you get it from
      imgstrm = io.BytesIO(row[2])

      so is that the same data in your real app you give it ?

      No, that's not actually the original. That's just like a rough work which I was using to test. That one was without a Qtablewidget for display of the retrieved data.

      1 Reply Last reply
      0
      • C CEO.

        @mrjj heeeeyyyyy you're here. From these lines:

                       imgcon = bytes(self.passlbbtx.text(), 'utf-8')
                        imgstrm = io.BytesIO(imgcon)
                        imgfile = Image.open(imgstrm)
        
        C Offline
        C Offline
        CEO.
        wrote on last edited by CEO.
        #19

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

        @mrjj heeeeyyyyy you're here. From these lines:

                       imgcon = bytes(self.passlbbtx.text(), 'utf-8')
                        imgstrm = io.BytesIO(imgcon)
                        imgfile = Image.open(imgstrm)
        

        You would notice I tried to do a conversion from string to byte here. This is because the data is automatically appended in the QLineEdits of the qFormLayout as a string after it was retrieved and displayed in the cells of the qtablewidget as a byte.

        So I was trying to convert that string to byte and then convert the byte to jpg/jpeg image format.

        mrjjM 1 Reply Last reply
        0
        • C CEO.

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

          @mrjj heeeeyyyyy you're here. From these lines:

                         imgcon = bytes(self.passlbbtx.text(), 'utf-8')
                          imgstrm = io.BytesIO(imgcon)
                          imgfile = Image.open(imgstrm)
          

          You would notice I tried to do a conversion from string to byte here. This is because the data is automatically appended in the QLineEdits of the qFormLayout as a string after it was retrieved and displayed in the cells of the qtablewidget as a byte.

          So I was trying to convert that string to byte and then convert the byte to jpg/jpeg image format.

          mrjjM Offline
          mrjjM Offline
          mrjj
          Lifetime Qt Champion
          wrote on last edited by
          #20

          @CEO
          Hi
          In the orignal code, you convert directly from io.BytesIO(row[2]) is is directly from self.cursor.execute
          so I guess it contains QBytearray in a Qvariant

          However, in real app it seems you are trying to take it from a Widget self.passlbbtx.text(),
          and I'm not sure that can work as its a QString.

          what is passlbbtx ?

          1 Reply Last reply
          0
          • C CEO.

            part of the sql data retrieval code:

                                   result = self.cursor.fetchall()             
                                 for row_number, row_data in enumerate(result):             
                                     self.tab.insertRow(row_number)             
                                     for column_number, data in enumerate(row_data):             
                                         self.tab.setItem(row_number, column_number, QTableWidgetItem(str(data)))
            

            part of the itemsArray code:

                                          for row in rows:                      
                                              for col in range(self.tab.columnCount()):                      
                                                  itemArray = self.tab.item(row, col)
                            
                                                
            
                                 
                               text = "" if itemArray is None else itemArray.text()                 
                            
                                 if (col == 14):
                                itemList[12].setText(text)
                                imgcon = self.passlbbtx.text()
                                imgstrm = io.BytesIO(imgcon)
                                imgfile = Image.open(imgstrm)
                                self.passlb.setPixmap(ImageQt.toqpixmap(imgfile).scaled(250, 250))
            

            it runs but with an error message: "a bytes-like object is required, not 'str' "

            C Offline
            C Offline
            CEO.
            wrote on last edited by CEO.
            #21

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

            part of the sql data retrieval code:

                                   result = self.cursor.fetchall()             
                                 for row_number, row_data in enumerate(result):             
                                     self.tab.insertRow(row_number)             
                                     for column_number, data in enumerate(row_data):             
                                         self.tab.setItem(row_number, column_number, QTableWidgetItem(str(data)))
            

            it runs but with an error message: "a bytes-like object is required, not 'str' "

            Could the self.tab.setItem(row_number, column_number, QtablewidgetItem(str(data))) be where the issue is coming from?

            self.passlbtx is a QLineEdit for appending the varbinary data retrieved and displayed in a column of the qtablewidget.

            @mrjj

            mrjjM 1 Reply Last reply
            0
            • C CEO.

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

              part of the sql data retrieval code:

                                     result = self.cursor.fetchall()             
                                   for row_number, row_data in enumerate(result):             
                                       self.tab.insertRow(row_number)             
                                       for column_number, data in enumerate(row_data):             
                                           self.tab.setItem(row_number, column_number, QTableWidgetItem(str(data)))
              

              it runs but with an error message: "a bytes-like object is required, not 'str' "

              Could the self.tab.setItem(row_number, column_number, QtablewidgetItem(str(data))) be where the issue is coming from?

              self.passlbtx is a QLineEdit for appending the varbinary data retrieved and displayed in a column of the qtablewidget.

              @mrjj

              mrjjM Offline
              mrjjM Offline
              mrjj
              Lifetime Qt Champion
              wrote on last edited by
              #22

              Hi

              Well the
              QTableWidgetItem(str(data))
              part tried to make str out of data but it complains about the reverse
              "a bytes-like object is required, not 'str' "
              so I think it must be related to when you do the other way.

              I think maybe from here
              imgcon = bytes(self.passlbbtx.text(), 'utf-8')

              as QLineEdit only contains QString not Qbytearry or the binary stream you read from database.

              Would it not be possible to directly read it into the image/pixmap and not via a QLineEdit ?

              C 4 Replies Last reply
              0
              • mrjjM mrjj

                Hi

                Well the
                QTableWidgetItem(str(data))
                part tried to make str out of data but it complains about the reverse
                "a bytes-like object is required, not 'str' "
                so I think it must be related to when you do the other way.

                I think maybe from here
                imgcon = bytes(self.passlbbtx.text(), 'utf-8')

                as QLineEdit only contains QString not Qbytearry or the binary stream you read from database.

                Would it not be possible to directly read it into the image/pixmap and not via a QLineEdit ?

                C Offline
                C Offline
                CEO.
                wrote on last edited by
                #23

                @mrjj please kindly see this thread:

                https://github.com/python-pillow/Pillow/issues/5712

                1 Reply Last reply
                0
                • mrjjM mrjj

                  Hi

                  Well the
                  QTableWidgetItem(str(data))
                  part tried to make str out of data but it complains about the reverse
                  "a bytes-like object is required, not 'str' "
                  so I think it must be related to when you do the other way.

                  I think maybe from here
                  imgcon = bytes(self.passlbbtx.text(), 'utf-8')

                  as QLineEdit only contains QString not Qbytearry or the binary stream you read from database.

                  Would it not be possible to directly read it into the image/pixmap and not via a QLineEdit ?

                  C Offline
                  C Offline
                  CEO.
                  wrote on last edited by
                  #24

                  @mrjj I want the images to be changing as different row selection is made on the qtablewidget

                  mrjjM 1 Reply Last reply
                  0
                  • C CEO.

                    @mrjj I want the images to be changing as different row selection is made on the qtablewidget

                    mrjjM Offline
                    mrjjM Offline
                    mrjj
                    Lifetime Qt Champion
                    wrote on last edited by mrjj
                    #25

                    @CEO
                    Hi

                    • I want the images to be changing as different row selection is made on the qtablewidget

                    But are those rows a complete record and you want to show its image in its label or
                    do you mean you click on some name in tablewidget and somewhere else it show
                    the full record and you want to switch data there ?

                    def retrieval(self):

                    does this get the image ok ?
                    That is also directly from DB.

                    update:
                    ah its names in listwidget and picture somewhere else.
                    alt text

                    C 1 Reply Last reply
                    0
                    • mrjjM mrjj

                      @CEO
                      Hi

                      • I want the images to be changing as different row selection is made on the qtablewidget

                      But are those rows a complete record and you want to show its image in its label or
                      do you mean you click on some name in tablewidget and somewhere else it show
                      the full record and you want to switch data there ?

                      def retrieval(self):

                      does this get the image ok ?
                      That is also directly from DB.

                      update:
                      ah its names in listwidget and picture somewhere else.
                      alt text

                      C Offline
                      C Offline
                      CEO.
                      wrote on last edited by
                      #26

                      @mrjj thanks for your effort.

                      The table is a complete record. I wouldn't mind you use a teamviewer to access my system to see what I'm talking about. The qtablewidget is a complete record. Ignore those strange characters you see scattered there, it happened when I was trying some things.

                      See the algorithm:

                      When you click on the search button, all the records in the database are retrieved and get displayed on the qtablewidget cells. There are 22 attributes in the database table. I hid five (5) of them from being displayed on the qtablewidget. 17 gets displayed. The data for the photo in the database is varbinary but gets retrieved in the qtab as a string.

                      Below the qtablewidget, I created a qformlayout with qwidgets. The QLineEdits are appended to the qtablewidget such that the record of any row selected will be displayed in their corresponding qLineEdit. one of the qlineEdits is self.passlbtx . This is for the photo data in the tablewidget column which is already in string.

                      There is a qpixmap meant for the display of the photo of the selected row.

                      The self.passlbtx qlineEdit data is already in string. So it is expected of the self.passlbtx qLineEdit data to be converted to byte and then jpg image so the image can display in the qpixmap.

                      I know very well you can resolve it, I just think you're not understanding me. I believe it's a simple thing for you. I am attaching a photo to this post. In this photo, the first row of the qtab was selected (highlighted), thereby appending the data of the row in the qformlayout qlineEdits. Notice the image did not display, meanwhile there is a column for image data there, the texts of the image data is displayed in the qLineEdit of image byte label. So how do I make the image display in jpg or jpeg or png format in the qpixmap there?

                      tabb.JPG

                      1 Reply Last reply
                      0
                      • mrjjM Offline
                        mrjjM Offline
                        mrjj
                        Lifetime Qt Champion
                        wrote on last edited by
                        #27

                        Hi

                        • So how do I make the image display in jpg or jpeg or png format in the qpixmap there
                          I think storing it in a LineEdit kills the data unless python can do something very magical.

                        a you can see it shows as \x86\x8eu

                        which is a text version of binay.

                        So I think

                                    imgcon = bytes(self.passlbbtx.text(), 'utf-8')
                                    imgstrm = io.BytesIO(imgcon)
                                    imgfile = Image.open(imgstrm)
                        

                        cannot work as self.passlbbtx.text() returns a text string and I'm not sure the bytes function understands that or at least
                        get an image out of it.

                        Would it be possible to directly load it from db on click in table instead of preloading it to a LineEdit ?

                        C 3 Replies Last reply
                        0
                        • mrjjM mrjj

                          Hi

                          • So how do I make the image display in jpg or jpeg or png format in the qpixmap there
                            I think storing it in a LineEdit kills the data unless python can do something very magical.

                          a you can see it shows as \x86\x8eu

                          which is a text version of binay.

                          So I think

                                      imgcon = bytes(self.passlbbtx.text(), 'utf-8')
                                      imgstrm = io.BytesIO(imgcon)
                                      imgfile = Image.open(imgstrm)
                          

                          cannot work as self.passlbbtx.text() returns a text string and I'm not sure the bytes function understands that or at least
                          get an image out of it.

                          Would it be possible to directly load it from db on click in table instead of preloading it to a LineEdit ?

                          C Offline
                          C Offline
                          CEO.
                          wrote on last edited by
                          #28

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

                          Hi

                          • So how do I make the image display in jpg or jpeg or png format in the qpixmap there
                            I think storing it in a LineEdit kills the data unless python can do something very magical.

                          a you can see it shows as \x86\x8eu

                          which is a text version of binay.

                          So I think

                                      imgcon = bytes(self.passlbbtx.text(), 'utf-8')
                                      imgstrm = io.BytesIO(imgcon)
                                      imgfile = Image.open(imgstrm)
                          

                          cannot work as self.passlbbtx.text() returns a text string and I'm not sure the bytes function understands that or at least
                          get an image out of it.

                          Would it be possible to directly load it from db on click in table instead of preloading it to a LineEdit ?

                          if it's possible, I wouldn't mind giving it a trial, but without a qPixmap in the qtab, will it be possible?

                          1 Reply Last reply
                          0
                          • mrjjM mrjj

                            Hi

                            Well the
                            QTableWidgetItem(str(data))
                            part tried to make str out of data but it complains about the reverse
                            "a bytes-like object is required, not 'str' "
                            so I think it must be related to when you do the other way.

                            I think maybe from here
                            imgcon = bytes(self.passlbbtx.text(), 'utf-8')

                            as QLineEdit only contains QString not Qbytearry or the binary stream you read from database.

                            Would it not be possible to directly read it into the image/pixmap and not via a QLineEdit ?

                            C Offline
                            C Offline
                            CEO.
                            wrote on last edited by
                            #29

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

                            Would it not be possible to directly read it into the image/pixmap and not via a QLineEdit ?

                            When I tried to do this, it didn't work well with the fetchall() method, i.e result[the passport column]

                            It only works with fetchone() method.

                            Besides, using that would no longer be subjected to the row selection changes.

                            1 Reply Last reply
                            0
                            • mrjjM mrjj

                              Hi

                              Well the
                              QTableWidgetItem(str(data))
                              part tried to make str out of data but it complains about the reverse
                              "a bytes-like object is required, not 'str' "
                              so I think it must be related to when you do the other way.

                              I think maybe from here
                              imgcon = bytes(self.passlbbtx.text(), 'utf-8')

                              as QLineEdit only contains QString not Qbytearry or the binary stream you read from database.

                              Would it not be possible to directly read it into the image/pixmap and not via a QLineEdit ?

                              C Offline
                              C Offline
                              CEO.
                              wrote on last edited by
                              #30

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

                              Hi

                              Well the
                              QTableWidgetItem(str(data))
                              part tried to make str out of data but it complains about the reverse
                              "a bytes-like object is required, not 'str' "
                              so I think it must be related to when you do the other way.

                              I think maybe from here
                              imgcon = bytes(self.passlbbtx.text(), 'utf-8')

                              as QLineEdit only contains QString not Qbytearry or the binary stream you read from database.

                              Would it not be possible to directly read it into the image/pixmap and not via a QLineEdit ?

                              I tried to use this:

                                           self.tab.setItem(row_number, column_number, QTableWidgetItem(data if column_number == 7 else str(data)))
                              

                              It still says: "a bytes-like object is required, not 'str' "

                              1 Reply Last reply
                              0
                              • mrjjM mrjj

                                Hi

                                • So how do I make the image display in jpg or jpeg or png format in the qpixmap there
                                  I think storing it in a LineEdit kills the data unless python can do something very magical.

                                a you can see it shows as \x86\x8eu

                                which is a text version of binay.

                                So I think

                                            imgcon = bytes(self.passlbbtx.text(), 'utf-8')
                                            imgstrm = io.BytesIO(imgcon)
                                            imgfile = Image.open(imgstrm)
                                

                                cannot work as self.passlbbtx.text() returns a text string and I'm not sure the bytes function understands that or at least
                                get an image out of it.

                                Would it be possible to directly load it from db on click in table instead of preloading it to a LineEdit ?

                                C Offline
                                C Offline
                                CEO.
                                wrote on last edited by
                                #31

                                @mrjj will it be possible I use the qtab column directly in my conversion?
                                For example:

                                             imgg = column7
                                             imgstrm = io.BytesIO(imgg)
                                

                                whereby column7 is the passport photo column in my qtable. Or is there a better way to instantiate it?

                                1 Reply Last reply
                                0
                                • mrjjM mrjj

                                  Hi

                                  • So how do I make the image display in jpg or jpeg or png format in the qpixmap there
                                    I think storing it in a LineEdit kills the data unless python can do something very magical.

                                  a you can see it shows as \x86\x8eu

                                  which is a text version of binay.

                                  So I think

                                              imgcon = bytes(self.passlbbtx.text(), 'utf-8')
                                              imgstrm = io.BytesIO(imgcon)
                                              imgfile = Image.open(imgstrm)
                                  

                                  cannot work as self.passlbbtx.text() returns a text string and I'm not sure the bytes function understands that or at least
                                  get an image out of it.

                                  Would it be possible to directly load it from db on click in table instead of preloading it to a LineEdit ?

                                  C Offline
                                  C Offline
                                  CEO.
                                  wrote on last edited by CEO.
                                  #32

                                  @mrjj

                                  I had to do a sketch of what I want in another file, in a simpler way so as to reduce the codes but to pass the same message:

                                  ```
                                  

                                  import sys
                                  import pyodbc, uuid, os, hashlib, base64
                                  from PyQt5 import QtWidgets, QtCore, QtGui
                                  from PyQt5.QtWidgets import *
                                  from PyQt5.QtGui import (QIcon, QFont, QPixmap)
                                  from PyQt5.QtWidgets import *
                                  from PyQt5.QtCore import *
                                  import datetime, getpass, psutil, io
                                  from random import randint as ri
                                  from io import BytesIO, StringIO
                                  from PIL import Image, ImageQt

                                  class userRecords(QWidget):
                                  def init(self):
                                  super().init()
                                  self.setGeometry(100, 100, 800, 700)

                                      # setting the background stylesheet
                                      self.setAutoFillBackground(True)
                                      winP = self.palette()
                                      winP.setColor(self.backgroundRole(), Qt.darkGray)
                                      self.setPalette(winP)
                                  
                                      gridtab = QGridLayout()
                                      gboxtab = QGroupBox()
                                      gboxtab.setCheckable(True)
                                      self.setLayout(gridtab)
                                  
                                      vboxtab = QVBoxLayout()
                                      gboxtab.setLayout(vboxtab)
                                  
                                      hboxtab = QHBoxLayout()
                                      hboxtab2 = QHBoxLayout()
                                      vboxtab.addLayout(hboxtab)
                                      vboxtab.addLayout(hboxtab2)
                                  
                                      self.tab = QtWidgets.QTableWidget(self)
                                      gboxtab.setStyleSheet("background-color: powderblue")
                                      self.tab.setStyleSheet("background-color: cornsilk; gridline-color: red; border: 2px solid gray; selection-color: yellow")
                                  
                                      self.searchbtn = QPushButton("Search:")
                                      self.searchbtn.setStyleSheet("background-color: lightsteelblue; color: black")
                                      self.searchbtn.clicked.connect(self.retrieve1)
                                  
                                      displaylb = QLabel("Selected row")
                                      self.displaytx = QLineEdit()
                                      self.displaytx.setReadOnly(True)
                                      self.displaytx.setStyleSheet("background-color: moccasin;")
                                  
                                      global searchtxtab
                                      searchtxtab = QLineEdit()
                                      searchtxtab.setStyleSheet("background-color: moccasin;")
                                  
                                      clearbtn = QPushButton("Clear Records")
                                      clearbtn.setStyleSheet("background-color: lightsteelblue; color: black")
                                      clearbtn.clicked.connect(self.clearData)
                                  
                                      hboxtab.addWidget(self.searchbtn)
                                      hboxtab.addWidget(searchtxtab)
                                      hboxtab.addWidget(clearbtn)
                                  
                                      hboxtab2.addWidget(displaylb)
                                      hboxtab2.addWidget(self.displaytx)
                                  
                                      vboxtab.addWidget(self.tab)
                                  
                                      gboxtab2 = QGroupBox()
                                      fboxtab = QFormLayout()
                                      hboxtab3 = QHBoxLayout()
                                      vboxtab.addLayout(hboxtab3)
                                      hboxtab3.addWidget(gboxtab2)
                                      gboxtab2.setLayout(fboxtab)
                                      gboxtab2.setStyleSheet("background-color: lightsteelblue")
                                  
                                  
                                      gboxtab4 = QGroupBox()
                                      fboxtab3 = QFormLayout()
                                      hboxtab3.addWidget(gboxtab4)
                                      gboxtab4.setLayout(fboxtab3)
                                      gboxtab4.setCheckable(True)
                                  
                                      gboxtab5 = QGroupBox()
                                      vboxtab2 = QVBoxLayout()
                                      hboxtab3.addWidget(gboxtab5)
                                      gboxtab5.setLayout(vboxtab2)
                                  
                                      gboxtab5.setCheckable(True)
                                      gboxtab4.setStyleSheet("background-color: lightsteelblue")
                                      gboxtab5.setStyleSheet("background-color: lightsteelblue")
                                  
                                      fulln = QLabel("Fullname:")
                                      self.fulln = QLineEdit()
                                      self.fulln.setStyleSheet("background-color: mistyrose;")
                                  
                                      deptlb = QLabel("Department:")
                                      self.depttx = QLineEdit()
                                      self.depttx.setStyleSheet("background-color: mistyrose;")
                                  
                                      quallb = QLabel("H.Qualification:")
                                      self.qualtx = QLineEdit()
                                      self.qualtx.setStyleSheet("background-color: mistyrose;")
                                  
                                      pspt = QLabel("Photo path:")
                                      self.pspttx = QLineEdit()
                                      self.pspttx.setStyleSheet("background-color: mistyrose;")
                                  
                                      self.passlb = QLabel("Passport Photo here")
                                      self.passlb.setPixmap(QPixmap("C:\\Users\PC\\Pictures\\avaters\\avatar1.png").scaled(250,250))
                                  
                                      passlbb = QLabel("Image byte")
                                      self.passlbbtx = QLineEdit()
                                      self.passlbbtx.setStyleSheet("background-color: mistyrose;")
                                      self.passlbbtx.setReadOnly(True)
                                  
                                      ptbtn = QPushButton("Upload Your Passport")
                                      ptbtn.setStyleSheet("background-color: grey; color: navy; Font: 20px")
                                      ptbtn.clicked.connect(self.openfile)
                                  
                                      fboxtab.addRow(fulln, self.fulln)
                                      fboxtab.addRow(deptlb, self.depttx)
                                      fboxtab.addRow(quallb, self.qualtx)
                                  
                                      fboxtab3.addRow(passlbb, self.passlbbtx)
                                  
                                      vboxtab2.addWidget(self.passlb)
                                      vboxtab2.addWidget(ptbtn)
                                  
                                      scrol = QScrollArea()  # whatever you want to appear on the scrollArea must be coded before this scrollarea code
                                      scrol.setWidget(gboxtab)
                                      scrol.setVerticalScrollBarPolicy(Qt.ScrollBarAlwaysOn)
                                      scrol.setHorizontalScrollBarPolicy(Qt.ScrollBarAlwaysOn)
                                      scrol.setWidgetResizable(True)
                                      scrol.ensureVisible(1500, 1500)
                                      gridtab.addWidget(scrol)
                                  
                                      Headerlist = ["Fullname", "Dept",  "H.Qualification", "Passport"]
                                      self.tab.setRowCount(1000)
                                      self.tab.setColumnCount(4)
                                      self.tab.setHorizontalHeaderLabels(Headerlist)
                                      # self.tab.horizontalHeader().setStyleSheet("::section{background-color: lightsteelblue}")
                                      self.tab.horizontalHeader().setStyleSheet(
                                          "QHeaderView::section{background: lightsteelblue; padding- left: 4px; border: 3px solid red}")
                                      self.tab.setGeometry(150, 200, 1700, 1700)
                                      self.tab.setSizeAdjustPolicy(QAbstractScrollArea.AdjustToContents)
                                      self.tab.resizeColumnsToContents()
                                      self.tab.setSelectionBehavior(QAbstractItemView.SelectRows)
                                      self.tab.setSelectionMode(QAbstractItemView.SingleSelection)
                                      self.tab.horizontalHeader().setSectionResizeMode(QHeaderView.Stretch)  # this makes the columns fit in the widget
                                      self.tab.setEditTriggers(QtWidgets.QTableWidget.NoEditTriggers)            # this makes the QTable widget uneditable.
                                  
                                      self.tab.setFont(QFont("Courier"))
                                      self.tab.selectionModel().selectionChanged.connect(self.handle_selection_changed)
                                  
                                      self.msgBox = QMessageBox()
                                      self.msgBox.setIcon(QMessageBox.Information)
                                      self.msgBox.setGeometry(100, 100, 100, 100)
                                      # self.update = updateRecord()
                                  
                                  def openfile(self):
                                      try:
                                          fname, _ = QFileDialog.getOpenFileName(self, 'Open', 'c:\\', "image Files (*.jpg *.png)")
                                          self.pixlb.setPixmap(QPixmap(fname).scaled(250, 250))
                                          self.img = open(fname, 'rb')
                                          self.pixtx.setText(fname)
                                          print(self.pixlb.setText(''))
                                  
                                      except Exception as err:
                                          print(err)
                                  
                                  def db_connection(self):
                                      try:
                                          # ensure there's no space before and after the = sign
                                          self.conn = pyodbc.connect('Driver={SQL Server}; Server=mine1;database=logistics; Trusted_Connection=yes;')
                                          self.cursor = self.conn.cursor()
                                          print("Connected to database")
                                          self.msgBox.setText("Program connected to database")
                                          self.msgBox.exec_()
                                  
                                      except Exception as err:
                                          print("couldn't connect")
                                          print("General error :: ", err)
                                          self.conn.close()
                                          dlg = QDialog(self)
                                          dlg.setWindowTitle("ALERT!")
                                          dlg.setGeometry(100, 100, 200, 100)
                                          dlg.move(300, 300)
                                          bb = QPushButton("ERROR!", dlg)
                                          bb.move(30, 50)
                                          dlg.exec_()
                                  
                                  def retrieve1(self):
                                      try:
                                          self.db_connection()
                                          schbox = searchtxtab.text()  # to make the searchbox active, ensure it is coded close to the db connection.
                                          self.cursor.execute(
                                           " SELECT * FROM qTabTest WHERE fullname LIKE '%{}%' OR dept LIKE '%{}%' OR qual LIKE '%{}%' OR photo LIKE '%{}%' "
                                             .format(schbox, schbox, schbox, schbox))
                                          result = self.cursor.fetchall()
                                  
                                          for row_number, row_data in enumerate(result):
                                              self.tab.insertRow(row_number)
                                              for column_number, data in enumerate(row_data):
                                                  #self.tab.setItem(row_number, column_number, QTableWidgetItem(str(data)))
                                                  self.tab.setItem(row_number, column_number,QTableWidgetItem(data if column_number == 3 else str(data)))
                                                  #column 3 of the qtab is where the passport photo data is and I don't want it converted to string.
                                  
                                          print(self.cursor.rowcount, "row(s) affected")
                                          self.conn.commit()
                                          msgBox = QMessageBox()
                                          msgBox.setIcon(QMessageBox.Information)
                                          msgBox.setText("DATA RETRIEVED")
                                          msgBox.setWindowTitle("MESSAGE FROM DB")
                                          msgBox.exec_()
                                  
                                      except Exception as err:
                                          print(err)
                                          self.conn.close()
                                          dlg = QDialog(self)
                                          dlg.setWindowTitle("ALERT!")
                                          dlg.setGeometry(100, 100, 200, 200)
                                          dlg.move(300, 300)
                                          dlg.setGeometry(100, 100, 200, 100)
                                          bb = QPushButton("ERROR", dlg)
                                          bb.move(30, 50)
                                          dlg.exec_()
                                  
                                      self.show()
                                  
                                  def handle_selection_changed(self):
                                      rows = {
                                          index.row() for index in self.tab.selectionModel().selectedIndexes()
                                      }
                                      lines = []
                                      for row in rows:
                                          texts = []
                                          for j in range(self.tab.columnCount()):
                                              item = self.tab.item(row, j)
                                              text = "" if item is None else item.text()
                                              texts.append(text)
                                          line = " ".join(texts)
                                          lines.append(line)
                                      output = "\n".join(lines)
                                      self.displaytx.setText(output)
                                      self.appendSelection()
                                  
                                  def appendSelection(self):
                                      try:
                                          rows = {index.row() for index in self.tab.selectionModel().selectedIndexes()}
                                          lines = []
                                          itemList = []
                                  
                                          itemList.append(self.fulln)
                                          itemList.append(self.depttx)
                                  
                                          itemList.append(self.qualtx)
                                  
                                          itemList.append(self.passlbbtx)
                                  
                                  
                                         # itemList.append(self.passlb)
                                  
                                          for row in rows:
                                              for col in range(self.tab.columnCount()):
                                                  itemArray = self.tab.item(row, col)
                                                  text = "" if itemArray is None else itemArray.text()
                                                  if (col == 0):
                                                      itemList[0].setText(text)
                                                  if (col == 1):
                                                      itemList[1].setText(text)
                                                  if (col == 2):
                                                      itemList[2].setText(text)
                                                  if (col == 3):
                                                      itemList[3].setText(text)
                                  
                                  
                                      except Exception as err:
                                          print(err)
                                  
                                      print("This is passport bytes", self.passlbbtx.text())
                                  
                                  def clearData(self):
                                      self.tab.clearContents()
                                  

                                  if name == 'main':
                                  app = QApplication(sys.argv)
                                  window = userRecords()
                                  window.show()
                                  app.exec()

                                  
                                  
                                  
                                  Here is the database table created in Microsoft SQL.
                                  
                                                         CREATE TABLE qtabTest(
                                  	           fullname varchar(100),
                                  	            dept varchar(100),
                                  	           qual varchar(50),
                                  	          photo varbinary(max)
                                  )
                                  
                                   I use pyodbc to connect with my Python code
                                  1 Reply Last reply
                                  0
                                  • mrjjM Offline
                                    mrjjM Offline
                                    mrjj
                                    Lifetime Qt Champion
                                    wrote on last edited by
                                    #33

                                    Hi

                                    so in your opinion the line
                                    self.tab.setItem(row_number, column_number,QTableWidgetItem(data if column_number == 3 else str(data)))
                                    should make sure the binary stream of the image, is kept safe as we don't call str on it ?

                                    In c++ this would not work, but I don't know if python can do something magic.

                                    If you can't get it to function, then you could try storing the image stream in a user role. its kept as QVariant so might work.

                                    item = QTableWidgetItem("the text it should show")
                                    MyRole = QtCore.Qt.UserRole + 2
                                    item.setData(MyRole, data ) // data should be the real stream.

                                    then when you click on a row and want the image
                                    grab the item via one of the functions that directly gives it
                                    https://doc.qt.io/qtforpython-5/PySide2/QtWidgets/QTableWidget.html#PySide2.QtWidgets.PySide2.QtWidgets.QTableWidget.itemChanged

                                    and get the data back as
                                    data = item.data(MyRole)
                                    imgstrm = io.BytesIO(data)
                                    imgfile = Image.open(imgstrm)

                                    C 4 Replies Last reply
                                    1
                                    • mrjjM mrjj

                                      Hi

                                      so in your opinion the line
                                      self.tab.setItem(row_number, column_number,QTableWidgetItem(data if column_number == 3 else str(data)))
                                      should make sure the binary stream of the image, is kept safe as we don't call str on it ?

                                      In c++ this would not work, but I don't know if python can do something magic.

                                      If you can't get it to function, then you could try storing the image stream in a user role. its kept as QVariant so might work.

                                      item = QTableWidgetItem("the text it should show")
                                      MyRole = QtCore.Qt.UserRole + 2
                                      item.setData(MyRole, data ) // data should be the real stream.

                                      then when you click on a row and want the image
                                      grab the item via one of the functions that directly gives it
                                      https://doc.qt.io/qtforpython-5/PySide2/QtWidgets/QTableWidget.html#PySide2.QtWidgets.PySide2.QtWidgets.QTableWidget.itemChanged

                                      and get the data back as
                                      data = item.data(MyRole)
                                      imgstrm = io.BytesIO(data)
                                      imgfile = Image.open(imgstrm)

                                      C Offline
                                      C Offline
                                      CEO.
                                      wrote on last edited by
                                      #34

                                      @mrjj thanks for your follow-up, I discovered it made no difference. I'm talking about this line:

                                            self.tab.setItem(row_number, column_number,QTableWidgetItem(data if column_number == 3 else str(data)))
                                      

                                      The QTableWidgetItem is already in string, so whatever I print out from there would be in string. I tried it before.

                                      1 Reply Last reply
                                      0
                                      • mrjjM mrjj

                                        Hi

                                        so in your opinion the line
                                        self.tab.setItem(row_number, column_number,QTableWidgetItem(data if column_number == 3 else str(data)))
                                        should make sure the binary stream of the image, is kept safe as we don't call str on it ?

                                        In c++ this would not work, but I don't know if python can do something magic.

                                        If you can't get it to function, then you could try storing the image stream in a user role. its kept as QVariant so might work.

                                        item = QTableWidgetItem("the text it should show")
                                        MyRole = QtCore.Qt.UserRole + 2
                                        item.setData(MyRole, data ) // data should be the real stream.

                                        then when you click on a row and want the image
                                        grab the item via one of the functions that directly gives it
                                        https://doc.qt.io/qtforpython-5/PySide2/QtWidgets/QTableWidget.html#PySide2.QtWidgets.PySide2.QtWidgets.QTableWidget.itemChanged

                                        and get the data back as
                                        data = item.data(MyRole)
                                        imgstrm = io.BytesIO(data)
                                        imgfile = Image.open(imgstrm)

                                        C Offline
                                        C Offline
                                        CEO.
                                        wrote on last edited by
                                        #35

                                        @mrjj please have you done something like this before? If yes, I wouldn't mind having a study of it, I might get one or two ideas on how to manipulate it in Python.

                                        1 Reply Last reply
                                        0
                                        • mrjjM mrjj

                                          Hi

                                          so in your opinion the line
                                          self.tab.setItem(row_number, column_number,QTableWidgetItem(data if column_number == 3 else str(data)))
                                          should make sure the binary stream of the image, is kept safe as we don't call str on it ?

                                          In c++ this would not work, but I don't know if python can do something magic.

                                          If you can't get it to function, then you could try storing the image stream in a user role. its kept as QVariant so might work.

                                          item = QTableWidgetItem("the text it should show")
                                          MyRole = QtCore.Qt.UserRole + 2
                                          item.setData(MyRole, data ) // data should be the real stream.

                                          then when you click on a row and want the image
                                          grab the item via one of the functions that directly gives it
                                          https://doc.qt.io/qtforpython-5/PySide2/QtWidgets/QTableWidget.html#PySide2.QtWidgets.PySide2.QtWidgets.QTableWidget.itemChanged

                                          and get the data back as
                                          data = item.data(MyRole)
                                          imgstrm = io.BytesIO(data)
                                          imgfile = Image.open(imgstrm)

                                          C Offline
                                          C Offline
                                          CEO.
                                          wrote on last edited by
                                          #36

                                          @mrjj can you think over this line:

                                                       self.tab.setItem(row_number, column_number,QTableWidgetItem(data if column_number == 12 else str(data)))
                                          

                                          ...and how I can convert the data there to bytes right there?

                                          1 Reply Last reply
                                          0

                                          • Login

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • Users
                                          • Groups
                                          • Search
                                          • Get Qt Extensions
                                          • Unsolved