Package com.splout.db.engine

Examples of com.splout.db.engine.SQLite4JavaClient.query()

82
83
84
85
86
87
88
89
90
91
92
    for(int i = 0; i < N_DNODES; i++) {
      File dbData = new File(deployData, i + ".db");
      SQLite4JavaClient manager = new SQLite4JavaClient(dbData + "", null);
      // We create a foo database with one integer and one text
      manager.query("CREATE TABLE foo (intCol INT, strCol TEXT);", 100);
      // We insert as many values as the ones we defined in the partition map
      for(int j = i * 10; j < (i * 10 + 10); j++) {
        manager.query("INSERT INTO foo VALUES (" + j + ", " + "'" + randomStr + "');", 100);
      }
      manager.close();
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
      SQLite4JavaClient manager = new SQLite4JavaClient(dbData + "", null);
      // We create a foo database with one integer and one text
      manager.query("CREATE TABLE foo (intCol INT, strCol TEXT);", 100);
      // We insert as many values as the ones we defined in the partition map
      for(int j = i * 10; j < (i * 10 + 10); j++) {
        manager.query("INSERT INTO foo VALUES (" + j + ", " + "'" + randomStr + "');", 100);
      }
      manager.close();
    }

    SploutConfiguration config = SploutConfiguration.getTestConfig();
View Full Code Here
108
109
110
111
112
113
114
115
116
117
118
    List<String> jsonGeoData = new ArrayList<String>();
   
    for(int i = 0; i < 3; i++) {
      SQLite4JavaClient manager = new SQLite4JavaClient(TEST_OUTPUT + "/store/" + i + ".db", null);
      List list;
      list = JSONSerDe.deSer(manager.query("SELECT * FROM payments;", 100), ArrayList.class);
      totalPayments.addAll(list);
      System.out.println(list);
      assertEquals(1, list.size()); // There is one payment per each person
      list = JSONSerDe.deSer(manager.query("SELECT * FROM logs;", 100), ArrayList.class);
      totalLogs.addAll(list);
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
      List list;
      list = JSONSerDe.deSer(manager.query("SELECT * FROM payments;", 100), ArrayList.class);
      totalPayments.addAll(list);
      System.out.println(list);
      assertEquals(1, list.size()); // There is one payment per each person
      list = JSONSerDe.deSer(manager.query("SELECT * FROM logs;", 100), ArrayList.class);
      totalLogs.addAll(list);
      assertEquals(2, list.size()); // There are two log events per each person
      String geoDataStr = manager.query("SELECT * FROM geodata;", 100);
      jsonGeoData.add(geoDataStr);
      list = JSONSerDe.deSer(geoDataStr, ArrayList.class);
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
      System.out.println(list);
      assertEquals(1, list.size()); // There is one payment per each person
      list = JSONSerDe.deSer(manager.query("SELECT * FROM logs;", 100), ArrayList.class);
      totalLogs.addAll(list);
      assertEquals(2, list.size()); // There are two log events per each person
      String geoDataStr = manager.query("SELECT * FROM geodata;", 100);
      jsonGeoData.add(geoDataStr);
      list = JSONSerDe.deSer(geoDataStr, ArrayList.class);
      assertEquals(3, list.size()); // There are 3 countries in the replicated geo data file
      manager.close();
    }
View Full Code Here
108
109
110
111
112
113
114
115
116
117
118
    List distinctKeys = new ArrayList();
   
    for(int i = 0; i < 3; i++) {
      SQLite4JavaClient manager = new SQLite4JavaClient(TEST_OUTPUT + "/store/" + i + ".db", null);
      List list;
      list = JSONSerDe.deSer(manager.query("SELECT * FROM payments;", 100), ArrayList.class);
      totalPayments.addAll(list);
      Set<String> uniqueKeysInPartition = new HashSet<String>();
      for(Object obj: list) {
        uniqueKeysInPartition.add(((Map)obj).get("name") + "" + ((Map)obj).get("commerce"));
      }
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
      Set<String> uniqueKeysInPartition = new HashSet<String>();
      for(Object obj: list) {
        uniqueKeysInPartition.add(((Map)obj).get("name") + "" + ((Map)obj).get("commerce"));
      }
      distinctKeys.addAll(uniqueKeysInPartition);
      list = JSONSerDe.deSer(manager.query("SELECT * FROM logs;", 100), ArrayList.class);
      totalLogs.addAll(list);
      manager.close();
    }

    String keys = StringUtils.join(distinctKeys.toArray(), ", ");
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
    // Assert that the DB has been created successfully
   
    assertTrue(new File(OUTPUT + "/0.db").exists());
    SQLite4JavaClient manager = new SQLite4JavaClient(OUTPUT + "/0.db", null);
    @SuppressWarnings("rawtypes")
    List list = JSONSerDe.deSer(manager.query("SELECT * FROM schema1;", 100), ArrayList.class);
    assertEquals(6, list.size());
   
    manager.close();
  }
}
View Full Code Here
207
208
209
210
211
212
213
214
215
216
217
    for(int i = 0; i < N_DNODES; i++) {
      File dbData = new File(deployData, i + ".db");
      SQLite4JavaClient manager = new SQLite4JavaClient(dbData + "", null);
      // We create a foo database with one integer and one text
      manager.query("CREATE TABLE " + TABLE + " (iteration INT, dnode INT);", 100);
      // We insert as many values as the ones we defined in the partition map
      manager.query("INSERT INTO " + TABLE + " VALUES (" + iteration + ", " + i + ");", 100);
      manager.close();
    }
View Full Code Here
209
210
211
212
213
214
215
216
217
218
219
      File dbData = new File(deployData, i + ".db");
      SQLite4JavaClient manager = new SQLite4JavaClient(dbData + "", null);
      // We create a foo database with one integer and one text
      manager.query("CREATE TABLE " + TABLE + " (iteration INT, dnode INT);", 100);
      // We insert as many values as the ones we defined in the partition map
      manager.query("INSERT INTO " + TABLE + " VALUES (" + iteration + ", " + i + ");", 100);
      manager.close();
    }

    log.info("Deploying deploy iteration [" + iteration + "]");
    client.deploy(TABLESPACE, testTablespace.getPartitionMap(), testTablespace.getReplicationMap(),
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.