Package com.foundationdb.ais.model

Examples of com.foundationdb.ais.model.TableName

62
63
64
65
66
67
68
69
70
71
72
            "cafter int not null", // cid mod 5
            "clat decimal(11, 7)", // plat + cid % 10
            "clon decimal(11, 7)", // plon + cid % 10
            "primary key(cid)",
            "grouping foreign key(pid) references parent(pid)");
        groupName = new TableName("schema", "parent");
        createSpatialGroupIndex(groupName, "pbefore_clat_clon_cafter",
                                1, Spatial.LAT_LON_DIMENSIONS, Index.JoinType.LEFT,
                                "parent.pbefore", "child.clat", "child.clon", "child.cafter");
        createSpatialGroupIndex(groupName, "pbefore_plat_plon_cafter",
                                1, Spatial.LAT_LON_DIMENSIONS, Index.JoinType.LEFT,
View Full Code Here
241
242
243
244
245
246
247
248
249
250
251
    //

    @Test
    public void addGroupingForeignKey_C() {
        String xTable = "x";
        TableName xName = new TableName(SCHEMA, xTable);
        int xid = createTable(xName, "id varchar(5) not null primary key");
        writeRows(
                row(xid, "1"), // Adopts 1 (well formed group)
                                        // Leave 2 orphan
                row(xid, "4"), // Adopts 2 (c has no children)
View Full Code Here
376
377
378
379
380
381
382
383
384
385
386
        createIndex(SCHEMA, "customers", "name_dob", "name", "dob_year");
        int oTable = createTable(SCHEMA, "orders", "oid int not null primary key, cid varchar(4), placed varchar(64)",
                akibanFK("cid", "customers", "cid"));
        createIndex(SCHEMA, "orders", "placed", "placed");
        // schema: GIs
        TableName groupName = getTable(SCHEMA, "customers").getGroup().getName();
        namePlacedGi = createLeftGroupIndex(groupName, "namePlaced", "customers.name", "orders.placed");

        // insert data
        int startingCid = 0;
        int endingCid = CUSTOMERS_COUNT;
View Full Code Here
33
34
35
36
37
38
39
40
        createSpatialTableIndex("schem", "tab", "idxgeo", 0, 2, "lat", "lon");
        writeRow(cid, 10L, "10", "11");
        getStats(cid);
        serviceManager().getDXL().ddlFunctions().updateTableStatistics(session(),
                new TableName("schem", "tab"), Collections.singleton("idxgeo"));
        getStats(cid);
    }
View Full Code Here
46
47
48
49
50
51
52
53
        createSpatialTableIndex("schem", "tab", "idxgeo", 0, 2, "lat", "lon", "name");
        writeRow(cid, 10L, "10", "11", "foo");
        getStats(cid);
        serviceManager().getDXL().ddlFunctions().updateTableStatistics(session(),
                new TableName("schem", "tab"), Collections.singleton("idxgeo"));
        getStats(cid);
    }
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
        int cid = createTable("schem", "cust", "id int not null primary key", "lat decimal(11,07)", "lon decimal(11,7)",
                "name varchar(32)");
        int oid = createTable("schem", "orders", "id int not null primary key", "cid int not null", "colour varchar(3)",
                akibanFK("cid", "cust", "id"));

        TableName groupName = ais().getTable("schem", "cust").getGroup().getName();

        createSpatialGroupIndex(groupName, "idxgeogrp", 0, Spatial.LAT_LON_DIMENSIONS, Index.JoinType.LEFT,
                                "cust.lat", "cust.lon", "orders.colour");
        writeRow(cid, 10L, "10", "11", "foo");
        writeRow(oid, 20L, 10L, "red");
        getStats(cid);
        serviceManager().getDXL().ddlFunctions().updateTableStatistics(session(),
                new TableName("schem", "orders"), Collections.singleton("idxgeogrp"));
        getStats(cid);
        getStats(cid);
    }
View Full Code Here
44
45
46
47
48
49
50
    @Test(expected=NotAllowedByConfigException.class)
    public void groupIndex() {
        createTable("test", "c", "id int not null primary key, x int");
        createTable("test", "a", "id int not null primary key, cid int, lat decimal(11,7), lon decimal(11,7), grouping foreign key(cid) references c(id)");
        createSpatialGroupIndex(new TableName("test", "c"), "s", 1, 2, JoinType.LEFT, "c.x", "a.lat", "a.lon");
    }
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
import static org.junit.Assert.assertNotNull;

public class TableIDCollisionIT extends ITBase {
    private Table simpleISTable() {
        final TableName FAKE_TABLE = new TableName(TableName.INFORMATION_SCHEMA, "fake_table");
        NewAISBuilder builder = AISBBasedBuilder.create(ddl().getTypesTranslator());
        builder.table(FAKE_TABLE).colInt("id").pk("id");
        Table table = builder.ais().getTable(FAKE_TABLE);
        assertNotNull("Found table", table);
        return table;
View Full Code Here
96
97
98
99
100
101
102
103
104
105
    }

    private void expectSequences (String schemaName, String... sequenceNames) {
        final AkibanInformationSchema ais = ddl().getAIS(session());
        for (String name : sequenceNames) {
            final Sequence sequence = ais.getSequence(new TableName(schemaName, name));
            assertNotNull (schemaName + "." + name + " doesn't exist", sequence);
        }
       
    }
View Full Code Here
104
105
106
107
108
109
110
111
112
       
    }
    private void expectNotSequence (String schemaName, String... sequenceNames) {
        final AkibanInformationSchema ais = ddl().getAIS(session());
        for (String name : sequenceNames) {
            final Sequence sequence = ais.getSequence(new TableName(schemaName, name));
            assertNull (schemaName + "." + name + " still exists", sequence);
        }
    }
View Full Code Here
TOP

Related Classes of com.foundationdb.ais.model.TableName

  • com.foundationdb.ais.model.aisb2.AISBBasedBuilder$ActualBuilder
  • com.foundationdb.ais.model.aisb2.AISBBasedBuilder$ActualGroupIndexBuilder
  • com.foundationdb.ais.model.aisb2.AISBBasedBuilderTest
  • com.foundationdb.ais.model.validation.SupportedColumnTypes$ColumnTypeVisitor
  • com.foundationdb.ais.model.validation.TableIDsUnique
  • com.foundationdb.ais.protobuf.ProtobufReaderWriterTest
  • com.foundationdb.ais.util.TableChangeValidator
  • com.foundationdb.qp.loadableplan.std.DumpGroupLoadablePlan$SQLRowFormatter
  • com.foundationdb.qp.loadableplan.std.GroupProtobufLoadablePlan$GroupProtobufCursor
  • com.foundationdb.qp.operator.GroupScan_Default
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.