Example #1
0
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)
Example #2
0
def missingSmugMugCategoriesHTML(conn):
    rows = db.missingSmugMugCategories(conn)
    columns = ["Category"]
    if len(rows) == 0:
        return ""
    else:
        return webUtil.getTable(columns, rows)
Example #3
0
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)
Example #4
0
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)
Example #5
0
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)
Example #6
0
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)
Example #7
0
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)
Example #8
0
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)
Example #9
0
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)