当前位置: 首页>>代码示例>>Python>>正文


Python Photo.load_from_tuple方法代码示例

本文整理汇总了Python中photo.Photo.load_from_tuple方法的典型用法代码示例。如果您正苦于以下问题:Python Photo.load_from_tuple方法的具体用法?Python Photo.load_from_tuple怎么用?Python Photo.load_from_tuple使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在photo.Photo的用法示例。


在下文中一共展示了Photo.load_from_tuple方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。

示例1: load_all_photos_by_likes

# 需要导入模块: from photo import Photo [as 别名]
# 或者: from photo.Photo import load_from_tuple [as 别名]
    def load_all_photos_by_likes(self, db, cursor, limit=10):
        sql = (
            "SELECT photos.id, photos.fb_id, photos.filename, photos.caption, \
           photos.owner_id, photos.state, photos.created_at, photos.approved_at, \
           likes_count.count \
           FROM photos \
           LEFT JOIN (SELECT photo_id, count(*) AS count FROM likes GROUP BY photo_id) AS likes_count \
           ON photos.id = likes_count.photo_id \
           ORDER BY likes_count.count DESC, \
           photos.approved_at DESC LIMIT %d"
            % limit
        )

        try:
            cursor.execute(sql)
            data = cursor.fetchall()

            for row in data:
                photo = Photo()
                photo.load_from_tuple(row)

                self.photos_list.append(photo)

            return self.photos_list
        except Exception, e:
            raise e
开发者ID:abhikandoi2000,项目名称:snaps-web-app,代码行数:28,代码来源:photolist.py

示例2: load_after

# 需要导入模块: from photo import Photo [as 别名]
# 或者: from photo.Photo import load_from_tuple [as 别名]
    def load_after(self, timestamp, limit, state, cursor):
        sql = "SELECT id, fb_id, filename, caption, owner_id, state, \
           created_at, approved_at \
           FROM photos \
           WHERE state = %s AND approved_at > %s \
           ORDER BY approved_at ASC LIMIT %s"

        try:
            cursor.execute(sql, (state, timestamp, limit))
            data = cursor.fetchall()

            for row in data:
                photo = Photo()
                photo.load_from_tuple(row)

                self.photos_list.append(photo)

            return self.photos_list
        except Exception, e:
            raise e
开发者ID:abhikandoi2000,项目名称:snaps-web-app,代码行数:22,代码来源:photolist.py

示例3: load_by_likes

# 需要导入模块: from photo import Photo [as 别名]
# 或者: from photo.Photo import load_from_tuple [as 别名]
    def load_by_likes(self, photo_id, db, cursor):
        # select photos where like < likes_for(photo_id)
        # union
        # select photos where like = likes_for(photo_id) and timestamp < timestamp_for(photo_id)
        curr_photo = Photo()
        curr_photo.load_from_db(photo_id, cursor)
        curr_photo_likes = curr_photo.like_count(db, cursor)
        curr_photo_approve_timestamp = curr_photo.get_dict()["approved_at"]

        sql = "SELECT photos.id, photos.fb_id, photos.filename, photos.caption, \
           photos.owner_id, photos.state, photos.created_at, photos.approved_at, \
           likes_count.count \
           FROM photos \
           LEFT JOIN (SELECT photo_id, count(*) AS count FROM likes GROUP BY photo_id) AS likes_count \
           ON photos.id = likes_count.photo_id \
           WHERE likes_count.count = %s \
           AND photos.approved_at < %s \
           \
           UNION \
           \
           SELECT photos.id, photos.fb_id, photos.filename, photos.caption, \
           photos.owner_id, photos.state, photos.created_at, photos.approved_at, \
           likes_count.count \
           FROM photos \
           LEFT JOIN (SELECT photo_id, count(*) AS count FROM likes GROUP BY photo_id) AS likes_count \
           ON photos.id = likes_count.photo_id \
           WHERE likes_count.count < %s"

        try:
            cursor.execute(sql, (curr_photo_likes, curr_photo_approve_timestamp, curr_photo_likes))
            data = cursor.fetchall()

            for row in data:
                photo = Photo()
                photo.load_from_tuple(row)

                self.photos_list.append(photo)

            return self.photos_list
        except Exception, e:
            raise e
开发者ID:abhikandoi2000,项目名称:snaps-web-app,代码行数:43,代码来源:photolist.py

示例4: load

# 需要导入模块: from photo import Photo [as 别名]
# 或者: from photo.Photo import load_from_tuple [as 别名]
    def load(self, offset, limit, state, cursor):
        sql = (
            "SELECT id, fb_id, filename, caption, owner_id, state, created_at \
           FROM photos \
           WHERE state = '%s' LIMIT %d OFFSET %d"
            % (state, limit, offset)
        )

        try:
            cursor.execute(sql)
            data = cursor.fetchall()

            for row in data:
                photo = Photo()
                photo.load_from_tuple(row)

                self.photos_list.append(photo)

            return self.photos_list
        except Exception, e:
            raise e
开发者ID:abhikandoi2000,项目名称:snaps-web-app,代码行数:23,代码来源:photolist.py


注:本文中的photo.Photo.load_from_tuple方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。