Laravel Eloquent & Its Hidden Power

What is Eloquent
Provides ActiveRecord implementation to interact with database.
Each Table has corresponding Model.
Use Model to do CRUD operations with database.
Let’s See Hidden Powers of Eloquent, like clone a model, get changed values, server to server copy etc.

Transcript

1. LARAVEL LIVE INDIA 1 LEARN | CONTRIBUTE | EXPAND | SHARE
2. LARAVEL LIVE INDIA 2 Laravel Eloquent & Its Hidden Power
3. LARAVEL LIVE INDIA 3 What is Eloquent • Provides ActiveRecord implementation to interact with database. • Each Table has corresponding Model. • Use Model to do CRUD operations with database.
4. LARAVEL LIVE INDIA 4 While Working With Framework One Should Leverage Its Power.
5. LARAVEL LIVE INDIA 5 Let’s See Hidden Powers of Eloquent
6. LARAVEL LIVE INDIA 6 Clone a Model • Trick to make a clone of database row. • Use the replicate method of Eloquent
7. LARAVEL LIVE INDIA 7 DEMO
8. LARAVEL LIVE INDIA 8 Increment or Decrement Values • Trick to increase or decrease values of Number columns. • Use the increment or decrement method of Eloquent.
9. LARAVEL LIVE INDIA 9 DEMO
10. LARAVEL LIVE INDIA 10 Check if Record is Changed • Trick to determine if the model values are changed or not. • Use the isDirty method of eloquent.
11. LARAVEL LIVE INDIA 11 DEMO
12. LARAVEL LIVE INDIA 12 Get Original Values • Trick to get old value of model attributes. • Use the getOriginal method of eloquent.
13. LARAVEL LIVE INDIA 13 DEMO
14. LARAVEL LIVE INDIA 14 Get Changed Values • Trick to get all of model attributes whose values are changed. • Use the getChanges method of eloquent.
15. LARAVEL LIVE INDIA 15 DEMO
16. LARAVEL LIVE INDIA 16 QUIZ
17. LARAVEL LIVE INDIA 17 What is method of Eloquent to clone a row in table a) cloneRow() b) duplicateRow() c) replicate() d) copyRow() How to get old values of Model attributes using Eloquent? a) getInitialValue() b) getOriginalValue() c) getOldValue() d) getOriginal()
18. LARAVEL LIVE INDIA 18 What is method of Eloquent to clone a row in table a) cloneRow() b) duplicateRow() c) replicate() d) copyRow() How to get old values of Model attributes using Eloquent? a) getInitialValue() b) getOriginalValue() c) getOldValue() d) getOriginal()
19. LARAVEL LIVE INDIA 19 Accessors – Custom Values to Models • Allows you to create custom attribute to model. • This attributes / columns does not exist in table . • It’s created run time.
20. LARAVEL LIVE INDIA 2 0 DEMO
21. LARAVEL LIVE INDIA 21 Mutators – For Non Existing Columns • Opposite of accessors. • Use non exiting column in model. • Use mutator to map it to correct column in database.
22. LARAVEL LIVE INDIA 2 2 DEMO
23. LARAVEL LIVE INDIA 2 3 Eager Loading with $with • While working with relation ship get the data of related model immediately. • Set in model to always eager load related data. • Saves no of queries in database.
24. LARAVEL LIVE INDIA 2 4 DEMO
25. LARAVEL LIVE INDIA 2 5 Model Keys • Can be used fetch specific attribute or column. • Use method modelKeys provides by eloquent.
26. LARAVEL LIVE INDIA 2 6 DEMO
27. LARAVEL LIVE INDIA 2 7 QUIZ
28. LARAVEL LIVE INDIA 2 8 What is use of Accessors in Eloquent a) To access row in table. b) Appending custom values to models. c) To get access of database. d) To get access of table. What keyword is used for Eager loading? a) $fetch b) $eager c) $prefetch d) $with
29. LARAVEL LIVE INDIA 2 9 What is use of Accessors in Eloquent a) To access row in table. b) Appending custom values to models. c) To get access of database. d) To get access of table. What keyword is used for Eager loading? a) $fetch b) $eager c) $prefetch d) $with
30. LARAVEL LIVE INDIA 3 0 New Query • Can be used to add global WHERE condition. • Override new query in model and specify condition there.
31. LARAVEL LIVE INDIA 31 DEMO
32. LARAVEL LIVE INDIA 3 2 Server to Server or DB to DB Copy • Trick to have real time copy or record to different server or different database • Idea is to use connection property in Eloquent.
33. LARAVEL LIVE INDIA 3 3 DEMO
34. LARAVEL LIVE INDIA 3 4 Eloquent Observers • Kind of an event listeners for Model • Can be used with CRUD operations.
35. LARAVEL LIVE INDIA 3 5 DEMO
36. LARAVEL LIVE INDIA 3 6 Contact Me Website https://hiren.dev https://hirendave.tech Email hdave10@gmail.com Social Media https://twitter.com/hjdave https://www.facebook.com/davehiren
37. LARAVEL LIVE INDIA 3 7 Thank You