Deveel.Data.Sql.Statements.CreateTableStringFormatTests.ColumnWithDefault C# (CSharp) Метод

        public static void ColumnWithDefault()
        {
            var statement = new CreateTableStatement(new ObjectName("test_table"),
                new[] {
                    new SqlTableColumn("a", PrimitiveTypes.Integer()) {
                        DefaultExpression = SqlExpression.Constant(1)
                    },
                    new SqlTableColumn("b", PrimitiveTypes.String()) {
                        IsNotNull = true
                    }
                });

            var sql = statement.ToString();

            var expected = new StringBuilder();
            expected.AppendLine("CREATE TABLE test_table (");
            expected.AppendLine("  a INTEGER DEFAULT 1,");
            expected.AppendLine("  b STRING NOT NULL");
            expected.Append(")");

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