Tweet
Tweet

Slide 1

Slide 1 text

S Q L F Á C I L N O A N D R O I D C O M Q U E R Y D S L E d s o n Ya n a g a @ y a n a g a # T D C 2 0 1 4

Slide 2

Slide 2 text

E D S O N YA N A G A • Bacharel em Ciência da Computação/UEM • Mestre em Engenharia Elétrica/UTFPR • Desenvolvedor Java desde 1997 • Administrador Unix desde 1999 • Líder Técnico na Produtec desde 2012 • Instrutor Líder da GlobalCode desde 2012

Slide 3

Slide 3 text

C E R T I F I C A Ç Õ E S • Oracle Certified Professional, Java Platform, Enterprise Edition 6 Enterprise JavaBeans Developer • Sun Certified Enterprise Architect for the Java Platform,Enterprise Edition 5 (i) • Certified ScrumMaster • Sun Certified Developer for Java Web Services 5 • Sun Certified Specialist for NetBeans IDE • Sun Certified Web Component Developer for J2EE 1.4 • Sun Certified Programmer for Java 2 Platform 1.4

Slide 4

Slide 4 text

No content

Slide 5

Slide 5 text

No content

Slide 6

Slide 6 text

No content

Slide 7

Slide 7 text

M Ó D U L O S PA R A : S Q L J PA M O N G O D B L U C E N E …

Slide 8

Slide 8 text

CriteriaQuery query = builder.createQuery();! Root men = query.from( Person.class );! Root women = query.from( Person.class );! Predicate menRestriction = builder.and(! ! builder.equal( men.get( Person_.gender ), Gender.MALE ),! ! builder.equal( men.get( Person_.relationshipStatus ),! RelationshipStatus.SINGLE ));! Predicate womenRestriction = builder.and(! ! builder.equal( women.get( Person_.gender ), Gender.FEMALE ),! ! builder.equal( women.get( Person_.relationshipStatus ),! RelationshipStatus.SINGLE ));! query.where( builder.and( menRestriction, womenRestriction ) );!

Slide 9

Slide 9 text

JPAQuery query = new JPAQuery(em);! QPerson men = new QPerson("men");! QPerson women = new QPerson("women");! query.from(men, women).where(! ! men.gender.eq(Gender.MALE),! ! men.relationshipStatus.eq(RelationshipStatus.SINGLE),! ! women.gender.eq(Gender.FEMALE),! ! women.relationshipStatus.eq(RelationshipStatus.SINGLE));!

Slide 10

Slide 10 text

No content

Slide 11

Slide 11 text

D ATA B A S E M I G R AT I O N S

Slide 12

Slide 12 text

J AVA E S Q L

Slide 13

Slide 13 text

No content

Slide 14

Slide 14 text

No content

Slide 15

Slide 15 text

S O F T W A R E M E L H O R PA R A U M M U N D O M E L H O R

Slide 16

Slide 16 text

E D S O N YA N A G A  ! e d s o n @ y a n a g a . c o m . b r  @ y a n a g a  w w w. y a n a g a . c o m . b r