name: build and deploy movie app  service backend  
  
on:  
  push:  
    branches:  
      - dev  
  
jobs:  
  build-deploy:  
    name: build and deploy city-app-movie-backend  
    runs-on: ubuntu-22.04  
  
    steps:  
      - name: checkout code  
        uses: actions/checkout@v3  
  
      - name: setup jdk 21  
        uses: actions/setup-java@v3  
        with:  
          distribution: 'corretto'  
          java-version: 21  
  
      - name: grant execute permission for gradlew  
        run: chmod +x ./gradlew  
  
      - name: build the app  
        run: ./gradlew clean build -x test  
  
      - name: login to docker hub  
        uses: docker/login-action@v1  
        with:  
          username: ragjn_the_goat  
          password: password  
  
      - name: push the docker image to docker hub  
        uses: docker/build-push-action@v4  
        with:  
          context: .  
          dockerfile: Dockerfile  
          push: true  
          tags: rag_jn_ep/city-app-movie-backend:latest  
  
      - name: Deploy on contabo  
        env:  
          SSH_PASS: rag_the_goat  
        run: |  
          sshpass -p "$SSH_PASS" ssh -o StrictHostKeyChecking=no [email protected] << EOF  
            #Stop the existing container  
            docker stop city-app-movie-backend || true  
            docker rm city-app-movie-backend || true  
            docker pull rag_jn_ep/city-app-movie-backend:latest  
            docker run --name city-app-movie-backend -d -p 8086:8086 -p 9002:9002 --network my-bridge-network \  
           --mount type=bind,source=/var/log/movie-service,target=/logs \  
          rag_jn_ep/city-app-movie-backend:latest  
          EOF

name: build and deploy movie app  service backend  
  
on:  
  push:  
    branches:  
      - dev  
  
jobs:  
  build-deploy:  
    name: build and deploy city-app-movie-backend  
    runs-on: ubuntu-22.04  
  
    steps:  
      - name: checkout code  
        uses: actions/checkout@v3  
  
      - name: setup jdk 21  
        uses: actions/setup-java@v3  
        with:  
          distribution: 'corretto'  
          java-version: 21  
  
      - name: grant execute permission for gradlew  
        run: chmod +x ./gradlew  
  
      - name: build the app  
        run: ./gradlew clean build -x test  
  
      - name: login to docker hub  
        uses: docker/login-action@v1  
        with:  
          username: ragjn_the_goat  
          password: password  
  
      - name: push the docker image to docker hub  
        uses: docker/build-push-action@v4  
        with:  
          context: .  
          dockerfile: Dockerfile  
          push: true  
          tags: rag_jn_ep/city-app-movie-backend:latest  
  
      - name: Deploy on contabo  
        env:  
          SSH_PASS: rag_the_goat  
        run: |  
          sshpass -p "$SSH_PASS" ssh -o StrictHostKeyChecking=no [email protected] << EOF  
            #Stop the existing container  
            docker stop city-app-movie-backend || true  
            docker rm city-app-movie-backend || true  
            docker pull rag_jn_ep/city-app-movie-backend:latest  
            docker run --name city-app-movie-backend -d -p 8086:8086 -p 9002:9002 --network my-bridge-network \  
           --mount type=bind,source=/var/log/movie-service,target=/logs \  
          rag_jn_ep/city-app-movie-backend:latest  
          EOF

    @Query(value = "SELECT ST_Distance(" +
            "ST_SetSRID(ST_MakePoint(:userLng, :userLat), 4326), " +
            "ST_SetSRID(ST_MakePoint(:hotelLng, :hotelLat), 4326)" +
            ") AS distance", nativeQuery = true)
    Double hotelDistanceBetweenUser2(@Param("userLng") Double userLongitude,
                                     @Param("userLat") Double userLatitude,
                                     @Param("hotelLng") Double hotelLongitude,
                                     @Param("hotelLat") Double hotelLatitude);

    @Query(value = "SELECT ST_Distance(" +
            "ST_SetSRID(ST_MakePoint(:userLng, :userLat), 4326), " +
            "ST_SetSRID(ST_MakePoint(:hotelLng, :hotelLat), 4326)" +
            ") AS distance", nativeQuery = true)
    Double hotelDistanceBetweenUser2(@Param("userLng") Double userLongitude,
                                     @Param("userLat") Double userLatitude,
                                     @Param("hotelLng") Double hotelLongitude,
                                     @Param("hotelLat") Double hotelLatitude);

import org.junit.Test;
import org.junit.jupiter.api.BeforeAll;
public class OrderTest {
    @PersistenceContext(unitName = "WebPU")
    private EntityManager em;

    @BeforeAll
    public static void setUpClass() {

    }
    @Test
    public boolean testOrderCreation() {
        List<Destination> destinationList = em.createQuery("SELECT dt FROM Destination dt WHERE dt.id=:id", Destination.class)
                .setParameter("id", 1).getResultList();
        Destination destination = destinationList.get(0);
        if (destinationList.size() != 1) {
           return false;
        }
        List<Product> productList = em.createQuery("SELECT pdt FROM Product pdt WHERE pdt.id=:id", Product.class)
                .setParameter("id", 1).getResultList();

        if (productList.size() != 1) {
             return false;
        }
        Product product = productList.get(0);

        Orders order = new Orders();
        order.setProductId(product);
        order.setDestination(destination);
        order.setQty(10);
        order.setCreatedAt(LocalDateTime.now());
        order.setExpectedDate(LocalDateTime.now().plusDays(5));
        order.setOrderStatus("not_shipped");
        em.persist(order);
        return true;
    }
}

import org.junit.Test;
import org.junit.jupiter.api.BeforeAll;
public class OrderTest {
    @PersistenceContext(unitName = "WebPU")
    private EntityManager em;

    @BeforeAll
    public static void setUpClass() {

    }
    @Test
    public boolean testOrderCreation() {
        List<Destination> destinationList = em.createQuery("SELECT dt FROM Destination dt WHERE dt.id=:id", Destination.class)
                .setParameter("id", 1).getResultList();
        Destination destination = destinationList.get(0);
        if (destinationList.size() != 1) {
           return false;
        }
        List<Product> productList = em.createQuery("SELECT pdt FROM Product pdt WHERE pdt.id=:id", Product.class)
                .setParameter("id", 1).getResultList();

        if (productList.size() != 1) {
             return false;
        }
        Product product = productList.get(0);

        Orders order = new Orders();
        order.setProductId(product);
        order.setDestination(destination);
        order.setQty(10);
        order.setCreatedAt(LocalDateTime.now());
        order.setExpectedDate(LocalDateTime.now().plusDays(5));
        order.setOrderStatus("not_shipped");
        em.persist(order);
        return true;
    }
}

Artifacts builder: Archive 'F:/web_multi_module_2/final_project/jta-app/ear/target/ear-1.0.ear!/com.jiat-ejb-1.0.jar' doesn't contain files so it won't be created

Artifacts builder: Archive 'F:/web_multi_module_2/final_project/jta-app/ear/target/ear-1.0.ear!/com.jiat-ejb-1.0.jar' doesn't contain files so it won't be created