package safeluck.drive.evaluation.DB.route;

import androidx.lifecycle.LiveData;
import androidx.room.Dao;
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:41:55
 * 邮箱：632393724@qq.com
 * All Rights Saved! Chongqing AnYun Tech co. LTD
 */
@Dao
public interface RouteCrossDao {
    @Insert(onConflict = OnConflictStrategy.REPLACE)
    void insertRouteCross(RouteCross routeCross);
    @Query("SELECT * FROM RouteCross where routeline_id = :routeline_id")
    List<RouteCross> getAllRouteCross(int routeline_id);

    @Query("DELETE FROM RouteCross where routeline_id=:id")
    void deleteRouteCross(int id);

    @Query("UPDATE RouteCross SET active =:active where routeline_id=:id and road =:road and idx=:idx ")
    void updateRouteCrossActive(int id, int road, int idx,int active);
}