当前位置: 首页>>代码示例>>Java>>正文


Java QueryProcessor.executeInternal方法代码示例

本文整理汇总了Java中org.apache.cassandra.cql3.QueryProcessor.executeInternal方法的典型用法代码示例。如果您正苦于以下问题:Java QueryProcessor.executeInternal方法的具体用法?Java QueryProcessor.executeInternal怎么用?Java QueryProcessor.executeInternal使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在org.apache.cassandra.cql3.QueryProcessor的用法示例。


在下文中一共展示了QueryProcessor.executeInternal方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: testValidationCompactStorage

import org.apache.cassandra.cql3.QueryProcessor; //导入方法依赖的package包/类
/**
 * For CASSANDRA-6892 too, check that for a compact table with one cluster column, we can insert whatever
 * we want as value for the clustering column, including something that would conflict with a CQL column definition.
 */
@Test
public void testValidationCompactStorage() throws Exception
{
    QueryProcessor.process("CREATE TABLE \"Keyspace1\".test_compact_dynamic_columns (a int, b text, c text, PRIMARY KEY (a, b)) WITH COMPACT STORAGE", ConsistencyLevel.ONE);

    Keyspace keyspace = Keyspace.open("Keyspace1");
    ColumnFamilyStore cfs = keyspace.getColumnFamilyStore("test_compact_dynamic_columns");

    QueryProcessor.executeInternal("INSERT INTO \"Keyspace1\".test_compact_dynamic_columns (a, b, c) VALUES (0, 'a', 'foo')");
    QueryProcessor.executeInternal("INSERT INTO \"Keyspace1\".test_compact_dynamic_columns (a, b, c) VALUES (0, 'b', 'bar')");
    QueryProcessor.executeInternal("INSERT INTO \"Keyspace1\".test_compact_dynamic_columns (a, b, c) VALUES (0, 'c', 'boo')");
    cfs.forceBlockingFlush();
    CompactionManager.instance.performScrub(cfs, true);

    // Scrub is silent, but it will remove broken records. So reading everything back to make sure nothing to "scrubbed away"
    UntypedResultSet rs = QueryProcessor.executeInternal("SELECT * FROM \"Keyspace1\".test_compact_dynamic_columns");
    assertEquals(3, rs.size());

    Iterator<UntypedResultSet.Row> iter = rs.iterator();
    assertEquals("foo", iter.next().getString("c"));
    assertEquals("bar", iter.next().getString("c"));
    assertEquals("boo", iter.next().getString("c"));
}
 
开发者ID:vcostet,项目名称:cassandra-kmean,代码行数:28,代码来源:ScrubTest.java

示例2: testInvalidSearch

import org.apache.cassandra.cql3.QueryProcessor; //导入方法依赖的package包/类
@Test
public void testInvalidSearch() throws IOException
{
    Mutation rm;
    rm = new Mutation("PerRowSecondaryIndex", ByteBufferUtil.bytes("k4"));
    rm.add("Indexed1", Util.cellname("indexed"), ByteBufferUtil.bytes("foo"), 1);
    rm.apply();
    
    // test we can search:
    UntypedResultSet result = QueryProcessor.executeInternal("SELECT * FROM \"PerRowSecondaryIndex\".\"Indexed1\" WHERE indexed = 'foo'");
    assertEquals(1, result.size());

    // test we can't search if the searcher doesn't validate the expression:
    try
    {
        QueryProcessor.executeInternal("SELECT * FROM \"PerRowSecondaryIndex\".\"Indexed1\" WHERE indexed = 'invalid'");
        fail("Query should have been invalid!");
    }
    catch (Exception e)
    {
        assertTrue(e instanceof InvalidRequestException || (e.getCause() != null && (e.getCause() instanceof InvalidRequestException)));
    }
}
 
开发者ID:vcostet,项目名称:cassandra-kmean,代码行数:24,代码来源:PerRowSecondaryIndexTest.java

示例3: testScrubColumnValidation

