@Repository
public interface OssDao extends JpaRepository<OssFileEntity, Long> {

    @Query(nativeQuery = true, value =
            " SELECT " +
                    " \"uri\" " +
                    " FROM " +
                    "         \"oss_file\" " +
                    " WHERE " +
                    " \"namespace\" = :namespace " +
                    " AND \"prefix\" LIKE COALESCE (:prefix, ‘%%‘) " +
                    " AND \"name\" LIKE COALESCE (:fileName, ‘%%‘) "
    )
    List<String> findUriByCondition(@Param("namespace") String namespace,
                                    @Param("prefix") String prefix,
                                    @Param("fileName") String fileName);
}