def missingSmugMugSubCategoriesHTML(conn): rows = db.missingSmugMugSubCategories(conn) columns = ["SubCategory", "Category", "Category Id"] columnsclass = [None, None, "hidden"] if len(rows) == 0: return "" else: return webUtil.getTable(columns, rows, columnsclass)
def createMissingSubCategories(configobj, smugmug, lock): """ Will create any missing SubCategories on SmugMug that have been found locally, but not on SmugMug. """ myLogger.debug('createMissingSubCategories - parent process: %s process id: %s', os.getppid(), os.getpid()) conn = db.getConn(configobj) sync = datetime.now() subcategories = db.missingSmugMugSubCategories(conn) for subcategory in subcategories: result = smugmug.subcategories_create(Name=subcategory[0], CategoryID=subcategory[2]) id = result["SubCategory"]["id"] myLogger.debug("SubCategory created: '%s' and id '%s'", subcategory[0], id) lock.acquire() db.addUserSubCategory(conn,id,"",subcategory[0], subcategory[2]) db.insertSubCategoryLog(conn, id, subcategory[0],subcategory[1], sync) lock.release()