Interface ISubscriptionsDAO

interface ISubscriptionsDAO {
    addSubscription(
        user_id: number,
        streamer_id: number,
    ): Promise<Subscription | null>;
    getRecentSubscriptionsByUser(
        user_id: number,
        limit: number,
    ): Promise<UserAsSubscriber[]>;
    getSubscriberDetails(
        subscriberId: number,
    ): Promise<UserAsSubscriberWithStreamer | null>;
    getSubscribersByStreamer(streamer_id: number): Promise<UserAsSubscriber[]>;
    getSubscribersPaginated(
        streamer_id: number,
        offset: number,
        limit: number,
    ): Promise<UserAsSubscriber[]>;
    getSubscriptionCountByStreamer(streamer_id: number): Promise<number>;
    getSubscriptionCountByUser(user_id: number): Promise<number>;
    getSubscriptionDetails(
        user_id: number,
        streamer_id: number,
    ): Promise<UserAsSubscriberWithStreamer | null>;
    getSubscriptionsByUser(user_id: number): Promise<UserAsSubscriber[]>;
    getSubscriptionsPaginated(
        user_id: number,
        offset: number,
        limit: number,
    ): Promise<UserAsSubscriber[]>;
    getTopStreamersBySubscribers(limit: number): Promise<TopStreamer[]>;
    removeAllSubscribersByStreamer(streamer_id: number): Promise<number>;
    removeAllSubscriptionsByUser(user_id: number): Promise<number>;
    removeSubscription(user_id: number, streamer_id: number): Promise<boolean>;
    subscriptionExists(user_id: number, streamer_id: number): Promise<boolean>;
}