Tweet
Tweet

Slide 1

Slide 1 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers The Database Layer of Yii Framework 2.0 Carsten Brandt June 16, 2017 - Yiiconf, Ìîñêâà Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 2

Slide 2 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers Table of Contents 1 Why do we need DB abstraction? 2 Yii DB abstraction layers DAO Query Builder Active Record 3 Switching between layers Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 3

Slide 3 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers Why do we need DB abstraction? code simplication and readablity Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 4

Slide 4 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers Why do we need DB abstraction? code simplication and readablity reusable code and MVC separation Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 5

Slide 5 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers Why do we need DB abstraction? code simplication and readablity reusable code and MVC separation security enhancements Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 6

Slide 6 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record 3 Layers DAO Database Access Objects Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 7

Slide 7 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record 3 Layers DAO Database Access Objects Query Builder Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 8

Slide 8 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record 3 Layers DAO Database Access Objects Query Builder Active Record Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 9

Slide 9 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record 3 Layers DAO Database Access Objects Query Builder Active Record yii\db\Command Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 10

Slide 10 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record 3 Layers DAO Database Access Objects Query Builder Active Record yii\db\Command yii\db\Query uses Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 11

Slide 11 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record 3 Layers DAO Database Access Objects Query Builder Active Record yii\db\Command yii\db\Query yii\db\ActiveQuery uses extends Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 12

Slide 12 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db = new C o n n e c t i o n ( [ ' dsn ' = > ' m y s q l : h o s t=l o c a l h o s t ; dbname=example ' , ' username ' = > ' cebe ' , ' p a s s w o r d ' = > ' 1 3 3 7 ' , ] ) ; $db−>open ( ) ; $command = $db−>createCommand ( " SELECT ∗ FROM u s e r " ) ; $ u s e r = $command−>queryOne ( ) ; $ u s e r s = $command−>q u e r y A l l ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 13

Slide 13 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db = new C o n n e c t i o n ( [ ' dsn ' = > ' m y s q l : h o s t=l o c a l h o s t ; dbname=example ' , ' username ' = > ' cebe ' , ' p a s s w o r d ' = > ' 1 3 3 7 ' , ] ) ; $db−>open ( ) ; $command = $db−>createCommand ( " SELECT ∗ FROM u s e r " ) ; $ u s e r = $command−>queryOne ( ) ; $ u s e r s = $command−>q u e r y A l l ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 14

Slide 14 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db = new C o n n e c t i o n ( [ ' dsn ' = > ' m y s q l : h o s t=l o c a l h o s t ; dbname=example ' , ' username ' = > ' cebe ' , ' p a s s w o r d ' = > ' 1 3 3 7 ' , ] ) ; $db−>open ( ) ; $command = $db−>createCommand ( " SELECT ∗ FROM u s e r " ) ; $ u s e r = $command−>queryOne ( ) ; $ u s e r s = $command−>q u e r y A l l ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 15

Slide 15 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db = new C o n n e c t i o n ( [ ' dsn ' = > ' m y s q l : h o s t=l o c a l h o s t ; dbname=example ' , ' username ' = > ' cebe ' , ' p a s s w o r d ' = > ' 1 3 3 7 ' , ] ) ; $db−>open ( ) ; $command = $db−>createCommand ( " SELECT ∗ FROM u s e r " ) ; $ u s e r = $command−>queryOne ( ) ; $ u s e r s = $command−>q u e r y A l l ( ) ; yii\db\Connection PHP PDO uses Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 16

Slide 16 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db = new C o n n e c t i o n ( [ ' dsn ' = > ' m y s q l : h o s t=l o c a l h o s t ; dbname=example ' , ' username ' = > ' cebe ' , ' p a s s w o r d ' = > ' 1 3 3 7 ' , ] ) ; $db−>open ( ) ; $command = $db−>createCommand ( " SELECT ∗ FROM u s e r " ) ; $ u s e r = $command−>queryOne ( ) ; $ u s e r s = $command−>q u e r y A l l ( ) ; yii\db\Connection PHP PDO uses Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 17

Slide 17 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db = new C o n n e c t i o n ( [ ' dsn ' = > ' m y s q l : h o s t=l o c a l h o s t ; dbname=example ' , ' username ' = > ' cebe ' , ' p a s s w o r d ' = > ' 1 3 3 7 ' , ] ) ; $db−>open ( ) ; $command = $db−>createCommand ( " SELECT ∗ FROM u s e r " ) ; $ u s e r = $command−>queryOne ( ) ; $ u s e r s = $command−>q u e r y A l l ( ) ; yii\db\Connection PHP PDO uses Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 18

Slide 18 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db = new C o n n e c t i o n ( [ ' dsn ' = > ' m y s q l : h o s t=l o c a l h o s t ; dbname=example ' , ' username ' = > ' cebe ' , ' p a s s w o r d ' = > ' 1 3 3 7 ' , ] ) ; $db−>open ( ) ; $command = $db−>createCommand ( " SELECT ∗ FROM u s e r " ) ; $ u s e r = $command−>queryOne ( ) ; $ u s e r s = $command−>q u e r y A l l ( ) ; yii\db\Connection PHP PDO uses Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 19

Slide 19 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db = new C o n n e c t i o n ( [ ' dsn ' = > ' m y s q l : h o s t=l o c a l h o s t ; dbname=example ' , ' username ' = > ' cebe ' , ' p a s s w o r d ' = > ' 1 3 3 7 ' , ] ) ; $db−>open ( ) ; $command = $db−>createCommand ( " SELECT ∗ FROM u s e r " ) ; $ u s e r = $command−>queryOne ( ) ; $ u s e r s = $command−>q u e r y A l l ( ) ; yii\db\Connection PHP PDO uses Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 20

