getRelation static method

dynamic getRelation({ Function? withFunction, })

Implementation

static getRelation({Function? withFunction}) async {
  currentForeignKey = null;
  loading.refresh((listener) => listener.value = true);
  await replacedFunction(
    StackFunction(
      id: 2,
      function: () async {
        listOtherRelation = [];
        final getDataForeign = await DB.table('_sql_query_foreign_key').where('name_table', '=', selectedTable?.tableName).get();
        for (var i in getDataForeign) {
          currentForeignKey = ForeignKey(
            baseColumn: i['name_column'],
            referenceTable: i['name_table_target'],
            referenceColumn: i['name_column_target'],
            deleteAction: ForeignKey.parseAction(i['on_delete']),
            updateAction: ForeignKey.parseAction(i['on_update']),
          );
        }
        final getDataOtherForeign = await DB.table('_sql_query_foreign_key').where('name_table_target', '=', selectedTable!.tableName).get();
        for (var i in getDataOtherForeign) {
          listOtherRelation.add(ForeignKey(
            baseColumn: i['name_column'],
            referenceTable: i['name_table_target'],
            baseTable: i['name_table'],
            referenceColumn: i['name_column_target'],
            deleteAction: ForeignKey.parseAction(i['on_delete']),
            updateAction: ForeignKey.parseAction(i['on_update']),
          ));
        }
        dataTable.refresh((listener) => null);
        if (withFunction != null) {
          withFunction();
        }
        loading.refresh((listener) => listener.value = false);
      },
    ),
  );
}