Upgrade to Pro — share decks privately, control downloads, hide ads and more …

tests and the database

8d96626e52beb1ff90f57a8e189e1e6f?s=47 John Mettraux
November 29, 2018
Programming
0
110

tests and the database

making some tests faster by starting from test database dumps

8d96626e52beb1ff90f57a8e189e1e6f?s=128

John Mettraux

November 29, 2018
Tweet

More Decks by John Mettraux

See All by John Mettraux
8d96626e52beb1ff90f57a8e189e1e6f?s=48 jmettraux
0
100
8d96626e52beb1ff90f57a8e189e1e6f?s=48 jmettraux
1
320
8d96626e52beb1ff90f57a8e189e1e6f?s=48 jmettraux
0
120
8d96626e52beb1ff90f57a8e189e1e6f?s=48 jmettraux
0
130
8d96626e52beb1ff90f57a8e189e1e6f?s=48 jmettraux
0
460
8d96626e52beb1ff90f57a8e189e1e6f?s=48 jmettraux
1
590
8d96626e52beb1ff90f57a8e189e1e6f?s=48 jmettraux
0
470
8d96626e52beb1ff90f57a8e189e1e6f?s=48 jmettraux
0
480
8d96626e52beb1ff90f57a8e189e1e6f?s=48 jmettraux
0
240

Other Decks in Programming

See All in Programming
3cb4e761dbdb7aebd1ffd85f752e1e3e?s=48 sonatard
24
3.7k
3931098ae486b6df619050c63e24f6cc?s=48 osyo
1
220
B1702643adfb1c2216f6db6fab3e5073?s=48 chocoyama
5
510
249b3122eee454c0a818bfe7851418e4?s=48 fromkk
0
580
20c5ddcad23304aed77ce8c3aa020562?s=48 tkmru
0
860
Bfc42a2fb137897db919bac632c83085?s=48 teruhisafukumoto
0
110
Dd280d6d98be3c13dfa14d63dde92299?s=48 fuga0618
0
100
746c5d84a717cf7f74822d248e06574e?s=48 nkmrh
3
770
9bda8755a689204677a198ee85c0eb07?s=48 banjun
PRO
0
160
29dd31db419a2e56cf6a8a11f9de98ee?s=48 masakazoo
2
520
E4e01fb8b7105e61e3876224139503ab?s=48 niw
2
520
9a805d1d3fb2ca4943cb240dee106d5a?s=48 kawakin
1
140

Featured

See All Featured
F57e2136eb9895eb95ff5dc8a1c02677?s=48 zakiwarfel
91
3.6k
245cee81a9c424266e5e401d844ea881?s=48 lara
26
3.4k
06f8b41980eb4c577fa40c41d5030c19?s=48 keathley
25
910
F383c6a4dc55e331bbe2987b622cee6b?s=48 stephaniewalter
263
11k
3ab1249be442027903e1180025340b3f?s=48 reverentgeek
171
7.7k
A415db3ac9e9668acbc1fb36eead84ac?s=48 mthomps
44
2.5k
433acaea1012b25d97ae66da9b998dad?s=48 malarkey
122
16k
9cde37f47e4a800ea081ea42de8d749a?s=48 dougneiner
56
5.6k
E76911cbe088e5b850d966de3fc7435b?s=48 robhawkes
55
3k
91cefdf141106fa10674aae74ce05890?s=48 yeseniaperezcruz
307
32k
4394ceb8b277f35ee3da7030384efb5d?s=48 davidbonilla
75
3.8k
9cde37f47e4a800ea081ea42de8d749a?s=48 dougneiner
122
8.2k

Transcript

  1. None

  2. tests and
 the database

  3. hiro shima .rb #67 • Sinatra • Sequel • JRuby

  4. hiro shima .rb #67

  5. hiro shima .rb #67

  6. hiro shima .rb #67 took 20s.

  7. hiro shima .rb #67 took 20s.

  8. hiro shima .rb #67 bxs spec/functional/models/sg_mandate_spec.rb:210 bxs spec/functional/models/sg_mandate_spec.rb -e fubar

    bxs spec/functional/models/sg_mandate_spec.rb bxs spec/functional/models/ alias bxs=“bundle exec rspec” bxs

  9. hiro shima .rb #67 bxs spec/functional/models/sg_mandate_spec.rb:210 bxs spec/functional/models/sg_mandate_spec.rb -e fubar

    bxs spec/functional/models/sg_mandate_spec.rb bxs spec/functional/models/ alias bxs=“bundle exec rspec” bxs 30s to 2m 20m to 30m

  10. hiro shima .rb #67 bxs spec/functional/models/sg_mandate_spec.rb:210 bxs spec/functional/models/sg_mandate_spec.rb -e fubar

    bxs spec/functional/models/sg_mandate_spec.rb bxs spec/functional/models/ alias bxs=“bundle exec rspec” bxs focus control

  11. hiro shima .rb #67 bxs spec/functional/models/sg_mandate_spec.rb:210 bxs spec/functional/models/sg_mandate_spec.rb -e fubar

    bxs spec/functional/models/sg_mandate_spec.rb bxs spec/functional/models/ alias bxs=“bundle exec rspec” bxs focus control

  12. hiro shima .rb #67 bxs spec/functional/models/sg_mandate_spec.rb:210 bxs spec/functional/models/sg_mandate_spec.rb -e fubar

    bxs spec/functional/models/sg_mandate_spec.rb bxs spec/functional/models/ alias bxs=“bundle exec rspec” bxs focus control unit (no db access) functional (no browser) integration (selenium)

  13. hiro shima .rb #67

  14. hiro shima .rb #67

  15. hiro shima .rb #67 what if we had a dump

    of the test database, right after load_integration_fixtures()
 ?

  16. hiro shima .rb #67 what if we had a dump

    of the test database, right after load_integration_fixtures()
 ?

  17. hiro shima .rb #67 what if we had a dump

    of the test database, right after load_integration_fixtures()
 ?

  18. hiro shima .rb #67 what if we had a dump

    of the test database, right after load_integration_fixtures()
 ?

  19. hiro shima .rb #67 what if we had a dump

    of the test database, right after load_integration_fixtures()
 ? dump: 0.2s dump: 61M load: 1.8s

  20. hiro shima .rb #67

  21. hiro shima .rb #67

  22. hiro shima .rb #67

  23. hiro shima .rb #67

  24. hiro shima .rb #67 still
 20s cost remains

  25. hiro shima .rb #67 still
 20s cost remains

  26. hiro shima .rb #67 still
 20s cost remains

  27. hiro shima .rb #67 still
 20s cost remains

  28. hiro shima .rb #67 still
 20s cost remains

  29. hiro shima .rb #67

  30. hiro shima .rb #67

  31. hiro shima .rb #67 the end