getSqlResult method

dynamic getSqlResult(
  1. dynamic strSql,
  2. dynamic context
)

Implementation

getSqlResult(strSql, context) {
  myLogAll('getSqlResult');
  if (isNull(strSql)) {
    return [];
  }
  strSql = getWhereFilter(strSql);
  myLog('getSqlResult $strSql');
  List fromS = strSql.toString().split(" from ");
  if (fromS.length < 2) {
    return [];
  }
  List whereS = fromS[1].toString().split(" where ");

  var tableName = whereS[0];
  var where = '';
  if (whereS.length > 1) {
    where = whereS[1];
  }
  //bool isExists = !fromS[0].toString().contains("not exists");
  dynamic result =
      getTableDataFromWhere(tableName, where, context, false, -1);
  return result;
}