Deveel.Data.CompositeSelectTests.CreateTable C# (CSharp) Méthode

CreateTable() private méthode

private CreateTable ( IQuery query ) : void
query IQuery
Résultat void
        private void CreateTable(IQuery query)
        {
            var tableName = ObjectName.Parse("APP.persons");

            query.Access().CreateTable(table => table
                .Named(tableName)
                .WithColumn(column => column
                    .Named("id")
                    .HavingType(PrimitiveTypes.BigInt())
                    .NotNull()
                    .WithDefault(SqlExpression.FunctionCall("UNIQUEKEY", new SqlExpression[] {
                        SqlExpression.Constant(tableName.FullName)
                    })))
                .WithColumn("name", PrimitiveTypes.String())
                .WithColumn("age", PrimitiveTypes.Integer()));
        }