def get_original_answer_and_mark(id):
original_id = []
db=SqliteDatabase('retention.db')
db.connect()
#get the original tweet id for each short_id
answer = ShortTweetID.select(ShortTweetID.original_tweet_id).distinct().where(ShortTweetID.short_tweet_id == id)
for a in answer:
print("original tweetid: ",a.original_tweet_id.tweet_id)
original_id.append(a.original_tweet_id.tweet_id)
#marcar la pregunta como verificada, quiere decir que esa pregunta ya no se vuelve a mandar a los usuarios
#get the original answer that belongs to that tweetid
for oid in original_id:
original_answer =AnswerTweets.select(AnswerTweets.user,AnswerTweets.woman,AnswerTweets.reason).where(AnswerTweets.tweet_message_answer ==oid)
mark_as_verified = AnswerTweets.update(has_been_verified=True).where(AnswerTweets.tweet_message_answer ==oid)
mark_as_verified.execute()
return original_answer