import org.apache.cassandra.cql3.QueryProcessor; //导入方法依赖的package包/类
@Test
public void testScrubColumnValidation() throws InterruptedException, RequestExecutionException, ExecutionException
{
    QueryProcessor.process(String.format("CREATE TABLE \"%s\".test_compact_static_columns (a bigint, b timeuuid, c boolean static, d text, PRIMARY KEY (a, b))", KEYSPACE), ConsistencyLevel.ONE);

    Keyspace keyspace = Keyspace.open(KEYSPACE);
    ColumnFamilyStore cfs = keyspace.getColumnFamilyStore("test_compact_static_columns");

    QueryProcessor.executeInternal(String.format("INSERT INTO \"%s\".test_compact_static_columns (a, b, c, d) VALUES (123, c3db07e8-b602-11e3-bc6b-e0b9a54a6d93, true, 'foobar')", KEYSPACE));
    cfs.forceBlockingFlush();
    CompactionManager.instance.performScrub(cfs, false, true, 2);

    QueryProcessor.process("CREATE TABLE \"Keyspace1\".test_scrub_validation (a text primary key, b int)", ConsistencyLevel.ONE);
    ColumnFamilyStore cfs2 = keyspace.getColumnFamilyStore("test_scrub_validation");

    new Mutation(UpdateBuilder.create(cfs2.metadata, "key").newRow().add("b", LongType.instance.decompose(1L)).build()).apply();
    cfs2.forceBlockingFlush();

    CompactionManager.instance.performScrub(cfs2, false, false, 2);
}
 
开发者ID:scylladb,项目名称:scylla-tools-java,代码行数:21,代码来源:ScrubTest.java

示例4: testValidationCompactStorage

import org.apache.cassandra.cql3.QueryProcessor; //导入方法依赖的package包/类
/**
 * For CASSANDRA-6892 too, check that for a compact table with one cluster column, we can insert whatever
 * we want as value for the clustering column, including something that would conflict with a CQL column definition.
 */
@Test
public void testValidationCompactStorage() throws Exception
{
    QueryProcessor.process(String.format("CREATE TABLE \"%s\".test_compact_dynamic_columns (a int, b text, c text, PRIMARY KEY (a, b)) WITH COMPACT STORAGE", KEYSPACE), ConsistencyLevel.ONE);

    Keyspace keyspace = Keyspace.open(KEYSPACE);
    ColumnFamilyStore cfs = keyspace.getColumnFamilyStore("test_compact_dynamic_columns");

    QueryProcessor.executeInternal(String.format("INSERT INTO \"%s\".test_compact_dynamic_columns (a, b, c) VALUES (0, 'a', 'foo')", KEYSPACE));
    QueryProcessor.executeInternal(String.format("INSERT INTO \"%s\".test_compact_dynamic_columns (a, b, c) VALUES (0, 'b', 'bar')", KEYSPACE));
    QueryProcessor.executeInternal(String.format("INSERT INTO \"%s\".test_compact_dynamic_columns (a, b, c) VALUES (0, 'c', 'boo')", KEYSPACE));
    cfs.forceBlockingFlush();
    CompactionManager.instance.performScrub(cfs, true, true, 2);

    // Scrub is silent, but it will remove broken records. So reading everything back to make sure nothing to "scrubbed away"
    UntypedResultSet rs = QueryProcessor.executeInternal(String.format("SELECT * FROM \"%s\".test_compact_dynamic_columns", KEYSPACE));
    assertEquals(3, rs.size());

    Iterator<UntypedResultSet.Row> iter = rs.iterator();
    assertEquals("foo", iter.next().getString("c"));
    assertEquals("bar", iter.next().getString("c"));
    assertEquals("boo", iter.next().getString("c"));
}
 
开发者ID:scylladb,项目名称:scylla-tools-java,代码行数:28,代码来源:ScrubTest.java

示例5: addNewKS

import org.apache.cassandra.cql3.QueryProcessor; //导入方法依赖的package包/类
@Test
public void addNewKS() throws ConfigurationException
{
    CFMetaData cfm = addTestTable("newkeyspace1", "newstandard1", "A new cf for a new ks");
    KeyspaceMetadata newKs = KeyspaceMetadata.create(cfm.ksName, KeyspaceParams.simple(5), Tables.of(cfm));
    MigrationManager.announceNewKeyspace(newKs);

    assertNotNull(Schema.instance.getKSMetaData(cfm.ksName));
    assertEquals(Schema.instance.getKSMetaData(cfm.ksName), newKs);

    // test reads and writes.
    QueryProcessor.executeInternal("INSERT INTO newkeyspace1.newstandard1 (key, col, val) VALUES (?, ?, ?)",
                                   "key0", "col0", "val0");
    ColumnFamilyStore store = Keyspace.open(cfm.ksName).getColumnFamilyStore(cfm.cfName);
    assertNotNull(store);
    store.forceBlockingFlush();

    UntypedResultSet rows = QueryProcessor.executeInternal("SELECT * FROM newkeyspace1.newstandard1");
    assertRows(rows, row("key0", "col0", "val0"));
}
 
