If you find this page useful and would like to be notified of changes made to this page, start by inputting your email below.
powered by ChangeDetection
(→CreateEntitySources.py: Fixed formatting) |
|||
| Line 19: | Line 19: | ||
'''UPDATE `wikiManagerPages` | '''UPDATE `wikiManagerPages` | ||
| − | SET `NEEDS_UPDATE`='1' | + | |
| − | WHERE `PAGE_NAME` LIKE '37%''' | + | '''SET `NEEDS_UPDATE`='1' |
| + | |||
| + | '''WHERE `PAGE_NAME` LIKE '37%''' | ||
''wikiManagerPages should be updated periodically, especially prior to conducting updates such as this. The script to do this is currently unable to be located'' | ''wikiManagerPages should be updated periodically, especially prior to conducting updates such as this. The script to do this is currently unable to be located'' | ||
| − | |||
==commit_staged_sources.py== | ==commit_staged_sources.py== | ||
Wellwiki uses three primary scripts in order to generate new pages. All of these scripts are located within ~/installers/wikimanager/
The first script updates the violation counts for wells in the well table of wellsdb_dev. It can be run from mysql by logging in as root, selecting wellsdb_dev as the table of choice, and running source ~/installers/wikimanager/pre_deployment.sql
The script takes about 1 minute to fully execute.
This is a python2 script that will read through all wiki pages located in the wikiManagerPages table within the wikidb database that have "NEEDS_UPDATE" set to 1.
Each entry within the wikiManagerPages table will be queried for in the wellsdb_dev database, which then outputs newly generated pages to ~/PycharmProjects/WikiManager/WikiSources
Here is some sample SQL to flag all Pennsylvania pages for update:
UPDATE `wikiManagerPages`
SET `NEEDS_UPDATE`='1'
WHERE `PAGE_NAME` LIKE '37%
wikiManagerPages should be updated periodically, especially prior to conducting updates such as this. The script to do this is currently unable to be located
This python2 file takes a source directory as an argument, and begins adding all wiki pages within that source directory to the actual wikimedia database, making them available for viewing here.
Usage: python commit_staged_sources.py ~/PycharmProjects/WikiManager/WikiSources