Examples of com.foundationdb.ais.model.aisb2.NewAISBuilder.table()

Package com.foundationdb.ais.model.aisb2

Class com.foundationdb.ais.model.aisb2.NewAISBuilder

Examples of com.foundationdb.ais.model.aisb2.NewAISBuilder.table()

com.foundationdb.ais.model.aisb2.NewAISBuilder.table()
Starts creating a new table using the default schema. @param table the table's name @return the new table's builder


    @Test
    public void sameRootTableNameTwoSchemas() {
        NewAISBuilder builder = AISBBasedBuilder.create(typesTranslator());
        builder.table(SCHEMA+"1", "t").colInt("id", false).pk("id");
        builder.table(SCHEMA+"2", "t").colInt("id", false).pk("id");
        AkibanInformationSchema inAIS = builder.ais();
        writeAndRead(inAIS);
    }
    
    @Test

View Full Code Here

    @Test 
    public void columnSequence() {
        NewAISBuilder builder = AISBBasedBuilder.create(SCHEMA, typesTranslator());
        TableName sequenceName = new TableName (SCHEMA, "sequence-4");
        builder.sequence(sequenceName.getTableName());
        builder.table("customers").
            colBigInt("customer_id", false).
            colString("customer_name", 100, false).
            pk("customer_id");
        AkibanInformationSchema inAIS = builder.unvalidatedAIS();
        Column idColumn = inAIS.getTable(new TableName (SCHEMA, "customers")).getColumn(0);

View Full Code Here


    @Test
    public void maxStorageSizeAndPrefixSize() {
        final String TABLE = "t";
        NewAISBuilder builder = AISBBasedBuilder.create(SCHEMA, typesTranslator());
        builder.table(TABLE).colBigInt("id");
        AkibanInformationSchema inAIS = builder.unvalidatedAIS();


        // Note: If storage* methods go away, or are non-null by default, that is *good* and these can go away
        Column inCol = inAIS.getTable(SCHEMA, TABLE).getColumn(0);
        assertNull("storedMaxStorageSize null by default", inCol.getMaxStorageSizeWithoutComputing());

View Full Code Here


    @Test
    public void columnDefaultValue() {
        final String TABLE = "t";
        NewAISBuilder builder = AISBBasedBuilder.create(SCHEMA, typesTranslator());
        builder.table(TABLE).colBigInt("id");


        AkibanInformationSchema inAIS = builder.unvalidatedAIS();
        Column inCol = inAIS.getTable(SCHEMA, TABLE).getColumn("id");


        AkibanInformationSchema outAIS = writeAndRead(inAIS);

View Full Code Here

    }


    public RowDataFormatTest(TableMaker tableMaker, Object[] fields, String bytesString) {
        TypesTranslator typesTranslator = MTypesTranslator.INSTANCE;
        NewAISBuilder aisBuilder = AISBBasedBuilder.create(SCHEMA, typesTranslator);
        NewTableBuilder tableBuilder = aisBuilder.table(TABLE).colInt("pkid");
        tableMaker.make(tableBuilder);
        tableBuilder.pk("pkid");
        AkibanInformationSchema ais = aisBuilder.ais();
        Table table = ais.getTable(SCHEMA, TABLE);
        table.setTableId(1);

View Full Code Here

    public void dropPrimaryKeyMiddleOfGroup() {
        TableName cName = new TableName(SCHEMA, "c");
        TableName oName = new TableName(SCHEMA, "o");
        TableName iName = new TableName(SCHEMA, "i");
        NewAISBuilder builder1 = AISBBasedBuilder.create(typesTranslator);
        builder1.table(cName).colBigInt("id", false).pk("id")
                .table(oName).colBigInt("id", false).colBigInt("cid", true).pk("id").joinTo(SCHEMA, "c", "fk1").on("cid", "id")
                .table(iName).colBigInt("id", false).colBigInt("oid", true).pk("id").joinTo(SCHEMA, "o", "fk2").on("oid", "id");
        NewAISBuilder builder2 = AISBBasedBuilder.create(typesTranslator);
        builder2.table(cName).colBigInt("id", false).pk("id")
                .table(oName).colBigInt("id", false).colBigInt("cid", true).joinTo(SCHEMA, "c", "fk1").on("cid", "id")

View Full Code Here

        NewAISBuilder builder1 = AISBBasedBuilder.create(typesTranslator);
        builder1.table(cName).colBigInt("id", false).pk("id")
                .table(oName).colBigInt("id", false).colBigInt("cid", true).pk("id").joinTo(SCHEMA, "c", "fk1").on("cid", "id")
                .table(iName).colBigInt("id", false).colBigInt("oid", true).pk("id").joinTo(SCHEMA, "o", "fk2").on("oid", "id");
        NewAISBuilder builder2 = AISBBasedBuilder.create(typesTranslator);
        builder2.table(cName).colBigInt("id", false).pk("id")
                .table(oName).colBigInt("id", false).colBigInt("cid", true).joinTo(SCHEMA, "c", "fk1").on("cid", "id")
                .table(iName).colBigInt("id", false).colBigInt("oid", true).pk("id").joinTo(SCHEMA, "o", "fk2").on("oid", "id");
        Table t1 = builder1.unvalidatedAIS().getTable(oName);
        Table t2 = builder2.unvalidatedAIS().getTable(oName);
        validate(

View Full Code Here

    //


    @Test
    public void dropColumnInGroupIndex() {
        NewAISBuilder builder = AISBBasedBuilder.create(SCHEMA, typesTranslator);
        builder.table("p").colInt("id").colInt("x").pk("id")
               .table(TABLE).colInt("id").colInt("pid").colInt("y").pk("id").joinTo(SCHEMA, "p", "fk").on("pid", "id")
               .groupIndex("x_y", Index.JoinType.LEFT).on(TABLE, "y").and("p", "x");
        Table t1 = builder.unvalidatedAIS().getTable(TABLE_NAME);
        builder = AISBBasedBuilder.create(SCHEMA, typesTranslator);
        builder.table("p").colInt("id").colInt("x").pk("id")

View Full Code Here

        builder.table("p").colInt("id").colInt("x").pk("id")
               .table(TABLE).colInt("id").colInt("pid").colInt("y").pk("id").joinTo(SCHEMA, "p", "fk").on("pid", "id")
               .groupIndex("x_y", Index.JoinType.LEFT).on(TABLE, "y").and("p", "x");
        Table t1 = builder.unvalidatedAIS().getTable(TABLE_NAME);
        builder = AISBBasedBuilder.create(SCHEMA, typesTranslator);
        builder.table("p").colInt("id").colInt("x").pk("id")
               .table(TABLE).colInt("id").colInt("pid").pk("id").joinTo(SCHEMA, "p", "fk").on("pid", "id");
        Table t2 = builder.unvalidatedAIS().getTable(TABLE_NAME);
        final String KEY1 = Index.PRIMARY;
        final String KEY2 = "fk";
        validate(

View Full Code Here


    @Test
    public void dropGFKFrommMiddleWithGroupIndexes() {
        TableName iName = new TableName(SCHEMA, "i");
        NewAISBuilder builder = AISBBasedBuilder.create(SCHEMA, typesTranslator);
        builder.table("p").colInt("id").colInt("x").pk("id")
               .table(TABLE).colInt("id").colInt("pid").colInt("y").pk("id").joinTo(SCHEMA, "p", "fk1").on("pid", "id")
               .table(iName).colInt("id").colInt("tid").colInt("z").pk("id").joinTo(SCHEMA, TABLE, "fk2").on("tid", "id")
               .groupIndex("x_y", Index.JoinType.LEFT).on(TABLE, "y").and("p", "x")                  // spans 2
               .groupIndex("x_y_z", Index.JoinType.LEFT).on("i", "z").and(TABLE, "y").and("p", "x"); // spans 3
        Table t1 = builder.unvalidatedAIS().getTable(TABLE_NAME);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.