product.service.ts - supabase base service implementation

product.service.ts

import { Injectable } from '@angular/core'
import { BaseService } from '@core/services/base.service'
import { SupabaseService } from '@core/services/supabase.service'
import { Product } from '@features/products/types/product'

const TABLE_PRODUCT = 'products'

@Injectable({
    providedIn: 'root',
})
export class ProductService extends BaseService<Product> {
    constructor(protected supabaseService: SupabaseService) {
        super(supabaseService, TABLE_PRODUCT)
    }
    
    // a custom method
    findByCategory(categoryId: number, range = [0, 10]): Observable<Product[]> {
        const filters: FindFilter[] = [['category_id', 'eq', categoryId]]
        const select = '*,category:categories(*)' // select all columns from product, populate category
        const orderBy: FindOrder[] = ['published', false]
        const query = this.find(filters, select, range, orderBy)
        
        return this.returnList(query)
    }
}