@Override public Void run(TransactionContext transaction) throws UserException { long rowCount = transaction.executeUpdate(Statement.of(INSERT_DML)); assertThat(rowCount).isEqualTo(DML_COUNT); throw new UserException("failing to commit"); } };
@Override public Long run(TransactionContext transaction) { long rowCount = 0; for (String stmt : stmts) { if (throwAbortOnce) { throwAbortOnce = false; throw SpannerExceptionFactory.newSpannerException( ErrorCode.ABORTED, "Abort in test"); } rowCount += transaction.executeUpdate(Statement.of(stmt)); } return rowCount; } };
@Override public Void run(TransactionContext transaction) { long rowCount = transaction.executeUpdate(Statement.of("UPDATE T SET v = v * 2 WHERE k = 'boo2';")); assertThat(rowCount).isEqualTo(1); assertThat(transaction.readRow("T", Key.of("boo2"), Arrays.asList("v")).getLong(0)) .isEqualTo(2 * 2); return null; } };
@Override public Void run(TransactionContext transaction) throws Exception { long rowCount = transaction.executeUpdate(s); System.out.printf("%d record updated.\n", rowCount); return null; } });
@Override public Void run(TransactionContext transaction) { // DML long rowCount = transaction.executeUpdate( Statement.of("INSERT INTO T (k, v) VALUES ('" + key1 + "', 1)")); assertThat(rowCount).isEqualTo(1); // Mutations transaction.buffer( Mutation.newInsertOrUpdateBuilder("T").set("K").to(key2).set("V").to(2).build()); return null; } };
@Override public Void run(TransactionContext transaction) throws Exception { String sql = "UPDATE Albums " + "SET LastUpdateTime = PENDING_COMMIT_TIMESTAMP() WHERE SingerId = 1"; long rowCount = transaction.executeUpdate(Statement.of(sql)); System.out.printf("%d records updated.\n", rowCount); return null; } });
@Override public Void run(TransactionContext transaction) throws Exception { String sql = "INSERT INTO Singers (SingerId, FirstName, LastName) " + " VALUES (10, 'Virginia', 'Watson')"; long rowCount = transaction.executeUpdate(Statement.of(sql)); System.out.printf("%d record inserted.\n", rowCount); return null; } });
@Override public Void run(TransactionContext transaction) throws Exception { String sql = "UPDATE Albums " + "SET MarketingBudget = MarketingBudget * 2 " + "WHERE SingerId = 1 and AlbumId = 1"; long rowCount = transaction.executeUpdate(Statement.of(sql)); System.out.printf("%d record updated.\n", rowCount); return null; } });
@Override public Void run(TransactionContext transaction) throws Exception { String sql = "DELETE FROM Singers WHERE FirstName = 'Alice'"; long rowCount = transaction.executeUpdate(Statement.of(sql)); System.out.printf("%d record deleted.\n", rowCount); return null; } });
@Override public Void run(TransactionContext transaction) throws Exception { String sql = "INSERT INTO Singers (SingerId, FirstName, LastName) VALUES " + "(12, 'Melissa', 'Garcia'), " + "(13, 'Russell', 'Morales'), " + "(14, 'Jacqueline', 'Long'), " + "(15, 'Dylan', 'Shaw')"; long rowCount = transaction.executeUpdate(Statement.of(sql)); System.out.printf("%d records inserted.\n", rowCount); return null; } });
@Override public Void run(TransactionContext transaction) throws Exception { // Insert record. String sql = "INSERT INTO Singers (SingerId, FirstName, LastName) " + " VALUES (11, 'Timothy', 'Campbell')"; long rowCount = transaction.executeUpdate(Statement.of(sql)); System.out.printf("%d record inserted.\n", rowCount); // Read newly inserted record. sql = "SELECT FirstName, LastName FROM Singers WHERE SingerId = 11"; ResultSet resultSet = transaction.executeQuery(Statement.of(sql)); while (resultSet.next()) { System.out.printf( "%s %s\n", resultSet.getString("FirstName"), resultSet.getString("LastName")); } return null; } });
@Override public long executeDmlStatement(Statement statement) { return this.transactionContext.executeUpdate(statement); }
@Override public long executeDmlStatement(Statement statement) { return this.transactionContext.executeUpdate(statement); }
.to(album1Budget) .build(); transaction.executeUpdate(updateStatement); Statement updateStatement2 = Statement.newBuilder( .to(album2Budget) .build(); transaction.executeUpdate(updateStatement2);
@Override public long executeDmlStatement(Statement statement) { return doWithOrWithoutTransactionContext((x) -> x.executeUpdate(statement), () -> this.databaseClient.executePartitionedUpdate(statement)); }
@Override public long executeDmlStatement(Statement statement) { Assert.notNull(statement, "A non-null statement is required."); maybeEmitEvent(new BeforeExecuteDmlEvent(statement)); long rowsAffected = doWithOrWithoutTransactionContext((x) -> x.executeUpdate(statement), () -> this.databaseClient.executePartitionedUpdate(statement)); maybeEmitEvent(new AfterExecuteDmlEvent(statement, rowsAffected)); return rowsAffected; }