diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2017-08-01 21:16:51 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2017-08-02 19:54:54 +0100 |
| commit | 5a3b24d0f16b9d4c80a94795341a7d393314a8e7 (patch) | |
| tree | 80a2efb80d6dd14b7a8f121d5124a71f5d919a37 /p2pvr/daemon/sql/storage | |
| parent | Mocks should accept and pass through options for DryIce (diff) | |
| download | p2pvr-5a3b24d0f16b9d4c80a94795341a7d393314a8e7.tar.bz2 p2pvr-5a3b24d0f16b9d4c80a94795341a7d393314a8e7.tar.xz p2pvr-5a3b24d0f16b9d4c80a94795341a7d393314a8e7.zip | |
Store videos in the database
Diffstat (limited to 'p2pvr/daemon/sql/storage')
| -rw-r--r-- | p2pvr/daemon/sql/storage/getSize.sql | 3 | ||||
| -rw-r--r-- | p2pvr/daemon/sql/storage/writeBlock.sql | 2 |
2 files changed, 5 insertions, 0 deletions
diff --git a/p2pvr/daemon/sql/storage/getSize.sql b/p2pvr/daemon/sql/storage/getSize.sql new file mode 100644 index 0000000..1427d02 --- /dev/null +++ b/p2pvr/daemon/sql/storage/getSize.sql @@ -0,0 +1,3 @@ +SELECT SUM(LENGTH(videodata)) +FROM recordedvideo +WHERE recordingid = ? diff --git a/p2pvr/daemon/sql/storage/writeBlock.sql b/p2pvr/daemon/sql/storage/writeBlock.sql new file mode 100644 index 0000000..1b787e7 --- /dev/null +++ b/p2pvr/daemon/sql/storage/writeBlock.sql @@ -0,0 +1,2 @@ +INSERT INTO recordedvideo(recordingid, videodata) +VALUES(?, ?) |