package safeluck.drive.evaluation.DB.route;

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

import java.util.List;

/**
 * DriveJudge
 * Created by lzw on 2020/9/16. 15:49:36
 * 邮箱：632393724@qq.com
 * All Rights Saved! Chongqing AnYun Tech co. LTD
 */
@Dao
public interface RouteBeanDao {
    @Query("SELECT * FROM RouteBean")
    LiveData<List<RouteBean>> getAllRoutes();
    @Query("SELECT * FROM RouteBean where currentCollectFlag=1")
    RouteBean getCurrRouteBean();

    //更新整张表的 采集标志

    @Query("UPDATE RouteBean SET currentCollectFlag=0 ")
    void setCurrtentNotCollectFlag();

    //更新某个id的采集标志

    @Query("UPDATE RouteBean SET currentCollectFlag=1 where routeName=:name ")
    void setCurrtentFlagWithName(String name);

    @Insert(onConflict = OnConflictStrategy.REPLACE)
    void insertRouteBean(RouteBean routeBean);

    @Delete
    void deleteRouteBean(RouteBean item);
}