public void MultipleValues()
        {
            // Creating node hierarchy.
            var node = new Node();

            node.Add(new Node("table", "foo"));
            var values = new Node("values");

            values.Add(new Node("field1", "howdy"));
            values.Add(new Node("field2", "world"));
            node.Add(values);
            var builder = new SqlCreateBuilder(node, "'");

            // Extracting SQL + params, and asserting correctness.
            var result = builder.Build();
            var sql    = result.Get <string>();

            Assert.Equal("insert into 'foo' ('field1', 'field2') values (@0, @1)", sql);
            var arg1 = result.Children.First();

            Assert.Equal("@0", arg1.Name);
            Assert.Equal("howdy", arg1.Get <string>());
            var arg2 = result.Children.Skip(1).First();

            Assert.Equal("@1", arg2.Name);
            Assert.Equal("world", arg2.Get <string>());
        }
        /// <summary>
        /// Implementation of your slot.
        /// </summary>
        /// <param name="signaler">Signaler used to raise the signal.</param>
        /// <param name="input">Arguments to your slot.</param>
        public void Signal(ISignaler signaler, Node input)
        {
            var builder = new SqlCreateBuilder(input, "'");
            var result  = builder.Build();

            input.Value = result.Value;
            input.Clear();
            input.AddRange(result.Children.ToList());
        }
        public void NoValuesContent_Throws()
        {
            // Creating node hierarchy.
            var node = new Node();

            node.Add(new Node("table", "foo"));
            var values = new Node("values");

            node.Add(values);
            var builder = new SqlCreateBuilder(node, "'");

            // Extracting SQL + params, and asserting correctness.
            Assert.Throws <ArgumentException>(() => builder.Build());
        }
Exemple #4
0
        public void Signal(Node input)
        {
            var builder = new SqlCreateBuilder(input, _signaler);
            var sqlNode = builder.Build();

            // Checking if this is a "build only" invocation.
            if (builder.IsGenerateOnly)
            {
                input.Value = sqlNode.Value;
                input.Clear();
                input.AddRange(sqlNode.Children.ToList());
                return;
            }

            // Executing SQL, now parametrized.
            Executor.Execute(sqlNode, _connections, _signaler, (cmd) =>
            {
                // Notice, create SQL returns last inserted ID!
                input.Value = cmd.ExecuteScalar();
                input.Clear();
            });
        }
        public void GenerateArgument()
        {
            // Creating node hierarchy.
            var node = new Node();

            node.Add(new Node("generate", true));
            node.Add(new Node("table", "foo"));
            var values = new Node("values");

            values.Add(new Node("field1", "howdy"));
            node.Add(values);
            var builder = new SqlCreateBuilder(node, "'");

            // Extracting SQL + params, and asserting correctness.
            Assert.True(builder.IsGenerateOnly);
            var result = builder.Build();
            var sql    = result.Get <string>();
            var arg1   = result.Children.First();

            Assert.Equal("insert into 'foo' ('field1') values (@0)", sql);
            Assert.Equal("@0", arg1.Name);
            Assert.Equal("howdy", arg1.Get <string>());
        }
 public void SetUp()
 {
     _sqlCreateBuilder = new SqlCreateBuilder();
 }
 public void SetUp()
 {
     _sqlCreateBuilder = new SqlCreateBuilder();
 }