Package io.crate.action.sql

Examples of io.crate.action.sql.SQLRequest

86
87
88
89
90
91
92
93
94
95
96
                .field("population", 1000)
                .endObject().string();
    }

    private SQLRequest getSingleSqlInsertRequest() {
        return new SQLRequest(SINGLE_INSERT_SQL_STMT,
                new Object[]{"Mordor", "MO", "666", 0.0, 180.0, 90.0, 0.0,
                             "MOR", "NAZ", "ME", "Mittelerde", "naz", "MOR",
                             "Schicksalsberg", 1000 }
        );
    }
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
                             "Schicksalsberg", 1000 }
        );
    }

    private SQLRequest getBulkSqlInsertRequest() {
        return new SQLRequest(BULK_INSERT_SQL_STMT,
                new Object[]{
                        "Mordor", "MO", "666", 0.0, 180.0, 90.0, 0.0,
                        "MOR", "NAZ", "ME", "Mittelerde", "naz", "MOR",
                        "Schicksalsberg", 1000,
View Full Code Here
78
79
80
81
82
83
84
    @Rule
    public TestRule ruleChain = RuleChain.emptyRuleChain();

    public SQLResponse execute(String stmt, Object[] args, boolean queryPlannerEnabled) {
        return getClient(queryPlannerEnabled).execute(SQLAction.INSTANCE, new SQLRequest(stmt, args)).actionGet();
    }
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
    }

    @Before
    public void getUpdateIds() {
        if (updateId == null || updateIdqueryPlannerEnabled == null) {
            SQLRequest request = new SQLRequest("SELECT \"_id\" FROM countries WHERE \"countryCode\"=?", new Object[]{"AT"});
            SQLResponse response = getClient(false).execute(SQLAction.INSTANCE, request).actionGet();
            assert response.rows().length == 1;
            updateId = (String)response.rows()[0][0];

            request = new SQLRequest("SELECT \"_id\" FROM countries WHERE \"countryCode\"=?", new Object[]{"AT"});
            response = getClient(true).execute(SQLAction.INSTANCE, request).actionGet();
            assert response.rows().length == 1;
            updateIdqueryPlannerEnabled = (String)response.rows()[0][0];
        }
    }
View Full Code Here
87
88
89
90
91
92
93
            updateIdqueryPlannerEnabled = (String)response.rows()[0][0];
        }
    }

    public SQLRequest getSqlUpdateByIdRequest(boolean queryPlannerEnabled) {
        return new SQLRequest("UPDATE countries SET population=? WHERE \"_id\"=?", new Object[]{ Math.abs(getRandom().nextInt()), queryPlannerEnabled ? updateIdqueryPlannerEnabled : updateId });
    }
View Full Code Here
97
98
99
100
101
102
103
        updateDoc.put("population", Math.abs(getRandom().nextInt()));
        return new UpdateRequest(INDEX_NAME, "default", queryPlannerEnabled ? updateIdqueryPlannerEnabled : updateId).doc(updateDoc);
    }

    public SQLRequest getSqlUpdateRequest() {
        return new SQLRequest("UPDATE countries SET population=? WHERE \"countryCode\"=?", new Object[]{ Math.abs(getRandom().nextInt()), "US" });
    }
View Full Code Here
158
159
160
161
162
163
164
165
    @Test
    public void testSQLSingleDelete() {
        HashMap<String, String> ids = createSampleData();
        for(String id: ids.keySet()){
            getClient(false).execute(SQLAction.INSTANCE,
                                     new SQLRequest(DELETE_SQL_STMT, new Object[]{id})).actionGet();
        }
    }
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
    @Before
    public void prepare() throws Exception {
        if (ids.isEmpty() || countryCodes.isEmpty()) {
            doLoadData();
            // setupOnce non-static
            SQLRequest request = new SQLRequest("SELECT \"_id\", \"countryCode\" FROM countries");
            SQLResponse response = getClient(false).execute(SQLAction.INSTANCE, request).actionGet();
            for (int i=0; i<response.rows().length;i++ ) {
                ids.add((String) response.rows()[i][0]);
                countryCodes.add((String) response.rows()[i][1]);
            }
View Full Code Here
100
101
102
103
104
105
106
    public DeleteRequest getDeleteApiByIdRequest() throws Exception {
        return new DeleteRequest(INDEX_NAME, "default", getDeleteId());
    }

    public SQLRequest getDeleteSqlByIdRequest() throws Exception {
        return new SQLRequest("DELETE FROM countries WHERE \"_id\"=?", new Object[]{ getDeleteId() });
    }
View Full Code Here
104
105
106
107
108
109
110
    public SQLRequest getDeleteSqlByIdRequest() throws Exception {
        return new SQLRequest("DELETE FROM countries WHERE \"_id\"=?", new Object[]{ getDeleteId() });
    }

    public SQLRequest getDeleteSqlByQueryRequest() throws Exception {
        return new SQLRequest("DELETE FROM countries WHERE \"countryCode\"=?", new Object[]{ getCountryCode() });
    }
View Full Code Here
TOP

Related Classes of io.crate.action.sql.SQLRequest

  • io.crate.client.CrateClient
  • io.crate.client.CrateClientTest
  • io.crate.integrationtests.InformationSchemaTest
  • io.crate.integrationtests.SQLTypeMappingTest
  • io.crate.integrationtests.TransportSQLActionSingleNodeTest
  • io.crate.module.sql.benchmark.BenchmarkBase
  • io.crate.module.sql.benchmark.BulkDeleteBenchmark
  • io.crate.module.sql.benchmark.DeleteBenchmark
  • io.crate.module.sql.benchmark.InsertBenchmark
  • io.crate.module.sql.benchmark.UpdateBenchmark
    • 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.