query method

@override Future<RawTableData> query(String sql, FieldData fieldData)

Implementation

@override
Future<RawTableData> query(String sql, FieldData fieldData) async {
  List<List<Object?>> rowList = [];
  try {
    ResultSet rs = _db.select(sql);
    List<List<Object?>> rawQueryList = rs.rows;
    rawQueryList.forEach((List<Object?> list) {
      List<Object?> fieldList = [];
      list.forEach((value) {
        fieldList.add(value);
      });
      rowList.add(fieldList);
    });
    return RawTableData(
        fieldData.table_id, rowList, fieldData.getFieldNameList);
  } catch (e) {
    print(e);
    throw SqlException(SqlExceptionEnum.SQL_SYNTAX_ERROR,
        cause: e.toString());
  }
}