def findDuplicateSmugMugImageHtml(conn):
"""
list duplicate files found in a SmugMug album.
"""
rows = db.findDuplicateSmugMugImage(conn)
columns = ["First Filename","Second Filename","Album","SubCategory","Category"]
return webUtil.getTable(columns, rows)
def missingSmugMugCategoriesHTML(conn):
rows = db.missingSmugMugCategories(conn)
columns = ["Category"]
if len(rows) == 0:
return ""
else:
return webUtil.getTable(columns, rows)
def missingImagesHTML(conn):
rows = db.findMissingPictures(conn)
columns = ["Album", "Need Upload", "Need Download"]
columnsclass = [None, None, None]
if len(rows) == 0:
return ""
else:
return webUtil.getTable(columns, rows, columnsclass)
def missingSmugMugAlbumsHTML(conn):
rows = db.missingSmugMugAlbums(conn)
columns = ["Album", "Category", "Category Id", "SubCategory", "SubCategory Id"]
columnsclass = [None, None, "hidden", None, "hidden"]
if len(rows) == 0:
return ""
else:
return webUtil.getTable(columns, rows, columnsclass)
def findImagesinDbNotScannedThisRunHtml(conn):
"""
Finds the images that where found on previous scans that was not
found in the latest scan.
"""
rows = db.findImagesinDbNotScannedThisRun(conn)
columns = ["Last Scanned On","Filename","Album","SubCategory","Category"]
return webUtil.getTable(columns, rows)
def findMissingPicturesHtml(conn):
"""
list by album show the number of images that are not in both. This will
only include albums that are in both
"""
rows = db.findMissingPictures(conn)
columns = ["Album","Need Upload","Need Download"]
return webUtil.getTable(columns, rows)
def findMissingSmugMugAlbumsHtml(conn):
"""
list of albums that are found local but not found on smug mug. This would
exclude albums that are local but under different category and sub-category
"""
rows = db.findMissingSmugMugAlbums(conn)
columns = ["Local Category","Local SubCategory","Local Album","# of Images"]
return webUtil.getTable(columns, rows)
def findMisatchedFilenamesHtml(conn):
"""
list of local images that have the same md5sum as an image in smug mug, but they
have different filenames.
"""
rows = db.findMisatchedFilenames(conn)
columns = ["Local File Name","SmugMug File Name","Local Category","Local SubCategory","Local Album"]
return webUtil.getTable(columns, rows)
def findMismatchedCategoriesHtml(conn):
"""
list of albums by name that exist both locally and on smug mug that have
different category and/or sub-category.
"""
rows = db.findMismatchedCategories(conn)
columns = ["Album Name","Local Category","Local SubCategory","SmugMug Category","SmugMug SubCategory"]
return webUtil.getTable(columns, rows)