开发者ID:scylladb,项目名称:scylla-tools-java,代码行数:21,代码来源:DefsTest.java

示例6: testScrubColumnValidation

import org.apache.cassandra.cql3.QueryProcessor; //导入方法依赖的package包/类
@Test
public void testScrubColumnValidation() throws InterruptedException, RequestExecutionException, ExecutionException
{
    QueryProcessor.process("CREATE TABLE \"Keyspace1\".test_compact_static_columns (a bigint, b timeuuid, c boolean static, d text, PRIMARY KEY (a, b))", ConsistencyLevel.ONE);

    Keyspace keyspace = Keyspace.open("Keyspace1");
    ColumnFamilyStore cfs = keyspace.getColumnFamilyStore("test_compact_static_columns");

    QueryProcessor.executeInternal("INSERT INTO \"Keyspace1\".test_compact_static_columns (a, b, c, d) VALUES (123, c3db07e8-b602-11e3-bc6b-e0b9a54a6d93, true, 'foobar')");
    cfs.forceBlockingFlush();
    CompactionManager.instance.performScrub(cfs, false);
}
 
开发者ID:vcostet,项目名称:cassandra-kmean,代码行数:13,代码来源:ScrubTest.java

示例7: assertUpdateIsAugmented

import org.apache.cassandra.cql3.QueryProcessor; //导入方法依赖的package包/类
private void assertUpdateIsAugmented(int key)
{
    UntypedResultSet rs = QueryProcessor.executeInternal(
                            String.format("SELECT * FROM %s.%s WHERE k=%s", ksName, cfName, key));
    assertTrue(String.format("Expected value (%s) for augmented cell v2 was not found", key), rs.one().has("v2"));
    assertEquals(999, rs.one().getInt("v2"));
}
 
开发者ID:vcostet,项目名称:cassandra-kmean,代码行数:8,代码来源:TriggersTest.java

示例8: truncateTables

import org.apache.cassandra.cql3.QueryProcessor; //导入方法依赖的package包/类
private static void truncateTables(String legacyVersion)
{
    for (int compact = 0; compact <= 1; compact++)
    {
        QueryProcessor.executeInternal(String.format("TRUNCATE legacy_tables.legacy_%s_simple%s", legacyVersion, getCompactNameSuffix(compact)));
        QueryProcessor.executeInternal(String.format("TRUNCATE legacy_tables.legacy_%s_simple_counter%s", legacyVersion, getCompactNameSuffix(compact)));
        QueryProcessor.executeInternal(String.format("TRUNCATE legacy_tables.legacy_%s_clust%s", legacyVersion, getCompactNameSuffix(compact)));
        QueryProcessor.executeInternal(String.format("TRUNCATE legacy_tables.legacy_%s_clust_counter%s", legacyVersion, getCompactNameSuffix(compact)));
    }
    CacheService.instance.invalidateCounterCache();
    CacheService.instance.invalidateKeyCache();
}
 
开发者ID:scylladb,项目名称:scylla-tools-java,代码行数:13,代码来源:LegacySSTableTest.java

示例9: testFilterOutDuplicates

import org.apache.cassandra.cql3.QueryProcessor; //导入方法依赖的package包/类
/**
 * Tests with invalid sstables (containing duplicate entries in 2.0 and 3.0 storage format),
 * that were caused by upgrading from 2.x with duplicate range tombstones.
 *
 * See CASSANDRA-12144 for details.
 */
