wiki
/
jogobot-red
1
0
Fork 0
Code Issues 4 Pull Requests Releases Wiki Activity
Labels Milestones
New Issue

FS#157: Artikelnamen Beginnen mit einem Kleinbuchstaben #1

Closed
opened 7 years ago by golderweb · 2 comments
golderweb commented 7 years ago
Owner

Artikel mit Kleinbuchstaben am Anfang sollten beim Parsen auf Großbuchstaben gewandelt werden.

DB-Query Ansatz (muss noch für alle articleX erweitert werden:

SELECT *
FROM dewikipedia_redfams
WHERE CAST( article0 as BINARY ) REGEXP '^[a-z]'

Schritte zum Beheben:

  • Parser anpassen
  • über Subselect bei betroffenen RedPages "parsed" löschen
  • Parser ausführen
  • Stichprobenartig auf neue RedFams prüfen (neuer Famhash)
  • alte RedFams löschen

Imported from https://fs.golderweb.de/task/157 via GOLDERWEB FS->GITEA TICKETIMPORTER

Originially opened: Sat Sep 2 21:42:57 2017

Artikel mit Kleinbuchstaben am Anfang sollten beim Parsen auf Großbuchstaben gewandelt werden. DB-Query Ansatz (muss noch für alle articleX erweitert werden: <code> SELECT * FROM `dewikipedia_redfams` WHERE CAST( `article0` as BINARY ) REGEXP '^[a-z]' </code> Schritte zum Beheben: - Parser anpassen - über Subselect bei betroffenen RedPages "parsed" löschen - Parser ausführen - Stichprobenartig auf neue RedFams prüfen (neuer Famhash) - alte RedFams löschen ---- Imported from https://fs.golderweb.de/task/157 via GOLDERWEB FS->GITEA TICKETIMPORTER Originially opened: Sat Sep 2 21:42:57 2017
golderweb commented 7 years ago
Poster
Owner

SELECT *
FROM dewikipedia_redfams
WHERE CAST( article0 as BINARY ) REGEXP '^[a-z]' OR
CAST( article1 as BINARY ) REGEXP '^[a-z]' OR
CAST( article2 as BINARY ) REGEXP '^[a-z]' OR
CAST( article3 as BINARY ) REGEXP '^[a-z]' OR
CAST( article4 as BINARY ) REGEXP '^[a-z]' OR
CAST( article5 as BINARY ) REGEXP '^[a-z]' OR
CAST( article6 as BINARY ) REGEXP '^[a-z]' OR
CAST( article7 as BINARY ) REGEXP '^[a-z]'

Imported from https://fs.golderweb.de/task/157#comment35 via GOLDERWEB FS->GITEA TICKETIMPORTER

Originially added: Sat Sep 23 17:25:09 2017

<code>SELECT * FROM `dewikipedia_redfams` WHERE CAST( `article0` as BINARY ) REGEXP '^[a-z]' OR CAST( `article1` as BINARY ) REGEXP '^[a-z]' OR CAST( `article2` as BINARY ) REGEXP '^[a-z]' OR CAST( `article3` as BINARY ) REGEXP '^[a-z]' OR CAST( `article4` as BINARY ) REGEXP '^[a-z]' OR CAST( `article5` as BINARY ) REGEXP '^[a-z]' OR CAST( `article6` as BINARY ) REGEXP '^[a-z]' OR CAST( `article7` as BINARY ) REGEXP '^[a-z]'</code> ---- Imported from https://fs.golderweb.de/task/157#comment35 via GOLDERWEB FS->GITEA TICKETIMPORTER Originially added: Sat Sep 23 17:25:09 2017
golderweb closed this issue 7 years ago
golderweb commented 7 years ago
Poster
Owner

Closed as https://fs.golderweb.de/task/157#taskclosed via GOLDERWEB FS->GITEA TICKETIMPORTER

Originally closed: Sat Sep 23 17:25:26 2017

---- Closed as https://fs.golderweb.de/task/157#taskclosed via GOLDERWEB FS->GITEA TICKETIMPORTER Originally closed: Sat Sep 23 17:25:26 2017
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
develop
master
Labels
Apply labels
Clear labels
No items
No Label
Milestone
Set milestone
Clear milestone
No items
No Milestone
Assignees
Assign users
Clear assignees
No Assignees
1 Participants
Notifications
Due Date

No due date set.

Dependencies

This issue currently doesn't have any dependencies.

Write Preview
Loading…
Cancel
Save
There is no content yet.
Delete Branch '%!s(MISSING)'

Deleting a branch is permanent. It CANNOT be undone. Continue?

No
Yes