import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.rest.core.annotation.RepositoryRestResource;
-
import java.util.List;
@RepositoryRestResource(collectionResourceRel = "vfModule", path = "vfModule")
public interface VFModuleRepository extends JpaRepository<VfModule, String> {
- VfModule findByModelUUID(String modelUUID);
-
- VfModule findFirstVfModuleByModelInvariantUUIDAndModelVersion(String modelInvariantUUID, String modelVersion);
-
- VfModule findByModelName(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 vf_module WHERE MODEL_NAME = ?1 ORDER BY INET_ATON(SUBSTRING_INDEX(CONCAT(MODEL_VERSION,'.0.0.0'),'.',4)) DESC LIMIT 1;", nativeQuery = true)
- VfModule findFirstByModelNameOrderByModelVersionDesc(String modelName);
-
- VfModule findFirstByModelInvariantUUIDAndModelUUID(String modelCustomizationUUID, String modelUUID);
-
- VfModule findFirstByModelInvariantUUID(String modelCustomizationUUID);
-
- /**
- * This method will not work for versions greater than 255, as it is utilizing an ip address function to do the sorting
- * @param modelInvariantUUID
- * @return
- */
- @Query(value = "SELECT * FROM vf_module WHERE MODEL_INVARIANT_UUID = ?1 ORDER BY INET_ATON(SUBSTRING_INDEX(CONCAT(MODEL_VERSION,'.0.0.0'),'.',4)) DESC;", nativeQuery = true)
- List<VfModule> findByModelInvariantUUIDOrderByModelVersionDesc(String modelInvariantUUID);
-}
\ No newline at end of file
+ VfModule findByModelUUID(String modelUUID);
+
+ VfModule findFirstVfModuleByModelInvariantUUIDAndModelVersion(String modelInvariantUUID, String modelVersion);
+
+ VfModule findByModelName(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 vf_module WHERE MODEL_NAME = ?1 ORDER BY INET_ATON(SUBSTRING_INDEX(CONCAT(MODEL_VERSION,'.0.0.0'),'.',4)) DESC LIMIT 1;",
+ nativeQuery = true)
+ VfModule findFirstByModelNameOrderByModelVersionDesc(String modelName);
+
+ VfModule findFirstByModelInvariantUUIDAndModelUUID(String modelCustomizationUUID, String modelUUID);
+
+ VfModule findFirstByModelInvariantUUID(String modelCustomizationUUID);
+
+ /**
+ * This method will not work for versions greater than 255, as it is utilizing an ip address function to do the
+ * sorting
+ *
+ * @param modelInvariantUUID
+ * @return
+ */
+ @Query(value = "SELECT * FROM vf_module WHERE MODEL_INVARIANT_UUID = ?1 ORDER BY INET_ATON(SUBSTRING_INDEX(CONCAT(MODEL_VERSION,'.0.0.0'),'.',4)) DESC;",
+ nativeQuery = true)
+ List<VfModule> findByModelInvariantUUIDOrderByModelVersionDesc(String modelInvariantUUID);
+}