Examples of CQLTranslator

com.impetus.client.cassandra.thrift.CQLTranslator
CQL translator interface, to translate all CRUD operations into CQL queries. In case compound primary key is boolean, we need to $COLUMNS,$COLUMNFAMILY,$COLUMNVALUES : They need to be comma separated. $COLUMNVALUES : It has to be according to data type(add "'" only for text/string) @author vivek.mishra

Examples of com.impetus.client.cassandra.thrift.CQLTranslator

    }
    
    @Test
    public void testGetKeyword()
    {
        CQLTranslator translator = new CQLTranslator();
        Assert.assertEquals("read_repair_chance", translator.getKeyword(CassandraConstants.READ_REPAIR_CHANCE));
        Assert.assertEquals("dclocal_read_repair_chance", translator.getKeyword(CassandraConstants.DCLOCAL_READ_REPAIR_CHANCE));
        Assert.assertEquals("bloom_filter_fp_chance", translator.getKeyword(CassandraConstants.BLOOM_FILTER_FP_CHANCE));
        Assert.assertEquals("compaction_strategy_class", translator.getKeyword(CassandraConstants.COMPACTION_STRATEGY));
        Assert.assertEquals("bloom_filter_fp_chance", translator.getKeyword(CassandraConstants.BLOOM_FILTER_FP_CHANCE));
        Assert.assertEquals("replicate_on_write", translator.getKeyword(CassandraConstants.REPLICATE_ON_WRITE));
        Assert.assertEquals("caching", translator.getKeyword(CassandraConstants.CACHING));
        Assert.assertEquals("comment", translator.getKeyword(CassandraConstants.COMMENT));
        Assert.assertEquals("gc_grace_seconds", translator.getKeyword(CassandraConstants.GC_GRACE_SECONDS));    
        
    }

View Full Code Here

Examples of com.impetus.client.cassandra.thrift.CQLTranslator

    {


        String queryWithoutLimit = parsedQuery.replaceAll(
                parsedQuery.substring(parsedQuery.lastIndexOf(CQLTranslator.LIMIT), parsedQuery.length()), "");


        CQLTranslator translator = new CQLTranslator();


        final String tokenCondition = prepareNext(translator, queryWithoutLimit);


        StringBuilder builder = new StringBuilder(queryWithoutLimit);


        if (tokenCondition != null)
        {
            if (query.getKunderaQuery().getFilterClauseQueue().isEmpty())
            {
                builder.append(CQLTranslator.ADD_WHERE_CLAUSE);
            }
            else
            {
                builder.append(CQLTranslator.AND_CLAUSE);
            }
            builder.append(tokenCondition);
        }


        String replaceQuery = replaceAndAppendLimit(builder.toString());
        builder.replace(0, builder.toString().length(), replaceQuery);
        translator.buildFilteringClause(builder);


        // in case of fetch by ID, token condition will be null and results will
        // not be empty.
        return checkOnEmptyResult() && tokenCondition == null ? null : builder.toString();
    }

View Full Code Here

Examples of com.impetus.client.cassandra.thrift.CQLTranslator

        query = query.replaceAll(tokenRegex, pattern);


        if (query.indexOf(pattern) > -1) // Means token( has been present and
                                         // replaced.
        {
            CQLTranslator translator = new CQLTranslator();


            int closingIndex = query.indexOf(CQLTranslator.CLOSE_BRACKET, query.lastIndexOf(pattern));


            String object = query.substring(query.lastIndexOf(pattern) + pattern.length(), closingIndex);


            Object entity = results.get(results.size() - 1);
            Class idClazz = ((AbstractAttribute) entityMetadata.getIdAttribute()).getBindableJavaType();
            Object id = PropertyAccessorHelper.getId(entity, entityMetadata);
            StringBuilder builder = new StringBuilder();


            translator.appendValue(builder, idClazz, id, false, false);


            query = query.replaceAll(pattern + object, pattern + builder.toString());
            query = query.replaceAll(pattern, CQLTranslator.TOKEN);
        }
        return query;

View Full Code Here

Examples of com.impetus.client.cassandra.thrift.CQLTranslator

            mulationMap.put(ByteBuffer.wrap("1".getBytes()), columnFamilyValues);
            CassandraCli.client.batch_mutate(mulationMap, ConsistencyLevel.ONE);
        }
        else
        {
            CQLTranslator translator = new CQLTranslator();
            String query = "insert into \"PERSON_ESINDEXER\" (key,\"PERSON_NAME\",\"AGE\") values (1,'Amry',10 )";
            CassandraCli.client.execute_cql3_query(ByteBuffer.wrap(query.getBytes()), Compression.NONE,
                    ConsistencyLevel.ONE);
        }

