Simple to use image handler for python sqlite3.
| Function Name | Parameters | Returns |
|---|---|---|
| init | databasePath : str tableName : str |
- |
| startConnection | - | - |
| imageSelector | path : str | bytesContent : bytes extensionType : str |
| addImage | imageName : str imageBytes : bytes extensionType : str |
- |
| getSaveImage | imageName : str savePath : str |
- |
| isImageExists | imageName : str | isExists : bool |
| deleteImage | imageName : str | - |
| updateImage | imageName : str newImageBytes : bytes newExtensionType : str |
- |
from SQLiteImageHandler.SQLiteImageHandler import ImageHandler
handler = ImageHandler(databasePath = "database.db", tableName = "myimages")handler.addImage(imageName = "Image 1", *handler.imageSelector(path = r"C:\Users\mozancetin\Desktop\myimage1.png"))# If you want, use a save name like "savedImage" instead of "savedImage.png"
# ..because whatever you write, it will automatically fetch the extension from the database.
handler.getSaveImage(imageName = "Image 1", savePath = r"C:\Users\mozancetin\Desktop\savedImage.png")handler.updateImage(imageName = "Image 1", *handler.imageSelector(path=r"C:\Users\mozancetin\Desktop\myimage2.png"))handler.deleteImage(imageName = "Image 1")isExists = handler.isImageExists(imageName = "Image 1")
print(isExists)bytesOfImage, extensionType = handler.imageSelector(path=r"C:\Users\mozancetin\Desktop\myimage1.png")
print("Bytes Length: " + str(len(bytesOfImage)) + "\nExtension Type: " + extensionType)- Sets the self.databasePath, self.tableName and calls startConnection() func.
- Starts the connection with SQLite Database.
- Selects an image and returns the image's bytes content and extension type.
- bytesContent[bytes]: Bytes content of image.
- extensionType[str]: Extension type like png, jpg or something...
- Adds an image to database.
- Saves the previously saved image in the database as an image to the given path.
- Checks if image exists in database by image name.
- isExists[bool]: True if image exists in the database otherwise False
- Deletes image by name in database.
updateImage(self, imageName : str = None, newImageBytes : bytes = None, newExtensionType : str = None) -> None
- Updates image by name in database.
C:\Users\mozancetin\Desktop\Handler>python SQLiteImageHandler
usage: SQLiteImageHandler [-h] [-v] [--database-path DBPATH] [--table-name TABLENAME] [-a] [-sn SAVE_NAME]
[-ip IMAGE_PATH] [-s] [-sdn SAVED_NAME] [-sp SAVE_PATH] [-u] [-in IMAGE_NAME]
[-uip UPDATE_IMAGE_PATH] [-d] [-c] [-is]
SQLite Image Handler.
optional arguments:
-h, --help show this help message and exit
-v, --version show program's version number and exit
--database-path DBPATH
database path.
--table-name TABLENAME
table name of the database
Add an Image:
Adding an image to the database.
-a, --add-image Adds an image to database. (Requires -sn and -ip)
-sn SAVE_NAME, --save-name SAVE_NAME
Save name of image.
-ip IMAGE_PATH, --image-path IMAGE_PATH
Path of the selected image
Save an Image:
Saving image from database to computer.
-s, --save-image Saves the previously saved image in the database as an image to the given path. (Requires -sdn
and -sp)
-sdn SAVED_NAME, --saved-name SAVED_NAME
Saved name of image in the database.
-sp SAVE_PATH, --save-path SAVE_PATH
Save path. (default: savedImage.png)
Update an Image:
Updating the image in the database.
-u, --update-image Updates image by name in database. (Requires -in and -uip)
-in IMAGE_NAME, --image-name IMAGE_NAME
Saved name of image in the database.
-uip UPDATE_IMAGE_PATH, --update-image-path UPDATE_IMAGE_PATH
Path of the selected image
Delete an Image:
Deleting an image from database
-d, --delete Deletes image by name in database. (Requires -in)
Other:
-c, --check Checks if image exists in database by image name. (Requires -in)
-is, --image-selector
Selects an image and returns the image's bytes length and extension type. (Requires -ip)- Write a readme file
- Add different types of images (Right now just png is supported)
- Add more explanation to functions
- Add deletePhoto, updatePhoto functions
- Raise some errors
- Add Usage to readme
- Upload to pypi
- Write a description of each function for README
- Add some cmd things