DatabaseReader class

Database reader and writer utility class

Constructors

DatabaseReader()

Properties

hashCode → int
The hash code for this object.
no setterinherited
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited

Methods

noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
toString() → String
A string representation of this object.
inherited

Operators

operator ==(Object other) → bool
The equality operator.
inherited

Static Methods

createConnection(String connectionString) → DatabaseConnection
Creates a database connection based on the connection string
readSql(String sql, String connectionString, {List? parameters}) → Future<DataFrame>
Convenience alias for readSqlQuery
readSqlQuery(String sql, String connectionString, {List? parameters}) → Future<DataFrame>
Reads SQL query results into a DataFrame (pandas-like read_sql_query)
readSqlTable(String tableName, String connectionString, {List<String>? columns, String? whereClause, int? limit, int? offset}) → Future<DataFrame>
Reads an entire SQL table into a DataFrame (pandas-like read_sql_table)
readTable(String tableName, String connectionString, {List<String>? columns, String? whereClause, int? limit}) → Future<DataFrame>
Convenience alias for readSqlTable