About using queries

• Types of queries

  • @Insert
  • @Update
  • @Delete
  • @Query

• Autocomplete is available for writing the queries using properties,parameters,entities

• Special highlighting for the id etc.

• Insert and Update have a special OnConflict strategy feature.

• Conflict strategy feature - > This happens when you try to insert the same data twice that might result in conflicts in the database. There are some ways to handle this using the conflict strategy feature.

  • Abort ----> This will stop the transaction.
  • Fail------> This fails the transaction.
  • Ignore----> This ignores the transaction.
  • Replace---> This replaces the old object with a new one.
  • Rollback--> This goes back to old data.

• We can combine the two DAO's in the repository using the two DAO's reference.