package com.doumee.keyCabinet.dao;

import androidx.room.Dao;
import androidx.room.Delete;
import androidx.room.Insert;
import androidx.room.Query;
import androidx.room.Transaction;
import androidx.room.Update;

import java.util.List;
/**"SELECT user.id, user.name, user.departmentId," +
        "department.name AS departmentName FROM user " +
        "INNER JOIN department ON user.departmentId = department.id"*/

/**
 * 一对一
 * @Entity
    public class User {
        @PrimaryKey public long userId;
        public String name;
        public int age;
    }

     @Entity
     public class Library {
         @PrimaryKey public long libraryId;
         public long userOwnerId;
     }
 */
@Dao
public interface CabinetGridDao {

    @Transaction
    @Query("SELECT * FROM cabinet_grid")
    List<CabinetGridDo> loadAll();

    @Transaction
    @Query("SELECT * FROM cabinet_grid WHERE id = :id")
    CabinetGridDo getGridBuyId(int id);

    @Transaction
    @Query("SELECT * FROM cabinet_grid WHERE grid_key = :key")
    CabinetGridDo getGridByKey(String key);

    @Transaction
    @Query("SELECT * FROM cabinet_grid WHERE grid_key IN (:keys)")
    List<CabinetGridDo> getGridByKeys(List<String> keys);

    @Transaction
    @Query("SELECT * FROM cabinet_grid WHERE id = :id")
    List<CabinetGridDo> getGridsById(int id);

    @Transaction
    @Query("SELECT * FROM cabinet_grid WHERE id IN (:ids)")
    List<CabinetGridDo> getGridsByIds(int... ids);

/*
    @Transaction
    @Query("SELECT * FROM cabinet_grid WHERE cabinet_name = :name LIMIT 1")
    List<CabinetGridDo> getStudentByName(String name);

    @Transaction
    @Query("SELECT * FROM cabinet_grid WHERE cabinet_name LIKE '%' || :name || '%'")
    List<CabinetGridDo> searchStudentByName(String name);
*/

    @Transaction
    @Query("SELECT * FROM cabinet_grid WHERE is_open = :isOpen")
    List<CabinetGridDo> getGridByOpenStatus(int isOpen);

    @Transaction
    @Query("SELECT * FROM cabinet_grid WHERE is_open = 1 and working_status = 0 and grid_status = 0  and key_status !=3 order by grid_key asc")
    List<CabinetGridDo> getOpenGrids();

    @Transaction
    @Query("SELECT count(*) FROM cabinet_grid WHERE is_open = 1")
    int getOpenGridCount();

    @Transaction
    @Insert
    void insert(CabinetGridDo data);

    @Transaction
    @Insert
    void insertAll(CabinetGridDo... datas);

    @Transaction
    @Insert
    void insert(List<CabinetGridDo> studentLists);

    @Transaction
    @Update
    void update(CabinetGridDo... datas);

    @Transaction
    @Delete
    void delete(CabinetGridDo... datas);
}