execute method

  1. @override
Future<int> execute(
  1. String sql, {
  2. List? parameters,
})
override

Executes a SQL command (INSERT, UPDATE, DELETE) and returns affected rows

Implementation

@override
Future<int> execute(String sql, {List<dynamic>? parameters}) async {
  if (!_isConnected || _connection == null) {
    await connect();
  }

  try {
    final result = await _connection!.execute(sql);
    return result.affectedRows.toInt();
  } catch (e) {
    throw DatabaseQueryError('MySQL execute failed: $e');
  }
}