change dynamically db connection per Model

[mortenko]

Let say I have model
const Theme = use('App/Models/Theme');

When I'm performing query on it I would like to define also db connection on model:

const themes = await Theme.connection('pg').query()
              .select(...)
              .innerJoin(...)
              .where(...)
              .distinct(...)
              .orderBy(...)
              .fetch();

I know that is not possible now...I have to use Database provider but anyway shouldn't be added in some later version of adonis ...maybe... ?

[tsulatsitamim]

you can use this

const themes = await Theme.query({connection: 'pg'})
              .select(...)
              .innerJoin(...)
              .where(...)
              .distinct(...)
              .orderBy(...)
              .fetch();