package dao;
import model.Bet;
import java.sql.ResultSet;

public class BetImplDao extends AbstractImplDao<Bet> {
    @Override
    public String getTable(){
        return Bet.TABLE_NAME;
    }

    @Override
    public String updateQuery(Bet bet) { return "UPDATE "+ getTable() +" SET "+Bet.ID_COLUMN+" = "+ bet.getId() + " , "+Bet.MATCH_ID_COLUMN+" = "+ bet.getMatch().getId() +" , "+Bet.USER_ID_COLUMN+" = "+ bet.getUser().getId() +" , "+Bet.SUM_BETS_COLUMN+" = "+ bet.getSum() +" WHERE "+Bet.MATCH_ID_COLUMN+" = " + bet.getMatch().getId() + " AND " + Bet.USER_ID_COLUMN + " = " + bet.getUser().getId(); }

    @Override
    public String createQuery(Bet bet) { return "INSERT INTO "+ getTable() +"("+Bet.MATCH_ID_COLUMN+" , "+Bet.USER_ID_COLUMN+" , "+Bet.SUM_BETS_COLUMN+") VALUES ("+bet.getId()+","+bet.getMatch().getId()+","+bet.getUser().getId()+","+bet.getSum()+ ")"; }

    @Override
    public Bet getResult(ResultSet resultSet){
        return null;
    }
}