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

     *            the compound key object
     * @param compoundKey
     *            the compound key
     */
    protected String onDeleteQuery(EntityMetadata metadata, String tableName, MetamodelImpl metaModel, Object keyObject) {
        CQLTranslator translator = new CQLTranslator();
        String deleteQuery = CQLTranslator.DELETE_QUERY;


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


        StringBuilder deleteQueryBuilder = new StringBuilder(deleteQuery);


        deleteQueryBuilder.append(CQLTranslator.ADD_WHERE_CLAUSE);
        onWhereClause(metadata, keyObject, translator, deleteQueryBuilder, metaModel, metadata.getIdAttribute());

View Full Code Here

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

        long latestCount = 0l;
        try {
            conn.set_keyspace(descriptor.getSchema());


            if (isCql3Enabled()) {
                CQLTranslator translator = new CQLTranslator();
                execute(translator.buildUpdateQuery(descriptor).toString(), conn);


                CqlResult result = execute(translator.buildSelectQuery(descriptor).toString(), conn);


                for (CqlRow row : result.getRows()) {
                    latestCount = ByteBufferUtil.toLong(ByteBuffer.wrap(row.getColumns().get(0).getValue()));
                }
            } else {

View Full Code Here

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

        EntityMetadata entityMetadata =
            KunderaMetadataManager.getEntityMetadata(kunderaMetadata, joinTableData.getEntityClass());


        // need to bring in an insert query for this
        // add columns & execute query
        CQLTranslator translator = new CQLTranslator();


        String batch_Query = CQLTranslator.BATCH_QUERY;


        String insert_Query = translator.INSERT_QUERY;


        StringBuilder builder = new StringBuilder();
        builder.append(CQLTranslator.DEFAULT_KEY_NAME);
        builder.append(CQLTranslator.COMMA_STR);
        builder.append(translator.ensureCase(new StringBuilder(), joinTableData.getJoinColumnName(), false));
        builder.append(CQLTranslator.COMMA_STR);
        builder.append(translator.ensureCase(new StringBuilder(), joinTableData.getInverseJoinColumnName(), false));


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


        insert_Query = StringUtils.replace(insert_Query, CQLTranslator.COLUMNS, builder.toString());


        StringBuilder columnValueBuilder = new StringBuilder();


        StringBuilder statements = new StringBuilder();


        // insert query for each row key


        for (Object key : joinTableRecords.keySet()) {
            PropertyAccessor accessor =
                PropertyAccessorFactory.getPropertyAccessor((Field) entityMetadata.getIdAttribute().getJavaMember());


            Set<Object> values = joinTableRecords.get(key); // join column value


            for (Object value : values) {
                if (value != null) {
                    String insertQuery = insert_Query;
                    columnValueBuilder.append(CQLTranslator.QUOTE_STR);
                    columnValueBuilder.append(PropertyAccessorHelper.getString(key) + "\001"
                        + PropertyAccessorHelper.getString(value));
                    columnValueBuilder.append(CQLTranslator.QUOTE_STR);
                    columnValueBuilder.append(CQLTranslator.COMMA_STR);
                    translator.appendValue(columnValueBuilder, key.getClass(), key, true, false);
                    columnValueBuilder.append(CQLTranslator.COMMA_STR);
                    translator.appendValue(columnValueBuilder, value.getClass(), value, true, false);


                    insertQuery =
                        StringUtils.replace(insertQuery, CQLTranslator.COLUMN_VALUES, columnValueBuilder.toString());
                    statements.append(insertQuery);
                    statements.append(" ");

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 \"PERSONCASSANDRA\" (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

    protected <E> List<E> getColumnsByIdUsingCql(String schemaName, String tableName, String pKeyColumnName,
        String columnName, Object pKeyColumnValue, Class columnJavaType) {
        // select columnName from tableName where pKeyColumnName =
        // pKeyColumnValue
        List results = new ArrayList();
        CQLTranslator translator = new CQLTranslator();
        String selectQuery = translator.SELECT_QUERY;
        selectQuery =
            StringUtils.replace(selectQuery, CQLTranslator.COLUMN_FAMILY,
                translator.ensureCase(new StringBuilder(), tableName, false).toString());
        selectQuery =
            StringUtils.replace(selectQuery, CQLTranslator.COLUMNS,
                translator.ensureCase(new StringBuilder(), columnName, false).toString());


        StringBuilder selectQueryBuilder = new StringBuilder(selectQuery);


        selectQueryBuilder.append(CQLTranslator.ADD_WHERE_CLAUSE);


        translator.buildWhereClause(selectQueryBuilder, columnJavaType, pKeyColumnName, pKeyColumnValue,
            CQLTranslator.EQ_CLAUSE, false);
        selectQueryBuilder
            .delete(selectQueryBuilder.lastIndexOf(CQLTranslator.AND_CLAUSE), selectQueryBuilder.length());


        CqlResult cqlResult = execute(selectQueryBuilder.toString(), getRawClient(schemaName));

View Full Code Here

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

     * @throws Exception
     */
    private void createOrUpdateUsingCQL3(TableInfo tableInfo, KsDef ksDef) throws Exception
    {
        MetaDataHandler handler = new MetaDataHandler();
        CQLTranslator translator = new CQLTranslator();
        String columnFamilyQuery = CQLTranslator.CREATE_COLUMNFAMILY_QUERY;
        columnFamilyQuery = StringUtils.replace(columnFamilyQuery, CQLTranslator.COLUMN_FAMILY,
                translator.ensureCase(new StringBuilder(), tableInfo.getTableName(), false).toString());


        List<ColumnInfo> columns = tableInfo.getColumnMetadatas();


        Properties cfProperties = getColumnFamilyProperties(tableInfo);


        String defaultValidationClass = cfProperties != null ? cfProperties
                .getProperty(CassandraConstants.DEFAULT_VALIDATION_CLASS) : null;


        StringBuilder queryBuilder = new StringBuilder();


        // For normal columns
        boolean isCounterColumnType = isCounterColumnType(tableInfo, defaultValidationClass);
        onCompositeColumns(translator, columns, queryBuilder, null, isCounterColumnType);
        onCollectionColumns(translator, tableInfo.getCollectionColumnMetadatas(), queryBuilder);


        // ideally it will always be one as more super column families
        // are not allowed with compound/composite key.
        List<EmbeddedColumnInfo> compositeColumns = tableInfo.getEmbeddedColumnMetadatas();
        EmbeddableType compoEmbeddableType = null;
        if (!compositeColumns.isEmpty())
        {
            compoEmbeddableType = compositeColumns.get(0).getEmbeddable();
            onCompositeColumns(translator, compositeColumns.get(0).getColumns(), queryBuilder, columns,
                    isCounterColumnType);
        }
        else
        {
            String dataType = CassandraValidationClassMapper.getValidationClass(tableInfo.getTableIdType(), true);
            String cqlType = translator.getCQLType(dataType);
            translator.appendColumnName(queryBuilder, tableInfo.getIdColumnName(), cqlType);
            queryBuilder.append(" ,");
        }


        queryBuilder = stripLastChar(columnFamilyQuery, queryBuilder);

View Full Code Here

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

     * @param tableInfo
     */
    private void dropTableUsingCql(TableInfo tableInfo) throws Exception
    {


        CQLTranslator translator = new CQLTranslator();
        StringBuilder dropQuery = new StringBuilder("drop table ");
        translator.ensureCase(dropQuery, tableInfo.getTableName(), false);


        KunderaCoreUtils.printQuery(dropQuery.toString(), showQuery);


        cassandra_client.execute_cql3_query(ByteBuffer.wrap(dropQuery.toString().getBytes()), Compression.NONE,
                ConsistencyLevel.ONE);

View Full Code Here

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

     * @throws UnavailableException
     * @throws InvalidRequestException
     */
    private void addColumnToTable(TableInfo tableInfo, ColumnInfo column) throws Exception
    {
        CQLTranslator translator = new CQLTranslator();
        StringBuilder addColumnQuery = new StringBuilder("ALTER TABLE ");
        translator.ensureCase(addColumnQuery, tableInfo.getTableName(), false);
        addColumnQuery.append(" ADD ");
        translator.ensureCase(addColumnQuery, column.getColumnName(), false);
        addColumnQuery.append(" "
                + translator.getCQLType(CassandraValidationClassMapper.getValidationClass(column.getType(),
                        isCql3Enabled(tableInfo))));
        try
        {
            KunderaCoreUtils.printQuery(addColumnQuery.toString(), showQuery);
            cassandra_client.execute_cql3_query(ByteBuffer.wrap(addColumnQuery.toString().getBytes()),

View Full Code Here

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


                metadata.setDefault_name_type(UTF8Type.class.getSimpleName());
                metadata.setDefault_value_type(UTF8Type.class.getSimpleName());
                metadata.setName_types(name_types);
                metadata.setValue_types(value_types);
                CQLTranslator translator = new CQLTranslator();
                final String describeTable = "select * from ";
                StringBuilder builder = new StringBuilder(describeTable);
                translator.ensureCase(builder, tableInfo.getTableName(), false);
                builder.append("LIMIT 1");
                cassandra_client.set_cql_version(CassandraConstants.CQL_VERSION_3_0);
                CqlResult cqlResult = cassandra_client.execute_cql3_query(ByteBufferUtil.bytes(builder.toString()),
                        Compression.NONE, ConsistencyLevel.ONE);

View Full Code Here

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

        boolean isPresent = false;
        List<String> columns = getColumnList(m, metaModel, getKunderaQuery().getResult(), compoundKey);
        String selectQuery = columns != null && !columns.isEmpty() ? CQLTranslator.SELECT_QUERY
                : CQLTranslator.SELECTALL_QUERY;


        CQLTranslator translator = new CQLTranslator();


        selectQuery = StringUtils.replace(selectQuery, CQLTranslator.COLUMN_FAMILY,
                translator.ensureCase(new StringBuilder(), m.getTableName(), false).toString());


        builder = CassandraUtilities.appendColumns(builder, columns, selectQuery, translator);


        addWhereClause(builder);

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.