update_database_add_video.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Entry for DJI_0113.MP4 already exists. Skipping...\n",
      "Entry for DJI_0114.MP4 already exists. Skipping...\n",
      "Entry for DJI_0115.MP4 already exists. Skipping...\n",
      "Entry for DJI_0116.MP4 already exists. Skipping...\n",
      "Entry for DJI_0117.MP4 already exists. Skipping...\n",
      "Entry for DJI_0118.MP4 already exists. Skipping...\n",
      "Entry for DJI_0119.MP4 already exists. Skipping...\n",
      "Entry for DJI_0120.MP4 already exists. Skipping...\n",
      "Entry for DJI_0121.MP4 already exists. Skipping...\n",
      "Entry for DJI_0122.MP4 already exists. Skipping...\n",
      "Entry for DJI_0123.MP4 already exists. Skipping...\n",
      "Entry for DJI_0124.MP4 already exists. Skipping...\n",
      "Entry for DJI_0125.MP4 already exists. Skipping...\n",
      "Entry for DJI_0126.MP4 already exists. Skipping...\n",
      "Entry for DJI_0127.MP4 already exists. Skipping...\n",
      "Entry for DJI_0128.MP4 already exists. Skipping...\n",
      "Entry for DJI_0129.MP4 already exists. Skipping...\n",
      "Entry for DJI_0130.MP4 already exists. Skipping...\n",
      "Entry for DJI_0131.MP4 already exists. Skipping...\n",
      "Entry for DJI_0132.MP4 already exists. Skipping...\n",
      "Entry for DJI_0133.MP4 already exists. Skipping...\n",
      "Entry for DJI_0134.MP4 already exists. Skipping...\n",
      "Entry for DJI_0135.MP4 already exists. Skipping...\n",
      "Entry for DJI_0136.MP4 already exists. Skipping...\n",
      "Entry for DJI_0137.MP4 already exists. Skipping...\n",
      "Entry for DJI_0138.MP4 already exists. Skipping...\n",
      "Entry for DJI_0139.MP4 already exists. Skipping...\n",
      "Entry for DJI_0140.MP4 already exists. Skipping...\n",
      "Entry for DJI_0141.MP4 already exists. Skipping...\n",
      "Entry for DJI_0142.MP4 already exists. Skipping...\n",
      "Entry for DJI_0143.MP4 already exists. Skipping...\n",
      "Entry for DJI_0151.MP4 already exists. Skipping...\n",
      "Entry for DJI_0152.MP4 already exists. Skipping...\n",
      "Entry for DJI_0153.MP4 already exists. Skipping...\n",
      "Entry for DJI_0154.MP4 already exists. Skipping...\n",
      "Entry for DJI_0155.MP4 already exists. Skipping...\n",
      "Entry for DJI_0156.MP4 already exists. Skipping...\n",
      "Entry for DJI_0157.MP4 already exists. Skipping...\n",
      "Entry for DJI_0158.MP4 already exists. Skipping...\n",
      "Entry for DJI_0159.MP4 already exists. Skipping...\n",
      "Entry for DJI_0160.MP4 already exists. Skipping...\n",
      "Entry for DJI_0161.MP4 already exists. Skipping...\n",
      "Entry for DJI_0162.MP4 already exists. Skipping...\n",
      "Entry for DJI_0163.MP4 already exists. Skipping...\n",
      "Entry for DJI_0164.MP4 already exists. Skipping...\n",
      "Entry for DJI_0165.MP4 already exists. Skipping...\n",
      "Entry for DJI_0166.MP4 already exists. Skipping...\n",
      "Entry for DJI_0167.MP4 already exists. Skipping...\n",
      "Entry for DJI_0168.MP4 already exists. Skipping...\n",
      "Entry for DJI_0169.MP4 already exists. Skipping...\n",
      "Entry for DJI_0170.MP4 already exists. Skipping...\n",
      "Entry for DJI_0171.MP4 already exists. Skipping...\n",
      "Entry for DJI_0172.MP4 already exists. Skipping...\n",
      "Entry for DJI_0173.MP4 already exists. Skipping...\n",
      "Entry for DJI_0174.MP4 already exists. Skipping...\n",
      "Entry for DJI_0175.MP4 already exists. Skipping...\n",
      "Entry for DJI_0176.MP4 already exists. Skipping...\n",
      "Entry for DJI_0177.MP4 already exists. Skipping...\n",
      "Entry for DJI_0178.MP4 already exists. Skipping...\n",
      "Entry for DJI_0179.MP4 already exists. Skipping...\n",
      "Entry for DJI_0180.MP4 already exists. Skipping...\n",
      "Entry for DJI_0181.MP4 already exists. Skipping...\n",
      "Entry for DJI_0182.MP4 already exists. Skipping...\n",
      "Entry for DJI_0183.MP4 already exists. Skipping...\n",
      "Entry for DJI_0184.MP4 already exists. Skipping...\n",
      "Entry for DJI_0185.MP4 already exists. Skipping...\n",
      "Entry for DJI_0186.MP4 already exists. Skipping...\n",
      "Entry for DJI_0187.MP4 already exists. Skipping...\n",
      "Entry for DJI_0188.MP4 already exists. Skipping...\n",
      "Entry for DJI_0189.MP4 already exists. Skipping...\n",
      "Entry for DJI_0190.MP4 already exists. Skipping...\n",
      "Entry for DJI_0191.MP4 already exists. Skipping...\n",
      "Entry for DJI_0192.MP4 already exists. Skipping...\n",
      "Entry for DJI_0193.MP4 already exists. Skipping...\n",
      "Entry for DJI_0194.MP4 already exists. Skipping...\n",
      "Entry for DJI_0195.MP4 already exists. Skipping...\n",
      "Entry for DJI_0196.MP4 already exists. Skipping...\n",
      "Entry for DJI_0197.MP4 already exists. Skipping...\n",
      "Entry for DJI_0198.MP4 already exists. Skipping...\n",
      "Entry for DJI_0199.MP4 already exists. Skipping...\n",
      "Entry for DJI_0200.MP4 already exists. Skipping...\n",
      "Entry for DJI_0201.MP4 already exists. Skipping...\n",
      "Entry for DJI_0202.MP4 already exists. Skipping...\n",
      "Entry for DJI_0203.MP4 already exists. Skipping...\n",
      "Entry for DJI_0204.MP4 already exists. Skipping...\n",
      "Entry for DJI_0205.MP4 already exists. Skipping...\n",
      "Entry for DJI_0206.MP4 already exists. Skipping...\n",
      "Entry for DJI_0207.MP4 already exists. Skipping...\n",
      "Entry for DJI_0208.MP4 already exists. Skipping...\n",
      "Entry for DJI_0209.MP4 already exists. Skipping...\n",
      "Entry for DJI_0210.MP4 already exists. Skipping...\n",
      "Entry for DJI_0211.MP4 already exists. Skipping...\n",
      "Entry for DJI_0212.MP4 already exists. Skipping...\n",
      "Entry for DJI_0213.MP4 already exists. Skipping...\n",
      "Entry for DJI_0214.MP4 already exists. Skipping...\n",
      "Entry for DJI_0215.MP4 already exists. Skipping...\n",
      "Entry for DJI_0216.MP4 already exists. Skipping...\n",
      "Entry for DJI_0217.MP4 already exists. Skipping...\n",
      "Entry for DJI_0218.MP4 already exists. Skipping...\n",
      "Entry for DJI_0219.MP4 already exists. Skipping...\n",
      "Entry for DJI_0220.MP4 already exists. Skipping...\n",
      "Entry for DJI_0221.MP4 already exists. Skipping...\n",
      "Entry for DJI_0222.MP4 already exists. Skipping...\n",
      "Entry for DJI_0223.MP4 already exists. Skipping...\n",
      "Entry for DJI_0224.MP4 already exists. Skipping...\n",
      "Entry for DJI_0225.MP4 already exists. Skipping...\n",
      "Entry for DJI_0226.MP4 already exists. Skipping...\n",
      "Entry for DJI_0227.MP4 already exists. Skipping...\n",
      "Entry for DJI_0228.MP4 already exists. Skipping...\n",
      "Entry for DJI_0229.MP4 already exists. Skipping...\n",
      "Entry for DJI_0230.MP4 already exists. Skipping...\n",
      "Entry for DJI_0231.MP4 already exists. Skipping...\n",
      "Entry for DJI_0232.MP4 already exists. Skipping...\n",
      "Entry for DJI_0233.MP4 already exists. Skipping...\n",
      "Entry for DJI_0234.MP4 already exists. Skipping...\n",
      "Entry for DJI_0235.MP4 already exists. Skipping...\n",
      "Entry for DJI_0236.MP4 already exists. Skipping...\n",
      "Entry for DJI_0237.MP4 already exists. Skipping...\n",
      "Entry for DJI_0238.MP4 already exists. Skipping...\n",
      "Entry for DJI_0239.MP4 already exists. Skipping...\n",
      "Entry for DJI_0240.MP4 already exists. Skipping...\n",
      "Entry for DJI_0241.MP4 already exists. Skipping...\n",
      "Entry for DJI_0242.MP4 already exists. Skipping...\n",
      "Entry for DJI_0243.MP4 already exists. Skipping...\n",
      "Entry for DJI_0244.MP4 already exists. Skipping...\n",
      "Entry for DJI_0245.MP4 already exists. Skipping...\n",
      "Entry for DJI_0246.MP4 already exists. Skipping...\n",
      "Entry for DJI_0247.MP4 already exists. Skipping...\n",
      "Entry for DJI_0248.MP4 already exists. Skipping...\n",
      "Entry for DJI_0249.MP4 already exists. Skipping...\n",
      "Entry for DJI_0250.MP4 already exists. Skipping...\n",
      "Entry for DJI_0251.MP4 already exists. Skipping...\n",
      "Entry for DJI_0252.MP4 already exists. Skipping...\n",
      "Entry for DJI_0253.MP4 already exists. Skipping...\n",
      "Entry for DJI_0254.MP4 already exists. Skipping...\n",
      "Entry for DJI_0255.MP4 already exists. Skipping...\n",
      "Entry for DJI_0256.MP4 already exists. Skipping...\n",
      "Entry for DJI_0257.MP4 already exists. Skipping...\n",
      "Entry for DJI_0258.MP4 already exists. Skipping...\n",
      "Entry for DJI_0259.MP4 already exists. Skipping...\n",
      "Entry for DJI_0260.MP4 already exists. Skipping...\n",
      "Entry for DJI_0261.MP4 already exists. Skipping...\n",
      "Entry for DJI_0262.MP4 already exists. Skipping...\n",
      "Entry for DJI_0263.MP4 already exists. Skipping...\n",
      "Entry for DJI_0264.MP4 already exists. Skipping...\n",
      "Entry for DJI_0265.MP4 already exists. Skipping...\n",
      "Entry for DJI_0266.MP4 already exists. Skipping...\n",
      "Entry for DJI_0267.MP4 already exists. Skipping...\n",
      "Entry for DJI_0268.MP4 already exists. Skipping...\n",
      "Entry for DJI_0269.MP4 already exists. Skipping...\n",
      "Entry for DJI_0270.MP4 already exists. Skipping...\n",
      "Entry for DJI_0271.MP4 already exists. Skipping...\n",
      "Entry for DJI_0272.MP4 already exists. Skipping...\n",
      "Entry for DJI_0273.MP4 already exists. Skipping...\n",
      "Entry for DJI_0274.MP4 already exists. Skipping...\n",
      "Entry for DJI_0275.MP4 already exists. Skipping...\n",
      "Entry for DJI_0276.MP4 already exists. Skipping...\n",
      "Entry for DJI_0277.MP4 already exists. Skipping...\n",
      "Entry for DJI_0278.MP4 already exists. Skipping...\n",
      "Entry for DJI_0279.MP4 already exists. Skipping...\n",
      "Entry for DJI_0280.MP4 already exists. Skipping...\n",
      "Entry for DJI_0287.MP4 already exists. Skipping...\n",
      "Entry for DJI_0288.MP4 already exists. Skipping...\n",
      "Entry for DJI_0289.MP4 already exists. Skipping...\n",
      "Entry for DJI_0290.MP4 already exists. Skipping...\n",
      "Entry for DJI_0291.MP4 already exists. Skipping...\n",
      "Entry for DJI_0292.MP4 already exists. Skipping...\n",
      "Entry for DJI_0293.MP4 already exists. Skipping...\n",
      "Entry for DJI_0294.MP4 already exists. Skipping...\n",
      "Entry for DJI_0295.MP4 already exists. Skipping...\n",
      "Entry for DJI_0296.MP4 already exists. Skipping...\n",
      "Entry for DJI_0297.MP4 already exists. Skipping...\n",
      "Entry for DJI_0298.MP4 already exists. Skipping...\n",
      "Entry for DJI_0299.MP4 already exists. Skipping...\n",
      "Entry for DJI_0300.MP4 already exists. Skipping...\n",
      "Entry for DJI_0301.MP4 already exists. Skipping...\n",
      "Entry for DJI_0302.MP4 already exists. Skipping...\n",
      "Entry for DJI_0303.MP4 already exists. Skipping...\n",
      "Entry for DJI_0304.MP4 already exists. Skipping...\n",
      "Entry for DJI_0305.MP4 already exists. Skipping...\n",
      "Entry for DJI_0306.MP4 already exists. Skipping...\n",
      "Entry for DJI_0307.MP4 already exists. Skipping...\n",
      "Entry for DJI_0308.MP4 already exists. Skipping...\n",
      "Entry for DJI_0309.MP4 already exists. Skipping...\n",
      "Entry for DJI_0313.MP4 already exists. Skipping...\n",
      "Entry for DJI_0323.MP4 already exists. Skipping...\n",
      "Entry for DJI_0324.MP4 already exists. Skipping...\n",
      "Entry for DJI_0329.MP4 already exists. Skipping...\n",
      "Entry for DJI_0330.MP4 already exists. Skipping...\n",
      "Entry for DJI_0331.MP4 already exists. Skipping...\n",
      "Entry for DJI_0332.MP4 already exists. Skipping...\n",
      "Entry for DJI_0333.MP4 already exists. Skipping...\n",
      "Entry for DJI_0334.MP4 already exists. Skipping...\n",
      "Entry for DJI_0335.MP4 already exists. Skipping...\n",
      "Entry for DJI_0336.MP4 already exists. Skipping...\n",
      "Entry for DJI_0337.MP4 already exists. Skipping...\n",
      "Entry for DJI_0338.MP4 already exists. Skipping...\n",
      "Entry for DJI_0339.MP4 already exists. Skipping...\n",
      "Entry for DJI_0340.MP4 already exists. Skipping...\n",
      "Entry for DJI_0341.MP4 already exists. Skipping...\n",
      "Entry for DJI_0342.MP4 already exists. Skipping...\n",
      "Entry for DJI_0343.MP4 already exists. Skipping...\n",
      "Entry for DJI_0344.MP4 already exists. Skipping...\n",
      "Entry for DJI_0345.MP4 already exists. Skipping...\n",
      "Entry for DJI_0346.MP4 already exists. Skipping...\n",
      "Entry for DJI_0347.MP4 already exists. Skipping...\n",
      "Entry for DJI_0348.MP4 already exists. Skipping...\n",
      "Entry for DJI_0349.MP4 already exists. Skipping...\n",
      "Entry for DJI_0350.MP4 already exists. Skipping...\n",
      "Entry for DJI_0351.MP4 already exists. Skipping...\n",
      "Entry for DJI_0352.MP4 already exists. Skipping...\n",
      "Entry for DJI_0353.MP4 already exists. Skipping...\n",
      "Entry for DJI_0354.MP4 already exists. Skipping...\n",
      "Entry for DJI_0355.MP4 already exists. Skipping...\n",
      "Entry for DJI_0356.MP4 already exists. Skipping...\n",
      "Entry for DJI_0357.MP4 already exists. Skipping...\n",
      "Entry for DJI_0358.MP4 already exists. Skipping...\n",
      "Entry for DJI_0359.MP4 already exists. Skipping...\n",
      "Entry for DJI_0360.MP4 already exists. Skipping...\n",
      "Entry for DJI_0361.MP4 already exists. Skipping...\n",
      "Entry for DJI_0362.MP4 already exists. Skipping...\n",
      "Entry for DJI_0363.MP4 already exists. Skipping...\n",
      "Entry for DJI_0364.MP4 already exists. Skipping...\n",
      "Entry for DJI_0365.MP4 already exists. Skipping...\n",
      "Entry for DJI_0366.MP4 already exists. Skipping...\n",
      "Entry for DJI_0367.MP4 already exists. Skipping...\n",
      "Entry for DJI_0368.MP4 already exists. Skipping...\n",
      "Entry for DJI_0369.MP4 already exists. Skipping...\n",
      "Entry for DJI_0370.MP4 already exists. Skipping...\n",
      "Entry for DJI_0371.MP4 already exists. Skipping...\n",
      "Entry for DJI_0372.MP4 already exists. Skipping...\n",
      "Entry for DJI_0373.MP4 already exists. Skipping...\n",
      "Entry for DJI_0374.MP4 already exists. Skipping...\n",
      "Entry for DJI_0375.MP4 already exists. Skipping...\n",
      "Entry for DJI_0376.MP4 already exists. Skipping...\n",
      "Entry for DJI_0377.MP4 already exists. Skipping...\n",
      "Entry for DJI_0378.MP4 already exists. Skipping...\n",
      "Entry for DJI_0379.MP4 already exists. Skipping...\n",
      "Entry for DJI_0380.MP4 already exists. Skipping...\n",
      "Entry for DJI_0381.MP4 already exists. Skipping...\n",
      "Entry for DJI_0382.MP4 already exists. Skipping...\n",
      "Entry for DJI_0383.MP4 already exists. Skipping...\n",
      "Entry for DJI_0391.MP4 already exists. Skipping...\n",
      "Entry for DJI_0392.MP4 already exists. Skipping...\n",
      "Entry for DJI_0393.MP4 already exists. Skipping...\n",
      "Entry for DJI_0394.MP4 already exists. Skipping...\n",
      "Entry for DJI_0395.MP4 already exists. Skipping...\n",
      "Entry for DJI_0400.MP4 already exists. Skipping...\n",
      "Entry for DJI_0401.MP4 already exists. Skipping...\n",
      "Entry for DJI_0402.MP4 already exists. Skipping...\n",
      "Entry for DJI_0403.MP4 already exists. Skipping...\n",
      "Entry for DJI_0404.MP4 already exists. Skipping...\n",
      "Entry for DJI_0405.MP4 already exists. Skipping...\n",
      "Entry for DJI_0406.MP4 already exists. Skipping...\n",
      "Entry for DJI_0407.MP4 already exists. Skipping...\n",
      "Entry for DJI_0408.MP4 already exists. Skipping...\n",
      "Entry for DJI_0409.MP4 already exists. Skipping...\n",
      "Entry for DJI_0410.MP4 already exists. Skipping...\n",
      "Entry for DJI_0411.MP4 already exists. Skipping...\n",
      "Entry for DJI_0412.MP4 already exists. Skipping...\n",
      "Entry for DJI_0413.MP4 already exists. Skipping...\n",
      "Entry for DJI_0414.MP4 already exists. Skipping...\n",
      "Entry for DJI_0415.MP4 already exists. Skipping...\n",
      "Entry for DJI_0416.MP4 already exists. Skipping...\n",
      "Entry for DJI_0417.MP4 already exists. Skipping...\n",
      "Entry for DJI_0418.MP4 already exists. Skipping...\n",
      "Entry for DJI_0419.MP4 already exists. Skipping...\n",
      "Entry for DJI_0420.MP4 already exists. Skipping...\n",
      "Entry for DJI_0421.MP4 already exists. Skipping...\n",
      "Entry for DJI_0422.MP4 already exists. Skipping...\n",
      "Entry for DJI_0423.MP4 already exists. Skipping...\n",
      "Entry for DJI_0424.MP4 already exists. Skipping...\n",
      "Entry for DJI_0425.MP4 already exists. Skipping...\n",
      "Entry for DJI_0426.MP4 already exists. Skipping...\n",
      "Entry for DJI_0427.MP4 already exists. Skipping...\n",
      "Entry for DJI_0428.MP4 already exists. Skipping...\n",
      "Entry for DJI_0429.MP4 already exists. Skipping...\n",
      "Entry for DJI_0430.MP4 already exists. Skipping...\n",
      "Entry for DJI_0431.MP4 already exists. Skipping...\n",
      "Entry for DJI_0432.MP4 already exists. Skipping...\n",
      "Entry for DJI_0433.MP4 already exists. Skipping...\n",
      "Entry for DJI_0434.MP4 already exists. Skipping...\n",
      "Entry for DJI_0445.MP4 already exists. Skipping...\n",
      "Entry for DJI_0446.MP4 already exists. Skipping...\n",
      "Entry for DJI_0447.MP4 already exists. Skipping...\n",
      "Entry for DJI_0448.MP4 already exists. Skipping...\n",
      "Entry for DJI_0449.MP4 already exists. Skipping...\n",
      "Entry for DJI_0450.MP4 already exists. Skipping...\n",
      "Entry for DJI_0451.MP4 already exists. Skipping...\n",
      "Entry for DJI_0452.MP4 already exists. Skipping...\n",
      "Entry for DJI_0453.MP4 already exists. Skipping...\n",
      "Entry for DJI_0454.MP4 already exists. Skipping...\n",
      "Entry for DJI_0455.MP4 already exists. Skipping...\n",
      "Entry for DJI_0456.MP4 already exists. Skipping...\n",
      "Entry for DJI_0457.MP4 already exists. Skipping...\n",
      "Entry for DJI_0458.MP4 already exists. Skipping...\n",
      "Entry for DJI_0459.MP4 already exists. Skipping...\n",
      "Entry for DJI_0460.MP4 already exists. Skipping...\n",
      "Entry for DJI_0461.MP4 already exists. Skipping...\n",
      "Entry for DJI_0462.MP4 already exists. Skipping...\n",
      "Entry for DJI_0463.MP4 already exists. Skipping...\n",
      "Entry for DJI_0464.MP4 already exists. Skipping...\n",
      "Entry for DJI_0465.MP4 already exists. Skipping...\n",
      "Entry for DJI_0466.MP4 already exists. Skipping...\n",
      "Entry for DJI_0467.MP4 already exists. Skipping...\n",
      "Entry for DJI_0468.MP4 already exists. Skipping...\n",
      "Entry for DJI_0469.MP4 already exists. Skipping...\n",
      "Entry for DJI_0470.MP4 already exists. Skipping...\n",
      "Entry for DJI_0471.MP4 already exists. Skipping...\n",
      "Entry for DJI_0472.MP4 already exists. Skipping...\n",
      "Entry for DJI_0473.MP4 already exists. Skipping...\n",
      "Entry for DJI_0474.MP4 already exists. Skipping...\n",
      "Entry for DJI_0475.MP4 already exists. Skipping...\n",
      "Entry for DJI_0476.MP4 already exists. Skipping...\n",
      "Entry for DJI_0477.MP4 already exists. Skipping...\n",
      "Entry for DJI_0478.MP4 already exists. Skipping...\n",
      "Entry for DJI_0479.MP4 already exists. Skipping...\n",
      "Entry for DJI_0480.MP4 already exists. Skipping...\n",
      "Entry for DJI_0481.MP4 already exists. Skipping...\n",
      "Entry for DJI_0482.MP4 already exists. Skipping...\n",
      "Entry for DJI_0483.MP4 already exists. Skipping...\n",
      "Entry for DJI_0484.MP4 already exists. Skipping...\n",
      "Entry for DJI_0485.MP4 already exists. Skipping...\n",
      "Entry for DJI_0486.MP4 already exists. Skipping...\n",
      "Entry for DJI_0487.MP4 already exists. Skipping...\n",
      "Entry for DJI_0488.MP4 already exists. Skipping...\n",
      "Entry for DJI_0489.MP4 already exists. Skipping...\n",
      "Entry for DJI_0490.MP4 already exists. Skipping...\n",
      "Entry for DJI_0491.MP4 already exists. Skipping...\n",
      "Entry for DJI_0492.MP4 already exists. Skipping...\n",
      "Entry for DJI_0493.MP4 already exists. Skipping...\n",
      "Entry for DJI_0494.MP4 already exists. Skipping...\n",
      "Entry for DJI_0495.MP4 already exists. Skipping...\n",
      "Entry for DJI_0496.MP4 already exists. Skipping...\n",
      "Entry for DJI_0497.MP4 already exists. Skipping...\n",
      "Entry for DJI_0498.MP4 already exists. Skipping...\n",
      "Entry for DJI_0499.MP4 already exists. Skipping...\n",
      "Entry for DJI_0500.MP4 already exists. Skipping...\n",
      "Entry for DJI_0501.MP4 already exists. Skipping...\n",
      "Entry for DJI_0502.MP4 already exists. Skipping...\n",
      "Entry for DJI_0503.MP4 already exists. Skipping...\n",
      "Entry for DJI_0504.MP4 already exists. Skipping...\n",
      "Entry for DJI_0505.MP4 already exists. Skipping...\n",
      "Entry for DJI_0506.MP4 already exists. Skipping...\n",
      "Entry for DJI_0519.MP4 already exists. Skipping...\n",
      "Entry for DJI_0520.MP4 already exists. Skipping...\n",
      "Entry for DJI_0521.MP4 already exists. Skipping...\n",
      "Entry for DJI_0522.MP4 already exists. Skipping...\n",
      "Entry for DJI_0523.MP4 already exists. Skipping...\n",
      "Entry for DJI_0524.MP4 already exists. Skipping...\n",
      "Entry for DJI_0525.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0526.MP4 to the video table.\n",
      "Entry for DJI_0527.MP4 already exists. Skipping...\n",
      "Entry for DJI_0528.MP4 already exists. Skipping...\n",
      "Entry for DJI_0529.MP4 already exists. Skipping...\n",
      "Entry for DJI_0530.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0531.MP4 to the video table.\n",
      "Entry for DJI_0532.MP4 already exists. Skipping...\n",
      "Entry for DJI_0542.MP4 already exists. Skipping...\n",
      "Entry for DJI_0543.MP4 already exists. Skipping...\n",
      "Entry for DJI_0544.MP4 already exists. Skipping...\n",
      "Entry for DJI_0545.MP4 already exists. Skipping...\n",
      "Entry for DJI_0550.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0551.MP4 to the video table.\n",
      "Added entry for DJI_0552.MP4 to the video table.\n",
      "Entry for DJI_0553.MP4 already exists. Skipping...\n",
      "Entry for DJI_0554.MP4 already exists. Skipping...\n",
      "Entry for DJI_0555.MP4 already exists. Skipping...\n",
      "Entry for DJI_0556.MP4 already exists. Skipping...\n",
      "Entry for DJI_0557.MP4 already exists. Skipping...\n",
      "Entry for DJI_0569.MP4 already exists. Skipping...\n",
      "Entry for DJI_0570.MP4 already exists. Skipping...\n",
      "Entry for DJI_0571.MP4 already exists. Skipping...\n",
      "Entry for DJI_0572.MP4 already exists. Skipping...\n",
      "Entry for DJI_0573.MP4 already exists. Skipping...\n",
      "Entry for DJI_0574.MP4 already exists. Skipping...\n",
      "Entry for DJI_0575.MP4 already exists. Skipping...\n",
      "Entry for DJI_0576.MP4 already exists. Skipping...\n",
      "Entry for DJI_0577.MP4 already exists. Skipping...\n",
      "Entry for DJI_0578.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0579.MP4 to the video table.\n",
      "Entry for DJI_0580.MP4 already exists. Skipping...\n",
      "Entry for DJI_0581.MP4 already exists. Skipping...\n",
      "Entry for DJI_0582.MP4 already exists. Skipping...\n",
      "Entry for DJI_0583.MP4 already exists. Skipping...\n",
      "Entry for DJI_0584.MP4 already exists. Skipping...\n",
      "Entry for DJI_0585.MP4 already exists. Skipping...\n",
      "Entry for DJI_0586.MP4 already exists. Skipping...\n",
      "Entry for DJI_0587.MP4 already exists. Skipping...\n",
      "Entry for DJI_0588.MP4 already exists. Skipping...\n",
      "Entry for DJI_0589.MP4 already exists. Skipping...\n",
      "Entry for DJI_0590.MP4 already exists. Skipping...\n",
      "Entry for DJI_0591.MP4 already exists. Skipping...\n",
      "Entry for DJI_0592.MP4 already exists. Skipping...\n",
      "Entry for DJI_0593.MP4 already exists. Skipping...\n",
      "Entry for DJI_0594.MP4 already exists. Skipping...\n",
      "Entry for DJI_0595.MP4 already exists. Skipping...\n",
      "Entry for DJI_0596.MP4 already exists. Skipping...\n",
      "Entry for DJI_0597.MP4 already exists. Skipping...\n",
      "Entry for DJI_0598.MP4 already exists. Skipping...\n",
      "Entry for DJI_0599.MP4 already exists. Skipping...\n",
      "Entry for DJI_0602.MP4 already exists. Skipping...\n",
      "Entry for DJI_0603.MP4 already exists. Skipping...\n",
      "Entry for DJI_0604.MP4 already exists. Skipping...\n",
      "Entry for DJI_0605.MP4 already exists. Skipping...\n",
      "Entry for DJI_0606.MP4 already exists. Skipping...\n",
      "Entry for DJI_0607.MP4 already exists. Skipping...\n",
      "Entry for DJI_0608.MP4 already exists. Skipping...\n",
      "Entry for DJI_0609.MP4 already exists. Skipping...\n",
      "Entry for DJI_0610.MP4 already exists. Skipping...\n",
      "Entry for DJI_0611.MP4 already exists. Skipping...\n",
      "Entry for DJI_0612.MP4 already exists. Skipping...\n",
      "Entry for DJI_0613.MP4 already exists. Skipping...\n",
      "Entry for DJI_0614.MP4 already exists. Skipping...\n",
      "Entry for DJI_0615.MP4 already exists. Skipping...\n",
      "Entry for DJI_0616.MP4 already exists. Skipping...\n",
      "Entry for DJI_0617.MP4 already exists. Skipping...\n",
      "Entry for DJI_0618.MP4 already exists. Skipping...\n",
      "Entry for DJI_0619.MP4 already exists. Skipping...\n",
      "Entry for DJI_0620.MP4 already exists. Skipping...\n",
      "Entry for DJI_0621.MP4 already exists. Skipping...\n",
      "Entry for DJI_0622.MP4 already exists. Skipping...\n",
      "Entry for DJI_0623.MP4 already exists. Skipping...\n",
      "Entry for DJI_0624.MP4 already exists. Skipping...\n",
      "Entry for DJI_0625.MP4 already exists. Skipping...\n",
      "Entry for DJI_0626.MP4 already exists. Skipping...\n",
      "Entry for DJI_0627.MP4 already exists. Skipping...\n",
      "Entry for DJI_0628.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0629.MP4 to the video table.\n",
      "Added entry for DJI_0630.MP4 to the video table.\n",
      "Entry for DJI_0632.MP4 already exists. Skipping...\n",
      "Entry for DJI_0633.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0634.MP4 to the video table.\n",
      "Entry for DJI_0635.MP4 already exists. Skipping...\n",
      "Entry for DJI_0636.MP4 already exists. Skipping...\n",
      "Entry for DJI_0637.MP4 already exists. Skipping...\n",
      "Entry for DJI_0638.MP4 already exists. Skipping...\n",
      "Entry for DJI_0639.MP4 already exists. Skipping...\n",
      "Entry for DJI_0640.MP4 already exists. Skipping...\n",
      "Entry for DJI_0641.MP4 already exists. Skipping...\n",
      "Entry for DJI_0644.MP4 already exists. Skipping...\n",
      "Entry for DJI_0652.MP4 already exists. Skipping...\n",
      "Entry for DJI_0653.MP4 already exists. Skipping...\n",
      "Entry for DJI_0654.MP4 already exists. Skipping...\n",
      "Entry for DJI_0655.MP4 already exists. Skipping...\n",
      "Entry for DJI_0656.MP4 already exists. Skipping...\n",
      "Entry for DJI_0657.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0658.MP4 to the video table.\n",
      "Entry for DJI_0659.MP4 already exists. Skipping...\n",
      "Entry for DJI_0660.MP4 already exists. Skipping...\n",
      "Entry for DJI_0661.MP4 already exists. Skipping...\n",
      "Entry for DJI_0662.MP4 already exists. Skipping...\n",
      "Entry for DJI_0663.MP4 already exists. Skipping...\n",
      "Entry for DJI_0664.MP4 already exists. Skipping...\n",
      "Entry for DJI_0665.MP4 already exists. Skipping...\n",
      "Entry for DJI_0666.MP4 already exists. Skipping...\n",
      "Entry for DJI_0667.MP4 already exists. Skipping...\n",
      "Entry for DJI_0668.MP4 already exists. Skipping...\n",
      "Entry for DJI_0669.MP4 already exists. Skipping...\n",
      "Entry for DJI_0670.MP4 already exists. Skipping...\n",
      "Entry for DJI_0671.MP4 already exists. Skipping...\n",
      "Entry for DJI_0672.MP4 already exists. Skipping...\n",
      "Entry for DJI_0673.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0674.MP4 to the video table.\n",
      "Entry for DJI_0675.MP4 already exists. Skipping...\n",
      "Entry for DJI_0676.MP4 already exists. Skipping...\n",
      "Entry for DJI_0677.MP4 already exists. Skipping...\n",
      "Entry for DJI_0678.MP4 already exists. Skipping...\n",
      "Entry for DJI_0679.MP4 already exists. Skipping...\n",
      "Entry for DJI_0680.MP4 already exists. Skipping...\n",
      "Entry for DJI_0681.MP4 already exists. Skipping...\n",
      "Entry for DJI_0682.MP4 already exists. Skipping...\n",
      "Entry for DJI_0683.MP4 already exists. Skipping...\n",
      "Entry for DJI_0684.MP4 already exists. Skipping...\n",
      "Entry for DJI_0685.MP4 already exists. Skipping...\n",
      "Entry for DJI_0686.MP4 already exists. Skipping...\n",
      "Entry for DJI_0695.MP4 already exists. Skipping...\n",
      "Entry for DJI_0696.MP4 already exists. Skipping...\n",
      "Entry for DJI_0697.MP4 already exists. Skipping...\n",
      "Entry for DJI_0698.MP4 already exists. Skipping...\n",
      "Entry for DJI_0699.MP4 already exists. Skipping...\n",
      "Entry for DJI_0700.MP4 already exists. Skipping...\n",
      "Entry for DJI_0701.MP4 already exists. Skipping...\n",
      "Entry for DJI_0702.MP4 already exists. Skipping...\n",
      "Entry for DJI_0703.MP4 already exists. Skipping...\n",
      "Entry for DJI_0704.MP4 already exists. Skipping...\n",
      "Entry for DJI_0705.MP4 already exists. Skipping...\n",
      "Entry for DJI_0706.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0707.MP4 to the video table.\n",
      "Entry for DJI_0708.MP4 already exists. Skipping...\n",
      "Entry for DJI_0709.MP4 already exists. Skipping...\n",
      "Entry for DJI_0710.MP4 already exists. Skipping...\n",
      "Entry for DJI_0711.MP4 already exists. Skipping...\n",
      "Entry for DJI_0712.MP4 already exists. Skipping...\n",
      "Entry for DJI_0722.MP4 already exists. Skipping...\n",
      "Entry for DJI_0723.MP4 already exists. Skipping...\n",
      "Entry for DJI_0724.MP4 already exists. Skipping...\n",
      "Entry for DJI_0725.MP4 already exists. Skipping...\n",
      "Entry for DJI_0726.MP4 already exists. Skipping...\n",
      "Entry for DJI_0727.MP4 already exists. Skipping...\n",
      "Entry for DJI_0728.MP4 already exists. Skipping...\n",
      "Entry for DJI_0729.MP4 already exists. Skipping...\n",
      "Entry for DJI_0730.MP4 already exists. Skipping...\n",
      "Entry for DJI_0731.MP4 already exists. Skipping...\n",
      "Entry for DJI_0732.MP4 already exists. Skipping...\n",
      "Entry for DJI_0733.MP4 already exists. Skipping...\n",
      "Entry for DJI_0734.MP4 already exists. Skipping...\n",
      "Entry for DJI_0735.MP4 already exists. Skipping...\n",
      "Entry for DJI_0736.MP4 already exists. Skipping...\n",
      "Entry for DJI_0737.MP4 already exists. Skipping...\n",
      "Entry for DJI_0738.MP4 already exists. Skipping...\n",
      "Entry for DJI_0739.MP4 already exists. Skipping...\n",
      "Entry for DJI_0740.MP4 already exists. Skipping...\n",
      "Entry for DJI_0741.MP4 already exists. Skipping...\n",
      "Entry for DJI_0742.MP4 already exists. Skipping...\n",
      "Entry for DJI_0743.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0744.MP4 to the video table.\n",
      "Entry for DJI_0745.MP4 already exists. Skipping...\n",
      "Entry for DJI_0746.MP4 already exists. Skipping...\n",
      "Entry for DJI_0747.MP4 already exists. Skipping...\n",
      "Entry for DJI_0748.MP4 already exists. Skipping...\n",
      "Entry for DJI_0749.MP4 already exists. Skipping...\n",
      "Entry for DJI_0750.MP4 already exists. Skipping...\n",
      "Entry for DJI_0751.MP4 already exists. Skipping...\n",
      "Entry for DJI_0752.MP4 already exists. Skipping...\n",
      "Entry for DJI_0753.MP4 already exists. Skipping...\n",
      "Entry for DJI_0754.MP4 already exists. Skipping...\n",
      "Entry for DJI_0755.MP4 already exists. Skipping...\n",
      "Entry for DJI_0756.MP4 already exists. Skipping...\n",
      "Entry for DJI_0757.MP4 already exists. Skipping...\n",
      "Entry for DJI_0758.MP4 already exists. Skipping...\n",
      "Entry for DJI_0759.MP4 already exists. Skipping...\n",
      "Entry for DJI_0760.MP4 already exists. Skipping...\n",
      "Entry for DJI_0761.MP4 already exists. Skipping...\n",
      "Entry for DJI_0762.MP4 already exists. Skipping...\n",
      "Entry for DJI_0763.MP4 already exists. Skipping...\n",
      "Entry for DJI_0764.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0765.MP4 to the video table.\n",
      "Entry for DJI_0766.MP4 already exists. Skipping...\n",
      "Entry for DJI_0767.MP4 already exists. Skipping...\n",
      "Entry for DJI_0768.MP4 already exists. Skipping...\n",
      "Entry for DJI_0769.MP4 already exists. Skipping...\n",
      "Entry for DJI_0770.MP4 already exists. Skipping...\n",
      "Entry for DJI_0771.MP4 already exists. Skipping...\n",
      "Entry for DJI_0772.MP4 already exists. Skipping...\n",
      "Entry for DJI_0773.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0774.MP4 to the video table.\n",
      "Entry for DJI_0775.MP4 already exists. Skipping...\n",
      "Entry for DJI_0776.MP4 already exists. Skipping...\n",
      "Entry for DJI_0777.MP4 already exists. Skipping...\n",
      "Entry for DJI_0778.MP4 already exists. Skipping...\n",
      "Entry for DJI_0779.MP4 already exists. Skipping...\n",
      "Entry for DJI_0780.MP4 already exists. Skipping...\n",
      "Entry for DJI_0781.MP4 already exists. Skipping...\n",
      "Entry for DJI_0782.MP4 already exists. Skipping...\n",
      "Entry for DJI_0783.MP4 already exists. Skipping...\n",
      "Entry for DJI_0784.MP4 already exists. Skipping...\n",
      "Entry for DJI_0785.MP4 already exists. Skipping...\n",
      "Entry for DJI_0786.MP4 already exists. Skipping...\n",
      "Entry for DJI_0787.MP4 already exists. Skipping...\n",
      "Entry for DJI_0788.MP4 already exists. Skipping...\n",
      "Entry for DJI_0789.MP4 already exists. Skipping...\n",
      "Entry for DJI_0790.MP4 already exists. Skipping...\n",
      "Entry for DJI_0791.MP4 already exists. Skipping...\n",
      "Entry for DJI_0792.MP4 already exists. Skipping...\n",
      "Entry for DJI_0793.MP4 already exists. Skipping...\n",
      "Entry for DJI_0794.MP4 already exists. Skipping...\n",
      "Entry for DJI_0795.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0796.MP4 to the video table.\n",
      "Entry for DJI_0804.MP4 already exists. Skipping...\n",
      "Entry for DJI_0805.MP4 already exists. Skipping...\n",
      "Entry for DJI_0806.MP4 already exists. Skipping...\n",
      "Entry for DJI_0807.MP4 already exists. Skipping...\n",
      "Entry for DJI_0808.MP4 already exists. Skipping...\n",
      "Entry for DJI_0809.MP4 already exists. Skipping...\n",
      "Entry for DJI_0810.MP4 already exists. Skipping...\n",
      "Entry for DJI_0811.MP4 already exists. Skipping...\n",
      "Entry for DJI_0812.MP4 already exists. Skipping...\n",
      "Entry for DJI_0813.MP4 already exists. Skipping...\n",
      "Entry for DJI_0814.MP4 already exists. Skipping...\n",
      "Entry for DJI_0815.MP4 already exists. Skipping...\n",
      "Entry for DJI_0816.MP4 already exists. Skipping...\n",
      "Entry for DJI_0817.MP4 already exists. Skipping...\n",
      "Entry for DJI_0821.MP4 already exists. Skipping...\n",
      "Entry for DJI_0822.MP4 already exists. Skipping...\n",
      "Entry for DJI_0823.MP4 already exists. Skipping...\n",
      "Entry for DJI_0824.MP4 already exists. Skipping...\n",
      "Entry for DJI_0825.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0826.MP4 to the video table.\n",
      "Entry for DJI_0827.MP4 already exists. Skipping...\n",
      "Entry for DJI_0828.MP4 already exists. Skipping...\n",
      "Entry for DJI_0829.MP4 already exists. Skipping...\n",
      "Entry for DJI_0830.MP4 already exists. Skipping...\n",
      "Entry for DJI_0831.MP4 already exists. Skipping...\n",
      "Entry for DJI_0832.MP4 already exists. Skipping...\n",
      "Entry for DJI_0833.MP4 already exists. Skipping...\n",
      "Entry for DJI_0834.MP4 already exists. Skipping...\n",
      "Entry for DJI_0835.MP4 already exists. Skipping...\n",
      "Entry for DJI_0836.MP4 already exists. Skipping...\n",
      "Entry for DJI_0837.MP4 already exists. Skipping...\n",
      "Entry for DJI_0838.MP4 already exists. Skipping...\n",
      "Entry for DJI_0839.MP4 already exists. Skipping...\n",
      "Entry for DJI_0840.MP4 already exists. Skipping...\n",
      "Entry for DJI_0841.MP4 already exists. Skipping...\n",
      "Entry for DJI_0842.MP4 already exists. Skipping...\n",
      "Entry for DJI_0843.MP4 already exists. Skipping...\n",
      "Entry for DJI_0844.MP4 already exists. Skipping...\n",
      "Entry for DJI_0845.MP4 already exists. Skipping...\n",
      "Entry for DJI_0846.MP4 already exists. Skipping...\n",
      "Entry for DJI_0847.MP4 already exists. Skipping...\n",
      "Entry for DJI_0848.MP4 already exists. Skipping...\n",
      "Entry for DJI_0849.MP4 already exists. Skipping...\n",
      "Entry for DJI_0850.MP4 already exists. Skipping...\n",
      "Entry for DJI_0851.MP4 already exists. Skipping...\n",
      "Entry for DJI_0852.MP4 already exists. Skipping...\n",
      "Entry for DJI_0853.MP4 already exists. Skipping...\n",
      "Entry for DJI_0854.MP4 already exists. Skipping...\n",
      "Entry for DJI_0866.MP4 already exists. Skipping...\n",
      "Entry for DJI_0867.MP4 already exists. Skipping...\n",
      "Entry for DJI_0869.MP4 already exists. Skipping...\n",
      "Entry for DJI_0874.MP4 already exists. Skipping...\n",
      "Entry for DJI_0875.MP4 already exists. Skipping...\n",
      "Entry for DJI_0876.MP4 already exists. Skipping...\n",
      "Entry for DJI_0877.MP4 already exists. Skipping...\n",
      "Entry for DJI_0878.MP4 already exists. Skipping...\n",
      "Entry for DJI_0879.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0880.MP4 to the video table.\n",
      "Entry for DJI_0881.MP4 already exists. Skipping...\n",
      "Entry for DJI_0882.MP4 already exists. Skipping...\n",
      "Entry for DJI_0883.MP4 already exists. Skipping...\n",
      "Entry for DJI_0884.MP4 already exists. Skipping...\n",
      "Entry for DJI_0885.MP4 already exists. Skipping...\n",
      "Entry for DJI_0886.MP4 already exists. Skipping...\n",
      "Entry for DJI_0887.MP4 already exists. Skipping...\n",
      "Entry for DJI_0888.MP4 already exists. Skipping...\n",
      "Entry for DJI_0889.MP4 already exists. Skipping...\n",
      "Entry for DJI_0890.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0891.MP4 to the video table.\n",
      "Entry for DJI_0892.MP4 already exists. Skipping...\n",
      "Entry for DJI_0893.MP4 already exists. Skipping...\n",
      "Entry for DJI_0894.MP4 already exists. Skipping...\n",
      "Entry for DJI_0895.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0899.MP4 to the video table.\n",
      "Entry for DJI_0900.MP4 already exists. Skipping...\n",
      "Entry for DJI_0901.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0902.MP4 to the video table.\n",
      "Entry for DJI_0903.MP4 already exists. Skipping...\n",
      "Entry for DJI_0904.MP4 already exists. Skipping...\n",
      "Entry for DJI_0905.MP4 already exists. Skipping...\n",
      "Entry for DJI_0906.MP4 already exists. Skipping...\n",
      "Entry for DJI_0907.MP4 already exists. Skipping...\n",
      "Entry for DJI_0908.MP4 already exists. Skipping...\n",
      "Entry for DJI_0909.MP4 already exists. Skipping...\n",
      "Entry for DJI_0910.MP4 already exists. Skipping...\n",
      "Entry for DJI_0911.MP4 already exists. Skipping...\n",
      "Entry for DJI_0912.MP4 already exists. Skipping...\n",
      "Entry for DJI_0921.MP4 already exists. Skipping...\n",
      "Entry for DJI_0922.MP4 already exists. Skipping...\n",
      "Entry for DJI_0923.MP4 already exists. Skipping...\n",
      "Entry for DJI_0924.MP4 already exists. Skipping...\n",
      "Entry for DJI_0925.MP4 already exists. Skipping...\n",
      "Entry for DJI_0926.MP4 already exists. Skipping...\n",
      "Entry for DJI_0927.MP4 already exists. Skipping...\n",
      "Entry for DJI_0928.MP4 already exists. Skipping...\n",
      "Entry for DJI_0929.MP4 already exists. Skipping...\n",
      "Entry for DJI_0930.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0931.MP4 to the video table.\n",
      "Entry for DJI_0932.MP4 already exists. Skipping...\n",
      "Entry for DJI_0933.MP4 already exists. Skipping...\n",
      "Entry for DJI_0934.MP4 already exists. Skipping...\n",
      "Entry for DJI_0935.MP4 already exists. Skipping...\n",
      "Entry for DJI_0936.MP4 already exists. Skipping...\n",
      "Entry for DJI_0937.MP4 already exists. Skipping...\n",
      "Entry for DJI_0938.MP4 already exists. Skipping...\n",
      "Entry for DJI_0939.MP4 already exists. Skipping...\n",
      "Entry for DJI_0940.MP4 already exists. Skipping...\n",
      "Entry for DJI_0941.MP4 already exists. Skipping...\n",
      "Entry for DJI_0942.MP4 already exists. Skipping...\n",
      "Entry for DJI_0943.MP4 already exists. Skipping...\n",
      "Entry for DJI_0944.MP4 already exists. Skipping...\n",
      "Entry for DJI_0945.MP4 already exists. Skipping...\n",
      "Entry for DJI_0946.MP4 already exists. Skipping...\n",
      "Entry for DJI_0947.MP4 already exists. Skipping...\n",
      "Entry for DJI_0948.MP4 already exists. Skipping...\n",
      "Entry for DJI_0949.MP4 already exists. Skipping...\n",
      "Entry for DJI_0950.MP4 already exists. Skipping...\n",
      "Entry for DJI_0951.MP4 already exists. Skipping...\n",
      "Entry for DJI_0952.MP4 already exists. Skipping...\n",
      "Entry for DJI_0953.MP4 already exists. Skipping...\n",
      "Entry for DJI_0954.MP4 already exists. Skipping...\n",
      "Entry for DJI_0955.MP4 already exists. Skipping...\n",
      "Entry for DJI_0956.MP4 already exists. Skipping...\n",
      "Entry for DJI_0957.MP4 already exists. Skipping...\n",
      "Entry for DJI_0958.MP4 already exists. Skipping...\n",
      "Entry for DJI_0959.MP4 already exists. Skipping...\n",
      "Entry for DJI_0960.MP4 already exists. Skipping...\n",
      "Entry for DJI_0961.MP4 already exists. Skipping...\n",
      "Entry for DJI_0962.MP4 already exists. Skipping...\n",
      "Entry for DJI_0963.MP4 already exists. Skipping...\n",
      "Entry for DJI_0964.MP4 already exists. Skipping...\n",
      "Entry for DJI_0965.MP4 already exists. Skipping...\n",
      "Entry for DJI_0966.MP4 already exists. Skipping...\n",
      "Entry for DJI_0967.MP4 already exists. Skipping...\n",
      "Entry for DJI_0968.MP4 already exists. Skipping...\n",
      "Entry for DJI_0969.MP4 already exists. Skipping...\n",
      "Entry for DJI_0970.MP4 already exists. Skipping...\n",
      "Entry for DJI_0971.MP4 already exists. Skipping...\n",
      "Entry for DJI_0972.MP4 already exists. Skipping...\n",
      "Entry for DJI_0973.MP4 already exists. Skipping...\n",
      "Entry for DJI_0974.MP4 already exists. Skipping...\n",
      "Entry for DJI_0975.MP4 already exists. Skipping...\n",
      "Entry for DJI_0978.MP4 already exists. Skipping...\n",
      "Entry for DJI_0979.MP4 already exists. Skipping...\n",
      "Entry for DJI_0980.MP4 already exists. Skipping...\n",
      "Entry for DJI_0981.MP4 already exists. Skipping...\n",
      "Added entry for DJI_0982.MP4 to the video table.\n",
      "Added entry for DJI_0983.MP4 to the video table.\n",
      "Added entry for DJI_0984.MP4 to the video table.\n",
      "Added entry for DJI_0988.MP4 to the video table.\n",
      "Added entry for DJI_0989.MP4 to the video table.\n",
      "Added entry for DJI_0990.MP4 to the video table.\n"
     ]
    }
   ],
   "source": [
    "# Add new video entries\n",
    "################################\n",
    "import os\n",
    "import datetime\n",
    "from moviepy.editor import VideoFileClip\n",
    "import mysql.connector\n",
    "\n",
    "# Connect to the database\n",
    "cnx = mysql.connector.connect(user='root', password='dronevideos', host='localhost', database='crop_videos')\n",
    "cursor = cnx.cursor()\n",
    "\n",
    "# Define the folders\n",
    "video_folders = [\n",
    "    # Add the paths of other folders you want to traverse here\n",
    "    \"\\\\\\\\sf3.bss.phy.private.cam.ac.uk\\\\cicutagroup\\\\crop_data\\\\wheat_videos\\\\drone_video_525_623\\\\original\",\n",
    "    \"\\\\\\\\sf3.bss.phy.private.cam.ac.uk\\\\cicutagroup\\\\crop_data\\\\wheat_videos\\\\drone_video_720\\\\original\",\n",
    "    \"\\\\\\\\sf3.bss.phy.private.cam.ac.uk\\\\cicutagroup\\\\crop_data\\\\wheat_videos\\\\drone_video_721_727\\\\original\"\n",
    "]\n",
    "\n",
    "for video_folder in video_folders:\n",
    "    # Verify if the folder path is valid and exists\n",
    "    if not os.path.exists(video_folder) or not os.path.isdir(video_folder):\n",
    "        print(f\"Skipping invalid folder path: {video_folder}\")\n",
    "        continue  # skip to the next folder if the current one is invalid\n",
    "    \n",
    "    # List all .MP4 files in the folder\n",
    "    video_files = [f for f in os.listdir(video_folder) if f.endswith('.MP4')]\n",
    "    # Sort the files by name\n",
    "    video_files.sort()\n",
    "\n",
    "    for video_file in video_files:\n",
    "        video_path = os.path.join(video_folder, video_file)\n",
    "        \n",
    "        # Check if this video entry already exists in the database\n",
    "        query_check = f\"SELECT * FROM video WHERE filename='{video_file}'\"\n",
    "        cursor.execute(query_check)\n",
    "        if cursor.fetchone():  # Entry exists, skip this file\n",
    "            print(f\"Entry for {video_file} already exists. Skipping...\")\n",
    "            continue\n",
    "        \n",
    "        try:\n",
    "            # Using moviepy to extract video properties\n",
    "            with VideoFileClip(video_path) as clip:\n",
    "                frame_rate = clip.fps\n",
    "                duration = clip.duration\n",
    "                frame_number = int(frame_rate * duration)\n",
    "\n",
    "            # Extract creation date and time from file metadata\n",
    "            creation_timestamp = os.path.getctime(video_path)\n",
    "            creation_date = datetime.datetime.fromtimestamp(creation_timestamp).date()\n",
    "            creation_time = datetime.datetime.fromtimestamp(creation_timestamp).time()\n",
    "\n",
    "            # Video properties\n",
    "            video_properties = {\n",
    "                \"filename\": video_file,\n",
    "                \"location\": video_path,\n",
    "                \"create_date\": creation_date,\n",
    "                \"create_time\": creation_time,\n",
    "                \"duration\": duration,\n",
    "                \"format\": \"MP4\",\n",
    "                \"frame_width\": 3840,\n",
    "                \"frame_height\": 2160,\n",
    "                \"frame_rate\": frame_rate,\n",
    "                \"frame_number\": frame_number,\n",
    "                \"color_space\": \"YUV\"\n",
    "            }\n",
    "\n",
    "            # SQL query to insert video properties into the database\n",
    "            insert_query = (\n",
    "                \"INSERT INTO video (filename, location, create_date, create_time, duration, format, frame_width, \"\n",
    "                \"frame_height, frame_rate, frame_number, color_space) \"\n",
    "                \"VALUES (%(filename)s, %(location)s, %(create_date)s, %(create_time)s, %(duration)s, %(format)s, \"\n",
    "                \"%(frame_width)s, %(frame_height)s, %(frame_rate)s, %(frame_number)s, %(color_space)s)\"\n",
    "            )\n",
    "            cursor.execute(insert_query, video_properties)\n",
    "            cnx.commit()\n",
    "            print(f\"Added entry for {video_file} to the video table.\")\n",
    "        \n",
    "        except:\n",
    "            print(f\"Failed to add entry for {video_file} to the video table, skipping\")\n",
    "            continue\n",
    "\n",
    "\n",
    "# Close database connection\n",
    "cursor.close()\n",
    "cnx.close()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Duplicates removed successfully!\n"
     ]
    }
   ],
   "source": [
    "# Remove duplicate video entries\n",
    "################################\n",
    "\n",
    "import mysql.connector\n",
    "\n",
    "# Establish a connection to the database\n",
    "cnx = mysql.connector.connect(\n",
    "    user='root', password='dronevideos', \n",
    "    host='localhost', database='crop_videos'\n",
    ")\n",
    "cursor = cnx.cursor()\n",
    "\n",
    "try:\n",
    "    # Identify duplicate rows except for the first occurrence\n",
    "    cursor.execute(\"\"\"\n",
    "        CREATE TEMPORARY TABLE duplicates AS\n",
    "        SELECT video_id\n",
    "        FROM video\n",
    "        WHERE (filename)\n",
    "        IN (\n",
    "            SELECT filename\n",
    "            FROM video\n",
    "            GROUP BY filename\n",
    "            HAVING COUNT(*) > 1\n",
    "        )\n",
    "        AND video_id NOT IN (\n",
    "            SELECT MIN(video_id)\n",
    "            FROM video\n",
    "            GROUP BY filename\n",
    "        )\n",
    "    \"\"\")\n",
    "    \n",
    "    # Delete the identified duplicate rows\n",
    "    cursor.execute(\"\"\"\n",
    "        DELETE FROM video\n",
    "        WHERE video_id IN (SELECT video_id FROM duplicates)\n",
    "    \"\"\")\n",
    "    \n",
    "    # Committing the changes\n",
    "    cnx.commit()\n",
    "    \n",
    "finally:\n",
    "    # Closing the cursor and connection\n",
    "    cursor.close()\n",
    "    cnx.close()\n",
    "\n",
    "print(\"Duplicates removed successfully!\")\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Updated entry for DJI_0004.MP4 in the video table.\n",
      "Updated entry for DJI_0012.MP4 in the video table.\n",
      "Updated entry for DJI_0013.MP4 in the video table.\n",
      "Updated entry for DJI_0014.MP4 in the video table.\n",
      "Updated entry for DJI_0015.MP4 in the video table.\n",
      "Updated entry for DJI_0016.MP4 in the video table.\n",
      "Updated entry for DJI_0017.MP4 in the video table.\n",
      "Updated entry for DJI_0018.MP4 in the video table.\n",
      "Updated entry for DJI_0019.MP4 in the video table.\n",
      "Updated entry for DJI_0024.MP4 in the video table.\n",
      "Updated entry for DJI_0025.MP4 in the video table.\n",
      "Updated entry for DJI_0026.MP4 in the video table.\n",
      "Updated entry for DJI_0028.MP4 in the video table.\n",
      "Updated entry for DJI_0029.MP4 in the video table.\n",
      "Updated entry for DJI_0030.MP4 in the video table.\n",
      "Updated entry for DJI_0031.MP4 in the video table.\n",
      "Updated entry for DJI_0032.MP4 in the video table.\n",
      "Updated entry for DJI_0033.MP4 in the video table.\n",
      "Updated entry for DJI_0034.MP4 in the video table.\n",
      "Updated entry for DJI_0035.MP4 in the video table.\n",
      "Updated entry for DJI_0036.MP4 in the video table.\n",
      "Updated entry for DJI_0037.MP4 in the video table.\n",
      "Updated entry for DJI_0038.MP4 in the video table.\n",
      "Updated entry for DJI_0039.MP4 in the video table.\n",
      "Updated entry for DJI_0040.MP4 in the video table.\n",
      "Updated entry for DJI_0041.MP4 in the video table.\n",
      "Updated entry for DJI_0042.MP4 in the video table.\n",
      "Updated entry for DJI_0043.MP4 in the video table.\n",
      "Updated entry for DJI_0044.MP4 in the video table.\n",
      "Updated entry for DJI_0045.MP4 in the video table.\n",
      "Updated entry for DJI_0046.MP4 in the video table.\n",
      "Updated entry for DJI_0047.MP4 in the video table.\n",
      "Updated entry for DJI_0048.MP4 in the video table.\n",
      "Updated entry for DJI_0049.MP4 in the video table.\n",
      "Updated entry for DJI_0050.MP4 in the video table.\n",
      "Updated entry for DJI_0051.MP4 in the video table.\n",
      "Updated entry for DJI_0052.MP4 in the video table.\n"
     ]
    }
   ],
   "source": [
    "# Update existing video entries\n",
    "################################\n",
    "\n",
    "import os\n",
    "import datetime\n",
    "from moviepy.editor import VideoFileClip\n",
    "import mysql.connector\n",
    "\n",
    "# Connect to the database\n",
    "cnx = mysql.connector.connect(user='root', password='dronevideos', host='localhost', database='crop_videos')\n",
    "cursor = cnx.cursor()\n",
    "\n",
    "# Define the folder\n",
    "video_folder = \"\\\\\\\\sf3.bss.phy.private.cam.ac.uk\\\\cicutagroup\\\\crop_data\\\\wheat_videos\\\\drone_videos\\\\original\"\n",
    "video_files = [f for f in os.listdir(video_folder) if f.endswith('.MP4')]\n",
    "\n",
    "for video_file in video_files:\n",
    "    video_path = os.path.join(video_folder, video_file)\n",
    "    \n",
    "    # Using moviepy to extract video properties\n",
    "    with VideoFileClip(video_path) as clip:\n",
    "        frame_rate = clip.fps\n",
    "        duration = clip.duration\n",
    "        frame_number = int(frame_rate * duration)\n",
    "\n",
    "    # Extract creation date and time from file metadata\n",
    "    creation_timestamp = os.path.getctime(video_path)\n",
    "    creation_date = datetime.datetime.fromtimestamp(creation_timestamp).date()\n",
    "    creation_time = datetime.datetime.fromtimestamp(creation_timestamp).time()\n",
    "\n",
    "    # Update query to set new properties for existing rows matching the filename\n",
    "    update_query = (\n",
    "        \"UPDATE video SET \"\n",
    "        \"location = %(location)s, create_date = %(create_date)s, create_time = %(create_time)s, \"\n",
    "        \"duration = %(duration)s, format = %(format)s, frame_width = %(frame_width)s, frame_height = %(frame_height)s, \"\n",
    "        \"frame_rate = %(frame_rate)s, frame_number = %(frame_number)s \"\n",
    "        \"WHERE filename = %(filename)s\"\n",
    "    )\n",
    "    \n",
    "    video_properties = {\n",
    "        \"filename\": video_file,\n",
    "        \"location\": video_path,\n",
    "        \"create_date\": creation_date,\n",
    "        \"create_time\": creation_time,\n",
    "        \"duration\": duration,\n",
    "        \"format\": \"MP4\",\n",
    "        \"frame_width\": 3840,  # Or the actual width, if different\n",
    "        \"frame_height\": 2160,  # Or the actual height, if different\n",
    "        \"frame_rate\": frame_rate,\n",
    "        \"frame_number\": frame_number,\n",
    "    }\n",
    "\n",
    "    cursor.execute(update_query, video_properties)\n",
    "    cnx.commit()\n",
    "    print(f\"Updated entry for {video_file} in the video table.\")\n",
    "\n",
    "# Close database connection\n",
    "cursor.close()\n",
    "cnx.close()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Added entry for rescale_crop_fps30_DJI_0526.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0531.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0551.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0552.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0579.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0629.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0630.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0634.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0658.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0674.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0707.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0744.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0765.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0774.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0796.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0826.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0880.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0891.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0899.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0902.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0931.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0982.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0983.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0984.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0988.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0989.MP4 to the processed_videos table.\n",
      "Added entry for rescale_crop_fps30_DJI_0990.MP4 to the processed_videos table.\n"
     ]
    }
   ],
   "source": [
    "# Add new processed_videos entries\n",
    "################################\n",
    "import os\n",
    "import datetime\n",
    "from moviepy.editor import VideoFileClip\n",
    "import mysql.connector\n",
    "\n",
    "# Connect to the database\n",
    "cnx = mysql.connector.connect(user='root', password='dronevideos', host='localhost', database='crop_videos')\n",
    "cursor = cnx.cursor()\n",
    "\n",
    "# Define the folders\n",
    "video_folders = [\n",
    "    # Add the paths of other folders you want to traverse here\n",
    "    \"\\\\\\\\sf3.bss.phy.private.cam.ac.uk\\\\cicutagroup\\\\crop_data\\\\wheat_videos\\\\drone_video_525_623\\\\rescale_crop_fps30\",\n",
    "    \"\\\\\\\\sf3.bss.phy.private.cam.ac.uk\\\\cicutagroup\\\\crop_data\\\\wheat_videos\\\\drone_video_720\\\\rescale_crop_fps30\",\n",
    "    \"\\\\\\\\sf3.bss.phy.private.cam.ac.uk\\\\cicutagroup\\\\crop_data\\\\wheat_videos\\\\drone_video_721_727\\\\rescale_crop_fps30\"\n",
    "]\n",
    "\n",
    "for video_folder in video_folders:\n",
    "    # Verify if the folder path is valid and exists\n",
    "    if not os.path.exists(video_folder) or not os.path.isdir(video_folder):\n",
    "        print(f\"Skipping invalid folder path: {video_folder}\")\n",
    "        continue  # skip to the next folder if the current one is invalid\n",
    "    \n",
    "    # List all .MP4 files in the folder\n",
    "    video_files = [f for f in os.listdir(video_folder) if f.endswith('.MP4')]\n",
    "    # Sort the files by name\n",
    "    video_files.sort()\n",
    "\n",
    "    for video_file in video_files:\n",
    "        video_path = os.path.join(video_folder, video_file)\n",
    "        \n",
    "        # Check if this video entry already exists in the database\n",
    "        query_check = f\"SELECT * FROM processed_videos WHERE filename='{video_file}'\"\n",
    "        cursor.execute(query_check)\n",
    "        if cursor.fetchone():  # Entry exists, skip this file\n",
    "            # print(f\"Entry for {video_file} already exists. Skipping...\")\n",
    "            continue\n",
    "        \n",
    "        try:\n",
    "            # Extract the base filename from the processed video filename\n",
    "            base_filename = \"_\".join(video_file.split(\"_\")[-2:])\n",
    "            \n",
    "            # Fetch video_id from video table for the base filename\n",
    "            video_id_query = f\"SELECT video_id FROM video WHERE filename='{base_filename}'\"\n",
    "            cursor.execute(video_id_query)\n",
    "            video_id_row = cursor.fetchone()\n",
    "            if not video_id_row:\n",
    "                print(f\"No video entry found for base filename {base_filename}. Skipping...\")\n",
    "                continue\n",
    "            video_id = video_id_row[0]\n",
    "\n",
    "            # Using moviepy to extract video properties\n",
    "            with VideoFileClip(video_path) as clip:\n",
    "                frame_rate = clip.fps\n",
    "                duration = clip.duration\n",
    "                frame_number = int(frame_rate * duration)\n",
    "\n",
    "            # Extract creation date and time from file metadata\n",
    "            creation_timestamp = os.path.getctime(video_path)\n",
    "            creation_date = datetime.datetime.fromtimestamp(creation_timestamp).date()\n",
    "            creation_time = datetime.datetime.fromtimestamp(creation_timestamp).time()\n",
    "\n",
    "            # Video properties\n",
    "            video_properties = {\n",
    "                \"filename\": video_file,\n",
    "                \"location\": video_path,\n",
    "                \"create_date\": creation_date,\n",
    "                \"create_time\": creation_time,\n",
    "                \"duration\": duration,\n",
    "                \"format\": \"MP4\",\n",
    "                \"frame_width\": 1024,\n",
    "                \"frame_height\": 1024,\n",
    "                \"frame_rate\": frame_rate,\n",
    "                \"frame_number\": frame_number,\n",
    "                \"color_space\": \"YUV\",\n",
    "                \"video_id\": video_id,\n",
    "                \"processing_type\": \"rescale_crop_fps30\", \n",
    "            }\n",
    "\n",
    "            # SQL query to insert video properties into the database\n",
    "            insert_query = (\n",
    "                \"INSERT INTO processed_videos (filename, location, create_date, create_time, duration, format, frame_width, \"\n",
    "                \"frame_height, frame_rate, color_space, video_id, processing_type) \"\n",
    "                \"VALUES (%(filename)s, %(location)s, %(create_date)s, %(create_time)s, %(duration)s, %(format)s, \"\n",
    "                \"%(frame_width)s, %(frame_height)s, %(frame_rate)s, %(color_space)s, %(video_id)s, %(processing_type)s)\" \n",
    "            )\n",
    "            cursor.execute(insert_query, video_properties)\n",
    "            cnx.commit()\n",
    "            print(f\"Added entry for {video_file} to the processed_videos table.\")\n",
    "        \n",
    "        except Exception as e:\n",
    "            print(f\"Failed to add entry for {video_file} to the processed_videos table due to error: {e}\")\n",
    "            continue\n",
    "            # break\n",
    "\n",
    "\n",
    "# Close database connection\n",
    "cursor.close()\n",
    "cnx.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Columns in video table: ['wind_data_id', 'wind_speed_avg', 'wind_direction_avg', 'detailed_wind_change_table', 'video_id']\n"
     ]
    }
   ],
   "source": [
    "import mysql.connector\n",
    "\n",
    "\n",
    "# Connect to the database\n",
    "cnx = mysql.connector.connect(user='root', password='dronevideos', host='localhost', database='crop_videos')\n",
    "cursor = cnx.cursor()\n",
    "\n",
    "# Query to describe the processed_videos table\n",
    "query_describe = \"DESCRIBE wind_data\"\n",
    "cursor.execute(query_describe)\n",
    "\n",
    "# Fetch all column names\n",
    "columns = cursor.fetchall()\n",
    "\n",
    "# Extract only the column names from the results\n",
    "column_names = [column[0] for column in columns]\n",
    "print(\"Columns in video table:\", column_names)\n",
    "\n",
    "# ...\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.0"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}