import time from RPi import GPIO from flask import Flask, jsonify, request from flask_socketio import SocketIO from flask_cors import CORS from DP1Database import Database import rfidreader app = Flask(__name__) CORS(app) socketio = SocketIO(app) conn = Database(app=app, user='******', password='******', db='SmartParking', host='localhost', port=3306) slagboom = rfidreader.rfid(conn) # refers to the class that makes the lighting work # licht = ldr.Verlichting(conn) # parking = parkingSensor.parkingSensor(conn) # if __name__ == '__main__': # socketio.run(app, host="0.0.0.0", port="5000")
# Imports from flask import Flask, jsonify, request from flask_socketio import SocketIO from flask_cors import CORS # Custom imports from DP1Database import Database # Start app app = Flask(__name__) CORS(app) socketio = SocketIO(app) conn = Database(app=app, user='******', password='******', db='quizdb', host='localhost', port=3306) endpoint = '/api/v1' @socketio.on('addQuestion') def question(data): conn.set_data( 'INSERT INTO vraag (QuizId, vraaginhoud, JuistAntwoord, VerkeerdAntwoord1, VerkeerdAntwoord2, VerkeerdAntwoord3) values (1, %s, %s, %s, %s, %s)', ['test', 'test', 'test', 'test', 'test']) # BACKEND - NIET WIJZIGEN!! # # Deze route wordt gebruikt voor het ophalen van de movies per beginletter.
from RPi import GPIO import random import time from flask import Flask from threading import Thread from DP1Database import Database import datetime app = Flask(__name__) conn = Database(app=app, user='******', password='******', db='SEmbebidos', host='localhost',port=3306) GPIO.setmode(GPIO.BCM) TRIG = 20 ECHO = 21 value = 0 ldr = 18 #Pin del led led = 27 GPIO.setwarnings(False) GPIO.setup(TRIG, GPIO.OUT) GPIO.setup(ECHO, GPIO.IN) GPIO.setup(led, GPIO.OUT) GPIO.output(led, 0) running=False distancia=0 """ Se obtienen datos de la base y se encienden los sensores """
from flask import Flask, jsonify, request from flask_socketio import SocketIO from flask_cors import CORS from DP1Database import Database import beweging import geluid import gewicht from lcd import LCDScreen from RPi import GPIO app = Flask(__name__) CORS(app) conn = Database(app=app, user='******', password='******', db='mydb') lcd = LCDScreen(False, 21, 20, 13, 19, 26, 17, 24, 25, 12, 16) lcd.LCD_init() lcd.send_line('Smart dog house') lcd.second_row() lcd.statusip1() lopen = beweging.Beweging(conn) geluid = geluid.Geluid(conn) gewicht = gewicht.Gewicht(conn) socketio = SocketIO(app) @socketio.on('getbeweging') def beweging(): bew = conn.get_data( 'SELECT count(*)*5 FROM metingen WHERE sensoren_idsensor = 1 and Date_time >= (CURRENT_DATE) AND Date_time < ((CURRENT_DATE ) + INTERVAL 1 DAY);'
from DP1Database import Database import RPi.GPIO as GPIO import time import ldr import vochtig import beweging import pigpio from PCF8574A import LCDScreen lcd = LCDScreen(False, 21, 20, 22, 5, 6, 27, 17, 25, 12, 16) # init van lcd lcd.LCD_init() # init van LCD (2 app = Flask(__name__) CORS(app) socketio = SocketIO(app) conn = Database(app=app, user='******', password='******', db='project1') vochtigheid = vochtig.Vochtig(conn) @socketio.on('getTemp') def temp(): temp = conn.get_data( "SELECT Value FROM project1.Historiek WHERE project1.Historiek.Sensor_SensorID = 2 ORDER BY project1.Historiek.HistoriekID DESC LIMIT 1;" ) socketio.emit('giveTemp', str(temp[0]['Value'])) @socketio.on('getVocht') def temp(): vocht = conn.get_data( "SELECT Value FROM project1.Historiek WHERE project1.Historiek.Sensor_SensorID = 1 ORDER BY project1.Historiek.HistoriekID DESC LIMIT 1;"