Run on Google Colab View source on GitHub Download notebook

Start EVA Server#

We are reusing the start server notebook for launching the EVA server

!wget -nc "https://raw.githubusercontent.com/georgia-tech-db/eva/master/tutorials/00-start-eva-server.ipynb"
%run 00-start-eva-server.ipynb
cursor = connect_to_server()
File ‘00-start-eva-server.ipynb’ already there; not retrieving.
nohup eva_server > eva.log 2>&1 &
Note: you may need to restart the kernel to use updated packages.

Video Files#

getting some video files to test

# A video of a happy person
!wget -nc https://www.dropbox.com/s/gzfhwmib7u804zy/defhappy.mp4?raw=1 -O defhappy.mp4

# Adding Emotion detection
!wget -nc https://raw.githubusercontent.com/georgia-tech-db/eva/master/eva/udfs/emotion_detector.py

# Adding Face Detector
!wget -nc https://raw.githubusercontent.com/georgia-tech-db/eva/master/eva/udfs/face_detector.py
File ‘defhappy.mp4’ already there; not retrieving.
File ‘emotion_detector.py’ already there; not retrieving.
File ‘face_detector.py’ already there; not retrieving.

Adding the video file to EVADB for analysis#

cursor.execute('DROP TABLE HAPPY')
response = cursor.fetch_all()
cursor.execute('LOAD VIDEO "defhappy.mp4" INTO HAPPY')
response = cursor.fetch_all()
02-08-2023 12:41:00 INFO  [db_api:db_api.py:_multiline_query_transformation:0084] Query: DROP TABLE HAPPY;
02-08-2023 12:41:00 INFO  [db_api:db_api.py:_multiline_query_transformation:0084] Query: LOAD VIDEO "defhappy.mp4" INTO HAPPY;
@status: ResponseStatus.SUCCESS
0  Table Successfully dropped: HAPPY
@query_time: 0.039577786810696125
@status: ResponseStatus.SUCCESS
0  Number of loaded VIDEO: 1
@query_time: 0.09385837288573384

Visualize Video#

from IPython.display import Video
Video("defhappy.mp4", height=450, width=800, embed=True)