def check_user_key(api_key, context): try: session = SESSION() api_key = session.query(ApiKey).filter_by(api_key=api_key).one() logger.debug("Authenticated user with key: %s" % api_key) user = api_key.user session.close() return user except MultipleResultsFound: traceback.print_exc() logger.critical("Impossible") except NoResultFound: logger.debug("Cannot authenticate user with key: %s" % api_key) return False
def get_users(input_item_id): user_emails = [] wishlists = SESSION.query(Wishlist).filter_by(item_id=input_item_id).all() for wishlist in wishlists: user_emails.append(wishlist.user.email) print wishlist.user.email return user_emails
def checker(): f = open("somefile.txt", "w") for item in SESSION.query(Item).order_by(Item.id): price_list =[] website = SESSION.query(Website).filter_by(hostname=item.host_url).first() prices = scrapedoc.price_check(item.url, website.price_class) for price in prices: this_price = price.split('$').replace(",", "") item_price = item.price.split('$') if float(this_price[1]) < float(item_price[1]): item.price = price user_emails = get_users(item.id) for users in user_emails: email_price(users, price, item.url) price_list.append(price) f.write(str(price_list)) f.close() SESSION.commit()
def session(context_name='session', request=None, **kwargs): """Returns the session associated with the current request""" return SESSION()
def unload(exception = None): db_session.remove()