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;

@Dao
public interface FingerPrintDao {

    @Transaction
    @Query("SELECT * FROM finger_print")
    List<FingerPrintDo> loadAll();

    @Transaction
    @Query("SELECT * FROM finger_print WHERE id = :id")
    FingerPrintDo getFingerById(int id);

    @Transaction
    @Query("SELECT * FROM finger_print WHERE member_id = :memberId")
    List<FingerPrintDo> getFingerByMemberId(int memberId);

    @Transaction
    @Query("SELECT * FROM finger_print WHERE finger_id = :fingerId")
    FingerPrintDo getByFingerId(int fingerId);

    @Transaction
    @Insert
    void insert(FingerPrintDo data);

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

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

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

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