Darkdadaah has uploaded a new change for review. https://gerrit.wikimedia.org/r/68931
Change subject: New SQL file to import with LOCAL INFILE ...................................................................... New SQL file to import with LOCAL INFILE Change-Id: If6d9052c0dafb946c4abcf7504dfe17f7ff7e018 --- A sql/sql_tables_import_local.sql 1 file changed, 31 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/wiktionary/anagrimes refs/changes/31/68931/1 diff --git a/sql/sql_tables_import_local.sql b/sql/sql_tables_import_local.sql new file mode 100644 index 0000000..e36724b --- /dev/null +++ b/sql/sql_tables_import_local.sql @@ -0,0 +1,31 @@ +DROP TABLE IF EXISTS articles_temp, mots_temp, langues_temp ; +SELECT '- Potential temporary tables dropped' AS '' ; + +CREATE TABLE articles_temp LIKE articles; +SELECT '- Filling the temporary ARTICLES table...' AS '' ; +LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/anagrimes/data/tables/current_articles.csv' +INTO TABLE articles_temp FIELDS + TERMINATED BY ',' + ENCLOSED BY '"' LINES + TERMINATED BY '\n' +(titre, r_titre, titre_plat, r_titre_plat, transcrit_plat, r_transcrit_plat, anagramme_id); + +CREATE TABLE mots_temp LIKE mots; +SELECT '- Filling the temporary MOTS table...' AS '' ; +LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/anagrimes/data/tables/current_mots.csv' +INTO TABLE mots_temp FIELDS + TERMINATED BY ',' + ENCLOSED BY '"' LINES + TERMINATED BY '\n' +(titre, langue, type, pron, pron_simple, r_pron_simple, rime_pauvre, rime_suffisante, rime_riche, rime_voyelle, syllabes, num, flex, loc, gent, rand); + +SELECT '- Filling the temporary LANGUES table...' AS '' ; +CREATE TABLE langues_temp LIKE langues; +LOAD DATA LOCAL INFILE '/data/project/anagrimes/data/tables/current_langues.csv' +INTO TABLE langues_temp FIELDS + TERMINATED BY ',' + ENCLOSED BY '"' LINES + TERMINATED BY '\n' +(langue,num,num_min); + +SELECT 'TABLES IMPORTED IN TEMP' AS '' ; -- To view, visit https://gerrit.wikimedia.org/r/68931 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: If6d9052c0dafb946c4abcf7504dfe17f7ff7e018 Gerrit-PatchSet: 1 Gerrit-Project: wiktionary/anagrimes Gerrit-Branch: master Gerrit-Owner: Darkdadaah <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
