X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=mso-catalog-db%2Fsrc%2Fmain%2Fjava%2Forg%2Fonap%2Fso%2Fdb%2Fcatalog%2Fdata%2Frepository%2FNetworkResourceRepository.java;h=eaeb4292fba2638f606957ce1a1517a9244aea38;hb=f47919f1fe367b612fa9c96d34c59f01a541e882;hp=94c57945d11e6a2b31506989bb1e024e08494930;hpb=662c5d0e961b7350f17929fa28a7b016fdc8753a;p=so.git diff --git a/mso-catalog-db/src/main/java/org/onap/so/db/catalog/data/repository/NetworkResourceRepository.java b/mso-catalog-db/src/main/java/org/onap/so/db/catalog/data/repository/NetworkResourceRepository.java index 94c57945d1..eaeb4292fb 100644 --- a/mso-catalog-db/src/main/java/org/onap/so/db/catalog/data/repository/NetworkResourceRepository.java +++ b/mso-catalog-db/src/main/java/org/onap/so/db/catalog/data/repository/NetworkResourceRepository.java @@ -28,14 +28,18 @@ import org.springframework.stereotype.Repository; @Repository public interface NetworkResourceRepository extends JpaRepository { - /** - * This method will not work for versions greater than 255, as it is utilizing an ip address function to do the sorting - * @param modelName - * @return - */ - @Query(value = "SELECT * FROM network_resource WHERE MODEL_NAME = ?1 ORDER BY INET_ATON(SUBSTRING_INDEX(CONCAT(MODEL_VERSION,'.0.0.0'),'.',4)) DESC LIMIT 1;", nativeQuery = true) - NetworkResource findFirstByModelNameOrderByModelVersionDesc(String modelName); - - NetworkResource findResourceByModelUUID(String modelUUID); - NetworkResource findOneByModelName(String modelName); + /** + * This method will not work for versions greater than 255, as it is utilizing an ip address function to do the + * sorting + * + * @param modelName + * @return + */ + @Query(value = "SELECT * FROM network_resource WHERE MODEL_NAME = ?1 ORDER BY INET_ATON(SUBSTRING_INDEX(CONCAT(MODEL_VERSION,'.0.0.0'),'.',4)) DESC LIMIT 1;", + nativeQuery = true) + NetworkResource findFirstByModelNameOrderByModelVersionDesc(String modelName); + + NetworkResource findResourceByModelUUID(String modelUUID); + + NetworkResource findOneByModelName(String modelName); }