Esempio n. 1
0
    def search(q):
        """
        Implement search method with SQLAlchemy
        """

        # Prepare query
        watches = session.query(Watch)

        if q:
            like_q = '%' + str(q) + '%'
        else:
            # Match nothing, return 0 results
            like_q = ''

        # Perform search
        results = watches.filter(
            or_(
                Watch.title.ilike(like_q),
                Watch.short_description.ilike(like_q),
                Watch.long_description.ilike(like_q),
                Watch.stk.ilike(like_q),
            )
        )

        # Make results serializable
        results = map(lambda r: r.as_dict(), results)

        return {
            'count': len(results),
            'results': results
        }
Esempio n. 2
0
    def get(self):
        feed = AtomFeed(
            'Recently Added Watches - Wanna Buy A Watch',
            feed_url=request.url,
            url=request.url_root
        )

        # Prepare query
        watches = session.query(Watch)

        # TODO: .limit(15) and date_added
        watches = watches.order_by(Watch.title).all()

        for watch in watches:
            feed.add(
                watch.title,
                unicode(watch.long_description),
                content_type='html',
                author='wbaw',
                url=BASE_URL + '/' + watch.page_url + '?src=wbawsearch',

                # TODO: Add updated and published
                updated=datetime.now(),
                published=datetime.now()
            )

        return feed.get_response()
Esempio n. 3
0
    def get(self, id=None):
        # Prepare query
        watches = session.query(Watch)

        if id:
            # Return the specific watch
            results = watches.get(id)

            # Make results serializable
            results = results.as_dict() if results else {}
        else:
            # Return them all
            results = watches.order_by(Watch.pk).all()

            results = {
                'count': len(results),
                'results': map(lambda r: r.as_dict(), results)
            }

        return jsonify(results)
Esempio n. 4
0
    def get(self):
        feed = RssFeed(
            title='Recently Added Watches - Wanna Buy A Watch',
            link=request.url,
            description='Recently Added Watches - Wanna Buy A Watch',
            author="wbaw"
        )

        # Prepare query
        watches = session.query(Watch)

        # TODO: .limit(15) and date_added
        watches = watches.order_by(Watch.title).all()

        for watch in watches:
            feed.add(
                title=watch.title,
                link=BASE_URL + '/' + watch.page_url + '?src=wbawsearch',
                description=unicode(watch.long_description),
            )

        return feed.get_response()