from marshmallow import fields

from analytics.connectors.snowflake import AbstractSnowflakeQuery
from analytics.queries.schema import QueryWithPermissionsSchema


class MarketRanksQuerySchema(QueryWithPermissionsSchema):
    store_ids = fields.List(fields.Int, required=False, allow_none=True)


class MarketRanks(AbstractSnowflakeQuery):
    query_schema = MarketRanksQuerySchema
    filename = "market_ranks.sql"