http://forge.mysql.com/wiki/RandomQueryGenerator
Is: "The Random Query Generator is a fully-customisable framework for creating random data and then running targeted random queries over it for testing purposes. " https://code.launchpad.net/~stewart-flamingspork/randgen/drizzle-experimental or: bzr branch lp:~stewart-flamingspork/randgen/drizzle-experimental and if you have DBD::drizzle installed (installing through CPAN works fine! it's what I did), you can run tests: e.g. cd drizzle/mtr2/tests; ./test-run.pl --start (and somewhere else) perl gentest.pl --gendata --grammar=conf/example.yy \ --dsn='dbi:drizzle:host=127.0.0.1:port=12500:database=test' you'll see a bunch of tables created, and a whole lotta queries running. a bunch get thrown as errors (e.g. deadlock timeout). This was pretty easy to get going. Would love someone to spend a bit of time getting my changes into a pluggable way so we could use the same upstream code for mysql and drizzle (e.g. we probably want our own Executor/Drizzle.pm and not my slightly hacked MySQL one). It'll also be a bit of effort going through and making sure query generation is good for Drizzle. I'd *really* like us to move towards having a bunch of tests that use the query generator run during 'make test'. Even if only a couple of seconds of queries - it'll help prove that we aren't screwing things. Was rather impressed that this was about zero effort to get going. Hopefully it inspires somebody else to have a real go :) -- Stewart Smith _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
