Sunday, 14 November 2021

Spring Data: ArangoDB: find by property value

Example 1: Find all the employees by their age.

List<Employee> findByAge(Integer age);

Example 2: Find all the employees by age and firstName.

List<Employee> findByAgeAndFirstName(Integer age, String firstName);


Example 3: Find all the employees by age or firstName.

List<Employee> findByAgeOrFirstName(Integer age, String firstName);


Find the below working application.

 

Step 1: Create new maven project ‘find-by-attributes-demo’.

 

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>find-by-attributes-demo</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 Employee entity.

 

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 [key=" + key + ", arangoId=" + arangoId + ", id=" + id + ", firstName=" + firstName
				+ ", lastName=" + lastName + ", age=" + age + "]";
	}

}


Step 4: Define EmployeeRepository interface.

 

EmployeeRepository.java

package com.sample.app.repository;

import java.util.List;

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

public interface EmployeeRepository extends ArangoRepository<Employee, String> {
	
	List<Employee> findByAge(Integer age);
	
	List<Employee> findByAgeAndFirstName(Integer age, String firstName);
	
	List<Employee> findByAgeOrFirstName(Integer age, String firstName);

}


Step 5: Define ArangoDB configuration.

 

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.Arrays;
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);

			employeeRepo.saveAll(Arrays.asList(emp1, emp2, emp3, emp4, emp5, emp6));

			System.out.println("Employees with age 31");
			List<Employee> emps = employeeRepo.findByAge(31);
			for (Employee emp : emps) {
				System.out.println(emp);
			}

			System.out.println("\nEmployees with age 31 and firstName Ram");
			emps = employeeRepo.findByAgeAndFirstName(31, "Ram");
			for (Employee emp : emps) {
				System.out.println(emp);
			}

			System.out.println("\nEmployees with age 31 and firstName Ram");
			emps = employeeRepo.findByAgeOrFirstName(31, "Joel");
			for (Employee emp : emps) {
				System.out.println(emp);
			}

		};
	}
}


Total project structure looks like below.





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


Employees with age 31
Employee [key=7736, arangoId=employees/7736, id=1, firstName=Ram, lastName=Gurram, age=31]
Employee [key=7738, arangoId=employees/7738, id=3, firstName=Gopi, lastName=Battu, age=31]
Employee [key=7740, arangoId=employees/7740, id=5, firstName=Sailu, lastName=Ptr, age=31]

Employees with age 31 and firstName Ram
Employee [key=7736, arangoId=employees/7736, id=1, firstName=Ram, lastName=Gurram, age=31]

Employees with age 31 and firstName Ram
Employee [key=7736, arangoId=employees/7736, id=1, firstName=Ram, lastName=Gurram, age=31]
Employee [key=7738, arangoId=employees/7738, id=3, firstName=Gopi, lastName=Battu, age=31]
Employee [key=7739, arangoId=employees/7739, id=4, firstName=Joel, lastName=Chelli, age=32]
Employee [key=7740, arangoId=employees/7740, id=5, firstName=Sailu, lastName=Ptr, age=31]


You can download complete working application from below link.

https://github.com/harikrishna553/springboot/tree/master/arangodb/find-by-attributes-demo





 

Previous                                                    Next                                                    Home

No comments:

Post a Comment