Cloud Spanner を使用した Spring Boot アプリケーション

gcloud auth list 

 Credentialed Accounts ACTIVE  ACCOUNT *       <my_account>@<my_domain.com>  To set the active account, run:     $ gcloud config set account `ACCOUNT` 

gcloud config list project 

[core] project = <PROJECT_ID> 

gcloud config set project <PROJECT_ID> 

Updated property [core/project]. 

gcloud services enable spanner.googleapis.com 

gcloud spanner instances create spanner-instance \  --config=regional-us-central1 \  --nodes=1 --description="A Spanner Instance" 

gcloud spanner databases create orders \   --instance=spanner-instance 

cat << EOF > schema.ddl CREATE TABLE orders (   order_id STRING(36) NOT NULL,   description STRING(255),   creation_timestamp TIMESTAMP, ) PRIMARY KEY (order_id);  CREATE TABLE order_items (   order_id STRING(36) NOT NULL,   order_item_id STRING(36) NOT NULL,   description STRING(255),   quantity INT64, ) PRIMARY KEY (order_id, order_item_id),   INTERLEAVE IN PARENT orders ON DELETE CASCADE; EOF 

gcloud spanner databases ddl update orders \   --instance=spanner-instance \   --ddl="$(<schema.ddl)" 

$ curl https://start.spring.io/starter.tgz \   -d packaging=jar \   -d dependencies=cloud-gcp,web,lombok \   -d baseDir=spanner-example \   -d type=maven-project \   -d bootVersion=3.2.6 | tar -xzvf -  $ cd spanner-example 

<project>   ...   <dependencies>         ...         <!-- Add Spring Cloud GCP Spanner Starter -->         <dependency>                 <groupId>com.google.cloud</groupId>                 <artifactId>spring-cloud-gcp-starter-data-spanner</artifactId>         </dependency>          ...    </dependencies>    ... </project> 

spring.cloud.gcp.spanner.instance-id=spanner-instance spring.cloud.gcp.spanner.database=orders 

export JAVA_HOME=/usr/lib/jvm/java-17-openjdk-amd64/ 

./mvnw package 

package com.example.demo;  import com.google.cloud.spring.data.spanner.core.mapping.Column; import com.google.cloud.spring.data.spanner.core.mapping.PrimaryKey; import com.google.cloud.spring.data.spanner.core.mapping.Table;  @Table(name="order_items") @Data class OrderItem {   @PrimaryKey(keyOrder = 1)   @Column(name="order_id")   private String orderId;    @PrimaryKey(keyOrder = 2)   @Column(name="order_item_id")   private String orderItemId;    private String description;   private Long quantity; } 

package com.example.demo;  import java.time.LocalDateTime; import java.util.List; import lombok.Data; import com.google.cloud.spring.data.spanner.core.mapping.Column; import com.google.cloud.spring.data.spanner.core.mapping.Interleaved; import com.google.cloud.spring.data.spanner.core.mapping.PrimaryKey; import com.google.cloud.spring.data.spanner.core.mapping.Table;  @Table(name="orders") @Data public class Order {   @PrimaryKey   @Column(name="order_id")   private String id;    private String description;    @Column(name="creation_timestamp")   private LocalDateTime timestamp;    @Interleaved   private List<OrderItem> items; } 

package com.example.demo;  import com.google.cloud.spring.data.spanner.repository.SpannerRepository; import org.springframework.stereotype.Repository;  @Repository public interface OrderRepository extends SpannerRepository<Order, String> { } 

package com.example.demo;  import java.time.LocalDateTime; import java.util.UUID; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.http.HttpStatus; import org.springframework.web.bind.annotation.*; import org.springframework.web.server.ResponseStatusException;  @SpringBootApplication public class DemoApplication {         public static void main(String[] args) {                 SpringApplication.run(DemoApplication.class, args);         } }  @RestController class OrderController {   private final OrderRepository orderRepository;          OrderController(OrderRepository orderRepository) {                 this.orderRepository = orderRepository;         }          @GetMapping("/api/orders/{id}")         public Order getOrder(@PathVariable String id) {           return orderRepository.findById(id)                                 .orElseThrow(() -> new ResponseStatusException(HttpStatus.NOT_FOUND, id + " not found"));         }          @PostMapping("/api/orders")         public String createOrder(@RequestBody Order order) {                 // Spanner currently does not auto generate IDs                 // Generate UUID on new orders                 order.setId(UUID.randomUUID().toString());                 order.setTimestamp(LocalDateTime.now());                  order.getItems().forEach(item -> {                         // Assign parent ID, and also generate child ID                         item.setOrderId(order.getId());                         item.setOrderItemId(UUID.randomUUID().toString());                 });            Order saved = orderRepository.save(order);           return saved.getId();         } } 

./mvnw spring-boot:run 

curl -H"Content-Type: application/json" -d'{"description": "My orders", "items": [{"description": "Android Phone", "quantity": "1"}]}' \   http://localhost:8080/api/orders 

curl http://localhost:8080/api/orders/REPLACE_WITH_ORDER_UUID 

gcloud spanner instances delete spanner-instance -q