readSqlTable static method

Future<DataFrame> readSqlTable(
  1. String tableName,
  2. String connectionString, {
  3. List<String>? columns,
  4. String? whereClause,
  5. int? limit,
  6. int? offset,
})

Reads an entire SQL table into a DataFrame (pandas-like read_sql_table)

Implementation

static Future<DataFrame> readSqlTable(
    String tableName, String connectionString,
    {List<String>? columns,
    String? whereClause,
    int? limit,
    int? offset}) async {
  final columnList = columns?.join(', ') ?? '*';
  String sql = 'SELECT $columnList FROM $tableName';

  if (whereClause != null) {
    sql += ' WHERE $whereClause';
  }

  if (limit != null) {
    sql += ' LIMIT $limit';
  }

  if (offset != null) {
    sql += ' OFFSET $offset';
  }

  return readSqlQuery(sql, connectionString);
}