作者:搁浅几世琉璃 | 来源:互联网 | 2022-12-15 11:00
我一直在使用Room Persistence库,在我将其放入两个不同的插入项之前,它一直都很好用。
声音实体类
@Entity
public class Sound {
@PrimaryKey(autoGenerate = true)
private int sid;
@ColumnInfo(name = "sound_theme")
private int soundTheme;
@ColumnInfo(name = "sound_name")
private String soundName;
@ColumnInfo(name = "sound_resource")
private int soundResource;
@ColumnInfo(name = "sound_image_resource")
private int soundImageResource;
@ColumnInfo(name = "sound_favorite")
private boolean isFavorite;
@ColumnInfo
private int usedCount;
@ColumnInfo
private long lastUsed;
public Sound(int soundTheme, String soundName, int soundResource, int soundImageResource, boolean isFavorite, int usedCount, long lastUsed) {
this.soundTheme = soundTheme;
this.soundName = soundName;
this.soundResource = soundResource;
this.soundImageResource = soundImageResource;
this.isFavorite = isFavorite;
this.usedCount = usedCount;
this.lastUsed = lastUsed;
}
请注意,我有一个声音ID作为自动生成的主键。
声道
@Dao
public interface SoundDao {
@Query("SELECT * FROM sound")
List getAll();
@Query("SELECT * FROM sound WHERE sid IN (:soundIds)")
List loadAllByIds(int[] soundIds);
@Query("SELECT * FROM sound WHERE sound_name LIKE :name LIMIT 1")
Sound findByName(String name);
@Query("SELECT * FROM sound WHERE sid LIKE :id LIMIT 1")
Sound findById(int id);
@Insert
void insertAll(Sound... sounds);
@Insert
void insertAllArrList(ArrayList sounds);
@Delete
void delete(Sound sound);
@Query("DELETE FROM sound")
public void deleteAllSounds();
}
错误与以下行一起出现:
if (focusedSound.isFavorite())
favorites.soundDao().insertAll(focusedSound);
else favorites.soundDao().delete(selectedSound);
第一次插入效果很好(如果您在其中插入多个项目也可以),第二次插入会崩溃。我认为这与声音id(sid)的主键有关,但我不确定如何解决。
以下是一些错误日志:
06-03 20:03:36.454 8807-8807/com.zaid.green.soundpress E/InputEventReceiver:
Exception dispatching input event.
06-03 20:03:36.454 8807-8807/com.zaid.green.soundpress E/MessageQueue-JNI:
Exception in MessageQueue callback: handleReceiveCallback
06-03 20:03:36.460 8807-8807/com.zaid.green.soundpress E/MessageQueue-JNI:
android.database.sqlite.SQLiteConstraintException: UNIQUE constraint failed:
Sound.sid (code 1555)
SQLiteConnection at nativeExecuteForLastInsertedRowId(Native Method)
SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:782)
at
Pavneet_Sing..
5
是的,您是对的,问题出在主要约束和重复项被插入。
解决方案:OnConflictStratergy
在您的@intert
方法上定义为
@Insert(OnConflict= OnConflictStrategy.REPLACE)
void insertAll(Sound... sounds);
@Insert(OnConflict= OnConflictStrategy.REPLACE)
void insertAllArrList(ArrayList sounds);
如您所见,这会将新对象替换为旧对象
1> Pavneet_Sing..:
是的,您是对的,问题出在主要约束和重复项被插入。
解决方案:OnConflictStratergy
在您的@intert
方法上定义为
@Insert(OnConflict= OnConflictStrategy.REPLACE)
void insertAll(Sound... sounds);
@Insert(OnConflict= OnConflictStrategy.REPLACE)
void insertAllArrList(ArrayList sounds);
如您所见,这会将新对象替换为旧对象