Exemplo n.º 1
0
        public void Place2()
        {
            SqlExpr e;

            //
            // Expr演算子の結合の優先順位が適用前後で変わらないことを確認する
            //

            e = new SqlExpr("@PH");
            e.Place("PH", "~a");
            Assert.That(e.ToString(), Is.EqualTo("~a"));

            e = new SqlExpr("@PH");
            e.Place("PH", "a+b");
            Assert.That(e.ToString(), Is.EqualTo("a+b"));

            e = new SqlExpr("~@PH");
            e.Place("PH", "~a");
            Assert.That(e.ToString(), Is.EqualTo("~~a"));

            e = new SqlExpr("~@PH");
            e.Place("PH", "a+b");
            Assert.That(e.ToString(), Is.EqualTo("~(a+b)"));

            e = new SqlExpr("@PH || 'abc'");
            e.Place("PH", "~a");
            Assert.That(e.ToString(), Is.EqualTo("~a||'abc'"));

            e = new SqlExpr("@PH || 'abc'");
            e.Place("PH", "a+b");
            Assert.That(e.ToString(), Is.EqualTo("(a+b)||'abc'"));
        }
Exemplo n.º 2
0
        public void HasUnplacedHolders()
        {
            SqlExpr e;

            e = new SqlExpr("@PH");
            Assert.That(e.HasUnplacedHolders(), Is.True);
            e.Place("PH", "'abc'");
            Assert.That(e.HasUnplacedHolders(), Is.False);

            e = new SqlExpr("@PH1 + @PH2");
            e.Place("PH1", "+100");
            Assert.That(e.HasUnplacedHolders(), Is.True);
            e.Place("PH2", "-9");
            Assert.That(e.HasUnplacedHolders(), Is.False);

            e = new SqlExpr("@PH || @PH");
            e.Place("PH", "'abc'");
            Assert.That(e.HasUnplacedHolders(), Is.False);
            e.Place("PH", "'abc'");
            Assert.That(e.HasUnplacedHolders(), Is.False);
        }
Exemplo n.º 3
0
        public void GetAllPlaceHolders()
        {
            SqlExpr e;

            e = new SqlExpr("@PH");
            Assert.That(e.GetAllPlaceHolders()
                        , Is.EqualTo(new Dictionary <string, string> {
                { "PH", "" }
            }));
            e.Place("PH", "'abc'");
            Assert.That(e.GetAllPlaceHolders()
                        , Is.EqualTo(new Dictionary <string, string> {
                { "PH", "'abc'" }
            }));

            e = new SqlExpr("@PH1 + @PH2");
            e.Place("PH1", "+100");
            Assert.That(e.GetAllPlaceHolders(), Is.EqualTo(new Dictionary <string, string>
            {
                { "PH1", "+100" }, { "PH2", "" }
            }));
            e.Place("PH2", "-9");
            Assert.That(e.GetAllPlaceHolders(), Is.EqualTo(new Dictionary <string, string>
            {
                { "PH1", "+100" }, { "PH2", "-9" }
            }));

            e = new SqlExpr("@PH || @PH");
            e.Place("PH", "'abc'");
            Assert.That(e.GetAllPlaceHolders(), Is.EqualTo(new Dictionary <string, string>
            {
                { "PH", "'abc'" }
            }));
            e.Place("PH", "'abc'");
            Assert.That(e.GetAllPlaceHolders(), Is.EqualTo(new Dictionary <string, string>
            {
                { "PH", "'abc'" }
            }));
        }
Exemplo n.º 4
0
        public void Empty()
        {
            SqlExpr e = new SqlExpr();

            Assert.That(e.Clone().ToString(), Is.EqualTo(""));
            Assert.That(e.GetAllPlaceHolders(), Is.EqualTo(new string[] { }));
            Assert.That(e.HasUnplacedHolder("T"), Is.False);
            Assert.That(e.HasUnplacedHolders(), Is.False);
            Assert.That(e.IsEmpty, Is.True);
            Assert.That(e.IsPlaceHolderOnly, Is.False);
            e.Place("PH", "a");
            Assert.That(e.ToString(), Is.EqualTo(""));
        }
Exemplo n.º 5
0
        public void Place()
        {
            SqlExpr e;

            e = new SqlExpr("DEFAULT");
            e.Place("PH", "a");
            Assert.That(e.ToString(), Is.EqualTo("DEFAULT"));

            e = new SqlExpr("@PH");
            Assert.Throws <CannotBuildASTException>(() => { e.Place("PH", "a=1"); });

            e = new SqlExpr("@PH");
            e.Place("PH", "a");
            Assert.That(e.ToString(), Is.EqualTo("a"));

            e = new SqlExpr("cast(@PH as VARCHAR2)");
            e.Place("PH", "x");
            Assert.That(e.ToString(), Is.EqualTo("CAST(x AS VARCHAR2)"));
        }