search

pyk / rojak

Project Rojak, Yuk gabung diskusi di Slack nya Rojak: http://team.rojak.id/
Other
98 stars 46 forks source link

[rojak-database] [bug] Error on populate dummy data (Schema v0.5) #179

Closed bobbypriam closed 7 years ago

bobbypriam commented 7 years ago

Reproduce:

$ mysql -u root -h 127.0.0.1 -p
> DROP DATABASE rojak_database;
Query OK, 7 rows affected (0.13 sec)
> CREATE DATABASE rojak_database;
Query OK, 1 row affected (0.00 sec)

$ mysql -u root -h 127.0.0.1 rojak_database < rojak_schema_latest.sql

$ ROJAK_DB_HOST=127.0.0.1 ROJAK_DB_PASS= sh populate_rojak_database_with_dummy_data.sh
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'")
Traceback (most recent call last):
  File "generate_news_data.py", line 98, in <module>
    sentiment_i = random.randint(0, total_sentiment-1)
  File "/usr/local/Cellar/python/2.7.12_2/Frameworks/Python.framework/Versions/2.7/lib/python2.7/random.py", line 242, in randint
    return self.randrange(a, b+1)
  File "/usr/local/Cellar/python/2.7.12_2/Frameworks/Python.framework/Versions/2.7/lib/python2.7/random.py", line 218, in randrange
    raise ValueError, "empty range for randrange() (%d,%d, %d)" % (istart, istop, width)
ValueError: empty range for randrange() (0,0, 0)
pyk commented 7 years ago

oops, forgot to update the dummy data generator

pyk commented 7 years ago

@bobbypriambodo For now you can use this:

# Insert candidate, pair of candidates and sentiment data
python insert_candidate_data.py

# Insert media data
python insert_media_data.py

# Generate news data, sentiment and mention data
python generate_news_data.py
bobbypriam commented 7 years ago

Masih dapet multiple Something went wrong: (1054, "Unknown column 'candidate_id' in 'field list'") error di python generate_news_data.py mas 😅