def query_by_upc(upc): """Get a product from the database by upc. Should be only one so grab the first one from the query result. :param str upc: product upc. """ with app.app_context(): product = dbapi.productTable().search_by_upc(upc) return product
def query_price_range_search_db(manufacturer, price_low, price_high): """User can specify what items to lookup on Amazon from the database. User can choose manufacturer and a price range. Price range is optional. :param str manufacturer: the manufacturer to search for. :param float price_low: minimum price to search for :param float price_high: maximum price to search for """ with app.app_context(): if manufacturer: wildcard_manufacturer = '%' + manufacturer + '%' products = dbapi.productTable().search_by_price( price_low, price_high, wildcard_manufacturer) else: products = dbapi.productTable().search_by_price( price_low, price_high) return products
def query_price_range_search_db(manufacturer, price_low, price_high): """User can specify what items to lookup on Amazon from the database. User can choose manufacturer and a price range. Price range is optional. :param str manufacturer: the manufacturer to search for. :param float price_low: minimum price to search for :param float price_high: maximum price to search for """ with app.app_context(): if manufacturer: wildcard_manufacturer = '%' + manufacturer + '%' products = dbapi.productTable().search_by_price( price_low, price_high, wildcard_manufacturer ) else: products = dbapi.productTable().search_by_price( price_low, price_high ) return products