@Test
public void testFilterOutDuplicates() throws Exception
{
    DatabaseDescriptor.setPartitionerUnsafe(Murmur3Partitioner.instance);
    QueryProcessor.process(String.format("CREATE TABLE \"%s\".cf_with_duplicates_3_0 (a int, b int, c int, PRIMARY KEY (a, b))", KEYSPACE), ConsistencyLevel.ONE);

    Keyspace keyspace = Keyspace.open(KEYSPACE);
    ColumnFamilyStore cfs = keyspace.getColumnFamilyStore("cf_with_duplicates_3_0");

    Path legacySSTableRoot = Paths.get(System.getProperty(INVALID_LEGACY_SSTABLE_ROOT_PROP),
                                       "Keyspace1",
                                       "cf_with_duplicates_3_0");

    for (String filename : new String[]{ "mb-3-big-CompressionInfo.db",
                                         "mb-3-big-Digest.crc32",
                                         "mb-3-big-Index.db",
                                         "mb-3-big-Summary.db",
                                         "mb-3-big-Data.db",
                                         "mb-3-big-Filter.db",
                                         "mb-3-big-Statistics.db",
                                         "mb-3-big-TOC.txt" })
    {
        Files.copy(Paths.get(legacySSTableRoot.toString(), filename), cfs.getDirectories().getDirectoryForNewSSTables().toPath().resolve(filename));
    }

    cfs.loadNewSSTables();

    cfs.scrub(true, true, true, 1);

    UntypedResultSet rs = QueryProcessor.executeInternal(String.format("SELECT * FROM \"%s\".cf_with_duplicates_3_0", KEYSPACE));
    assertEquals(1, rs.size());
    QueryProcessor.executeInternal(String.format("DELETE FROM \"%s\".cf_with_duplicates_3_0 WHERE a=1 AND b =2", KEYSPACE));
    rs = QueryProcessor.executeInternal(String.format("SELECT * FROM \"%s\".cf_with_duplicates_3_0", KEYSPACE));
    assertEquals(0, rs.size());
}
 
开发者ID:scylladb,项目名称:scylla-tools-java,代码行数:42,代码来源:ScrubTest.java

示例10: testUpgradeSstablesWithDuplicates

import org.apache.cassandra.cql3.QueryProcessor; //导入方法依赖的package包/类
@Test
public void testUpgradeSstablesWithDuplicates() throws Exception
{
    DatabaseDescriptor.setPartitionerUnsafe(Murmur3Partitioner.instance);
    String cf = "cf_with_duplicates_2_0";
    QueryProcessor.process(String.format("CREATE TABLE \"%s\".%s (a int, b int, c int, PRIMARY KEY (a, b))", KEYSPACE, cf), ConsistencyLevel.ONE);

    Keyspace keyspace = Keyspace.open(KEYSPACE);
    ColumnFamilyStore cfs = keyspace.getColumnFamilyStore(cf);

    Path legacySSTableRoot = Paths.get(System.getProperty(INVALID_LEGACY_SSTABLE_ROOT_PROP),
                                       "Keyspace1",
                                       cf);

    for (String filename : new String[]{ "lb-1-big-CompressionInfo.db",
                                         "lb-1-big-Data.db",
                                         "lb-1-big-Digest.adler32",
                                         "lb-1-big-Filter.db",
                                         "lb-1-big-Index.db",
                                         "lb-1-big-Statistics.db",
                                         "lb-1-big-Summary.db",
                                         "lb-1-big-TOC.txt" })
    {
        Files.copy(Paths.get(legacySSTableRoot.toString(), filename), cfs.getDirectories().getDirectoryForNewSSTables().toPath().resolve(filename));
    }

    cfs.loadNewSSTables();

    cfs.sstablesRewrite(true, 1);

    UntypedResultSet rs = QueryProcessor.executeInternal(String.format("SELECT * FROM \"%s\".%s", KEYSPACE, cf));
    assertEquals(1, rs.size());
    QueryProcessor.executeInternal(String.format("DELETE FROM \"%s\".%s WHERE a=1 AND b =2", KEYSPACE, cf));
    rs = QueryProcessor.executeInternal(String.format("SELECT * FROM \"%s\".%s", KEYSPACE, cf));
    assertEquals(0, rs.size());
}
 
开发者ID:scylladb,项目名称:scylla-tools-java,代码行数:37,代码来源:ScrubTest.java

示例11: setupReleaseVersion

import org.apache.cassandra.cql3.QueryProcessor; //导入方法依赖的package包/类
private void setupReleaseVersion(String version)
{
    // besides the release_version, we also need to insert the cluster_name or the check
    // in SystemKeyspace.checkHealth were we verify it matches DatabaseDescriptor will fail
    QueryProcessor.executeInternal(String.format("INSERT INTO system.local(key, release_version, cluster_name) " +
                                                 "VALUES ('local', '%s', '%s')",
                                                 version,
                                                 DatabaseDescriptor.getClusterName()));
    String r = readLocalVersion();
    assertEquals(String.format("Expected %s, got %s", version, r), version, r);
}
 
开发者ID:scylladb,项目名称:scylla-tools-java,代码行数:12,代码来源:SystemKeyspaceTest.java

示例12: assertUpdateIsAugmented

