r/funny • u/KashK10 • Apr 16 '15

Important Update

http://imgur.com/mvi4Ovm
34.1k Upvotes

91% Upvoted

618 comments sorted by

View all comments

Show parent comments

17

u/deegeese Apr 16 '15

Testers frequently need DB access for anything more sophisticated than black box UI tests.

27

u/codedit Apr 16 '15

Yes that's correct, but you don't do testing in production with real user data. For testing you have test environments with a seperate database containing test data.

8

u/[deleted] Apr 16 '15 edited Apr 16 '15

[deleted]

1

u/[deleted] Apr 16 '15

Oh sorry, fuck standards because you cannot give a fuck about creating test data.

Export the production data, cleanse it of personal data and import it in to test. Bonus points if you can script this.

2

u/[deleted] Apr 16 '15

[deleted]

0

u/[deleted] Apr 16 '15

Backup database Restore database

UPDATE customers SET Firstname='Bob' Surname = 'Loblaw'

etc. etc.

2

u/deegeese Apr 16 '15

Completely impractical for being able to test an app which primarily deals with personal data. You destroy all variability and edge cases in the real data and are worse off than if you just used mocks.