pgSqlToDataset function

Dataset pgSqlToDataset(
  1. PostgreSQLResult pg
)

Implementation

Dataset pgSqlToDataset(PostgreSQLResult pg) {
  var ds = Dataset();
  var fieldDescription = pg.columnDescriptions;
  fieldDescription.forEach((element) {
    ds.structure.addAll({element.columnName: getFieldType(element)});
  });

  var i = -1;

  for (final row in pg) {
    ds.newRecord();
    i = -1;
    fieldDescription.forEach((element) {
      i++;
      ds.trySetValue(element.columnName, row[i]);
    });
  }
  ds.first();
  return ds;
}