from flask_sqlalchemy import BaseQuery
from sqlalchemy import desc
from sqlalchemy.orm import aliased

from core_notifications import models


class ImageQuery(BaseQuery):
    CREATED_ALIAS = aliased(models.DNAAccount, name="created")

    def desc(self):
        return self.order_by(desc(models.Image.id))

    def with_relations(self):
        return self.join(
            self.CREATED_ALIAS,
            models.Image.created_by_id == self.CREATED_ALIAS.id,
            isouter=True,
        )