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()
