belongsToMany method

DBHelper belongsToMany(
  1. String relatedTable,
  2. String pivotTable, {
  3. required String tableId,
  4. required String relatedId,
})

Add a belongsToMany relationship

Implementation

DBHelper belongsToMany(String relatedTable, String pivotTable,
    {required String tableId, required String relatedId}) {
  _query = "SELECT $table.*,$relatedTable.* FROM $table "
      "INNER JOIN $pivotTable ON $pivotTable.$tableId=$table.id "
      "INNER JOIN $relatedTable ON $relatedTable.id =$pivotTable.$relatedId";
  return this;
}