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)
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