def get_token_time_frame(word_id, word_number):
url_to_video_point = RawQuerySet.raw_query('SELECT word_to_url FROM annotation WHERE word_id = %s AND word_number = %s', [word_id, word_number])
return url_to_video_point
def get_transcript_of_user(user_id, video_id):
full_transcript = ''
for tran in RawQuerySet.raw_query('SELECT transcript FROM videos v, segments s WHERE v.user_id = %s AND s.video_id = %s ORDER BY s.segment_id',[user_id,video_id]):
full_transcript += tran
return full_transcript
def get_transcript_of_video_title(video_title, user_id):
video_id = RawQuerySet.raw_query('SELECT video_id FROM videos WHERE title = %s',[video_title])
full_transcript = ''
for tran in RawQuerySet.raw_query('SELECT transcript FROM videos v, segments s WHERE v.user_id = %s AND s.video_id = %s ORDER BY s.segment_id',[user_id,video_id]):
full_transcript += tran
return full_transcript
def get_url_to_video(title, user_id):
video_id = RawQuerySet.raw_query('SELECT video_id FROM videos WHERE user_id = %s ' , [user_id])
url = RawQuerySet.raw_query('SELECT video_blob FROM videos WHERE video_id = %s', [video_id])
return url
