Package com.foundationdb.ais.model

Examples of com.foundationdb.ais.model.Index

322
323
324
325
326
327
328
329
330
331
332
        writeRow(tId, 2, "WA");
        writeRow(tId, 3, "MA");
        writeRow(tId, 4, "IA");

        AkibanInformationSchema ais = createAISWithTable(tId);
        Index index = addIndex(ais, tId, "state", true, "state");

        try {
            ddl().createIndexes(session(), Arrays.asList(index));
            Assert.fail("DuplicateKeyException expected!");
        } catch(DuplicateKeyException e) {
View Full Code Here
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
        writeRow(tId, 2, 5000, "10.50");
        writeRow(tId, 3, 47000, "9.99");
        expectRowCount(tId, 3);
       
        AkibanInformationSchema ais = createAISWithTable(tId);
        Index index1 = addIndex(ais, tId, "otherId", true, "otherId");
        Index index2 = addIndex(ais, tId, "price", false, "price");
        ddl().createIndexes(session(), Arrays.asList(index1, index2));

        AkibanInformationSchema aisCheck = ais();
        Index indexCheck = aisCheck.getTable(tId).getIndex("otherId");
        assertNotNull(indexCheck);
        assertTrue(indexCheck.isUnique());
        assertFalse(indexCheck.isPrimaryKey());
        assertFalse(indexCheck.isConnectedToFK());
        assertEquals("column name: otherId", "otherId", indexCheck.getKeyColumns().get(0).getColumn().getName());
        assertEquals("Index count", 1, indexCheck.getKeyColumns().size());
       
        Index indexCheck2 = aisCheck.getTable(tId).getIndex("price");
        assertNotNull(indexCheck2);
        assertFalse(indexCheck2.isUnique());
        assertFalse(indexCheck2.isPrimaryKey());
        assertFalse(indexCheck2.isConnectedToFK());
        assertEquals("column name: price", "price", indexCheck2.getKeyColumns().get(0).getColumn().getName());
        assertEquals("Index count", 1, indexCheck2.getKeyColumns().size());
       
        List<Row> rows = scanAllIndex(getTable(tId).getIndex("otherId"));
        assertEquals("rows from index scan", 3, rows.size());

        rows = scanAllIndex(getTable(tId).getIndex("price"));
View Full Code Here
391
392
393
394
395
396
397
398
399
400
401
402
        writeRow(tId, 2, 20, 5000, "10.50");
        writeRow(tId, 3, 30, 47000, "9.99");
        writeRow(tId, 4, 40, 47000, "9.99");

        AkibanInformationSchema ais = createAISWithTable(tId);
        Index index1 = addIndex(ais, tId, "otherId", true, "i2");
        Index index2 = addIndex(ais, tId, "price", false, "price");

        try {
            ddl().createIndexes(session(), Arrays.asList(index1, index2));
            Assert.fail("DuplicateKeyException expected!");
        } catch(DuplicateKeyException e) {
View Full Code Here
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
        writeRow(tid, 1, 42);
        writeRow(tid, 2, 43);
        writeRow(uid, 1, 44);
       
        AkibanInformationSchema ais = createAISWithTable(tid, uid);
        Index index1 = addIndex(ais, tid, "foo", false, "foo");
        Index index2 = addIndex(ais, uid, "bar", false, "bar");
        ddl().createIndexes(session(), Arrays.asList(index1, index2));

        AkibanInformationSchema aisCheck = ais();
        Index tidIndex = aisCheck.getTable(tid).getIndex("foo");
        Index uidIndex = aisCheck.getTable(uid).getIndex("bar");
        assertNotNull(tidIndex);
        assertTrue(tidIndex.isTableIndex());
        assertFalse(tidIndex.isUnique());
        assertNotNull(uidIndex);
        assertTrue(uidIndex.isTableIndex());
        assertFalse(uidIndex.isUnique());
       
        List<Row> rows = scanAllIndex(getTable(tid).getIndex("foo"));
        assertEquals("t rows from index scan", 2, rows.size());
       
        rows = scanAllIndex(getTable(uid).getIndex("bar"));
View Full Code Here
447
448
449
450
451
452
453
454
455
    @Test
    public void oneIndexCheckIDs() throws InvalidOperationException {
        int tId = createTable("test", "t", "id int not null primary key, foo int");
        AkibanInformationSchema ais = createAISWithTable(tId);
        Index index = addIndex(ais, tId, "foo", false, "foo");
        ddl().createIndexes(session(), Arrays.asList(index));
        checkIndexIDsInGroup(getTable(tId).getGroup());
    }
View Full Code Here
456
457
458
459
460
461
462
463
464
465
    @Test
    public void twoIndexesAtOnceCheckIDs() throws InvalidOperationException {
        int tId = createTable("test", "t", "id int not null primary key, foo int, bar int");
        AkibanInformationSchema ais = createAISWithTable(tId);
        Index index1 = addIndex(ais, tId, "foo", false, "foo");
        Index index2 = addIndex(ais, tId, "bar", false, "bar");
        ddl().createIndexes(session(), Arrays.asList(index1, index2));
        checkIndexIDsInGroup(getTable(tId).getGroup());
    }
View Full Code Here
466
467
468
469
470
471
472
473
474
475
476
477
478
    @Test
    public void twoIndexSeparatelyCheckIDs() throws InvalidOperationException {
        int tId = createTable("test", "t", "id int not null primary key, foo int, bar int");
        final AkibanInformationSchema ais = createAISWithTable(tId);
        Index index = addIndex(ais, tId, "foo", false, "foo");
        ddl().createIndexes(session(), Arrays.asList(index));
        checkIndexIDsInGroup(getTable(tId).getGroup());

        Index index2 = addIndex(ais, tId, "bar", false, "bar");
        ddl().createIndexes(session(), Arrays.asList(index2));
        checkIndexIDsInGroup(getTable(tId).getGroup());
    }
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
    protected static final String TABLE = "frosty";

    @Test
    public void oldKeysAreRemoved_1Row() throws InvalidOperationException {
        int tableId = table();
        Index index = nameIndex();
        runTest(
                tableId,
                Arrays.asList(
                        row(tableId, 2, "c")
                ),
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
    }

    @Test
    public void oldKeysAreRemoved_2Rows_Partial_IndexChanged() throws InvalidOperationException {
        int tableId = table();
        Index index = nameIndex();
        runTest(
                tableId,
                Arrays.asList(
                        row(tableId, 1, "b"),
                        row(tableId, 2, "c")
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
    }

    @Test
    public void oldKeysAreRemoved_2Rows_IndexChanged() throws InvalidOperationException {
        int tableId = table();
        Index index = nameIndex();
        runTest(
                tableId,
                Arrays.asList(
                        row(tableId, 1, "b"),
                        row(tableId, 2, "c")
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.