Tool:PBbot
 PBbot Tools
| |
|---|---|
| Website | https://pbbot.toolforge.org/ |
| Description | A collection of tools for plwiktionary and others. |
| Keywords | bot, web tools, plwiktionary, eswiktionary, plwiki |
| Author(s) | Peter Bowmantalk |
| Maintainer(s) | Peter Bowman, Alkamid (View all) |
| Source code | https://github.com/PeterBowman/wikibot |
| License | GNU General Public License 3.0 |
| Issues | GitHub |
| Admin log | Nova Resource:Tools.pbbot/SAL |
Database layout (tools.db)
https://tool-db-usage.toolforge.org/owner/s52584
s52584__eswikt_anagrams (unused)
DESCRIBE normalized;
+----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+------------------+------+-----+---------+----------------+ | title_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | from | varchar(255) | NO | | NULL | | | to | varchar(255) | NO | | NULL | | +----------+------------------+------+-----+---------+----------------+
s52584__plwikt_common
DESCRIBE execution_log;
+-----------+-------------+------+-----+-------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+-------------------+-------+ | type | varchar(45) | NO | PRI | NULL | | | timestamp | timestamp | NO | | CURRENT_TIMESTAMP | | +-----------+-------------+------+-----+-------------------+-------+
s52584__plwikt_eom_backlinks
DESCRIBE morfeo;
+----------+-----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-----------------------+------+-----+---------+----------------+ | id | mediumint(8) unsigned | NO | PRI | NULL | auto_increment | | title | varchar(255) | NO | MUL | NULL | | | morphem | varchar(255) | NO | MUL | NULL | | | position | tinyint(3) unsigned | NO | | NULL | | | type | tinyint(3) unsigned | NO | | NULL | | +----------+-----------------------+------+-----+---------+----------------+
s52584__plwikt_verify_citations
DESCRIBE all_changes; (VIEW)
+-------------------+-----------------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+-----------------------+------+-----+---------------------+-------+ | entry_id | mediumint(8) unsigned | NO | | 0 | | | page_id | mediumint(8) unsigned | NO | | NULL | | | page_title | varchar(255) | NO | | NULL | | | language | varchar(50) | NO | | NULL | | | field_id | tinyint(3) unsigned | NO | | 0 | | | field_localized | varchar(35) | NO | | NULL | | | source_text | varchar(4095) | NO | | NULL | | | edited_text | varchar(4095) | NO | | NULL | | | current_change_id | mediumint(8) unsigned | NO | | NULL | | | change_log_id | mediumint(8) unsigned | NO | | NULL | | | editor | varchar(255) | NO | | @generated | | | change_timestamp | timestamp | NO | | 0000-00-00 00:00:00 | | | is_pending | int(1) | NO | | 0 | | | review_log_id | mediumint(8) unsigned | YES | | 0 | | | review_status | bit(1) | YES | | NULL | | | reviewer | varchar(255) | YES | | NULL | | | review_timestamp | timestamp | YES | | 0000-00-00 00:00:00 | | +-------------------+-----------------------+------+-----+---------------------+-------+
DESCRIBE all_entries; (VIEW)
+-------------------+-----------------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+-----------------------+------+-----+---------------------+-------+ | entry_id | mediumint(8) unsigned | NO | | 0 | | | page_id | mediumint(8) unsigned | NO | | NULL | | | page_title | varchar(255) | NO | | NULL | | | language | varchar(50) | NO | | NULL | | | field_id | tinyint(3) unsigned | NO | | 0 | | | field_localized | varchar(35) | NO | | NULL | | | source_text | varchar(4095) | NO | | NULL | | | edited_text | varchar(4095) | NO | | NULL | | | current_change_id | mediumint(8) unsigned | NO | | NULL | | | editor | varchar(255) | NO | | @generated | | | change_timestamp | timestamp | NO | | 0000-00-00 00:00:00 | | | is_pending | int(1) | NO | | 0 | | | review_log_id | mediumint(8) unsigned | YES | | 0 | | | review_status | bit(1) | YES | | NULL | | | reviewer | varchar(255) | YES | | NULL | | | review_timestamp | timestamp | YES | | 0000-00-00 00:00:00 | | +-------------------+-----------------------+------+-----+---------------------+-------+
DESCRIBE change_log;
+------------------+-----------------------+------+-----+-------------------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+-----------------------+------+-----+-------------------+-------+ | change_log_id | mediumint(8) unsigned | NO | PRI | NULL | | | entry_id | mediumint(8) unsigned | NO | MUL | NULL | | | user | varchar(255) | NO | MUL | @generated | | | change_timestamp | timestamp | NO | | CURRENT_TIMESTAMP | | +------------------+-----------------------+------+-----+-------------------+-------+
DESCRIBE edit_log;
+----------------+-----------------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+-----------------------+------+-----+-------------------+----------------+ | edit_log_id | mediumint(8) unsigned | NO | PRI | NULL | auto_increment | | change_log_id | mediumint(8) unsigned | NO | MUL | NULL | | | rev_id | int(10) unsigned | NO | UNI | NULL | | | edit_timestamp | timestamp | NO | | CURRENT_TIMESTAMP | | +----------------+-----------------------+------+-----+-------------------+----------------+
DESCRIBE edited_line;
+----------------+-----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+-----------------------+------+-----+---------+----------------+ | edited_line_id | mediumint(8) unsigned | NO | PRI | NULL | auto_increment | | edited_text | varchar(4095) | NO | | NULL | | +----------------+-----------------------+------+-----+---------+----------------+
DESCRIBE entry;
+----------------+-----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+-----------------------+------+-----+---------+----------------+ | entry_id | mediumint(8) unsigned | NO | PRI | NULL | auto_increment | | page_id | mediumint(8) unsigned | NO | MUL | NULL | | | language | varchar(50) | NO | | NULL | | | field_id | tinyint(3) unsigned | NO | MUL | NULL | | | source_line_id | mediumint(8) unsigned | NO | MUL | NULL | | | edited_line_id | mediumint(8) unsigned | NO | MUL | NULL | | +----------------+-----------------------+------+-----+---------+----------------+
DESCRIBE field;
+------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+---------------------+------+-----+---------+----------------+ | field_id | tinyint(3) unsigned | NO | PRI | NULL | auto_increment | | field_name | varchar(25) | NO | UNI | NULL | | | localized | varchar(35) | NO | | NULL | | +------------+---------------------+------+-----+---------+----------------+
DESCRIBE line;
+-----------+-----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+-----------------------+------+-----+---------+----------------+ | line_id | mediumint(8) unsigned | NO | PRI | NULL | auto_increment | | text | varchar(4095) | NO | | NULL | | | user | varchar(255) | YES | | NULL | | | timestamp | varchar(14) | NO | | NULL | | +-----------+-----------------------+------+-----+---------+----------------+
DESCRIBE page_title;
+------------+-----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-----------------------+------+-----+---------+-------+ | page_id | mediumint(8) unsigned | NO | PRI | NULL | | | page_title | varchar(255) | NO | MUL | NULL | | +------------+-----------------------+------+-----+---------+-------+
DESCRIBE pending;
+----------+-----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-----------------------+------+-----+---------+-------+ | entry_id | mediumint(8) unsigned | NO | PRI | NULL | | +----------+-----------------------+------+-----+---------+-------+
DESCRIBE review_log;
+------------------+-----------------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+-----------------------+------+-----+-------------------+----------------+ | review_log_id | mediumint(8) unsigned | NO | PRI | NULL | auto_increment | | edited_line_id | mediumint(8) unsigned | NO | MUL | NULL | | | user | varchar(255) | NO | MUL | NULL | | | review_status | bit(1) | NO | | NULL | | | review_timestamp | timestamp | NO | | CURRENT_TIMESTAMP | | +------------------+-----------------------+------+-----+-------------------+----------------+
DESCRIBE reviewed;
+---------------+-----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-----------------------+------+-----+---------+-------+ | entry_id | mediumint(8) unsigned | NO | PRI | NULL | | | review_log_id | mediumint(8) unsigned | NO | MUL | NULL | | +---------------+-----------------------+------+-----+---------+-------+
DESCRIBE source_line;
+----------------+-----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+-----------------------+------+-----+---------+----------------+ | source_line_id | mediumint(8) unsigned | NO | PRI | NULL | auto_increment | | source_text | varchar(4095) | NO | | NULL | | +----------------+-----------------------+------+-----+---------+----------------+
See also
- https://github.com/PeterBowman/wikibot
- https://github.com/PeterBowman/toolforge-pbbot (private)
- https://tools-info.toolforge.org/explorer/?dir=data/project/pbbot
- https://tools-static.wmflabs.org/pbbot/
- https://toolsadmin.wikimedia.org/tools/id/pbbot
- https://k8s-status.toolforge.org/namespaces/tool-pbbot/
- https://sal.toolforge.org/tools.pbbot
- https://toolhub.wikimedia.org/tools/toolforge-pbbot
- https://grafana.wmcloud.org/d/TJuKfnt4z/kubernetes-namespace?var-namespace=tool-pbbot