Storing Imagehash in mysql database

634 Views Asked by At

I am trying to save hash_value in mysql database using python. I have obtained hash value hash = imagehash.dhash(Image.open('temp_face.jpg')) but after the execution of insert query cursor.execute("INSERT INTO image(hash,name,photo) VALUES(%d,%s,%s )", (hash,name, binary_image))it gives me error "Python 'imagehash' cannot be converted to a MySQL type".

| Field   | Type        | Null | Key | Default           | Extra             |
+---------+-------------+------+-----+-------------------+-------------------+
| hash    | binary(32)  | NO   | PRI | NULL              |                   |
| name    | varchar(25) | NO   |     | NULL              |                   |
| photo   | blob        | NO   |     | NULL              |                   |
| arrival | datetime    | NO   |     | CURRENT_TIMESTAMP | DEFAULT_GENERATED |
+---------+-------------+------+-----+-------------------+-------------------+

So what can be done to store the value or is there any other way to do the same task?

0

There are 0 best solutions below