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 createMissingAlbums(configobj, smugmug, lock): """ Will create any albums on SmugMug that have been found locally, but not on SmugMug. Currently uses the SmugMug defaults for the album properties. """ myLogger.debug('createMissingAlbums - parent process: %s process id: %s', os.getppid(), os.getpid()) conn = db.getConn(configobj) sync = datetime.now() albums = db.missingSmugMugAlbums(conn) for album in albums: if album[2] == None: #no category or subcategory result = smugmug.albums_create(Title=album[0]) elif album[4] == None: # category but no subcategory result = smugmug.albums_create(Title=album[0], CategoryID=album[2]) else: #has category and subcategory result = smugmug.albums_create(Title=album[0], CategoryID=album[2],SubCategoryID=album[4]) id = result["Album"]["id"] key = result["Album"]["Key"] myLogger.debug("Album created: '%s' and id '%s' and key '%s'", album[0], id, key) lock.acquire() db.addSmugAlbum(conn,album[1], album[2], album[3], album[4], album[0], sync, key, id) db.insertAlbumLog(conn, id, album[0], album[1], album[3], sync) lock.release()