Ejemplo n.º 1
0
  public void test_true() throws Exception {
    WallProvider provider = new SQLServerWallProvider();

    provider.getConfig().setSelectHavingAlwayTrueCheck(true);

    Assert.assertFalse(
        provider.checkValid( //
            "update t set fid = 1 where LEN(HOST_NAME()) > 0"));

    Assert.assertEquals(1, provider.getTableStats().size());
    Assert.assertTrue(provider.getTableStats().containsKey("t"));
  }
Ejemplo n.º 2
0
  public void test_false() throws Exception {
    WallProvider provider = new MySqlWallProvider();

    Assert.assertTrue(
        provider.checkValid( //
            "select temp.*, u.CanComment, u.CanBeShared, "
                + //
                "   u.CanForward, COALESCE(b.UserID,0) as isBlocked, "
                + //
                "   COALESCE(f.UserID,0) as Followed, COALESCE(ff.UserID,0) as IsFollowed, "
                + //
                "   COALESCE(ul.UserID,0) as liked, "
                + //
                "   COALESCE(fff.UserID,0) as RIsFollowed "
                + //
                "from "
                + "(select 281319 as UserID, 0  as RUserID, 7797549 as PicID "
                + //
                "   union all "
                + //
                "   select 55608 as UserID, 0  as RUserID, 7797527 as PicID "
                + //
                "   union all "
                + //
                "   select 281319 as UserID, 0  as RUserID, 7797233 as PicID "
                + //
                "   union all "
                + //
                "   select 281319 as UserID, 0  as RUserID, 7797221 as PicID "
                + //
                "   union all select 281319 as UserID, 0  as RUserID, 7797217 as PicID "
                + //
                "   union all select 281319 as UserID, 0  as RUserID, 7797189 as PicID "
                + //
                "   union all select 12271 as UserID, 0  as RUserID, 7796057 as PicID "
                + //
                "   union all select 401697 as UserID, 494381  as RUserID, 7795057 as PicID "
                + //
                "   union all select 401697 as UserID, 470693  as RUserID, 7795041 as PicID "
                + //
                "   union all select 401697 as UserID, 470693  as RUserID, 7795039 as PicID) temp     "
                + //
                "left join Users as u on u.UserID = temp.UserID   "
                + //
                "left join BlockUser as b on b.UserID = temp.UserID and b.BlockUserID = 281319 "
                + //
                "left join Fans as f on f.FansID = temp.UserID and f.UserID = 281319   "
                + //
                "left join Fans as ff ON ff.FansID = 281319 and ff.UserID = temp.UserID   "
                + //
                "left join Fans as fff ON fff.FansID = 281319 and fff.UserID = temp.RUserID   "
                + //
                "left join UserLikes as ul on ul.PicID = temp.PicID and ul.UserID = 281319"));

    Assert.assertEquals(4, provider.getTableStats().size());
  }
Ejemplo n.º 3
0
  public void test_true() throws Exception {
    WallProvider provider = new MySqlWallProvider();

    Assert.assertTrue(
        provider.checkValid( //
            "COMMIT")); //

    Assert.assertEquals(0, provider.getTableStats().size());
    System.out.println(JSONUtils.toJSONString(provider.getStatsMap()));
  }
Ejemplo n.º 4
0
  public void test_true() throws Exception {
    WallProvider provider = new MySqlWallProvider();

    provider.getConfig().setCommentAllow(true);

    Assert.assertTrue(
        provider.checkValid( //
            "select * from T/**/"));

    Assert.assertEquals(1, provider.getTableStats().size());
  }