SQLite.dart

Future<void> save<T>(String type, int id, String field, T? value) async {
    if (value == null) {
      await customStatement(
        'DELETE FROM cache'
        ' WHERE id_type=\'$type\''
        '   AND id_object=$id'
        '   AND field=\'$field\'',
      );
    } else {
      String v;
      switch (value.runtimeType){
        case String: v = '\'$value\''; break;
        default: v = '$value';
      }
      await customStatement(
        'INSERT INTO cache (id_type,id_object,field,value) VALUES '
        '(\'$type\',$id,\'$field\',$v) '
        'ON CONFLICT DO UPDATE SET '
        'value=\'$value\'',
      );
    }