View Full Code Here

Examples of com.impetus.client.cassandra.thrift.CQLTranslator

                AbstractManagedType managedType =
                    (AbstractManagedType) metaModel.entity(entityMetadata.getEntityClazz());
                List<String> secondaryTables =
                    ((DefaultEntityAnnotationProcessor) managedType.getEntityAnnotation()).getSecondaryTablesName();


                CQLTranslator translator = new CQLTranslator();


                for (String tableName : secondaryTables) {
                    // Building query.
                    StringBuilder queryBuilder = new StringBuilder("select * from \"" + tableName + "\" where ");
                    Attribute attribute = entityMetadata.getIdAttribute();
                    translator.buildWhereClause(queryBuilder, ((AbstractAttribute) entityMetadata.getIdAttribute())
                        .getBindableJavaType(), CassandraUtilities.getIdColumnName(kunderaMetadata, entityMetadata,
                        getExternalProperties(), isCql3Enabled(entityMetadata)), PropertyAccessorHelper.getId(e,
                        entityMetadata), translator.EQ_CLAUSE, false);
                    // strip last "AND" clause.
                    queryBuilder.delete(queryBuilder.lastIndexOf(CQLTranslator.AND_CLAUSE), queryBuilder.length());

View Full Code Here

Examples of com.impetus.client.cassandra.thrift.CQLTranslator

         * @param relationNames
         * @return
         */
        public List<Object> find(MetamodelImpl metaModel, EntityMetadata metadata, Object rowId,
            List<String> relationNames) {
            CQLTranslator translator = new CQLTranslator();


            String tableName = metadata.getTableName();
            String select_Query = translator.SELECTALL_QUERY;
            select_Query =
                StringUtils.replace(select_Query, CQLTranslator.COLUMN_FAMILY,
                    translator.ensureCase(new StringBuilder(), tableName, false).toString());
            StringBuilder builder = new StringBuilder(select_Query);
            builder.append(CQLTranslator.ADD_WHERE_CLAUSE);
            onWhereClause(metadata, rowId, translator, builder, metaModel, metadata.getIdAttribute());


            // strip last "AND" clause.

View Full Code Here

Examples of com.impetus.client.cassandra.thrift.CQLTranslator

         * @param dataHandler
         * @return
         */
        protected List<Object> findByRelationQuery(EntityMetadata m, String columnName, Object columnValue,
            Class clazz, CassandraDataHandler dataHandler) {
            CQLTranslator translator = new CQLTranslator();
            String selectQuery = translator.SELECTALL_QUERY;
            selectQuery =
                StringUtils.replace(selectQuery, CQLTranslator.COLUMN_FAMILY,
                    translator.ensureCase(new StringBuilder(), m.getTableName(), false).toString());


            StringBuilder selectQueryBuilder = new StringBuilder(selectQuery);
            selectQueryBuilder.append(CQLTranslator.ADD_WHERE_CLAUSE);


            translator.buildWhereClause(selectQueryBuilder, columnValue.getClass(), columnName, columnValue,
                CQLTranslator.EQ_CLAUSE, false);
            selectQueryBuilder.delete(selectQueryBuilder.lastIndexOf(CQLTranslator.AND_CLAUSE),
                selectQueryBuilder.length());
            return this.executeQuery(clazz, m.getRelationNames(), dataHandler, true, false,
                selectQueryBuilder.toString());

View Full Code Here

Examples of com.impetus.client.cassandra.thrift.CQLTranslator

    private void testCountResult()
    {
        Map<String, Client> clientMap = (Map<String, Client>) entityManager.getDelegate();
        ThriftClient tc = (ThriftClient) clientMap.get(SEC_IDX_CASSANDRA_TEST);
        tc.setCqlVersion(CassandraConstants.CQL_VERSION_3_0);
        CQLTranslator translator = new CQLTranslator();


        String query = "select count(*) from "
                + translator.ensureCase(new StringBuilder(), "PERSONCASSANDRA", false).toString();
        Query q = entityManager.createNativeQuery(query, PersonCassandra.class);
        List noOfRows = q.getResultList();


        if (USE_CQL)
        {

View Full Code Here

Examples of com.impetus.client.cassandra.thrift.CQLTranslator

     * @return
     */
    protected List<String> createInsertQuery(EntityMetadata entityMetadata, Object entity,
        Cassandra.Client cassandra_client, List<RelationHolder> rlHolders, Object ttlColumns) {
        List<String> insert_Queries = new ArrayList<String>();
        CQLTranslator translator = new CQLTranslator();
        HashMap<TranslationType, Map<String, StringBuilder>> translation =
            translator.prepareColumnOrColumnValues(entity, entityMetadata, TranslationType.ALL, externalProperties,
                kunderaMetadata);


        Map<String, StringBuilder> columnNamesMap = translation.get(TranslationType.COLUMN);
        Map<String, StringBuilder> columnValuesMap = translation.get(TranslationType.VALUE);


        for (String tableName : columnNamesMap.keySet()) {
            String insert_Query = translator.INSERT_QUERY;


            insert_Query =
                StringUtils.replace(insert_Query, CQLTranslator.COLUMN_FAMILY,
                    translator.ensureCase(new StringBuilder(), tableName, false).toString());
            String columnNames = columnNamesMap.get(tableName).toString();
            String columnValues = columnValuesMap.get(tableName).toString();


            StringBuilder columnNameBuilder = new StringBuilder(columnNames);
            StringBuilder columnValueBuilder = new StringBuilder(columnValues);


            for (RelationHolder rl : rlHolders) {
                columnValueBuilder =
                    onRelationColumns(columnNames, columnValues, columnNameBuilder, columnValueBuilder, rl);


                columnNameBuilder.append(",");
                columnValueBuilder.append(",");
                translator.appendColumnName(columnNameBuilder, rl.getRelationName());
                translator.appendValue(columnValueBuilder, rl.getRelationValue().getClass(), rl.getRelationValue(),
                    true, false);


            }


            insert_Query =

View Full Code Here

Examples of com.impetus.client.cassandra.thrift.CQLTranslator

     */
    protected List<String> createUpdateQueryForCounter(EntityMetadata entityMetadata, Object entity,
        Cassandra.Client cassandra_client, List<RelationHolder> rlHolders) {
        Map<String, String> builders = new HashMap<String, String>();


        CQLTranslator translator = new CQLTranslator();


        Object rowId = PropertyAccessorHelper.getId(entity, entityMetadata);
        MetamodelImpl metaModel =
            (MetamodelImpl) kunderaMetadata.getApplicationMetadata().getMetamodel(entityMetadata.getPersistenceUnit());


        EntityType entityType = metaModel.entity(entityMetadata.getEntityClazz());


        Set<Attribute> attributes = entityType.getAttributes();


        for (Attribute attrib : attributes) {
            if (!entityMetadata.getIdAttribute().getName().equals(attrib.getName())
                && !metaModel.isEmbeddable(attrib.getJavaType()) && !attrib.isAssociation()) {
                String tableName =
                    ((AbstractAttribute) attrib).getTableName() != null ? ((AbstractAttribute) attrib).getTableName()
                        : entityMetadata.getTableName();


                String queryString = builders.get(tableName);
                StringBuilder builder;
                if (queryString == null) {
                    builder = new StringBuilder();
                } else {
                    builder = new StringBuilder(queryString);
                }
                translator.buildSetClauseForCounters(builder, ((AbstractAttribute) attrib).getJPAColumnName(),
                    PropertyAccessorHelper.getObject(entity, attrib.getName()));
                builders.put(tableName, builder.toString());
            }
        }
        for (RelationHolder rl : rlHolders) {
            translator.buildSetClauseForCounters(new StringBuilder(builders.get(entityMetadata.getTableName())),
                rl.getRelationName(), rl.getRelationValue());
        }


        for (String tableName : builders.keySet()) {
            StringBuilder builder = new StringBuilder(builders.get(tableName));


            String update_Query = translator.UPDATE_QUERY;


            update_Query =
                StringUtils.replace(update_Query, CQLTranslator.COLUMN_FAMILY,
                    translator.ensureCase(new StringBuilder(), tableName, false).toString());


            // strip last "," clause.
            builder.delete(builder.lastIndexOf(CQLTranslator.COMMA_STR), builder.length());


            builder.append(CQLTranslator.ADD_WHERE_CLAUSE);

View Full Code Here

0 1 2 3

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.