SQLite Image Handler
Simple to use image handler for python sqlite3.
Functions
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 |
- |
Usage
-
Importing & Creating Handler
from SQLiteImageHandler import SQLiteImageHandler
handler = SQLiteImageHandler(databasePath = "database.db", tableName = "myimages")
-
Adding an image to the database
handler.addImage(imageName = "Image 1", *handler.imageSelector(path = r"C:\Users\mozancetin\Desktop\myimage1.png"))
-
Saving image from database to computer
# 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")ΓΌ
-
Updating the image in the database
handler.updateImage(imageName = "Image 1", *handler.imageSelector(path=r"C:\Users\mozancetin\Desktop\myimage2.png"))
-
Deleting an image from database
handler.deleteImage(imageName = "Image 1")
-
Check if image exists in the database
isExists = handler.isImageExists(imageName = "Image 1")
print(isExists)
-
Get bytes of image and extension type
bytesOfImage, extensionType = handler.imageSelector(path=r"C:\Users\mozancetin\Desktop\myimage1.png")
print("Bytes Length: " + str(len(bytesOfImage)) + "\nExtension Type: " + extensionType)
TODO's
- [x] Write a readme file
- [x] Add different types of images (Right now just png is supported)
- [x] Add more explanation to functions
- [x] Add deletePhoto, updatePhoto functions
- [x] Raise some errors
- [x] Add Usage to readme
- [ ] Upload to pypi
- [ ] Write a description of each function for README
- [ ] Add some cmd things