insertOrIgnore method

@override Future<bool> insertOrIgnore(Map<String, dynamic> values)

Implementation

@override
Future<bool> insertOrIgnore(
  Map<String, dynamic> values,
) async {
  try {
    if (values.isEmpty) {
      throw InvalidArgumentException(
        "Values map cannot be empty for insertOrIgnore operation.",
      );
    }
    conn = await getConnection();
    final columns = values.keys.toList();
    final paramBindings = <String, dynamic>{};
    final placeholders = values.keys.map((key) {
      final paramName = _nextParamName();
      paramBindings[paramName] = values[key];
      return ":$paramName";
    }).join(", ");

    final query =
        "INSERT IGNORE INTO $getTable (${columns.join(', ')}) VALUES ($placeholders)";
    await conn.execute(query, paramBindings);
    return true;
  } catch (e) {
    rethrow;
  }
}