Diederik has uploaded a new change for review. https://gerrit.wikimedia.org/r/62450
Change subject: Simple bash script to generate seed.sql to load MW database with a small set of test data for UMAPI. ...................................................................... Simple bash script to generate seed.sql to load MW database with a small set of test data for UMAPI. Change-Id: I05daf93edcbbcdc3fa0ee42a6184e37623b4dd10 --- A scripts/generate_sql_seed.sh 1 file changed, 16 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/analytics/user-metrics refs/changes/50/62450/1 diff --git a/scripts/generate_sql_seed.sh b/scripts/generate_sql_seed.sh new file mode 100644 index 0000000..5b514a9 --- /dev/null +++ b/scripts/generate_sql_seed.sh @@ -0,0 +1,16 @@ +#!/bin/sh + +#This assumes that you have run mwdumper and imported an XML-based dump file into a Mediawiki db +#the mysql commands assume a working .my.cnf file + + +mysql -e "CREATE TABLE revision2 AS (SELECT * FROM revision LIMIT 2500);" +mysql -e "CREATE TABLE page2 AS (SELECT * FROM page,revision2 WHERE page_id=revision2.rev_id);" +mysql -e "CREATE TABLE user2 LIKE user;" +mysql -e "INSERT INTO user2 (user_name, user_editcount, user_registration) SELECT DISTINCT rev_user_text, COUNT(rev_user_text), MIN(rev_timestamp) FROM revision2 GROUP BY rev_user_text;" +mysqldump wiki revision2 page2 user2 > seed.sql + +#Rename the table names back to their original name +sed -i 's/revision2/revision/g' seed.sql +sed -i 's/page2/page/g' seed.sql +sed -i 's/user2/user/g' seed.sql -- To view, visit https://gerrit.wikimedia.org/r/62450 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I05daf93edcbbcdc3fa0ee42a6184e37623b4dd10 Gerrit-PatchSet: 1 Gerrit-Project: analytics/user-metrics Gerrit-Branch: master Gerrit-Owner: Diederik <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
