Deveel.Data.Sql.Statements.AlterTableStringFormatTests.AddCheck C# (CSharp) Method

        public static void AddCheck()
        {
            var constraint = new SqlTableConstraint(ConstraintType.Check) {
                CheckExpression = SqlExpression.Equal(SqlExpression.Reference(new ObjectName("a")),
                    SqlExpression.Constant(2))
            };

            var statement = new AlterTableStatement(ObjectName.Parse("test"), new AddConstraintAction(constraint));

            var sql = statement.ToString();
            var expected = new StringBuilder();
            expected.Append("ALTER TABLE test ADD CONSTRAINT ");
            expected.Append("CHECK a = 2");

            Assert.AreEqual(expected.ToString(), sql);
        }