Addshore has submitted this change and it was merged. Change subject: Also copy tsv files to aggregate-datasets ......................................................................
Also copy tsv files to aggregate-datasets Change-Id: I17beaaf296732f53428b23c8332b9f3d027c5362 --- M export.sh 1 file changed, 8 insertions(+), 1 deletion(-) Approvals: Addshore: Verified; Looks good to me, approved diff --git a/export.sh b/export.sh index 6fc563b..f42d544 100644 --- a/export.sh +++ b/export.sh @@ -1,10 +1,17 @@ #!/bin/bash # #Simple script to create tsv files from the tables used +# +#This script of course requires the tables to already exist! +#This script also requires /a/aggregate-datasets/wikidata to already exist mysqldefaults="/etc/mysql/conf.d/analytics-research-client.cnf" mysqlhost="analytics-store.eqiad.wmnet" mysql --defaults-file=$mysqldefaults -h $mysqlhost -e "SELECT * FROM staging.wikidata_social" > wikidata_social.tsv mysql --defaults-file=$mysqldefaults -h $mysqlhost -e "SELECT * FROM staging.wikidata_site_stats" > wikidata_site_stats.tsv -mysql --defaults-file=$mysqldefaults -h $mysqlhost -e "SELECT * FROM staging.wikidata_getclaims_property_use" > wikidata_getclaims_property_use.tsv \ No newline at end of file +mysql --defaults-file=$mysqldefaults -h $mysqlhost -e "SELECT * FROM staging.wikidata_getclaims_property_use" > wikidata_getclaims_property_use.tsv + +cp wikidata_social.tsv /a/aggregate-datasets/wikidata/social.tsv +cp wikidata_site_stats.tsv /a/aggregate-datasets/wikidata/site_stats.tsv +cp wikidata_getclaims_property_use.tsv /a/aggregate-datasets/wikidata/getclaims_property_use.tsv -- To view, visit https://gerrit.wikimedia.org/r/240725 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: I17beaaf296732f53428b23c8332b9f3d027c5362 Gerrit-PatchSet: 1 Gerrit-Project: analytics/limn-wikidata-data Gerrit-Branch: master Gerrit-Owner: Addshore <[email protected]> Gerrit-Reviewer: Addshore <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
