Ejemplo n.º 1
0
    def prepare(self):
        self.db = FSpotDB()
        self.period = self.options.get('period')

        if self.db:
            self.sql = FSpotPhotoSQL(self.target, self.period)
            self.photos = self.rate_list = RateList(self, FSpotDB)
Ejemplo n.º 2
0
    def _get_sql_obj(self, photo):
        version = photo.get('version')

        if version == 1:
            sql_templates = [
                "DELETE FROM photo_tags WHERE photo_id=$id;",
                "DELETE FROM photo_versions WHERE photo_id=$id;",
                "DELETE FROM photos WHERE id=$id;",
                "DELETE FROM exports WHERE image_id=$id;"
            ]
        else:
            sql_templates = [
                "DELETE FROM photo_versions "
                "WHERE photo_id=$id AND version_id=$version;",
                "Update photos SET default_version_id=1 WHERE id=$id;"
            ]

        db = FSpotDB()
        return db, sql_templates