Package com.foundationdb.ais.model

Examples of com.foundationdb.ais.model.Index

283
284
285
286
287
288
289
290
291
292
    @Test
    public void pkLessRootNoData() throws Exception {
        int tid = createTable("s", "t", "i int");
        createIndex("s", "t", "i", "i");
        Table t = getTable(tid);
        Index pk = t.getIndexIncludingInternal(Index.PRIMARY);
        ddl().dropTable(session(), t.getName());
        expectNoTree(pk);
        expectNoTree(t);
    }
View Full Code Here
297
298
299
300
301
302
303
304
305
306
307
        createIndex("s", "t", "i", "i");
        writeRows(row(tid, 10L),
                  row(tid, 20L));
        Table t = getTable(tid);
        expectTree(t);
        Index pk = t.getIndexIncludingInternal(Index.PRIMARY);
        expectTree(pk);
        ddl().dropTable(session(), t.getName());
        expectNoTree(t);
        expectNoTree(pk);
    }
View Full Code Here
311
312
313
314
315
316
317
318
319
320
321
        int pid = createTable("s", "p", "id int not null primary key");
        int cid = createTable("s", "c", "i int, pid int, grouping foreign key(pid) references p(id)");
        createIndex("s", "c", "i", "i");
        Table p = getTable(pid);
        Table c = getTable(cid);
        Index pk = c.getIndexIncludingInternal(Index.PRIMARY);
        ddl().dropTable(session(), c.getName());
        expectNoTree(pk);
        ddl().dropTable(session(), p.getName());
        expectNoTree(c);
        expectNoTree(p);
View Full Code Here
332
333
334
335
336
337
338
339
340
341
342
        expectTree(p);
        writeRows(row(cid, 10L, 1L),
                  row(cid, 20L, 2L));
        Table c = getTable(cid);
        expectTree(c);
        Index pk = c.getIndexIncludingInternal(Index.PRIMARY);
        expectTree(pk);
        ddl().dropTable(session(), c.getName());
        expectNoTree(pk);
        ddl().dropTable(session(), p.getName());
        expectNoTree(c);
View Full Code Here
354
355
356
357
358
359
360
361
362
363
364
        writeRows(row(cid, 10L, 1L),
                  row(cid, 20L, 1L),
                  row(cid, 30L, 2L));
        Table p = getTable(pid);
        expectTree(p);
        Index o = p.getIndex("o");
        expectTree(o);
        Table c = getTable(cid);
        expectTree(c);
        try {
            ddl().dropTable(session(), p.getName());
View Full Code Here
379
380
381
382
383
384
385
386
387
388
389
    public void dropTableInGroupIndexWithNoData() throws Exception {
        int pid = createTable("s", "p", "id int not null primary key, name varchar(32)");
        int cid = createTable("s", "c", "id int not null primary key, pid int, val int, grouping foreign key(pid) references p(id)");
        Table p = getTable(pid);
        Table c = getTable(cid);
        Index index = createLeftGroupIndex(p.getGroup().getName(), "name_val", "p.name", "c.val");
        ddl().dropTable(session(), c.getName());
        expectNoTree(index);
        ddl().dropTable(session(), p.getName());
        expectNoTree(c);
        expectNoTree(p);
View Full Code Here
393
394
395
396
397
398
399
400
401
402
403
    public void dropTableInGroupIndexWithData() throws Exception {
        int pid = createTable("s", "p", "id int not null primary key, name varchar(32)");
        int cid = createTable("s", "c", "id int not null primary key, pid int, val int, grouping foreign key(pid) references p(id)");
        Table p = getTable(pid);
        Table c = getTable(cid);
        Index index = createLeftGroupIndex(p.getGroup().getName(), "name_val", "p.name", "c.val");
        writeRows(row(pid, 1, "bob"),
                    row(cid, 1, 1, 100),
                    row(cid, 2, 1, 101),
                  row(pid, 2, "joe"),
                    row(cid, 3, 2, 102),
View Full Code Here
413
414
415
416
417
418
419
420
421
422
423
    public void dropGroupIndexWithNoData() throws Exception {
        int pid = createTable("s", "p", "id int not null primary key, name varchar(32)");
        int cid = createTable("s", "c", "id int not null primary key, pid int, val int, grouping foreign key(pid) references p(id)");
        Table p = getTable(pid);
        Table c = getTable(cid);
        Index index = createLeftGroupIndex(p.getGroup().getName(), "name_val", "p.name", "c.val");
        ddl().dropGroupIndexes(session(), p.getGroup().getName(), Collections.singleton("name_val"));
        ddl().dropTable(session(), c.getName());
        expectNoTree(index);
        ddl().dropTable(session(), p.getName());
        expectNoTree(c);
View Full Code Here
428
429
430
431
432
433
434
435
436
437
438
    public void dropGroupIndexWithData() throws Exception {
        int pid = createTable("s", "p", "id int not null primary key, name varchar(32)");
        int cid = createTable("s", "c", "id int not null primary key, pid int, val int, grouping foreign key(pid) references p(id)");
        Table p = getTable(pid);
        Table c = getTable(cid);
        Index index = createLeftGroupIndex(p.getGroup().getName(), "name_val", "p.name", "c.val");
        writeRows(row(pid, 1, "bob"),
                    row(cid, 1, 1, 100),
                    row(cid, 2, 1, 101),
                  row(pid, 2, "joe"),
                    row(cid, 3, 2, 102),
View Full Code Here
448
449
450
451
452
453
454
455
456
    @Test
    public void dropSingleTableWithGroupIndexWithNoData() throws Exception {
        int pid = createTable("s", "p", "id int not null primary key, name varchar(32)");
        int cid = createTable("s", "c", "cid int not null primary key, pid int, x int, grouping foreign key(pid) references p(id)");
        Table c = getTable(cid);
        Index index = createLeftGroupIndex(c.getGroup().getName(), "name", "c.x", "p.name");
        ddl().dropTable(session(), c.getName());
        expectNoTree(index);
    }
View Full Code Here
TOP

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

  • com.foundationdb.ais.model.validation.IndexIDValidation$IndexIDVisitor
  • com.foundationdb.ais.model.validation.IndexIDValidationTest
  • com.foundationdb.ais.model.validation.SupportedColumnTypes$ColumnTypeVisitor
  • com.foundationdb.ais.protobuf.ProtobufReaderWriterTest
  • com.foundationdb.qp.rowtype.TableRowType
  • com.foundationdb.qp.storeadapter.indexcursor.IndexCursorMixedOrder
  • com.foundationdb.qp.storeadapter.indexcursor.IndexCursorSpatial_InBox
  • com.foundationdb.qp.storeadapter.indexcursor.IndexCursorSpatial_NearPoint
  • com.foundationdb.qp.storeadapter.indexcursor.IndexCursorUnidirectional
  • com.foundationdb.qp.storeadapter.PersistitIndexCursor
    • 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.