import org.apache.cassandra.cql3.QueryProcessor; //导入方法依赖的package包/类
private void assertUpdateIsAugmented(int key)
{
    UntypedResultSet rs = QueryProcessor.executeInternal(
            String.format("SELECT * FROM %s.%s WHERE k=%s", ksName, cfName, key));
    assertTrue(String.format("Expected value (%s) for augmented cell v2 was not found", key), rs.one().has("v2"));
    assertEquals(999, rs.one().getInt("v2"));
}
 
开发者ID:scylladb,项目名称:scylla-tools-java,代码行数:8,代码来源:TriggersTest.java

示例13: addNewTable

import org.apache.cassandra.cql3.QueryProcessor; //导入方法依赖的package包/类
@Test
public void addNewTable() throws ConfigurationException
{
    final String ksName = KEYSPACE1;
    final String tableName = "anewtable";
    KeyspaceMetadata original = Schema.instance.getKSMetaData(ksName);

    CFMetaData cfm = addTestTable(original.name, tableName, "A New Table");

    assertFalse(Schema.instance.getKSMetaData(ksName).tables.get(cfm.cfName).isPresent());
    MigrationManager.announceNewColumnFamily(cfm);

    assertTrue(Schema.instance.getKSMetaData(ksName).tables.get(cfm.cfName).isPresent());
    assertEquals(cfm, Schema.instance.getKSMetaData(ksName).tables.get(cfm.cfName).get());

    // now read and write to it.
    QueryProcessor.executeInternal(String.format("INSERT INTO %s.%s (key, col, val) VALUES (?, ?, ?)",
                                                 ksName, tableName),
                                   "key0", "col0", "val0");

    // flush to exercise more than just hitting the memtable
    ColumnFamilyStore cfs = Keyspace.open(ksName).getColumnFamilyStore(tableName);
    assertNotNull(cfs);
    cfs.forceBlockingFlush();

    // and make sure we get out what we put in
    UntypedResultSet rows = QueryProcessor.executeInternal(String.format("SELECT * FROM %s.%s", ksName, tableName));
    assertRows(rows, row("key0", "col0", "val0"));
}
 
开发者ID:scylladb,项目名称:scylla-tools-java,代码行数:30,代码来源:DefsTest.java

示例14: readSimpleTable

import org.apache.cassandra.cql3.QueryProcessor; //导入方法依赖的package包/类
private static void readSimpleTable(String legacyVersion, String compactSuffix, String pkValue)
{
    logger.debug("Read simple: legacy_{}_simple{}", legacyVersion, compactSuffix);
    UntypedResultSet rs;
    rs = QueryProcessor.executeInternal(String.format("SELECT val FROM legacy_tables.legacy_%s_simple%s WHERE pk=?", legacyVersion, compactSuffix), pkValue);
    Assert.assertNotNull(rs);
    Assert.assertEquals(1, rs.size());
    Assert.assertEquals("foo bar baz", rs.one().getString("val"));
}
 
开发者ID:scylladb,项目名称:scylla-tools-java,代码行数:10,代码来源:LegacySSTableTest.java

示例15: createTables

import org.apache.cassandra.cql3.QueryProcessor; //导入方法依赖的package包/类
private static void createTables(String legacyVersion)
{
    for (int i=0; i<=1; i++)
    {
        String compactSuffix = getCompactNameSuffix(i);
        String tableSuffix = i == 0? "" : " WITH COMPACT STORAGE";
        QueryProcessor.executeInternal(String.format("CREATE TABLE legacy_tables.legacy_%s_simple%s (pk text PRIMARY KEY, val text)%s", legacyVersion, compactSuffix, tableSuffix));
        QueryProcessor.executeInternal(String.format("CREATE TABLE legacy_tables.legacy_%s_simple_counter%s (pk text PRIMARY KEY, val counter)%s", legacyVersion, compactSuffix, tableSuffix));
        QueryProcessor.executeInternal(String.format("CREATE TABLE legacy_tables.legacy_%s_clust%s (pk text, ck text, val text, PRIMARY KEY (pk, ck))%s", legacyVersion, compactSuffix, tableSuffix));
        QueryProcessor.executeInternal(String.format("CREATE TABLE legacy_tables.legacy_%s_clust_counter%s (pk text, ck text, val counter, PRIMARY KEY (pk, ck))%s", legacyVersion, compactSuffix, tableSuffix));
    }
}
 
开发者ID:scylladb,项目名称:scylla-tools-java,代码行数:13,代码来源:LegacySSTableTest.java


注:本文中的org.apache.cassandra.cql3.QueryProcessor.executeInternal方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。