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
95

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
80
8d96626e52beb1ff90f57a8e189e1e6f?s=48 jmettraux
1
290
8d96626e52beb1ff90f57a8e189e1e6f?s=48 jmettraux
0
110
8d96626e52beb1ff90f57a8e189e1e6f?s=48 jmettraux
0
120
8d96626e52beb1ff90f57a8e189e1e6f?s=48 jmettraux
0
420
8d96626e52beb1ff90f57a8e189e1e6f?s=48 jmettraux
1
580
8d96626e52beb1ff90f57a8e189e1e6f?s=48 jmettraux
0
450
8d96626e52beb1ff90f57a8e189e1e6f?s=48 jmettraux
0
450
8d96626e52beb1ff90f57a8e189e1e6f?s=48 jmettraux
0
210

Other Decks in Programming

See All in Programming
218473ff7abad0fcd72865da2b23bb5b?s=48 memory1994
6
620
De4cef85165e8a063b5e40fe1f24daa4?s=48 cocoeyes02
5
2.2k
1fc99b5c53469bd2a40de00649baa5fe?s=48 zizochan
0
130
9bf923e39671cde83584e3e926296c13?s=48 kishikawakatsumi
1
520
F5c2731f9a4dbfb4af319295a1f0cd28?s=48 dmitrytsepelev
0
210
3c7020b33ae8880dd9514b6469a28ae0?s=48 yt8492
0
160
924d7de2a5a7102a597728e5edbbff78?s=48 kekyo
PRO
0
270
E7151ab8219e76672f7a7691dd2c88e6?s=48 seike460
3
440
8e844e43f029ec38e206a464cf4587b3?s=48 ttskch
1
540
F8fc4ec35531ef9a285c1a84591cc16c?s=48 tosaka07
2
420
07fe43bbec550b3230b3a7f9a81de7cc?s=48 nishigori
2
1.4k
0620564f0125b8b3b7f4fe40c10b8b4e?s=48 tattn
6
550

Featured

See All Featured
25c7c18223fb42a4c6ae1c8db6f50f9b?s=48 mojombo
360
63k
C157b16234f1e75e8eac3698c1d4414a?s=48 ddemaree
273
32k
15f2b8221f247985a27a627d2ece72f0?s=48 pauljervisheath
194
15k
D67fff74178013024d833b3eec6cf27f?s=48 lynnandtonic
274
17k
78b475797a14c84799063c7cd073962f?s=48 holman
290
130k
0bce06bd06ee7a2c4f5500f25dcf7f18?s=48 paulrobertlloyd
73
1.5k
D8fc2580cfaca035f666d9e4ee79a7f7?s=48 mongodb
23
4k
245cee81a9c424266e5e401d844ea881?s=48 lara
21
3.1k
9cde37f47e4a800ea081ea42de8d749a?s=48 dougneiner
120
8.1k
7edec06b5435e0dac07a353b2cc26253?s=48 geeforr
333
29k
3ab1249be442027903e1180025340b3f?s=48 reverentgeek
167
7.5k
5f50f94346fbcb23706f0707169317a4?s=48 aarron
258
36k

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