def main(): if len(sys.argv) != 3: usage(sys.argv) config_uri = sys.argv[1] setup_logging(config_uri) settings = get_appsettings(config_uri) engine = engine_from_config(settings, 'sqlalchemy.') Session.configure(bind=engine) people = fetch_consent_data(sys.argv[2]) by_email = {} for user in people: email = user['email'] if email in by_email: if to_date(user) > by_email[email]: continue by_email[email] = to_date(user) matched = {} total = len(by_email) # Attempt to match by email for user in User.query_by().order_by(User.name).all(): if user.username in by_email: matched[user.username] = by_email[user.username] if not user.consent_at or \ by_email[user.username] < user.consent_at: print 'updating' user.consent_at = by_email[user.username] del by_email[user.username] transaction.commit() print('Matched {} out of {} ({} remaining)' .format(len(matched), total, len(by_email)))
def main(): if len(sys.argv) != 3: usage(sys.argv) config_uri = sys.argv[1] setup_logging(config_uri) settings = get_appsettings(config_uri) engine = engine_from_config(settings, 'sqlalchemy.') Session.configure(bind=engine) people = fetch_consent_data(sys.argv[2]) by_email = {} for user in people: email = user['email'] if email in by_email: if to_date(user) > by_email[email]: continue by_email[email] = to_date(user) matched = {} total = len(by_email) # Attempt to match by email for user in User.query_by().order_by(User.name).all(): if user.username in by_email: matched[user.username] = by_email[user.username] if not user.consent_at or \ by_email[user.username] < user.consent_at: print 'updating' user.consent_at = by_email[user.username] del by_email[user.username] transaction.commit() print('Matched {} out of {} ({} remaining)'.format(len(matched), total, len(by_email)))
def main(): if len(sys.argv) < 2: usage(sys.argv) config_uri = sys.argv[1] setup_logging(config_uri) settings = get_appsettings(config_uri) engine = engine_from_config(settings, 'sqlalchemy.') Session.configure(bind=engine) mailer = Mailer.from_settings(settings) ldap_conn = helper.connect() for line in sys.stdin: merge_to_umail(ldap_conn, mailer, *line.strip().split()) transaction.commit()
def main(): if len(sys.argv) < 2: usage(sys.argv) config_uri = sys.argv[1] setup_logging(config_uri) settings = get_appsettings(config_uri) engine = engine_from_config(settings, 'sqlalchemy.') Session.configure(bind=engine) #delete_unused_projects() #delete_inactive_classes() #delete_inactive_users() delete_unlinked_files(settings['file_directory']) if False: update_umail_users() match_to_umail()