Search in sources :

Example 11 with Statement

use of com.google.api.ads.admanager.axis.v202205.Statement in project sunbird-rc-core by Sunbird-RC.

the class Neo4jGraphProvider method createCompositeIndex.

@Override
public void createCompositeIndex(Graph graph, String label, List<String> propertyNames) {
    Neo4JGraph neo4jGraph = (Neo4JGraph) graph;
    if (propertyNames.size() > 0) {
        StringBuilder properties = new StringBuilder(String.join(",", propertyNames));
        logger.info("composite key properties values " + properties);
        Objects.requireNonNull(label, "label cannot be null");
        Objects.requireNonNull(properties, "properties cannot be null");
        neo4jGraph.execute(new Statement("CREATE INDEX ON :`" + label + "`(" + properties + ")"));
    } else {
        logger.info("Could not create composite index for empty properties");
    }
}
Also used : Statement(org.neo4j.driver.v1.Statement) Neo4JGraph(com.steelbridgelabs.oss.neo4j.structure.Neo4JGraph)

Example 12 with Statement

use of com.google.api.ads.admanager.axis.v202205.Statement in project eol-globi-data by jhpoelen.

the class CypherQueryExecutorIT method executeBoltQuery.

@Test
public void executeBoltQuery() {
    Driver driver = GraphDatabase.driver("bolt://preston:7687", AuthTokens.none());
    Session session = driver.session(AccessMode.READ);
    try (Transaction transaction = session.beginTransaction()) {
        String s = "CYPHER 2.3 START dataset = node:datasets({namespace}) RETURN dataset.namespace LIMIT 1";
        Statement statement = new Statement(s, new TreeMap<String, Object>() {

            {
                put("namespace", "namespace:\"globalbioticinteractions/template-dataset\"");
            }
        });
        StatementResult run = transaction.run(statement);
        run.stream().map(r -> r.asMap()).forEach(System.out::println);
        transaction.success();
    }
}
Also used : Driver(org.neo4j.driver.v1.Driver) CypherUtil(org.eol.globi.util.CypherUtil) AccessMode(org.neo4j.driver.v1.AccessMode) Assert.assertNotNull(org.junit.Assert.assertNotNull) AuthTokens(org.neo4j.driver.v1.AuthTokens) ObjectMapper(com.fasterxml.jackson.databind.ObjectMapper) Test(org.junit.Test) IOException(java.io.IOException) Transaction(org.neo4j.driver.v1.Transaction) CypherQuery(org.eol.globi.util.CypherQuery) Is(org.hamcrest.core.Is) Statement(org.neo4j.driver.v1.Statement) StringContains.containsString(org.hamcrest.core.StringContains.containsString) Session(org.neo4j.driver.v1.Session) TreeMap(java.util.TreeMap) StatementResult(org.neo4j.driver.v1.StatementResult) MatcherAssert.assertThat(org.hamcrest.MatcherAssert.assertThat) GraphDatabase(org.neo4j.driver.v1.GraphDatabase) Collections(java.util.Collections) StatementResult(org.neo4j.driver.v1.StatementResult) Transaction(org.neo4j.driver.v1.Transaction) Statement(org.neo4j.driver.v1.Statement) Driver(org.neo4j.driver.v1.Driver) StringContains.containsString(org.hamcrest.core.StringContains.containsString) Session(org.neo4j.driver.v1.Session) Test(org.junit.Test)

Example 13 with Statement

use of com.google.api.ads.admanager.axis.v202205.Statement in project googleads-java-lib by googleads.

the class DeleteUserTeamAssociations method runExample.

