SQLiteConnection class

SQLite database connection implementation using sqlite3 package

Implemented types

Constructors

SQLiteConnection(String _connectionString)

Properties

connectionString → String
Gets the connection string (useful for debugging)
no setter
databaseType → String
Gets the database type (sqlite, postgresql, mysql)
no setteroverride
hashCode → int
The hash code for this object.
no setterinherited
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited

Methods

beginTransaction() → Future<DatabaseTransaction>
Begins a database transaction
override
close() → Future<void>
Closes the database connection
override
connect() → Future<void>
Connects to the SQLite database
execute(String sql, {List? parameters}) → Future<int>
Executes a SQL command (INSERT, UPDATE, DELETE) and returns affected rows
override
executeBatch(String sql, List<List> parametersList) → Future<List<int>>
Executes multiple SQL commands in a batch
override
isConnected() → Future<bool>
Tests if the connection is still active
override
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
query(String sql, {List? parameters}) → Future<DataFrame>
Executes a SQL query and returns a DataFrame
override
toString() → String
A string representation of this object.
inherited

Operators

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