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
