gistfile1.txt

package com.mwb.digitalstorage.database;

import com.mwb.digitalstorage.model.Shelf;
import com.mwb.digitalstorage.model.Storage;

import androidx.lifecycle.LiveData;
import androidx.room.Dao;
import androidx.room.Insert;
import androidx.room.Query;

import java.util.List;

@Dao
public interface DAO extends Storable {

    @Override
    void store();

    @Insert
    void insertStorage(Storage storage);

    @Insert
    void insertShelf(Shelf shelf);

    @Query("DELETE FROM storage_table")
    void deleteAll();

    @Query("SELECT * from storage_table ORDER BY storage_name ASC")
    LiveData<List<Storage>> getAllStorages();

    @Query("SELECT shelf_id, shelf_name, shelf_location from shelf_table " +
            "INNER JOIN storage_table " +
            "WHERE storage_table.storage_id == storage_id ORDER BY shelf_name ASC")
    LiveData<List<Storage>> getAllShefls();
}