Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ```xml
- <dependency>
- <groupId>com.datastax.oss</groupId>
- <artifactId>java-driver-core</artifactId>
- <version>4.0.0-beta1</version>
- <scope>test</scope>
- </dependency>
- ```
- ```java
- session.execute("CREATE TABLE " + table + " (" +
- " key text PRIMARY KEY, " +
- " typelist frozen<list<" + typeName + ">>, " +
- " typemap frozen<map<int, " + typeName + ">>, " +
- " typeset frozen<set<" + typeName + ">>, " +
- " typefrozen frozen <" + typeName + ">, " +
- ")");
- UserDefinedType udt =
- new UserDefinedTypeBuilder(table.getSchemaName(), typeName)
- .withField("fieldtext", DataTypes.TEXT)
- .withField("fieldinteger", DataTypes.INT)
- .withField("fieldset", DataTypes.DOUBLE)
- .build();
- UdtValue udtValue = udt.newValue().setString(0, "hello").setInt(1, 1).setDouble(2, 1.2);
- RegularStatement regularStatement = QueryBuilder.insertInto(table.getSchemaName(), table.getTableName());
- for (int rowNumber = 1; rowNumber <= rowsCount; rowNumber++) {
- PreparedStatement preparedStatement = session.prepare(regularStatement);
- preparedStatement.bind()
- .setString("key", "key " + rowNumber)
- .setList("typelist", List.of(1))
- .setMap("typemap", ImmutableMap.of(1))
- .setSet("typeset", new Set<>{""})
- .setUDTValue("typefrozen", udt.newValue().setString(0, "hello").setInt(1, rowNumber).setDouble(2, 1.2))
- ;
- session.execute("INSERT INTO " + table + "(key, typelist, typemap, typeset, typefrozen) VALUES (" +
- String.format("'key %s', ", rowNumber) +
- String.format("[ { fieldtext: 'text %s', fieldinteger: %s, fieldset: 0.%s } ], ", rowNumber, rowNumber, rowNumber) +
- String.format("{ %s: { fieldtext: 'fieldText', fieldinteger: 0, fieldset: 0.0 } }, ", rowNumber) +
- "{{fieldtext: 'fieldText', fieldinteger: 0, fieldset: 0.0 }}, " +
- udt.newValue().setString(0, "hello").setInt(1, rowNumber).setDouble(2, 1.2) +
- ");");
- ```
Add Comment
Please, Sign In to add comment