Skip to content

Instantly share code, notes, and snippets.

@Danny-Hoang
Danny-Hoang / mysql-docker.sh
Created December 25, 2021 01:36 — forked from spalladino/mysql-docker.sh
Backup and restore a mysql database from a running Docker mysql container
# Backup
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql
# Restore
cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE
@Danny-Hoang
Danny-Hoang / AppApplication.java
Created July 12, 2021 17:43 — forked from jsfan3/AppApplication.java
Cloudinary in Spring Boot - Three files: the main AppApplication, the Controller and the Service, by Francesco Galgani, www.informatica-libera.net
package yourpackage.app;
import com.cloudinary.Cloudinary;
import com.cloudinary.SingletonManager;
import com.cloudinary.utils.ObjectUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.scheduling.annotation.EnableScheduling;
@Danny-Hoang
Danny-Hoang / SpringJPA11_2.java
Last active June 28, 2021 11:32 — forked from JavaNoobPig/SpringJPA11_2.java
jpa query 4 types
package com.pig.jpa.hibernate.demo.repository;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.Query;
import javax.persistence.TypedQuery;
import org.junit.Test;
import org.junit.runner.RunWith;
@Danny-Hoang
Danny-Hoang / CustomRepository.java
Created June 28, 2021 11:28 — forked from namkyu/CustomRepository.java
spring data jpa #jpa
public interface MemberRepository extends JpaRepository<SpringMember, Integer> {
SpringMember findBySeqAndName(int seq, String name);
List<SpringMember> findTop3ByNameLike(String name);
SpringMember readBySeq(int seq);
SpringMember readByName(String name);
@Danny-Hoang
Danny-Hoang / CriteriaQueryTest.java
Created June 28, 2021 11:27 — forked from olivercaine/CriteriaQueryTest.java
JPA with Hibernate CriteriaQuery test
package com.in28minutes.jpa.hibernate.demo.repository;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.TypedQuery;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Join;
import javax.persistence.criteria.JoinType;
@Danny-Hoang
Danny-Hoang / Customer.java
Created June 28, 2021 11:27 — forked from talk2debendra/Customer.java
Spring data Query By Example
package com.deb.qbe.model;
@Entity
@Table(name = "customers")
@Data
@NoArgsConstructor
@AllArgsConstructor
@EqualsAndHashCode
@ToString
@Builder
public class Customers implements Serializable{
package com.ypc.spring.data.elastic;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class ElasticApplication {
public static void main(String[] args) {
SpringApplication.run(ElasticApplication.class, args);
@Danny-Hoang
Danny-Hoang / BookQueryService.java
Created June 28, 2021 11:25 — forked from guozi/BookQueryService.java
Spring Boot + Spring Data Jpa
public interface BookQueryService {
Page<Book> findBookNoCriteria(Integer page,Integer size);
Page<Book> findBookCriteria(Integer page,Integer size,BookQuery bookQuery);
}
@Danny-Hoang
Danny-Hoang / jpa-query.java
Created June 28, 2021 11:02
JPA query samples
public interface DataArticleRepository extends CrudRepository<Article, UUID> {
Optional<Article> findBySlug(String slug);
Optional<Article> findByTitle(String title);
@Query("SELECT DISTINCT article_ FROM Article article_ " +
"LEFT JOIN article_.tags t " +
"LEFT JOIN article_.author p " +
"LEFT JOIN article_.favoredUsers f " +
@Entity
public class Parent implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Long id;
@OneToMany(mappedBy = "parent", cascade = CascadeType.ALL, orphanRemoval = true)
private Set<Child> children = new HashSet<>();
...