Slide 20 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db−>createCommand()−> i n s e r t ( ' u s e r s ' , [ ' name ' = > ' CeBe ' , ' e m a i l ' = > ' m a i l @ c e b e . cc ' , ' c r e a t e d _ a t ' = > t i m e ( ) , ' updated_at ' = > t i m e ( ) , ])−> e x e c u t e ( ) ; $db−>createCommand()−> u p d a t e ( ' u s e r s ' , // t a b l e [ ' name ' = > ' C a r s t e n ' ] , // SET "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; $db−>createCommand()−> d e l e t e ( ' u s e r s ' , // t a b l e "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 21

Slide 21 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db−>createCommand()−> i n s e r t ( ' u s e r s ' , [ ' name ' = > ' CeBe ' , ' e m a i l ' = > ' m a i l @ c e b e . cc ' , ' c r e a t e d _ a t ' = > t i m e ( ) , ' updated_at ' = > t i m e ( ) , ])−> e x e c u t e ( ) ; $db−>createCommand()−> u p d a t e ( ' u s e r s ' , // t a b l e [ ' name ' = > ' C a r s t e n ' ] , // SET "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; $db−>createCommand()−> d e l e t e ( ' u s e r s ' , // t a b l e "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 22

Slide 22 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db−>createCommand()−> i n s e r t ( ' u s e r s ' , [ ' name ' = > ' CeBe ' , ' e m a i l ' = > ' m a i l @ c e b e . cc ' , ' c r e a t e d _ a t ' = > t i m e ( ) , ' updated_at ' = > t i m e ( ) , ])−> e x e c u t e ( ) ; $db−>createCommand()−> u p d a t e ( ' u s e r s ' , // t a b l e [ ' name ' = > ' C a r s t e n ' ] , // SET "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; $db−>createCommand()−> d e l e t e ( ' u s e r s ' , // t a b l e "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 23

Slide 23 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db−>createCommand()−> i n s e r t ( ' u s e r s ' , [ ' name ' = > ' CeBe ' , ' e m a i l ' = > ' m a i l @ c e b e . cc ' , ' c r e a t e d _ a t ' = > t i m e ( ) , ' updated_at ' = > t i m e ( ) , ])−> e x e c u t e ( ) ; $db−>createCommand()−> u p d a t e ( ' u s e r s ' , // t a b l e [ ' name ' = > ' C a r s t e n ' ] , // SET "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; $db−>createCommand()−> d e l e t e ( ' u s e r s ' , // t a b l e "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 24

Slide 24 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db−>createCommand()−> i n s e r t ( ' u s e r s ' , [ ' name ' = > ' CeBe ' , ' e m a i l ' = > ' m a i l @ c e b e . cc ' , ' c r e a t e d _ a t ' = > t i m e ( ) , ' updated_at ' = > t i m e ( ) , ])−> e x e c u t e ( ) ; $db−>createCommand()−> u p d a t e ( ' u s e r s ' , // t a b l e [ ' name ' = > ' C a r s t e n ' ] , // SET "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; $db−>createCommand()−> d e l e t e ( ' u s e r s ' , // t a b l e "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 25

Slide 25 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db−>createCommand()−> i n s e r t ( ' u s e r s ' , [ ' name ' = > ' CeBe ' , ' e m a i l ' = > ' m a i l @ c e b e . cc ' , ' c r e a t e d _ a t ' = > t i m e ( ) , ' updated_at ' = > t i m e ( ) , ])−> e x e c u t e ( ) ; $db−>createCommand()−> u p d a t e ( ' u s e r s ' , // t a b l e [ ' name ' = > ' C a r s t e n ' ] , // SET "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; $db−>createCommand()−> d e l e t e ( ' u s e r s ' , // t a b l e "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 26

Slide 26 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db−>createCommand()−> i n s e r t ( ' u s e r s ' , [ ' name ' = > ' CeBe ' , ' e m a i l ' = > ' m a i l @ c e b e . cc ' , ' c r e a t e d _ a t ' = > t i m e ( ) , ' updated_at ' = > t i m e ( ) , ])−> e x e c u t e ( ) ; $db−>createCommand()−> u p d a t e ( ' u s e r s ' , // t a b l e [ ' name ' = > ' C a r s t e n ' ] , // SET "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; $db−>createCommand()−> d e l e t e ( ' u s e r s ' , // t a b l e "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 27

Slide 27 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db−>createCommand()−> i n s e r t ( ' u s e r s ' , [ ' name ' = > ' CeBe ' , ' e m a i l ' = > ' m a i l @ c e b e . cc ' , ' c r e a t e d _ a t ' = > t i m e ( ) , ' updated_at ' = > t i m e ( ) , ])−> e x e c u t e ( ) ; $db−>createCommand()−> u p d a t e ( ' u s e r s ' , // t a b l e [ ' name ' = > ' C a r s t e n ' ] , // SET "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; $db−>createCommand()−> d e l e t e ( ' u s e r s ' , // t a b l e "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 28

Slide 28 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db−>createCommand()−> i n s e r t ( ' u s e r s ' , [ ' name ' = > ' CeBe ' , ' e m a i l ' = > ' m a i l @ c e b e . cc ' , ' c r e a t e d _ a t ' = > t i m e ( ) , ' updated_at ' = > t i m e ( ) , ])−> e x e c u t e ( ) ; $db−>createCommand()−> u p d a t e ( ' u s e r s ' , // t a b l e [ ' name ' = > ' C a r s t e n ' ] , // SET "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; $db−>createCommand()−> d e l e t e ( ' u s e r s ' , // t a b l e "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 29

Slide 29 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db−>createCommand()−> i n s e r t ( ' u s e r s ' , [ ' name ' = > ' CeBe ' , ' e m a i l ' = > ' m a i l @ c e b e . cc ' , ' c r e a t e d _ a t ' = > t i m e ( ) , ' updated_at ' = > t i m e ( ) , ])−> e x e c u t e ( ) ; $db−>createCommand()−> u p d a t e ( ' u s e r s ' , // t a b l e [ ' name ' = > ' C a r s t e n ' ] , // SET "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; $db−>createCommand()−> d e l e t e ( ' u s e r s ' , // t a b l e "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 30

Slide 30 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Command Usage $db−>createCommand()−> i n s e r t ( ' u s e r s ' , [ ' name ' = > ' CeBe ' , ' e m a i l ' = > ' m a i l @ c e b e . cc ' , ' c r e a t e d _ a t ' = > t i m e ( ) , ' updated_at ' = > t i m e ( ) , ])−> e x e c u t e ( ) ; $db−>createCommand()−> u p d a t e ( ' u s e r s ' , // t a b l e [ ' name ' = > ' C a r s t e n ' ] , // SET "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; $db−>createCommand()−> d e l e t e ( ' u s e r s ' , // t a b l e "name = ' C a r s t e n ' " // WHERE ])−> e x e c u t e ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 31

Slide 31 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Other DAO features Transactions Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 32

Slide 32 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Other DAO features Transactions Read/Write splitting for Master-Slave setup Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 33

Slide 33 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Other DAO features Transactions Read/Write splitting for Master-Slave setup Connection Failover Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 34

Slide 34 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Other DAO features Transactions Read/Write splitting for Master-Slave setup Connection Failover Yii features: Events, Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 35

Slide 35 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Other DAO features Transactions Read/Write splitting for Master-Slave setup Connection Failover Yii features: Events, Conguration, Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 36

Slide 36 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Other DAO features Transactions Read/Write splitting for Master-Slave setup Connection Failover Yii features: Events, Conguration, DI Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 37

Slide 37 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder $ q u e r y = ( new y i i \ db \ Query ) −> s e l e c t ( [ ' name ' , ' e m a i l ' ] ) −>from ( ' u s e r s ' ) −>wh er e ( [ ' i d ' = > 4 2 ] ) ; $ u s e r = $ q u e r y −>one ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 38

Slide 38 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder SELECT name , email FROM users WHERE id = 42 $ q u e r y = ( new y i i \ db \ Query ) −> s e l e c t ( [ ' name ' , ' e m a i l ' ] ) −>from ( ' u s e r s ' ) −>wh er e ( [ ' i d ' = > 4 2 ] ) ; $ u s e r = $ q u e r y −>one ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 39

Slide 39 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder SELECT name , email FROM users WHERE id = 42 $ q u e r y = ( new y i i \ db \ Query ) −> s e l e c t ( [ ' name ' , ' e m a i l ' ] ) −>from ( ' u s e r s ' ) −>wh er e ( [ ' i d ' = > 4 2 ] ) ; $ u s e r = $ q u e r y −>one ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 40

Slide 40 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder SELECT name , email FROM users WHERE id = 42 $ q u e r y = ( new y i i \ db \ Query ) −> s e l e c t ( [ ' name ' , ' e m a i l ' ] ) −>from ( ' u s e r s ' ) −>wh er e ( [ ' i d ' = > $_GET [ ' i d ' ] ] ) ; $ u s e r = $ q u e r y −>one ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 41

Slide 41 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder SELECT name , email FROM users WHERE id = 42 $ q u e r y = ( new y i i \ db \ Query ) −> s e l e c t ( [ ' name ' , ' e m a i l ' ] ) −>from ( ' u s e r s ' ) −>wh er e ( ' i d = : i d ' , [ ' : i d ' = > $_GET [ ' i d ' ] ] ) ; $ u s e r = $ q u e r y −>one ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 42

Slide 42 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder SELECT name , email FROM users WHERE id = 42 $ q u e r y = ( new y i i \ db \ Query ) −> s e l e c t ( [ ' name ' , ' e m a i l ' ] ) −>from ( ' u s e r s ' ) −>wh er e ( ' i d = : i d ' , [ ' : i d ' = > $_GET [ ' i d ' ] ] ) ; $ u s e r = $ q u e r y −>one ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 43

Slide 43 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder - Subqueries $ a c t i v e Q u e r y = ( new Query ) −> s e l e c t ( ' i d ' ) −>from ( ' c a t e g o r i e s ' ) −>wh er e ( [ ' a c t i v e ' = > 1 ] ) ; $ q u e r y = ( new Query ) −>from ( ' a r t i c l e ' ) −>wh er e ( [ ' c a t e g o r y _ i d ' = > $ a c t i v e Q u e r y ] ) ; $ a r t i c l e s I n A c t i v e C a t e g o r i e s = $ q u e r y −> a l l ( ) ; SELECT ∗ FROM a r t i c l e WHERE category_id IN ( SELECT id FROM c a t e g o r i e s WHERE a c t i v e=1 ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 44

Slide 44 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder - Subqueries $ a c t i v e Q u e r y = ( new Query ) −> s e l e c t ( ' i d ' ) −>from ( ' c a t e g o r i e s ' ) −>wh er e ( [ ' a c t i v e ' = > 1 ] ) ; $ q u e r y = ( new Query ) −>from ( ' a r t i c l e ' ) −>wh er e ( [ ' c a t e g o r y _ i d ' = > $ a c t i v e Q u e r y ] ) ; $ a r t i c l e s I n A c t i v e C a t e g o r i e s = $ q u e r y −> a l l ( ) ; SELECT ∗ FROM a r t i c l e WHERE category_id IN ( SELECT id FROM c a t e g o r i e s WHERE a c t i v e=1 ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 45

Slide 45 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder - Subqueries $ a c t i v e Q u e r y = ( new Query ) −> s e l e c t ( ' i d ' ) −>from ( ' c a t e g o r i e s ' ) −>wh er e ( [ ' a c t i v e ' = > 1 ] ) ; $ q u e r y = ( new Query ) −>from ( ' a r t i c l e ' ) −>wh er e ( [ ' c a t e g o r y _ i d ' = > $ a c t i v e Q u e r y ] ) ; $ a r t i c l e s I n A c t i v e C a t e g o r i e s = $ q u e r y −> a l l ( ) ; SELECT ∗ FROM a r t i c l e WHERE category_id IN ( SELECT id FROM c a t e g o r i e s WHERE a c t i v e=1 ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 46

Slide 46 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder - Subqueries $ a c t i v e Q u e r y = ( new Query ) −> s e l e c t ( ' i d ' ) −>from ( ' c a t e g o r i e s ' ) −>wh er e ( [ ' a c t i v e ' = > 1 ] ) ; $ q u e r y = ( new Query ) −>from ( ' a r t i c l e ' ) −>wh er e ( [ ' c a t e g o r y _ i d ' = > $ a c t i v e Q u e r y ] ) ; $ a r t i c l e s I n A c t i v e C a t e g o r i e s = $ q u e r y −> a l l ( ) ; SELECT ∗ FROM a r t i c l e WHERE category_id IN ( SELECT id FROM c a t e g o r i e s WHERE a c t i v e=1 ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 47

Slide 47 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder - Subqueries $ a c t i v e Q u e r y = ( new Query ) −> s e l e c t ( ' i d ' ) −>from ( ' c a t e g o r i e s ' ) −>wh er e ( [ ' a c t i v e ' = > 1 ] ) ; $ q u e r y = ( new Query ) −>from ( ' a r t i c l e ' ) −>wh er e ( [ ' c a t e g o r y _ i d ' = > $ a c t i v e Q u e r y ] ) ; $ a r t i c l e s I n A c t i v e C a t e g o r i e s = $ q u e r y −> a l l ( ) ; select() Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 48

Slide 48 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder - Subqueries $ a c t i v e Q u e r y = ( new Query ) −> s e l e c t ( ' i d ' ) −>from ( ' c a t e g o r i e s ' ) −>wh er e ( [ ' a c t i v e ' = > 1 ] ) ; $ q u e r y = ( new Query ) −>from ( ' a r t i c l e ' ) −>wh er e ( [ ' c a t e g o r y _ i d ' = > $ a c t i v e Q u e r y ] ) ; $ a r t i c l e s I n A c t i v e C a t e g o r i e s = $ q u e r y −> a l l ( ) ; select() from() Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 49

Slide 49 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder - Subqueries $ a c t i v e Q u e r y = ( new Query ) −> s e l e c t ( ' i d ' ) −>from ( ' c a t e g o r i e s ' ) −>wh er e ( [ ' a c t i v e ' = > 1 ] ) ; $ q u e r y = ( new Query ) −>from ( ' a r t i c l e ' ) −>wh er e ( [ ' c a t e g o r y _ i d ' = > $ a c t i v e Q u e r y ] ) ; $ a r t i c l e s I n A c t i v e C a t e g o r i e s = $ q u e r y −> a l l ( ) ; select() from() join() Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 50

Slide 50 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder - Subqueries $ a c t i v e Q u e r y = ( new Query ) −> s e l e c t ( ' i d ' ) −>from ( ' c a t e g o r i e s ' ) −>wh er e ( [ ' a c t i v e ' = > 1 ] ) ; $ q u e r y = ( new Query ) −>from ( ' a r t i c l e ' ) −>wh er e ( [ ' c a t e g o r y _ i d ' = > $ a c t i v e Q u e r y ] ) ; $ a r t i c l e s I n A c t i v e C a t e g o r i e s = $ q u e r y −> a l l ( ) ; select() from() join() where() Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 51

Slide 51 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder - Subqueries $ a c t i v e Q u e r y = ( new Query ) −> s e l e c t ( ' i d ' ) −>from ( ' c a t e g o r i e s ' ) −>wh er e ( [ ' a c t i v e ' = > 1 ] ) ; $ q u e r y = ( new Query ) −>from ( ' a r t i c l e ' ) −>wh er e ( [ ' c a t e g o r y _ i d ' = > $ a c t i v e Q u e r y ] ) ; $ a r t i c l e s I n A c t i v e C a t e g o r i e s = $ q u e r y −> a l l ( ) ; select() from() join() where() union() Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 52

Slide 52 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder SQL as string, vs. real code Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 53

Slide 53 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder SQL as string, vs. real code Easier to create queries Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 54

Slide 54 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder SQL as string, vs. real code Easier to create queries More secure Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 55

Slide 55 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Query Builder SQL as string, vs. real code Easier to create queries More secure Separation of code Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 56

Slide 56 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record c l a s s U s e r e x t e n d s y i i \ db \ A c t i v e R e c o r d { p u b l i c s t a t i c f u n c t i o n tableName ( ) { r e t u r n ' u s e r s ' ; } } users id name 1 alice 2 bob 3 . . . . . . Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 57

Slide 57 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record c l a s s U s e r e x t e n d s y i i \ db \ A c t i v e R e c o r d { p u b l i c s t a t i c f u n c t i o n tableName ( ) { r e t u r n ' u s e r s ' ; } } users id name 1 alice 2 bob 3 . . . . . . Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 58

Slide 58 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record yii\db\ActiveRecord Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 59

Slide 59 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record yii\db\ActiveRecord yii\db\ActiveQuery nd() Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 60

Slide 60 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record yii\db\ActiveRecord yii\db\ActiveQuery nd() yii\db\Query extends Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 61

Slide 61 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record yii\db\ActiveRecord yii\db\ActiveQuery nd() yii\db\Query extends User extends Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 62

Slide 62 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record yii\db\ActiveRecord yii\db\ActiveQuery nd() yii\db\Query extends User extends UserQuery extends nd() Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 63

Slide 63 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record yii\db\ActiveRecord yii\db\ActiveQuery nd() yii\db\Query extends User extends UserQuery extends nd() yii\base\Model extends Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 64

Slide 64 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record $ u s e r = new U s e r ( ) ; $ u s e r −>a t t r i b u t e s = $_POST [ ' User ' ] ; i f ( $ u s e r −>s a v e ( ) ) { e c h o " s u c c e s s ! " ; } e l s e { e c h o " i n v a l i d d a t a : " . p r i n t _ r ( $ u s e r −>g e t E r r o r s ( ) ) ; } Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 65

Slide 65 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record $ u s e r = new U s e r ( ) ; $ u s e r −>a t t r i b u t e s = $_POST [ ' User ' ] ; i f ( $ u s e r −>s a v e ( ) ) { e c h o " s u c c e s s ! " ; } e l s e { e c h o " i n v a l i d d a t a : " . p r i n t _ r ( $ u s e r −>g e t E r r o r s ( ) ) ; } Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 66

Slide 66 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record $ u s e r = new U s e r ( ) ; $ u s e r −>a t t r i b u t e s = $_POST [ ' User ' ] ; i f ( $ u s e r −>s a v e ( ) ) { e c h o " s u c c e s s ! " ; } e l s e { e c h o " i n v a l i d d a t a : " . p r i n t _ r ( $ u s e r −>g e t E r r o r s ( ) ) ; } Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 67

Slide 67 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record $ u s e r = new U s e r ( ) ; $ u s e r −>a t t r i b u t e s = $_POST [ ' User ' ] ; i f ( $ u s e r −>s a v e ( ) ) { e c h o " s u c c e s s ! " ; } e l s e { e c h o " i n v a l i d d a t a : " . p r i n t _ r ( $ u s e r −>g e t E r r o r s ( ) ) ; } Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 68

Slide 68 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record $ u s e r = new U s e r ( ) ; $ u s e r −>a t t r i b u t e s = $_POST [ ' User ' ] ; i f ( $ u s e r −>s a v e ( ) ) { e c h o " s u c c e s s ! " ; } e l s e { e c h o " i n v a l i d d a t a : " . p r i n t _ r ( $ u s e r −>g e t E r r o r s ( ) ) ; } Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 69

Slide 69 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record $ a c t i v e U s e r s = U s e r : : f i n d ( ) −>wh er e ( [ ' a c t i v e ' = > 1 ] ) −>o r d e r B y ( ' name ' ) −> a l l ( ) ; $ u s e r = U s e r : : f i n d ()−> w he r e ( [ ' i d ' = > 1])−> one ( ) ; $ u s e r = U s e r : : f i n d O n e ( 1 ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 70

Slide 70 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record $ a c t i v e U s e r s = U s e r : : f i n d ( ) −>wh er e ( [ ' a c t i v e ' = > 1 ] ) −>o r d e r B y ( ' name ' ) −> a l l ( ) ; $ u s e r = U s e r : : f i n d ()−> w he r e ( [ ' i d ' = > 1])−> one ( ) ; $ u s e r = U s e r : : f i n d O n e ( 1 ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 71

Slide 71 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record $ a c t i v e U s e r s = U s e r : : f i n d ( ) −>wh er e ( [ ' a c t i v e ' = > 1 ] ) −>o r d e r B y ( ' name ' ) −> a l l ( ) ; $ u s e r = U s e r : : f i n d ()−> w he r e ( [ ' i d ' = > 1])−> one ( ) ; $ u s e r = U s e r : : f i n d O n e ( 1 ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 72

Slide 72 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record $ a c t i v e U s e r s = U s e r : : f i n d ( ) −>wh er e ( [ ' a c t i v e ' = > 1 ] ) −>o r d e r B y ( ' name ' ) −> a l l ( ) ; $ u s e r = U s e r : : f i n d ()−> w he r e ( [ ' i d ' = > 1])−> one ( ) ; $ u s e r = U s e r : : f i n d O n e ( 1 ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 73

Slide 73 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record $ a c t i v e U s e r s = U s e r : : f i n d ( ) −>wh er e ( [ ' a c t i v e ' = > 1 ] ) −>o r d e r B y ( ' name ' ) −> a l l ( ) ; $ u s e r = U s e r : : f i n d ()−> w he r e ( [ ' i d ' = > 1])−> one ( ) ; $ u s e r = U s e r : : f i n d O n e ( 1 ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 74

Slide 74 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record $ a c t i v e U s e r s = U s e r : : f i n d ( ) −>wh er e ( [ ' a c t i v e ' = > 1 ] ) −>o r d e r B y ( ' name ' ) −> a l l ( ) ; $ u s e r = U s e r : : f i n d ()−> w he r e ( [ ' i d ' = > 1])−> one ( ) ; $ u s e r = U s e r : : f i n d O n e ( 1 ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 75

Slide 75 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations c l a s s U s e r e x t e n d s y i i \ db \ A c t i v e R e c o r d { // . . . p u b l i c f u n c t i o n g e t P r o f i l e ( ) { r e t u r n $ t h i s −>hasOne ( P r o f i l e : : c l a s s , [ ' u s e r _ i d ' = > ' i d ' ] ) ; } p u b l i c f u n c t i o n g e t P o s t s ( ) { r e t u r n $ t h i s −>hasMany ( P o s t : : c l a s s , [ ' u s e r _ i d ' = > ' i d ' ] ) ; } } // SELECT ∗ FROM u s e r s WHERE i d = 1 ; $ u s e r = U s e r : : f i n d O n e ( 1 ) ; // SELECT ∗ FROM p r o f i l e WHERE u s e r _ i d = 1 ; $ p r o f i l e = $ u s e r −> p r o f i l e ; // P r o f i l e // SELECT ∗ FROM p o s t s WHERE u s e r _ i d = 1 ; $ p o s t s = $ u s e r −>p o s t s ; // P o s t [ ] $ p o s t Q u e r y = $ u s e r −>g e t P o s t s ()−> o r d e r B y ( ' c r e a t e d _ a t ' ) ; // SELECT ∗ FROM p o s t s WHERE u s e r _ i d = 1 ORDER BY c r e a t e d _ a t ; $ p o s t s = $ p o s t Q u e r y −> a l l ( ) ; // P o s t [ ] Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 76

Slide 76 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations c l a s s U s e r e x t e n d s y i i \ db \ A c t i v e R e c o r d { // . . . p u b l i c f u n c t i o n g e t P r o f i l e ( ) { r e t u r n $ t h i s −>hasOne ( P r o f i l e : : c l a s s , [ ' u s e r _ i d ' = > ' i d ' ] ) ; } p u b l i c f u n c t i o n g e t P o s t s ( ) { r e t u r n $ t h i s −>hasMany ( P o s t : : c l a s s , [ ' u s e r _ i d ' = > ' i d ' ] ) ; } } // SELECT ∗ FROM u s e r s WHERE i d = 1 ; $ u s e r = U s e r : : f i n d O n e ( 1 ) ; // SELECT ∗ FROM p r o f i l e WHERE u s e r _ i d = 1 ; $ p r o f i l e = $ u s e r −> p r o f i l e ; // P r o f i l e // SELECT ∗ FROM p o s t s WHERE u s e r _ i d = 1 ; $ p o s t s = $ u s e r −>p o s t s ; // P o s t [ ] $ p o s t Q u e r y = $ u s e r −>g e t P o s t s ()−> o r d e r B y ( ' c r e a t e d _ a t ' ) ; // SELECT ∗ FROM p o s t s WHERE u s e r _ i d = 1 ORDER BY c r e a t e d _ a t ; $ p o s t s = $ p o s t Q u e r y −> a l l ( ) ; // P o s t [ ] Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 77

Slide 77 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations c l a s s U s e r e x t e n d s y i i \ db \ A c t i v e R e c o r d { // . . . p u b l i c f u n c t i o n g e t P r o f i l e ( ) { r e t u r n $ t h i s −>hasOne ( P r o f i l e : : c l a s s , [ ' u s e r _ i d ' = > ' i d ' ] ) ; } p u b l i c f u n c t i o n g e t P o s t s ( ) { r e t u r n $ t h i s −>hasMany ( P o s t : : c l a s s , [ ' u s e r _ i d ' = > ' i d ' ] ) ; } } // SELECT ∗ FROM u s e r s WHERE i d = 1 ; $ u s e r = U s e r : : f i n d O n e ( 1 ) ; // SELECT ∗ FROM p r o f i l e WHERE u s e r _ i d = 1 ; $ p r o f i l e = $ u s e r −> p r o f i l e ; // P r o f i l e // SELECT ∗ FROM p o s t s WHERE u s e r _ i d = 1 ; $ p o s t s = $ u s e r −>p o s t s ; // P o s t [ ] $ p o s t Q u e r y = $ u s e r −>g e t P o s t s ()−> o r d e r B y ( ' c r e a t e d _ a t ' ) ; // SELECT ∗ FROM p o s t s WHERE u s e r _ i d = 1 ORDER BY c r e a t e d _ a t ; $ p o s t s = $ p o s t Q u e r y −> a l l ( ) ; // P o s t [ ] Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 78

Slide 78 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations c l a s s U s e r e x t e n d s y i i \ db \ A c t i v e R e c o r d { // . . . p u b l i c f u n c t i o n g e t P r o f i l e ( ) { r e t u r n $ t h i s −>hasOne ( P r o f i l e : : c l a s s , [ ' u s e r _ i d ' = > ' i d ' ] ) ; } p u b l i c f u n c t i o n g e t P o s t s ( ) { r e t u r n $ t h i s −>hasMany ( P o s t : : c l a s s , [ ' u s e r _ i d ' = > ' i d ' ] ) ; } } // SELECT ∗ FROM u s e r s WHERE i d = 1 ; $ u s e r = U s e r : : f i n d O n e ( 1 ) ; // SELECT ∗ FROM p r o f i l e WHERE u s e r _ i d = 1 ; $ p r o f i l e = $ u s e r −> p r o f i l e ; // P r o f i l e // SELECT ∗ FROM p o s t s WHERE u s e r _ i d = 1 ; $ p o s t s = $ u s e r −>p o s t s ; // P o s t [ ] $ p o s t Q u e r y = $ u s e r −>g e t P o s t s ()−> o r d e r B y ( ' c r e a t e d _ a t ' ) ; // SELECT ∗ FROM p o s t s WHERE u s e r _ i d = 1 ORDER BY c r e a t e d _ a t ; $ p o s t s = $ p o s t Q u e r y −> a l l ( ) ; // P o s t [ ] Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 79

Slide 79 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations c l a s s U s e r e x t e n d s y i i \ db \ A c t i v e R e c o r d { // . . . p u b l i c f u n c t i o n g e t P r o f i l e ( ) { r e t u r n $ t h i s −>hasOne ( P r o f i l e : : c l a s s , [ ' u s e r _ i d ' = > ' i d ' ] ) ; } p u b l i c f u n c t i o n g e t P o s t s ( ) { r e t u r n $ t h i s −>hasMany ( P o s t : : c l a s s , [ ' u s e r _ i d ' = > ' i d ' ] ) ; } } // SELECT ∗ FROM u s e r s WHERE i d = 1 ; $ u s e r = U s e r : : f i n d O n e ( 1 ) ; // SELECT ∗ FROM p r o f i l e WHERE u s e r _ i d = 1 ; $ p r o f i l e = $ u s e r −> p r o f i l e ; // P r o f i l e // SELECT ∗ FROM p o s t s WHERE u s e r _ i d = 1 ; $ p o s t s = $ u s e r −>p o s t s ; // P o s t [ ] $ p o s t Q u e r y = $ u s e r −>g e t P o s t s ()−> o r d e r B y ( ' c r e a t e d _ a t ' ) ; // SELECT ∗ FROM p o s t s WHERE u s e r _ i d = 1 ORDER BY c r e a t e d _ a t ; $ p o s t s = $ p o s t Q u e r y −> a l l ( ) ; // P o s t [ ] Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 80

Slide 80 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations c l a s s U s e r e x t e n d s y i i \ db \ A c t i v e R e c o r d { // . . . p u b l i c f u n c t i o n g e t P r o f i l e ( ) { r e t u r n $ t h i s −>hasOne ( P r o f i l e : : c l a s s , [ ' u s e r _ i d ' = > ' i d ' ] ) ; } p u b l i c f u n c t i o n g e t P o s t s ( ) { r e t u r n $ t h i s −>hasMany ( P o s t : : c l a s s , [ ' u s e r _ i d ' = > ' i d ' ] ) ; } } // SELECT ∗ FROM u s e r s WHERE i d = 1 ; $ u s e r = U s e r : : f i n d O n e ( 1 ) ; // SELECT ∗ FROM p r o f i l e WHERE u s e r _ i d = 1 ; $ p r o f i l e = $ u s e r −> p r o f i l e ; // P r o f i l e // SELECT ∗ FROM p o s t s WHERE u s e r _ i d = 1 ; $ p o s t s = $ u s e r −>p o s t s ; // P o s t [ ] $ p o s t Q u e r y = $ u s e r −>g e t P o s t s ()−> o r d e r B y ( ' c r e a t e d _ a t ' ) ; // SELECT ∗ FROM p o s t s WHERE u s e r _ i d = 1 ORDER BY c r e a t e d _ a t ; $ p o s t s = $ p o s t Q u e r y −> a l l ( ) ; // P o s t [ ] Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 81

Slide 81 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations c l a s s U s e r e x t e n d s y i i \ db \ A c t i v e R e c o r d { // . . . p u b l i c f u n c t i o n g e t P r o f i l e ( ) { r e t u r n $ t h i s −>hasOne ( P r o f i l e : : c l a s s , [ ' u s e r _ i d ' = > ' i d ' ] ) ; } p u b l i c f u n c t i o n g e t P o s t s ( ) { r e t u r n $ t h i s −>hasMany ( P o s t : : c l a s s , [ ' u s e r _ i d ' = > ' i d ' ] ) ; } } // SELECT ∗ FROM u s e r s WHERE i d = 1 ; $ u s e r = U s e r : : f i n d O n e ( 1 ) ; // SELECT ∗ FROM p r o f i l e WHERE u s e r _ i d = 1 ; $ p r o f i l e = $ u s e r −> p r o f i l e ; // P r o f i l e // SELECT ∗ FROM p o s t s WHERE u s e r _ i d = 1 ; $ p o s t s = $ u s e r −>p o s t s ; // P o s t [ ] $ p o s t Q u e r y = $ u s e r −>g e t P o s t s ()−> o r d e r B y ( ' c r e a t e d _ a t ' ) ; // SELECT ∗ FROM p o s t s WHERE u s e r _ i d = 1 ORDER BY c r e a t e d _ a t ; $ p o s t s = $ p o s t Q u e r y −> a l l ( ) ; // P o s t [ ] Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 82

Slide 82 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations c l a s s U s e r e x t e n d s y i i \ db \ A c t i v e R e c o r d { // . . . p u b l i c f u n c t i o n g e t P r o f i l e ( ) { r e t u r n $ t h i s −>hasOne ( P r o f i l e : : c l a s s , [ ' u s e r _ i d ' = > ' i d ' ] ) ; } p u b l i c f u n c t i o n g e t P o s t s ( ) { r e t u r n $ t h i s −>hasMany ( P o s t : : c l a s s , [ ' u s e r _ i d ' = > ' i d ' ] ) ; } } // SELECT ∗ FROM u s e r s WHERE i d = 1 ; $ u s e r = U s e r : : f i n d O n e ( 1 ) ; // SELECT ∗ FROM p r o f i l e WHERE u s e r _ i d = 1 ; $ p r o f i l e = $ u s e r −> p r o f i l e ; // P r o f i l e // SELECT ∗ FROM p o s t s WHERE u s e r _ i d = 1 ; $ p o s t s = $ u s e r −>p o s t s ; // P o s t [ ] $ p o s t Q u e r y = $ u s e r −>g e t P o s t s ()−> o r d e r B y ( ' c r e a t e d _ a t ' ) ; // SELECT ∗ FROM p o s t s WHERE u s e r _ i d = 1 ORDER BY c r e a t e d _ a t ; $ p o s t s = $ p o s t Q u e r y −> a l l ( ) ; // P o s t [ ] Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 83

Slide 83 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations // SELECT ∗ FROM u s e r s ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ()−> w i t h ( [ ' p r o f i l e ']) −> a l l ( ) ; f o r e a c h ( $ u s e r s a s $ u s e r ) { e c h o $ u s e r −>p r o f i l e −>name ; } // SELECT ∗ FROM u s e r s // JOIN p r o f i l e s AS p // WHERE p . s t a t u s = ' f e a t u r e d ' ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ( ) −>j o i n W i t h ( [ ' p r o f i l e AS p ' ] ) −>wh er e ( [ ' p . s t a t u s ' = > ' f e a t u r e d ' ] ) −> a l l ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 84

Slide 84 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations // SELECT ∗ FROM u s e r s ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ()−> w i t h ( [ ' p r o f i l e ']) −> a l l ( ) ; f o r e a c h ( $ u s e r s a s $ u s e r ) { e c h o $ u s e r −>p r o f i l e −>name ; } // SELECT ∗ FROM u s e r s // JOIN p r o f i l e s AS p // WHERE p . s t a t u s = ' f e a t u r e d ' ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ( ) −>j o i n W i t h ( [ ' p r o f i l e AS p ' ] ) −>wh er e ( [ ' p . s t a t u s ' = > ' f e a t u r e d ' ] ) −> a l l ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 85

Slide 85 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations // SELECT ∗ FROM u s e r s ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ()−> w i t h ( [ ' p r o f i l e ']) −> a l l ( ) ; f o r e a c h ( $ u s e r s a s $ u s e r ) { e c h o $ u s e r −>p r o f i l e −>name ; } // SELECT ∗ FROM u s e r s // JOIN p r o f i l e s AS p // WHERE p . s t a t u s = ' f e a t u r e d ' ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ( ) −>j o i n W i t h ( [ ' p r o f i l e AS p ' ] ) −>wh er e ( [ ' p . s t a t u s ' = > ' f e a t u r e d ' ] ) −> a l l ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 86

Slide 86 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations // SELECT ∗ FROM u s e r s ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ()−> w i t h ( [ ' p r o f i l e ']) −> a l l ( ) ; f o r e a c h ( $ u s e r s a s $ u s e r ) { e c h o $ u s e r −>p r o f i l e −>name ; } // SELECT ∗ FROM u s e r s // JOIN p r o f i l e s AS p // WHERE p . s t a t u s = ' f e a t u r e d ' ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ( ) −>j o i n W i t h ( [ ' p r o f i l e AS p ' ] ) −>wh er e ( [ ' p . s t a t u s ' = > ' f e a t u r e d ' ] ) −> a l l ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 87

Slide 87 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations // SELECT ∗ FROM u s e r s ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ()−> w i t h ( [ ' p r o f i l e ']) −> a l l ( ) ; f o r e a c h ( $ u s e r s a s $ u s e r ) { e c h o $ u s e r −>p r o f i l e −>name ; } // SELECT ∗ FROM u s e r s // JOIN p r o f i l e s AS p // WHERE p . s t a t u s = ' f e a t u r e d ' ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ( ) −>j o i n W i t h ( [ ' p r o f i l e AS p ' ] ) −>wh er e ( [ ' p . s t a t u s ' = > ' f e a t u r e d ' ] ) −> a l l ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 88

Slide 88 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations // SELECT ∗ FROM u s e r s ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ()−> w i t h ( [ ' p r o f i l e ']) −> a l l ( ) ; f o r e a c h ( $ u s e r s a s $ u s e r ) { e c h o $ u s e r −>p r o f i l e −>name ; } // SELECT ∗ FROM u s e r s // JOIN p r o f i l e s AS p // WHERE p . s t a t u s = ' f e a t u r e d ' ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ( ) −>j o i n W i t h ( [ ' p r o f i l e AS p ' ] ) −>wh er e ( [ ' p . s t a t u s ' = > ' f e a t u r e d ' ] ) −> a l l ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 89

Slide 89 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations // SELECT ∗ FROM u s e r s ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ()−> w i t h ( [ ' p r o f i l e ']) −> a l l ( ) ; f o r e a c h ( $ u s e r s a s $ u s e r ) { e c h o $ u s e r −>p r o f i l e −>name ; } // SELECT ∗ FROM u s e r s // JOIN p r o f i l e s AS p // WHERE p . s t a t u s = ' f e a t u r e d ' ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ( ) −>j o i n W i t h ( [ ' p r o f i l e AS p ' ] ) −>wh er e ( [ ' p . s t a t u s ' = > ' f e a t u r e d ' ] ) −> a l l ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 90

Slide 90 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations // SELECT ∗ FROM u s e r s ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ()−> w i t h ( [ ' p r o f i l e ']) −> a l l ( ) ; f o r e a c h ( $ u s e r s a s $ u s e r ) { e c h o $ u s e r −>p r o f i l e −>name ; } // SELECT ∗ FROM u s e r s // JOIN p r o f i l e s AS p // WHERE p . s t a t u s = ' f e a t u r e d ' ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ( ) −>j o i n W i t h ( [ ' p r o f i l e AS p ' ] ) −>wh er e ( [ ' p . s t a t u s ' = > ' f e a t u r e d ' ] ) −> a l l ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 91

Slide 91 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations // SELECT ∗ FROM u s e r s ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ()−> w i t h ( [ ' p r o f i l e ']) −> a l l ( ) ; f o r e a c h ( $ u s e r s a s $ u s e r ) { e c h o $ u s e r −>p r o f i l e −>name ; } // SELECT ∗ FROM u s e r s // JOIN p r o f i l e s AS p // WHERE p . s t a t u s = ' f e a t u r e d ' ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ( ) −>j o i n W i t h ( [ ' p r o f i l e AS p ' ] ) −>wh er e ( [ ' p . s t a t u s ' = > ' f e a t u r e d ' ] ) −> a l l ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 92

Slide 92 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record Relations // SELECT ∗ FROM u s e r s ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ()−> w i t h ( [ ' p r o f i l e ']) −> a l l ( ) ; f o r e a c h ( $ u s e r s a s $ u s e r ) { e c h o $ u s e r −>p r o f i l e −>name ; } // SELECT ∗ FROM u s e r s // JOIN p r o f i l e s AS p // WHERE p . s t a t u s = ' f e a t u r e d ' ; // SELECT ∗ FROM p r o f i l e s WHERE i d IN ( . . . ) ; $ u s e r s = U s e r : : f i n d ( ) −>j o i n W i t h ( [ ' p r o f i l e AS p ' ] ) −>wh er e ( [ ' p . s t a t u s ' = > ' f e a t u r e d ' ] ) −> a l l ( ) ; Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 93

Slide 93 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record NoSQL No JOINs? Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 94

Slide 94 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record NoSQL No JOINs? → NoSQL! Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 95

Slide 95 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record NoSQL No JOINs? → NoSQL! https://github.com/yiisoft/yii2-elasticsearch https://github.com/yiisoft/yii2-mongodb https://github.com/yiisoft/yii2-redis https://github.com/yiisoft/yii2-sphinx Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 96

Slide 96 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record NoSQL yii\db\ActiveRecordInterface Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 97

Slide 97 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record NoSQL yii\db\ActiveRecordInterface yii \elasticsearch \ActiveRecord Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 98

Slide 98 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record NoSQL yii\db\ActiveRecordInterface yii \elasticsearch \ActiveRecord yii \redis \ActiveRecord Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 99

Slide 99 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record NoSQL yii\db\ActiveRecordInterface yii \elasticsearch \ActiveRecord yii \redis \ActiveRecord yii \mongodb \ActiveRecord Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 100

Slide 100 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record NoSQL yii\db\ActiveRecordInterface yii \elasticsearch \ActiveRecord yii \redis \ActiveRecord yii \mongodb \ActiveRecord yii \sphinx \ActiveRecord Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 101

Slide 101 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record NoSQL ActiveRecord and ActiveQuery interfaces Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 102

Slide 102 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record NoSQL ActiveRecord and ActiveQuery interfaces common usage, select() where() orderBy() limit() Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 103

Slide 103 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record NoSQL ActiveRecord and ActiveQuery interfaces common usage, select() where() orderBy() limit() used by DataProvider Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 104

Slide 104 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers DAO Query Builder Active Record Active Record NoSQL ActiveRecord and ActiveQuery interfaces common usage, select() where() orderBy() limit() used by DataProvider Relation between SQL and NoSQL Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 105

Slide 105 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers Switching between layers findBySql("SELECT ... WHERE ...") Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 106

Slide 106 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers Switching between layers findBySql("SELECT ... WHERE ...") find()->asArray()->all() Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 107

Slide 107 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers Switching between layers findBySql("SELECT ... WHERE ...") find()->asArray()->all() yii\db\Expression("plain SQL") Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 108

Slide 108 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers Switching between layers findBySql("SELECT ... WHERE ...") find()->asArray()->all() yii\db\Expression("plain SQL") Yii philosophy: maximum exibilty. Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 109

Slide 109 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers Conclusion / Questions? DAO, Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 110

Slide 110 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers Conclusion / Questions? DAO, QueryBuilder, Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 111

Slide 111 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers Conclusion / Questions? DAO, QueryBuilder, ActiveRecord Simple to start with, Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 112

Slide 112 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers Conclusion / Questions? DAO, QueryBuilder, ActiveRecord Simple to start with, but not limited in complex situations. Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 113

Slide 113 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers Conclusion / Questions? DAO, QueryBuilder, ActiveRecord Simple to start with, but not limited in complex situations. SQL, Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 114

Slide 114 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers Conclusion / Questions? DAO, QueryBuilder, ActiveRecord Simple to start with, but not limited in complex situations. SQL, and NoSQL Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 115

Slide 115 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers Conclusion / Questions? DAO, QueryBuilder, ActiveRecord Simple to start with, but not limited in complex situations. SQL, and NoSQL Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20

Slide 116

Slide 116 text

Why do we need DB abstraction? Yii DB abstraction layers Switching between layers Conclusion / Questions? DAO, QueryBuilder, ActiveRecord Simple to start with, but not limited in complex situations. SQL, and NoSQL Contact: @cebe on Github @cebe_cc on Twitter [email protected] via Email https://github.com/yiisoft/yii2/issues Carsten Brandt The Database Layer of Yii Framework 2.0 June 16, 2017 - Yiiconf, Ìîñêâ / 20