#!/usr/bin/python3 import os import glob import requests import sqlite3 from dotenv import load_dotenv load_dotenv() passwd = os.

#!/usr/bin/python3 import os import glob import requests import sqlite3 from dotenv import load_dotenv load_dotenv() passwd = os.getenv('PASSWD') url = os.getenv('URL') folder = os.getenv('FOLDER') images = sorted(glob.glob(folder + '*.jpg')) conn = sqlite3.connect('rpicamera.db') cur = conn.cursor() for image in images: image_name = image.replace(folder, '') row = cur.execute("SELECT id FROM uploads WHERE filename = '%s'" % image_name) if len(row.fetchall()) > 0: continue response = requests.post(url, files={'file': open(image, 'rb')}, data={'passwd': passwd}) if response.json(): print("Error uploading '%s'" % image_name) continue cur.execute("INSERT INTO uploads (filename) VALUES ('%s')" % image_name) print("'%s' uploaded" % image_name) cur.close() conn.commit() conn.close()