Gabriel Ramirez gabanox

🥷

Hiring AWS Instructors in Latam 🌎

AWS Hero

gabanox / test-data.sql

Created October 16, 2014 15:27

	insert into contact (first_name, last_name, birth_date) values ('Clarence', 'Ho', '1980-07-30');
	insert into contact (first_name, last_name, birth_date) values ('Scott', 'Tiger', '1990-11-02');
	insert into contact (first_name, last_name, birth_date) values ('John', 'Smith', '1964-02-28');

	insert into contact_tel_detail (contact_id, tel_type, tel_number) values (1, 'Mobile', '1234567890');
	insert into contact_tel_detail (contact_id, tel_type, tel_number) values (1, 'Home', '1234567890');
	insert into contact_tel_detail (contact_id, tel_type, tel_number) values (2, 'Home', '1234567890');

	insert into hobby (hobby_id) values ('Swimming');
	insert into hobby (hobby_id) values ('Jogging');

gabanox / schema.sql

Created October 16, 2014 15:27

	DROP TABLE IF EXISTS CONTACT_HOBBY_DETAIL;
	DROP TABLE IF EXISTS CONTACT_TEL_DETAIL;
	DROP TABLE IF EXISTS HOBBY;
	DROP TABLE IF EXISTS CONTACT;
	DROP TABLE IF EXISTS CONTACT_AUDIT;

	CREATE TABLE CONTACT (
	ID INT NOT NULL AUTO_INCREMENT
	, FIRST_NAME VARCHAR(60) NOT NULL
	, LAST_NAME VARCHAR(40) NOT NULL

gabanox / ContactServiceImpl.java

Created October 16, 2014 15:26

	/**
	* Created on Oct 18, 2011
	*/
	package com.company.app.service;

	import java.util.List;

	import org.springframework.beans.factory.annotation.Autowired;
	import org.springframework.stereotype.Repository;
	import org.springframework.stereotype.Service;

gabanox / ContactService.java

Created October 16, 2014 15:26

	/**
	* Created on Oct 17, 2011
	*/
	package com.company.app.service;

	import java.util.List;

	import com.company.app.domain.Contact;
	public interface ContactService {

gabanox / ContactRepository.java

Created October 16, 2014 15:26

	/**
	* Created on Oct 18, 2011
	*/
	package com.company.app.repository;

	import java.util.List;


	import org.springframework.data.repository.CrudRepository;

gabanox / Hobby.java

Created October 16, 2014 15:25

	/**
	* Created on Oct 12, 2011
	*/
	package com.company.app.domain;

	import java.io.Serializable;
	import java.util.HashSet;
	import java.util.Set;

	import javax.persistence.Column;

gabanox / ContactTelDetail.java

Created October 16, 2014 15:25

	/**
	* Created on Oct 12, 2011
	*/
	package com.company.app.domain;

	import static javax.persistence.GenerationType.IDENTITY;

	import java.io.Serializable;

	import javax.persistence.Column;

gabanox / Contact.java

Created October 16, 2014 15:25

	/**
	* Created on Oct 12, 2011
	*/
	package com.company.app.domain;

	import java.io.Serializable;
	import java.util.Date;
	import java.util.HashSet;
	import java.util.Set;

gabanox / ContactTelDetail.java

Created October 16, 2014 13:40

	/**
	* Created on Oct 12, 2011
	*/
	package com.company.hibernate.domain;

	import static javax.persistence.GenerationType.IDENTITY;

	import java.io.Serializable;

	import javax.persistence.Column;

gabanox / test-data.sql

Created October 16, 2014 13:39

	insert into contact (first_name, last_name, birth_date) values ('Clarence', 'Ho', '1980-07-30');
	insert into contact (first_name, last_name, birth_date) values ('Scott', 'Tiger', '1990-11-02');
	insert into contact (first_name, last_name, birth_date) values ('John', 'Smith', '1964-02-28');

	insert into contact_tel_detail (contact_id, tel_type, tel_number) values (1, 'Mobile', '1234567890');
	insert into contact_tel_detail (contact_id, tel_type, tel_number) values (1, 'Home', '1234567890');
	insert into contact_tel_detail (contact_id, tel_type, tel_number) values (2, 'Home', '1234567890');

	insert into hobby (hobby_id) values ('Swimming');
	insert into hobby (hobby_id) values ('Jogging');