BibSonomy bookmarks for /user/jil/data

The best way to write a Spring Data Exists Query - Vlad Mihalcea

jil — 2023-10-25T16:43:00+02:00

["slug" being an entity attribute] Spring Data offers an existsBy query method, which we can define in the PostRepository, as follows: 1 2 3 4 5 6 @Repository public interface PostRepository extends JpaRepository<Post, Long> { boolean existsBySlug(String slug); } [another] option to emulate existence is using a CASE WHEN EXISTS native SQL query: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 @Repository public interface PostRepository extends JpaRepository<Post, Long> { @Query(value = """ SELECT CASE WHEN EXISTS ( SELECT 1 FROM post WHERE slug = :slug ) THEN 'true' ELSE 'false' END """, nativeQuery = true ) boolean existsBySlugWithCase(@Param("slug") String slug); }

The best way to use Spring Data JPA Stream methods - Vlad Mihalcea

jil — 2023-10-25T16:30:13+02:00

@Repository public interface PostRepository extends BaseJpaRepository<Post, Long> { @Query(""" select p from Post p where date(p.createdOn) >= :sinceDate """ ) @QueryHints( @QueryHint(name = AvailableHints.HINT_FETCH_SIZE, value = "25") ) Stream<Post> streamByCreatedOnSince(@Param("sinceDate") LocalDate sinceDate); } The FETCH_SIZE JPA query hint is necessary for PostgreSQL and MySQL to instruct the JDBC Driver to prefetch at most 25 records. Otherwise, the PostgreSQL and MySQL JDBC Drivers would prefetch all the query results prior to traversing the underlying ResultSet.

Use runtime and type-safe parameters - Azure Pipelines | Microsoft Learn

jil — 2023-06-20T13:20:09+02:00

https://learn.microsoft.com/en-us/azure/devops/pipelines/process/runtime-parameters?view=azure-devops&tabs=script#parameter-data-types

GitHub - IBM/Project_CodeNet: This repository is to support contributions for tools for the Project CodeNet dataset hosted in DAX

jil — 2021-07-05T10:58:02+02:00

https://github.com/IBM/Project_CodeNet

Users forum - Lazy loading pageable listview

jil — 2017-05-02T11:07:28+02:00

public class LazyLoad extends WebPage { public LazyLoad() { IColumn[] columns = new IColumn[] { new PropertyColumn(new Model("col1"), "intValue"), new PropertyColumn(new Model("col2"), "class") }; ISortableDataProvider dataProvider = new SortableDataProvider() { public int size() { return 300000; } public IModel model(Object object) { return new Model((Integer) object); } public Iterator iterator(int first, int count) { return loadEntriesFromDatabase(first, count).iterator(); } private List<Integer> loadEntriesFromDatabase(int first, int count) { List<Integer> items = new ArrayList<Integer>(); for (int i = 0; i < count; i++) { items.add(new Integer(first + i)); } return items; } }; DefaultDataTable t = new DefaultDataTable("t", columns, dataProvider, 3); add(t); } }

java - Possibility to explicit remove Serialization support for a lambda - Stack Overflow

jil — 2017-04-28T14:08:53+02:00

http://stackoverflow.com/questions/25443655/possibility-to-explicit-remove-serialization-support-for-a-lambda

SPMF: A Java Open-Source Data Mining Library

jil — 2017-04-20T11:47:21+02:00

http://www.philippe-fournier-viger.com/spmf/

unix - How to remove EXIF data without recompressing the JPEG? - Stack Overflow

jil — 2016-09-23T19:16:41+02:00

exiftool -all= image.jpg

Data Flow Analysis: Theory and Practice

jil — 2015-12-11T15:11:38+01:00

Publisher: CRC Press (Taylor and Francis Group)Cat. #: 2880 ISBN: 9780849328800 ISBN 10: 0849328802 Publication Date: March 27, 2009 Number of Pages: 395