Slick - The Structured Way

Slick (part of the Typesafe stack) is a modern database query and access library for Scala, based on functional principles. It allows you to write queries as if you are working with regular Scala collections.

In this presentation we’ll have a deep dive into how you can use this library in real projects. How to map your tables and queries to structured objects, how to create more advanced queries with multiple joins, how to setup integration tests against an in-memory database and how you can integrate Slick with the Play Framework are all questions which will have been answered at the end of this session.

Transcript

1. Slick The Structured Way
2. YENNICK? YANNICK? JANNICK? Reactive Applications Consultant Certified Typesafe “Fast Track to Scala” trainer @SlevinBE yennicktrevels.com Yennick.Trevels@xploregroup.be
3. WHY SLICK? Option(Anorm).orElse(Hibernate).orElse(Slick) èPure Scala èImmutable data structures èDB agnostic code èType safety
4. TALK MOTIVATION
5. MEAT OF THE TALK
6. ESSENTIALS Build queries with Scala Lifted embedding Query result à result rows ID TITLE ID FIRSTNAME LASTNAME 1 “Scala” 10 Yennick Trevels 1 “Scala” 11 Eric Loots 2 “Slick” 12 Filip Maelbrancke
7. IMPORTS Database specific Database agnostic import è use Play-Slick plugin
8. SESSION SCOPE
9. TRANSACTION SCOPE
10. SAMPLE DATABASE MEETING DOCUMENT ATTENDEE_LINK ATTENDEE ID … MEETING_ID ATTENDEE_ID ID … MEETING_ID ID … ID …
11. LEVEL 1: MAPPING TABLES
12. TABLE MAPPING: MEETING
13. TABLE MAPPING: MEETING
14. TABLE MAPPING: LINK TABLE
15. LEVEL 2: BASIC QUERIES
16. FILTER STATEMENTS Slick SQL è === instead of ==
17. FILTER STATEMENTS Slick èBrackets èPut || or && at end of line ↵  
18. SORTING Slick SQL
19. EXISTS Slick SQL
20. DEFINING THE RESULT Slick SQL Result
21. DEFINING THE RESULT Slick SQL Result
22. DEFINING THE RESULT Slick meetings.list è List[Meeting] meetings.first è Meeting or NoSuchElementException meetings.firstOption è Option[Meeting]
23. LEVEL 3: ADVANCED QUERIES
24. INNER JOIN Slick SQL Result
25. INNER JOIN (RESULT MAPPING) Slick Result
26. OUTER JOINS (THE PROBLEM) Slick
27. OUTER JOINS (THE PROBLEM) ID TITLE ID MEETING_ID ATTENDEE_ID 1 “Scala” NULL NULL NULL 2 “Slick” 10 2 20 3 “Slick” 11 2 21 ID TITLE 1 “Scala” 2 “Slick” ID MEETING_ID ATTENDEE_ID 10 2 20 11 2 21 Left Join Ref: http://www.slideshare.net/skillsmatter/patterns-for-slick-database-applications
28. OUTER JOINS Slick Result
29. OUTER JOINS (RESULT TRANSF.) Slick
30. THE ? FUNCTION Solution expected somewhere this year
31. LEVEL 4: INSERT/UPDATE/DELETE
32. INSERT Slick SQL
33. UPDATE Slick SQL
34. DELETE Slick SQL
35. LEVEL 5: SLICK + PLAY
36. APPLICATION.CONF
37. DATABASE AGNOSTIC IMPORTS
38. DB WRAPPER
39. LEVEL 6: INTEGRATION TESTING
40. TABLE CREATION Using Play-Slick plugin classes
41. IN-MEMORY DATABASE CONFIG
42. TEST DATA SETUP Just use Slick…
43. CONCLUSION
44. THOUGHTS ON SLICK + Lightweight + Level of control + Production ready -  Documentation -  Generated Queries (readability)
45. Development Coaching Training Hello Scala seminar June 25th 2014 Fast Track to Scala October 09th 2014 Fast Track to Akka with Scala November 04th 2014 Yennick.Trevels@xploregroup.be CONTACT US