UpdateTests.cs

using NUnit.Framework;

namespace WDE.SqlQueryGenerator.Test
{
    public class UpdateTests
    {
        [Test]
        public void SimpleSet()
        {
            var query = Queries.Table("a").Where(r => true).Set("b", 2).Update();
            Assert.AreEqual("UPDATE `a` SET `b` = 2;", query.QueryString);
        }
        
        [Test]
        public void DualSet()
        {
            var query = Queries.Table("a").Where(r => true).Set("b", 2).Set("c", 3.5).Update();
            Assert.AreEqual("UPDATE `a` SET `b` = 2, `c` = 3.5;", query.QueryString);
        }
        
        [Test]
        public void TripleSet()
        {
            var query = Queries.Table("a").Where(r => true).Set("b", 2).Set("c", 3.5).Set("d", "abc").Update();
            Assert.AreEqual("UPDATE `a` SET `b` = 2, `c` = 3.5, `d` = 'abc';", query.QueryString);
        }
        
        [Test]
        public void SimpleSetWithWhere()
        {
            var query = Queries.Table("a").Where(r => r.Column<int>("b") == 3).Set("b", 2).Update();
            Assert.AreEqual("UPDATE `a` SET `b` = 2 WHERE `b` = 3;", query.QueryString);
        }

    }
}