DB access for users that need to create test DBs

[dhensby]

SilverStripe specifically will create temporary databases for the TestRunner for running unit tests.

These are in the format of [prefix]tmpdb[rand_number]. If no prefix is specified for the site, it'll use ss_

Therefore, adding permissions for the DB user to have access to %tmpdb% would be helpful.

GRANT CREATE, DROP ON `%tmpdb%`.* TO 'user'@'%';

---

Edit: And DROP permission, of course, to clean up after itself.

[dhensby]

Ok, we obviously need to assign all privileges for reading and insterting on top of the CREATE and DELETE.

GRANT SELECT, INSERT, UPDATE, CREATE, DROP ON `%tmpdb%` TO 'user'@'%s';

[ThePeach]

I don't think that's a problem, my doubts are probably related to the way SS handles this: normally (i.e. on production) you won't have a db user with that set of credentials and, keeping aside the problems for people using it on a shared environment, it seems to partially invalidate the isolation and replication paradigm for tests, creating a non-coherent set of environments... hope this makes sense.

[dhensby]

Makes sense, at the moment I don't think you can set test DB credentials, but perhaps that's something I should push SS to do?

How do other frameworks handle the need for temp DBs when testing?