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;"