def create_account(db_session, email_address, response): try: account = db_session.query(ImapAccount).filter_by( email_address=email_address).one() except sqlalchemy.orm.exc.NoResultFound: namespace = Namespace() account = ImapAccount(namespace=namespace) account.provider = 'Yahoo' account.provider_prefix = PROVIDER_PREFIX account.imap_host = IMAP_HOST account.email_address = response['email'] account.password = response['password'] account.date = datetime.datetime.utcnow() return account