Wednesday 17 November 2021

Spring ArangoDB: @Query: Execute AQL queries

You can execute AQL queries using @Query annotation.

 

Example

public interface EmployeeRepository extends ArangoRepository<Employee, String> {

  @Query("FOR e IN employees FILTER e.lastName == @lName SORT e.age ASC RETURN e")
  public List<Employee> getWithLastName(@Param("lName") String lastName);

}

‘getWithLastName’ method execute an AQL query which return all the employees with given lastName in the ascending order of their age. @Param annotation is used to bind method parameters to the query.

 

Step 1: Create new maven project ‘execute-aql-query’.

 

Step 2: Update pom.xml with maven dependencies.

 

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.sample.app</groupId>
  <artifactId>execute-aql-query</artifactId>
  <version>1</version>

  <!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-parent -->
  <parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.4.5</version>
  </parent>


  <dependencies>
    <dependency>
      <groupId>com.arangodb</groupId>
      <artifactId>arangodb-spring-boot-starter</artifactId>
      <version>2.3.3.RELEASE</version>
    </dependency>
  </dependencies>

  <build>
    <plugins>
      <plugin>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-maven-plugin</artifactId>
      </plugin>
    </plugins>
  </build>

</project>

Step 3: Define entity class.

 

Employee.java

package com.sample.app.entity;

import org.springframework.data.annotation.Id;

import com.arangodb.springframework.annotation.ArangoId;
import com.arangodb.springframework.annotation.Document;

@Document("employees")
public class Employee {

  @Id // db document field: _key
  private String key;

  @ArangoId // db document field: _id
  private String arangoId;

  private Integer id;
  private String firstName;
  private String lastName;
  private Integer age;

  public Employee() {

  }

  public Employee(Integer id, String firstName, String lastName, Integer age) {
    super();
    this.id = id;
    this.firstName = firstName;
    this.lastName = lastName;
    this.age = age;
  }

  public String getKey() {
    return key;
  }

  public void setKey(String key) {
    this.key = key;
  }

  public String getArangoId() {
    return arangoId;
  }

  public void setArangoId(String arangoId) {
    this.arangoId = arangoId;
  }

  public Integer getId() {
    return id;
  }

  public void setId(Integer id) {
    this.id = id;
  }

  public String getFirstName() {
    return firstName;
  }

  public void setFirstName(String firstName) {
    this.firstName = firstName;
  }

  public String getLastName() {
    return lastName;
  }

  public void setLastName(String lastName) {
    this.lastName = lastName;
  }

  public Integer getAge() {
    return age;
  }

  public void setAge(Integer age) {
    this.age = age;
  }

  @Override
  public String toString() {
    return "Employee [id=" + id + ", firstName=" + firstName + ", lastName=" + lastName + ", age=" + age + "]";
  }

}

Step 4: Define repository interface.

 

EmployeeRepository.java

package com.sample.app.repository;

import java.util.List;

import org.springframework.data.repository.query.Param;

import com.arangodb.springframework.annotation.Query;
import com.arangodb.springframework.repository.ArangoRepository;
import com.sample.app.entity.Employee;

public interface EmployeeRepository extends ArangoRepository<Employee, String> {

  @Query("FOR e IN employees FILTER e.lastName == @lName SORT e.age ASC RETURN e")
  public List<Employee> getWithLastName(@Param("lName") String lastName);

}

Step 5: Define arangodb configuration class.

 

ArangoConfig.java

package com.sample.app.config;

import org.springframework.context.annotation.Configuration;

import com.arangodb.ArangoDB;
import com.arangodb.springframework.annotation.EnableArangoRepositories;
import com.arangodb.springframework.config.ArangoConfiguration;

@Configuration
@EnableArangoRepositories(basePackages = { "com.sample.app" })
public class ArangoConfig implements ArangoConfiguration {

  @Override
  public ArangoDB.Builder arango() {
    return new ArangoDB.Builder().host("localhost", 8529).user("root").password("tiger");
  }

  @Override
  public String database() {
    return "abc_org";
  }
}

Step 6: Define main application class.

 

App.java

package com.sample.app;

import java.util.List;

import org.springframework.boot.CommandLineRunner;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.annotation.Bean;

import com.sample.app.entity.Employee;
import com.sample.app.repository.EmployeeRepository;

@SpringBootApplication
public class App {
  public static void main(String args[]) {
    SpringApplication.run(App.class, args);
  }

  @Bean
  public CommandLineRunner demo(EmployeeRepository employeeRepo) {

    return (args) -> {

      Employee emp1 = new Employee(1, "Ram", "Gurram", 31);
      Employee emp2 = new Employee(2, "Rudra", "Gurram", 32);
      Employee emp3 = new Employee(3, "Gopi", "Battu", 31);
      Employee emp4 = new Employee(4, "Joel", "Chelli", 32);
      Employee emp5 = new Employee(5, "Sailu", "Ptr", 31);
      Employee emp6 = new Employee(6, "Lahari", "Gurram", 23);

      emp1 = employeeRepo.save(emp1);
      emp2 = employeeRepo.save(emp2);
      emp3 = employeeRepo.save(emp3);
      emp4 = employeeRepo.save(emp4);
      emp5 = employeeRepo.save(emp5);
      emp6 = employeeRepo.save(emp6);

      List<Employee> empsWithLastNameGurram = employeeRepo.getWithLastName("Gurram");
      for (Employee emp : empsWithLastNameGurram) {
        System.out.println(emp);
      }

    };
  }
}

Total project structure looks like below.



Run App.java, you will see below messages in console.

Employee [id=6, firstName=Lahari, lastName=Gurram, age=23]
Employee [id=1, firstName=Ram, lastName=Gurram, age=31]
Employee [id=2, firstName=Rudra, lastName=Gurram, age=32]

You can download the complete working application from the below link.

https://github.com/harikrishna553/springboot/tree/master/arangodb/execute-aql-query




Previous                                                    Next                                                    Home

No comments:

Post a Comment