knilssen / Founding_Fathers

Provides a reliable political feed for readers to become knowledgeable and informed voters on the state political level.
https://knilssen.github.io/Founding_Fathers
1 stars 1 forks source link

Nicknames and database entry #27

Open knilssen opened 6 years ago

knilssen commented 6 years ago

On article id = 300

['maria cantwell', 'cathy mcmorris rodgers', 'patty murray', 'jaime herrera beutler', 'dan newhouse', 'dave reichert']

ERROR: PROBLEM WITH MYSQL_ARTICLE_PERSON_LINK
MOST LIKELY HAS TO DO WITH PERSON NOT BEING IN DATABASE TABLE NEWS_PEOPLE

ARTICLE_ID:                       300
ARTICLE_PEOPLE:                   {'maria cantwell': 1, 'cathy mcmorris rodgers': 1, 'patty murray': 1, 'jaime herrera beutler': 1, 'dan newhouse': 1, 'dave reichert': 1}
PERSON:                           davereichert
MENTION_PERCENTAGE:               7.14
ARTICLE_TOTAL_COUNT_MENTIONS:     14
ERROR ON LINE 55:
          data = data[0]
PRINT DATA:
          []

dave reichert is the nickname for david reichert. For some reason we are passing the nicknamed version from petext to mysql_article_person_link.py for database entry