mozilla/kitsune — pull request #1723 by willkg (2013-11-13 14:15:24+00:00)
Title: Fix generatedata

* the hacking howto has instructions for creating the db that don't
include setting the CHARSET so it would die on creating revisions
using the revision model maker which includes unicode data
* the revision model maker code value strings were ... "interesting"
* cosmetic: i tweaked the formatting in the MozillaNews.wiki

To test:

1. run the tests
2. create a fresh db and run generate data in it

For the second one, I have this section in my `fabfile.py`:

```
def test_new_db():
db = 'kitsunenew'
local('mysql -e "DROP DATABASE IF EXISTS {0};"'.format(db))
local('mysql -e "CREATE DATABASE {0} CHARACTER SET utf8 COLLATE utf8_unicode_ci;"'.format(db))
local('mysql -e "GRANT ALL ON {0}.* TO kitsune@localhost IDENTIFIED BY \'kitsune\';"'.format(db))

# local('mysql kitsunenew < scripts/schema.sql')
# local('KITSUNEDB={0} ./vendor/src/schematic/schematic migrations/'.format(db))
local('KITSUNEDB={0} python manage.py syncdb --noinput --migrate'.format(db))
local('KITSUNEDB={0} python manage.py generatedata'.format(db))
```

That won't stomp on existing databases, so it's safe to run. It assumes you have a "kitsune" user with password "kitsune".

r?