Load data about a video file into SQLite
Project description
video-to-sqlite
Load data about a video file into SQLite
Installation
Install this tool using pip
:
pip install video-to-sqlite
Usage
To create a SQLite database with metadata about a video, run:
video-to-sqlite videos.db my_video.mp4
The tool will create two tables: videos
and frames
. If videos.db
already exists, the video will be added to the
videos
table.
To create the tables with a prefix, use --prefix prefix
. For example:
video-to-sqlite videos.db cool_video.mp4 --prefix cool_
This will create tables called cool_videos
and cool_frames
.
Extra processing
Using the library programatically allows extra columns to be added to the database via a callback. Specify the
callback
argument to cli.main()
.
The function will be called once per frame in the video. It should accept a numpy ndarray as the single argument, and return a dict. The dict's keys will be added as columns to the DB, and values will be the corresponding values for that row.
An example:
import video_to_sqlite
def my_callback(frame):
has_a_cat_in_it = ai_cat_image_detector(frame)
return {'cat': has_a_cat_in_it}
video_to_sqlite.main('my_database.db', 'cool_video.mp4', 'cool_', my_callback)
See callback.py
for a working example.
video-to-sqlite --help
Usage: video-to-sqlite DB_PATH VIDEO_FILE PREFIX
Load data about Python packages from PyPI into SQLite
Usage example:
video-to-sqlite videos.db my_video.mp4 my_
Created tables will be videos and frames
To create tables called cool_videos, cool_frames use
--prefix cool_:
video-to-sqlite videos.db my_video.mp4 --prefix cool_
Options:
--version Show the version and exit.
--prefix TEXT Prefix to use for the created database tables
--help Show this message and exit.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for video_to_sqlite-0.0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 697163c93fcf9f9416514d9bde97878f6a3ed627714db718429e50d8a1ca0196 |
|
MD5 | b3c3da1bcd0dff29e0ece944b3871971 |
|
BLAKE2b-256 | ea73e756a9cf2fa2d4fbc22050265234c5dd5169bdd676d8e1b7ed437af61ab9 |