/**
 * Runs the example.
 *
 * @param adManagerServices the services factory.
 * @param session the session.
 * @param userId the ID of the user to delete user team associations for.
 * @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) throws RemoteException {
    // Get the UserTeamAssociationService.
    UserTeamAssociationServiceInterface userTeamAssociationService = adManagerServices.get(session, UserTeamAssociationServiceInterface.class);
    // Create a statement to get all user team associations for a user.
    StatementBuilder statementBuilder = new StatementBuilder().where("WHERE userId = :userId ").orderBy("userId ASC, teamid ASC").limit(StatementBuilder.SUGGESTED_PAGE_LIMIT).withBindVariableValue("userId", userId);
    // Default for total result set size.
    int totalResultSetSize = 0;
    do {
        // Get user team associations by statement.
        UserTeamAssociationPage page = userTeamAssociationService.getUserTeamAssociationsByStatement(statementBuilder.toStatement());
        if (page.getResults() != null) {
            totalResultSetSize = page.getTotalResultSetSize();
            int i = page.getStartIndex();
            for (UserTeamAssociation userTeamAssociation : page.getResults()) {
                System.out.printf("%d) User team association with user ID %d and " + "team ID %d will be deleted.%n", i++, userTeamAssociation.getUserId(), userTeamAssociation.getTeamId());
            }
        }
        statementBuilder.increaseOffsetBy(StatementBuilder.SUGGESTED_PAGE_LIMIT);
    } while (statementBuilder.getOffset() < totalResultSetSize);
    System.out.printf("Number of user team associations to be deleted: %d%n", totalResultSetSize);
    if (totalResultSetSize > 0) {
        // Remove limit and offset from statement.
        statementBuilder.removeLimitAndOffset();
        // Create action.
        com.google.api.ads.admanager.axis.v202205.DeleteUserTeamAssociations action = new com.google.api.ads.admanager.axis.v202205.DeleteUserTeamAssociations();
        // Perform action.
        UpdateResult result = userTeamAssociationService.performUserTeamAssociationAction(action, statementBuilder.toStatement());
        if (result != null && result.getNumChanges() > 0) {
            System.out.printf("Number of user team associations deleted: %d%n", result.getNumChanges());
        } else {
            System.out.println("No user team associations were deleted.");
        }
    }
}
Also used : UserTeamAssociationServiceInterface(com.google.api.ads.admanager.axis.v202205.UserTeamAssociationServiceInterface) UserTeamAssociation(com.google.api.ads.admanager.axis.v202205.UserTeamAssociation) StatementBuilder(com.google.api.ads.admanager.axis.utils.v202205.StatementBuilder) UserTeamAssociationPage(com.google.api.ads.admanager.axis.v202205.UserTeamAssociationPage) UpdateResult(com.google.api.ads.admanager.axis.v202205.UpdateResult)

Example 14 with Statement

use of com.google.api.ads.admanager.axis.v202205.Statement in project googleads-java-lib by googleads.

the class GetUserTeamAssociationsForUser method runExample.

/**
 * Runs the example.
 *
 * @param adManagerServices the services factory.
 * @param session the session.
 * @param userId the user ID.
 * @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) throws RemoteException {
    UserTeamAssociationServiceInterface userTeamAssociationService = adManagerServices.get(session, UserTeamAssociationServiceInterface.class);
    // Create a statement to select user team associations.
    StatementBuilder statementBuilder = new StatementBuilder().where("userId = :userId").orderBy("userId ASC, teamId ASC").limit(StatementBuilder.SUGGESTED_PAGE_LIMIT).withBindVariableValue("userId", userId);
    // Retrieve a small amount of user team associations at a time, paging through
    // until all user team associations have been retrieved.
    int totalResultSetSize = 0;
    do {
        UserTeamAssociationPage page = userTeamAssociationService.getUserTeamAssociationsByStatement(statementBuilder.toStatement());
        if (page.getResults() != null) {
            // Print out some information for each user team association.
            totalResultSetSize = page.getTotalResultSetSize();
            int i = page.getStartIndex();
            for (UserTeamAssociation userTeamAssociation : page.getResults()) {
                System.out.printf("%d) User team association with user ID %d and team ID %d was found.%n", i++, userTeamAssociation.getUserId(), userTeamAssociation.getTeamId());
            }
        }
        statementBuilder.increaseOffsetBy(StatementBuilder.SUGGESTED_PAGE_LIMIT);
    } while (statementBuilder.getOffset() < totalResultSetSize);
    System.out.printf("Number of results found: %d%n", totalResultSetSize);
}
Also used : UserTeamAssociationServiceInterface(com.google.api.ads.admanager.axis.v202205.UserTeamAssociationServiceInterface) UserTeamAssociation(com.google.api.ads.admanager.axis.v202205.UserTeamAssociation) StatementBuilder(com.google.api.ads.admanager.axis.utils.v202205.StatementBuilder) UserTeamAssociationPage(com.google.api.ads.admanager.axis.v202205.UserTeamAssociationPage)

Example 15 with Statement

use of com.google.api.ads.admanager.axis.v202205.Statement in project googleads-java-lib by googleads.

the class UpdatePlacements method runExample.

/**
 * Runs the example.
 *
 * @param adManagerServices the services factory.
 * @param session the session.
 * @param placementId the ID of the placement 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 placementId) throws RemoteException {
    // Get the PlacementService.
    PlacementServiceInterface placementService = adManagerServices.get(session, PlacementServiceInterface.class);
    // Create a statement to only select a single placement by ID.
    StatementBuilder statementBuilder = new StatementBuilder().where("id = :id").orderBy("id ASC").limit(1).withBindVariableValue("id", placementId);
    // Get the placement.
    PlacementPage page = placementService.getPlacementsByStatement(statementBuilder.toStatement());
    Placement placement = Iterables.getOnlyElement(Arrays.asList(page.getResults()));
    placement.setDescription("This placement contains all leaderboards.");
    // Update the placement on the server.
    Placement[] placements = placementService.updatePlacements(new Placement[] { placement });
    for (Placement updatedPlacement : placements) {
        System.out.printf("Placement with ID %d and name '%s' was updated.%n", updatedPlacement.getId(), updatedPlacement.getName());
    }
}
Also used : PlacementPage(com.google.api.ads.admanager.axis.v202205.PlacementPage) Placement(com.google.api.ads.admanager.axis.v202205.Placement) StatementBuilder(com.google.api.ads.admanager.axis.utils.v202205.StatementBuilder) PlacementServiceInterface(com.google.api.ads.admanager.axis.v202205.PlacementServiceInterface)

Aggregations

StatementBuilder (com.google.api.ads.admanager.axis.utils.v202205.StatementBuilder)119 Test (org.junit.Test)77 UpdateResult (com.google.api.ads.admanager.axis.v202205.UpdateResult)18 Statement (com.google.api.ads.admanager.axis.v202105.Statement)16 Statement (com.google.api.ads.admanager.axis.v202108.Statement)16 Statement (com.google.api.ads.admanager.axis.v202111.Statement)16 Statement (com.google.api.ads.admanager.axis.v202202.Statement)16 Statement (com.google.api.ads.admanager.axis.v202205.Statement)16 CustomTargetingServiceInterface (com.google.api.ads.admanager.axis.v202205.CustomTargetingServiceInterface)8 InventoryServiceInterface (com.google.api.ads.admanager.axis.v202205.InventoryServiceInterface)8 AdUnit (com.google.api.ads.admanager.axis.v202205.AdUnit)7 AdUnitPage (com.google.api.ads.admanager.axis.v202205.AdUnitPage)7 PublisherQueryLanguageServiceInterface (com.google.api.ads.admanager.axis.v202205.PublisherQueryLanguageServiceInterface)7 ResultSet (com.google.api.ads.admanager.axis.v202205.ResultSet)7 Statement (org.neo4j.driver.v1.Statement)5 String_ValueMapEntry (com.google.api.ads.admanager.axis.v202105.String_ValueMapEntry)4 String_ValueMapEntry (com.google.api.ads.admanager.axis.v202108.String_ValueMapEntry)4 String_ValueMapEntry (com.google.api.ads.admanager.axis.v202111.String_ValueMapEntry)4 String_ValueMapEntry (com.google.api.ads.admanager.axis.v202202.String_ValueMapEntry)4 CustomFieldServiceInterface (com.google.api.ads.admanager.axis.v202205.CustomFieldServiceInterface)4