insert method

Future<DbResponse> insert({
  1. required List values,
  2. List<String>? columns,
})

Implementation

Future<DbResponse> insert({
  required List values,
  List<String>? columns,
}) async {
  // ignore: no_leading_underscores_for_local_identifiers
  List<String> _values = values.map((e) {
    if (e is String) {
      return "'$e'";
    } else if (e is List) {
      return "'${_listValue(e)}'";
    } else {
      return e.toString();
    }
  }).toList();
  String query =
      'INSERT INTO  "$tableName" ${columns == null ? "" : "(${columns.map((val) => '"$val"').join(',')})"} VALUES (${_values.join(",")})';
  var dbRes = await db.query(query);

  return DbResponse(
      dbRes.columnDescriptions.map((e) => e.columnName).toList(),
      List<List>.from(dbRes.toList()));
}