LibraFranca
LibraFranca
Programming language:Python
2021-06-26 08:24:50
0
Q:

how to read image from sql opencv

yibe
yibe
Code: Python
2021-07-04 19:27:23 
#I am reading an image in through cv2.imread() and cropping it (slicedImage). I want to save the result in a database as a blob.

originalImage = cv2.imread(self.imagePath.get())
    x1coord = int(self.x1.get())
    y1coord = int(self.y1.get())
    x2coord = int(self.x2.get())
    y2coord = int(self.y2.get())

    slicedImage = originalImage[x1coord:y1coord, x2coord:y2coord]
#How would I do this when this is my SQL statement?

sqlQuery = "UPDATE users SET UserImage="+slicedImage +", PointOfInterest1X=%d, PointOfInterest1Y=%d, " \
               "PointOfInterest2X=%d, PointOfInterest2Y=%d WHERE Email=%s"
    inputData = (slicedImage, x1, y1, x2, y2, prevEmail)
    mycursor.execute(sqlQuery, inputData)
0

Tags

New to Communities?

Join the community