new db structure added, users, filters, tweets and join table for user_filter
new db structure added, users, filters, tweets and join table for user_filter
corrected prev commit for this file
structural db creaion moved to another file
foreign key constraint added for join table to create index
new db_structural queries (_query_filter_tweet_count and _query_popular_users) added
query for tweet_id s added
location column added to tweets table
hashtags added to tweets table
save_tweet_sql method hashtag column added
user_id removed, new key is screen_name
table insertions added
new db structure table update sql queries added
find_user method and its Query_string added
update_tweet_count method added to increment the tweet count when an existing tweet arrives, it works for users, tweets, filters - common method
get_tweet_count method added to fetch the tweet count in the db
new_db structural methods added, checking if user exists if not creates, if exists update the tweet count for that user
messy code removed
user_id attribute removed
filters table PK changed to filter_name and also user_filter_join table changed