問題描述
我正在使用 PyOpenCV.如何在沒有臨時文件和 imwrite 的情況下將 cv2 圖像(numpy)轉換為二進制字符串以寫入 MySQL db?
I'm working with PyOpenCV. How to convert cv2 image (numpy) to binary string for writing to MySQL db without a temporary file and imwrite?
我用谷歌搜索了它，但什么也沒找到......
I googled it but found nothing...
我正在嘗試 imencode，但它不起作用.
I'm trying imencode, but it doesn't work.
capture = cv2.VideoCapture(url.path)
capture.set(cv2.cv.CV_CAP_PROP_POS_MSEC, float(url.query))
self.wfile.write(cv2.imencode('png', capture.read()))
錯誤:
File "server.py", line 16, in do_GET
self.wfile.write(cv2.imencode('png', capture.read()))
TypeError: img is not a numerical tuple
幫助別人！
推薦答案
如果你有一個圖像 img(這是一個 numpy 數組)，你可以使用以下方法將其轉換為字符串:
If you have an image img (which is a numpy array) you can convert it into string using:
>>> img_str = cv2.imencode('.jpg', img)[1].tostring()
>>> type(img_str)
'str'
現在您可以輕松地將圖像存儲在數據庫中，然后使用以下方法恢復它:
Now you can easily store the image inside your database, and then recover it by using:
>>> nparr = np.fromstring(STRING_FROM_DATABASE, np.uint8)
>>> img = cv2.imdecode(nparr, cv2.CV_LOAD_IMAGE_COLOR)
您需要將 STRING_FROM_DATABASE 替換為包含對包含圖像的數據庫的查詢結果的變量.
where you need to replace STRING_FROM_DATABASE with the variable that contains the result of your query to the database containing the image.
這篇關于Python OpenCV將圖像轉換為字節字符串?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！