title: Room - insert or replace, but keep a database field?
body: <p>I have in my local database a table called event with the fields:</p>
  
  <ul>
  <li>id (PK)</li>
  <li>name (text)</li>
  <li>date (time)</li>
  <li>favorite (int, 0 or 1)</li>
  </ul>
  
  <p>The server would give me a list of events, without the favorite field, the favorite field is only local.</p>
  
  <p>I'm using this code to insert events</p>
  
  <pre><code>@Insert(onConflict = OnConflictStrategy.REPLACE)
  void insertEvents(List&lt;Event&gt; events);
  </code></pre>
  
  <p>The thing is that, if an event is already stored in the local database, it will loose the favorite property, and it will always be false after is inserted and replaced.</p>
  
  <p>Is there a way to bulk insert like this, but keep the favorite field?</p>