Filters

[Rafael Felini]

Hi guys, I'm evaluating ActiveJDBC for a new project and I have a doubt.

How can I configure a default filter (more than one) for some models?

To be exactly it is a SaaS and I need multi tenancy, I have one database for all customers with a column discriminator.

Another use case is to filter all models with date deleted not null.

I think in rails this feature is called scopes and in hibernate is filters, so what is the equivalent in ActiveJDBC?

Thanks,

Rafael

[Igor Polevoy]

Hi, Rafael. 

Such feature is not present  in ActiveJDBC. It is typical in AJ to write a wrapper method: 

class MyClass extends Model{

    public static List<MyClass> deletedWhere( String additionalQuery){ 

          where( "date_deleted = NULL and " + additionalQuery) ;

    }

}

The only inconvenience is that you will have to repeat this for each class model, since the methods are static. 

tx

[Rafael Felini]

Hi Igor, thanks for the response, your insight give some ideas to deal with it.

Thanks

[Igor Polevoy]

glad I could help. enjoy