use of com.google.api.ads.admanager.axis.v202111.Statement in project googleads-java-lib by googleads.
the class UpdateUserTeamAssociations method runExample.
/**
* Runs the example.
*
* @param adManagerServices the services factory.
* @param session the session.
* @param userId the user ID of the user team association to update.
* @param teamId the team ID of the user team association to update.
* @throws ApiException if the API request failed with one or more service errors.
* @throws RemoteException if the API request failed due to other errors.
*/
public static void runExample(AdManagerServices adManagerServices, AdManagerSession session, long userId, long teamId) throws RemoteException {
// Get the UserTeamAssociationService.
UserTeamAssociationServiceInterface userTeamAssociationService = adManagerServices.get(session, UserTeamAssociationServiceInterface.class);
// Create a statement to only select a single user team association by ID.
StatementBuilder statementBuilder = new StatementBuilder().where("userId = :userId AND teamId = :teamId").orderBy("userId, teamId ASC").limit(1).withBindVariableValue("userId", userId).withBindVariableValue("teamId", teamId);
// Get the user team association.
UserTeamAssociationPage page = userTeamAssociationService.getUserTeamAssociationsByStatement(statementBuilder.toStatement());
UserTeamAssociation userTeamAssociation = Iterables.getOnlyElement(Arrays.asList(page.getResults()));
// Update the user's access type on the team.
userTeamAssociation.setOverriddenTeamAccessType(TeamAccessType.READ_ONLY);
// Update the user team associations on the server.
UserTeamAssociation[] userTeamAssociations = userTeamAssociationService.updateUserTeamAssociations(new UserTeamAssociation[] { userTeamAssociation });
for (UserTeamAssociation updatedUserTeamAssociation : userTeamAssociations) {
System.out.printf("User team association with user ID %d and team ID %d was updated.%n", updatedUserTeamAssociation.getUserId(), updatedUserTeamAssociation.getTeamId());
}
}
use of com.google.api.ads.admanager.axis.v202111.Statement in project googleads-java-lib by googleads.
the class StatementBuilderTest method testFrom_stripsFrom.
@Test
public void testFrom_stripsFrom() {
StatementBuilder statementBuilder = new StatementBuilder();
Statement statement = statementBuilder.from("FROM line_item").toStatement();
assertEquals("FROM line_item", statement.getQuery());
}
use of com.google.api.ads.admanager.axis.v202111.Statement in project googleads-java-lib by googleads.
the class StatementBuilderTest method testWhere.
@Test
public void testWhere() {
StatementBuilder statementBuilder = new StatementBuilder();
Statement statement = statementBuilder.where("id = 12345").toStatement();
assertEquals("WHERE id = 12345", statement.getQuery());
}
use of com.google.api.ads.admanager.axis.v202111.Statement in project googleads-java-lib by googleads.
the class StatementBuilderTest method testBindVariables_text.
@Test
public void testBindVariables_text() {
StatementBuilder statementBuilder = new StatementBuilder();
Statement statement = statementBuilder.where("text = :text").withBindVariableValue("text", "foo").toStatement();
String_ValueMapEntry entry = statement.getValues(0);
assertEquals("text", entry.getKey());
assertEquals(TextValue.class, entry.getValue().getClass());
assertEquals("foo", ((TextValue) entry.getValue()).getValue());
}
use of com.google.api.ads.admanager.axis.v202111.Statement in project googleads-java-lib by googleads.
the class StatementBuilderTest method testLimitOffsetDefaults.
@Test
public void testLimitOffsetDefaults() {
StatementBuilder statementBuilder = new StatementBuilder();
Statement initialOffset = statementBuilder.limit(100).toStatement();
assertEquals("LIMIT 100", initialOffset.getQuery());
Statement increasedOffset = statementBuilder.increaseOffsetBy(100).toStatement();
assertEquals("LIMIT 100 OFFSET 100", increasedOffset.getQuery());
}
Aggregations