在房间持久性库Android Studio中插入后获得RowID

Question

我一直在使用codelabs实现我的房间数据库持久化。现在，在将数据插入房间数据库后，我正在尝试获取最新的rowID。但是，我被困在存储库中，试图从异步任务返回rowID。

LogEntity.java

@Entity
public class LogEntity {
    @PrimaryKey(autoGenerate = true)
    private int id;

洛格道。JAVA

public interface LogDao {
    @Insert
    long insert(LogEntity logEntity);

日志数据库。JAVA

@Database(entities = LogEntity.class, version = 1)
public abstract class LogDatabase extends RoomDatabase {

    private static LogDatabase instance;
    public abstract  LogDao logDao();

    public static synchronized LogDatabase getInstance(Context context){
        if (instance == null){
            instance = Room.databaseBuilder(context.getApplicationContext(),
                    LogDatabase.class, "log_database").
                    fallbackToDestructiveMigration().build();
        }
        return instance;
    }
}

日志存储库。JAVA

    public long insertLogs(LogEntity logEntity) {
        new InsertLogAsyncTask(logDao).execute(logEntity);
        return **
    }
    private static class InsertLogAsyncTask extends AsyncTask<LogEntity, Void, Long>{
        private LogDao logDao;
        private InsertLogAsyncTask(LogDao logDao){
            this.logDao = logDao;
        }
        @Override
        protected Long doInBackground(LogEntity... logEntities) {
            logDao.insert(logEntities[0]);
            return logDao.insert(logEntities[0]);
        }
    }

我放了两个星号，因为我不确定在这里要做什么来获取insert RowID，以及我的AsyncTask是否完全正确。

LogViewModel。JAVA

    public long insertLog(LogEntity logEntity){
        return repository.insertLogs(logEntity);
    }

主要活动。JAVA

        long id = logViewModel.insertLog(logEntity);

我希望能够使用这个最终的id变量供将来使用。

Answer 1

你在正确的轨道上，但并不完全正确。您应该将AsyncTask类声明为ViewModel的内部类，而不是DB。

在ViewModel中添加一个ID变量，在AsyncWG中添加onPostExecute重写来处理执行结果。

LogViewModel。JAVA

long mLastInsertedID;

private static class InsertLogAsyncTask extends AsyncTask<LogEntity, Void, Long>{
    private LogDao logDao;
    private InsertLogAsyncTask(LogDao logDao){
        this.logDao = logDao;
    }
    @Override
    protected Long doInBackground(LogEntity... logEntities) {
        //you are now off the UI thread
        logDao.insert(logEntities[0]);
        return logDao.insert(logEntities[0]);
    }

    @Override
    protected void onPostExecute(Long result) {
        //Do whatever you like with the result as you are back on the UI thread
        mLastInsertedID = result;
    }
}