insert method
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()));
}