from databse_connection import Database_Connection import RPi.GPIO as GPIO import pysftp import os import time import subprocess import datetime with pysftp.Connection('104.236.252.214', username = '******', password = '******') as sftp: with sftp.cd('/var/Images'): sftp.put('/home/pi/image.jpg') db = Database_Connection() db.connect() db.add_image('104.236.252.214/var/Images/image.jpg') db.close() #os.system('fswebcam mages.fpg') #subprocess.call(['fswebcam', '%s.jpg' % datetime.datetime.utcnow().strftime('%Y-%M-%D-%H-%M-%S')]) #file_name = '/home/pi/Documents/images/{0}.jpg'.format(datetime.datetime.utcnow()) #subprocess.call(['fswebcam', file_name]) #things = 'INSERT INTO Thigns (thigns, thinsgs) VALUES (1,{0})'.format("'.txt'") #print (things) #db.add_message( #result = db.check_messages() #print (result) #action_id = result['action_id'] #message_id = result['message_id'] #db.update_message(message_id, 1)
if loop: db.connect() db.update_message(message_id) db.add_history(fingerprint, 1) db.close() loop = False manual = False # if a user is not allowed in the door else: led('red') result = take_picture() image = result[0] server_path = result[1] sftp(image) db.connect() db.add_history() db.add_image(server_path) db.update_message(message_id) db.close() elif result[1] == 1: fingerprint = int(arduino.enroll()) db.connect() db.insert_user(user_id, fingerprint) db.update_message(message_id) db.close() GPIO.cleanup()