An in-depth look at database migrations & seeding in Laravel

From the presentation presented at the Laravel Chicago PHP UG on February 23rd, 2016: http://www.meetup.com/laravel-chicago/events/228116711/

Transcript

1. Sammy Kaye Powers February 23rd, 2016 Database Migrations An in-depth look at &Seeding in
2. AssumptIons You have basic knowledge of > CLI
3. NEW! Let’s Create…
6. From the directory /public
9. Sequel Pro (Mac only)
14. /.env
16. Ship It!
17. Deployment TL;DR
18. Deployment $ vi ~/.ssh/config Host dance-app HostName example.com User sammyk IdentityFile ~/.ssh/foo
19. Deployment $ ssh dance-app
20. Deployment $ cd /path/to/example.com $ mkdir http $ mkdir git $ cd git $ git init . —-bare
21. Deployment $ cd hooks $ vi post-receive
22. Deployment #!/bin/bash app_root=‘/path/to/example.com/http/' echo "Updating public files..." GIT_WORK_TREE=$app_root git checkout -f echo "Installing composer packages..." cd $app_root composer install echo "Done!"
23. Deployment $ chmod +x post-receive $ exit
24. Deployment $ cd /path/to/repo $ git remote add production \ dancer-app:/path/to/example.com/git $ git push production \ +master:refs/heads/master
25. Deployment $ git add README.md $ git commit -m “Update docs” $ git push production
26. Deployment $ composer install Automatically runs
27. Deployment /.env Don’t forget + on production
28. What should we build!?
29. A USER!!
30. A USER!! #exciting
31. /app/User.php
36. Eloquent ORM
40. Let’s USE IT!
41. /app/Http/routes.php
46. Return A USEr
52. Old School Method
53. Old School Method CREATE TABLE `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB;
54. Old School Method INSERT INTO `users` (`id`, `name`, `email`, `password`) VALUES (1,'Jane Doe','jane@example.com','test123'), (2,'Jon Doe','jon@example.com','jon123');
55. <rant>
56. Old School Method INSERT INTO `users` (`id`, `name`, `email`, `password`) VALUES (1,'Jane Doe','jane@example.com','test123'), (2,'Jon Doe','jon@example.com','jon123'); should be hashed
57. Old School Method INSERT INTO `users` (`id`, `name`, `email`, `password`) VALUES (1,'Jane Doe','jane@example.com','test123'), (2,'Jon Doe','jon@example.com','jon123'); should be hashed MD5
58. Old School Method INSERT INTO `users` (`id`, `name`, `email`, `password`) VALUES (1,'Jane Doe','jane@example.com','test123'), (2,'Jon Doe','jon@example.com','jon123'); should be hashed MD5
59. Old School Method INSERT INTO `users` (`id`, `name`, `email`, `password`) VALUES (1,'Jane Doe','jane@example.com','test123'), (2,'Jon Doe','jon@example.com','jon123'); should be hashed MD5
60. Old School Method INSERT INTO `users` (`id`, `name`, `email`, `password`) VALUES (1,'Jane Doe','jane@example.com','test123'), (2,'Jon Doe','jon@example.com','jon123'); should be hashed MD5 +
61. bcrypt() To Hash Passwords Use
62. password_hash() PHP >= 5.5 …or
64. </rant>
65. Old School Method INSERT INTO `users` (`id`, `name`, `email`, `password`) VALUES (1,'Jane Doe','jane@example.com','test123'), (2,'Jon Doe','jon@example.com','jon123');
66. Old School Method
67. Old School Method
68. Old School Method
69. Old School Method
70. Old School Method
71. Old School Method
72. $ git add README.md $ git commit -m “Update docs” $ git push production Old School Method Ship IT!
73. Old School Method Ship IT! Manually Update The
75. Laravel Way
76. Laravel Way
77. Laravel Way
78. Laravel Way
79. Laravel Way $ php artisan
80. Laravel Way
81. Laravel Way
82. Laravel Way $ php artisan migrate
83. Laravel Way
84. Laravel Way What is this voodoo?
85. Laravel Way $ php artisan migrate
86. Laravel Way
87. Laravel Way
88. Laravel Way /database/migrations/
89. Laravel Way /database/migrations/2014_10_12_000000_create_users_table.php
90. Laravel Way
91. Laravel Way CREATE TABLE `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `password` varchar(60) COLLATE utf8_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
92. Laravel Way
93. Laravel Way
94. Laravel Way $ php artisan migrate:rollback
95. Laravel Way
96. Laravel Way
97. Laravel Way $ php artisan migrate Old School Method CREATE TABLE `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB;
98. Laravel Way $ php artisan migrate
99. Laravel Way
100. Laravel Way Seeding Time
101. Old School Method INSERT INTO `users` (`id`, `name`, `email`, `password`) VALUES (1,'Jane Doe','jane@example.com','test123'), (2,'Jon Doe','jon@example.com','jon123'); Remember When…
102. Laravel Way $ php artisan
103. Laravel Way $ php artisan
104. Laravel Way $ php artisan db:seed
105. Laravel Way $ php artisan db:seed
106. Laravel Way
107. Laravel Way
108. Laravel Way $ php artisan make:seeder UsersTableSeeder
109. Laravel Way /database/seeds/UsersTableSeeder.php
110. Laravel Way
111. Laravel Way laravel.com/docs
112. Laravel Way
113. Laravel Way $ php artisan db:seed
114. Laravel Way
115. Laravel Way
116. Laravel Way /database/seeds/DatabaseSeeder.php
117. Laravel Way
118. Laravel Way
119. Laravel Way $ php artisan db:seed
120. Laravel Way
121. Laravel Way Add More Users
122. Laravel Way /database/seeds/UsersTableSeeder.php
123. Laravel Way /database/seeds/UsersTableSeeder.php A Better Way
124. Laravel Way Model Factories
125. Laravel Way /database/factories/ModelFactory.php
126. Laravel Way
127. Laravel Way
128. Laravel Way
129. Laravel Way github.com/fzaninotto/Faker
130. Laravel Way
131. Laravel Way /database/seeds/UsersTableSeeder.php
132. Laravel Way
133. Laravel Way $ php artisan db:seed
134. Laravel Way
135. Laravel Way /database/seeds/UsersTableSeeder.php
136. Laravel Way $ php artisan db:seed
137. Laravel Way
138. Laravel Way Make 100 Users
139. Laravel Way /database/seeds/UsersTableSeeder.php
140. Laravel Way
141. Another Model Let’s add
142. User Model
143. User Model Tay-Tay
144. User Model Event Model
145. Laravel Way /app/Event.php
146. Laravel Way
147. Laravel Way $ php artisan make:migration create_events_table
148. Laravel Way /database/migrations/[…].php
149. Laravel Way
150. Laravel Way
151. Laravel Way $ php artisan migrate
152. Laravel Way
153. Laravel Way /database/factories/ModelFactory.php
154. Laravel Way
155. Laravel Way $ php artisan make:seeder EventsTableSeeder
156. Laravel Way /database/seeds/EventsTableSeeder.php
157. Laravel Way
158. Laravel Way /database/seeds/DatabaseSeeder.php
159. Laravel Way
160. Laravel Way
161. Laravel Way $ php artisan db:seed
162. Laravel Way
163. $ git add README.md $ git commit -m “Update docs” $ git push production Ship IT! Laravel Way
164. $ git add README.md $ git commit -m “Update docs” $ git push production Ship IT! Laravel Way Wait!
165. Deployment #!/bin/bash app_root=‘/path/to/example.com/http/' echo "Updating public files..." GIT_WORK_TREE=$app_root git checkout -f echo "Installing composer packages..." cd $app_root composer install echo "Done!"
166. Deployment #!/bin/bash app_root=‘/path/to/example.com/http/' echo "Updating public files..." GIT_WORK_TREE=$app_root git checkout -f echo "Updating the database..." php ${app_root}artisan migrate --force echo "Installing composer packages..." cd $app_root composer install echo "Done!"
167. Deployment echo "Updating the database..." php ${app_root}artisan migrate --force
168. $ git add README.md $ git commit -m “Update docs” $ git push production Ship IT! Laravel Way
169. Ship IT! Laravel Way Automatically Updates The
170. one more thing Let’s do
171. User Model Event Model
172. User Model Event Model Subscribe
173. User Model Event Model Subscribe Many users… …many events can subscribe to
174. User Model Event Model Subscribe Many users… …many events can subscribe to MANY To Many
175. User Model Event Model Subscribe event_user Pivot Table
176. User Model Event Model Subscribe event_user Pivot Table Singular + ABC
177. Laravel Way /app/Event.php
178. Laravel Way
179. Laravel Way /app/User.php
180. Laravel Way $ php artisan make:migration create_event_user_table
181. Laravel Way
182. Laravel Way $ php artisan migrate
183. Laravel Way
184. Laravel Way How Do We Seed?
185. Laravel Way Do We Make Model for Pivot?
186. Laravel Way $ php artisan make:seeder EventUserTableSeeder
187. Laravel Way EventUserTableSeeder.php
188. Laravel Way EventUserTableSeeder.php
189. Laravel Way DatabaseSeeder.php
190. Laravel Way $ php artisan db:seed
191. Laravel Way
192. Laravel Way /app/Http/routes.php
193. Laravel Way
194. Laravel Way
195. What did we Learn?
196. What did we Learn? NEW! Deployment Eloquent ORM migrations Model Factories Seeding MANY To Many +
198. Watch me open source! “It is recommended to store the result in a database column that can expand beyond 60 characters (255 characters would be a good choice).” password_hash()
199. Watch me open source!
200. Watch me open source!
201. Watch me open source!
202. Let’s fix it together!
203. THANKS! Sammy Kaye Powers @SammyK SammyK.me Host of @PHPRoundtable @ChiPHPUG West Coast Swing