[Raspberry Pi] 9. 라즈베리 파이, 스프링, DB 연동

https://github.com/upcake/Class_Examples

교육 중에 작성한 예제들은 깃허브에 올려두고 있습니다. 

gif 파일은 클릭해서 보는 것이 정확합니다.

---

 - 라즈베리 파이, 스프링, DB 연동 -

 

import RPi.GPIO as GPIO
import time

table1_btn1 = 11
table1_btn2 = 13

table1_led1 = 8
table1_led2 = 10

table2_btn1 = 29
table2_btn2 = 31

table2_led1 = 36
table2_led2 = 38

GPIO.setmode(GPIO.BOARD)
GPIO.setup(table1_btn1, GPIO.IN)
GPIO.setup(table1_btn2, GPIO.IN)
GPIO.setup(table2_btn1, GPIO.IN)
GPIO.setup(table2_btn2, GPIO.IN)
GPIO.setup(table1_led1, GPIO.OUT)
GPIO.setup(table1_led2, GPIO.OUT)
GPIO.setup(table2_led1, GPIO.OUT)
GPIO.setup(table2_led2, GPIO.OUT)  

while True:
    time.sleep(0.2)
    btn11 = GPIO.input(table1_btn1)
    btn12 = GPIO.input(table1_btn2)
    btn21 = GPIO.input(table2_btn1)
    btn22 = GPIO.input(table2_btn2)

    if btn11 is 1:
        GPIO.output(table1_led1, True)
    else:
        GPIO.output(table1_led1, False)
    
    if btn12 is 1:
        GPIO.output(table1_led2, True)
    else:
        GPIO.output(table1_led2, False)

    if btn21 is 1:
        GPIO.output(table2_led1, True)
    else:
        GPIO.output(table2_led1, False)
        
    if btn22 is 1:
        GPIO.output(table2_led2, True)
    else:
        GPIO.output(table2_led2, False)

▲회로 연결 확인

 

 

▲작동 영상

▲스프링 콘솔, 갱신된 DB

import RPi.GPIO as GPIO
import time
import requests
import json

# init led from server data
def webcontents_receive():
    url = "http://192.168.0.20:8080/app/raspGetData"
    dataJson = requests.get(url, params = {}).json()
    print(dataJson)    
    
    # json file parshing
    #data = json.loads(dataString)
    for dat in dataJson:
        print(dat.get('store_id'), dat.get('store_name'), dat.get('table_num'), dat.get('start_time'), dat.get('end_time'), dat.get('accupation_time'))
        
        global led1_on1, led1_on2, led2_on1, led2_on2
        
        if dat.get('table_num') == 'tb1num01':
            if dat.get('end_time') is not None:
                led1_on1 = False
                GPIO.output(table1_led1, False)
            else:
                led1_on1 = True
                GPIO.output(table1_led1, True)
        
        elif dat.get('table_num') == 'tb1num02':
            if dat.get('end_time') is not None:
                led1_on2 = False
                GPIO.output(table1_led2, False)
            else:
                led1_on2 = True
                GPIO.output(table1_led2, True)            
                    
        elif dat.get('table_num') == 'tb2num01':
            if dat.get('end_time') is not None:
                led2_on1 = False
                GPIO.output(table2_led1, False)
            else:
                led2_on1 = True
                GPIO.output(table2_led1, True)
            
        elif dat.get('table_num') == 'tb2num02':
            print('dat[table_num] is tb2num02')
            if dat.get('end_time') is not None:
                print('led2_on02 is not null')
                led2_on2 = False
                GPIO.output(table2_led2, False)
            else:
                print('led2_on02 is null')
                led2_on2 = True
                GPIO.output(table2_led2, True)            
   
# send data from rasp to server
def webcontents_send(store_id, store_name, table_num, table_value):
    url = "http://192.168.0.20:8080/app/raspSetData"
    r = requests.get(url, params = {'store_id' : store_id, 'store_name' : store_name, 'table_num' : table_num, 'table_value' : table_value})

# init All port and led
def initSetup():    
    GPIO.setmode(GPIO.BOARD)
    GPIO.setup(table1_btn1, GPIO.IN)
    GPIO.setup(table1_btn2, GPIO.IN)
    GPIO.setup(table2_btn1, GPIO.IN)
    GPIO.setup(table2_btn2, GPIO.IN)
    GPIO.setup(table1_led1, GPIO.OUT)
    GPIO.setup(table1_led2, GPIO.OUT)
    GPIO.setup(table2_led1, GPIO.OUT)
    GPIO.setup(table2_led2, GPIO.OUT)  
    webcontents_receive()   

# store 1
store1_id = 'AA0101'
store1_name = 'upcake 커피'

table1_num1 = 'tb1num01'
table1_num2 = 'tb1num02'

table1_btn1 = 11
table1_btn2 = 13

table1_led1 = 8
table1_led2 = 10

table1_pressed1 = 0
table1_pressed2 = 0

led1_on1 = False
led1_on2 = False

# store 2
store2_id = 'BB0101'
store2_name = 'upcake 편의점'

table2_num1 = 'tb2num01'
table2_num2 = 'tb2num02'

table2_btn1 = 29
table2_btn2 = 31

table2_led1 = 36
table2_led2 = 38

table2_pressed1 = 0;
table2_pressed2 = 0;

led2_on1 = False
led2_on2 = False

initSetup()

try:    
    while True:
        time.sleep(0.2)
        btn11 = GPIO.input(table1_btn1)
        btn12 = GPIO.input(table1_btn2)
        btn21 = GPIO.input(table2_btn1)
        btn22 = GPIO.input(table2_btn2)

        sendstate = False
        
        # store1 table1
        if btn11 is 1:   
            if table1_pressed1 == 0:
                led1_on1 = not led1_on1
                print(led1_on1)
                table1_pressed1 = 1
                sendstate = True
                    
        else:            
            table1_pressed1 = 0
            
        if led1_on1 is True and sendstate is True:
            GPIO.output(table1_led1, True)
            table_value = 'ON'                
            webcontents_send(store1_id, store1_name, table1_num1, table_value)
            sendstate = False        
                    
        elif led1_on1 is False and sendstate is True:
            GPIO.output(table1_led1, False)
            table_value = 'OFF'                
            webcontents_send(store1_id, store1_name, table1_num1, table_value)
            sendstate = False
            
        
        # store1 table2
        if btn12 is 1:   
            if table1_pressed2 == 0:
                led1_on2 = not led1_on2
                print(led1_on2)
                table1_pressed2 = 1
                sendstate = True
                    
        else:            
            table1_pressed2 = 0
            
        if led1_on2 is True and sendstate is True:
            GPIO.output(table1_led2, True)
            table_value = 'ON'                
            webcontents_send(store1_id, store1_name, table1_num2, table_value)
            sendstate = False        
                    
        elif led1_on2 is False and sendstate is True:
            GPIO.output(table1_led2, False)
            table_value = 'OFF'                
            webcontents_send(store1_id, store1_name, table1_num2, table_value)
            sendstate = False   
        
        # store2 table1
        if btn21 is 1:   
            if table2_pressed1 == 0:
                led2_on1 = not led2_on1
                print(led2_on1)
                table2_pressed1 = 1
                sendstate = True
                    
        else:            
            table2_pressed1 = 0
            
        if led2_on1 is True and sendstate is True:
            GPIO.output(table2_led1, True)
            table_value = 'ON'                
            webcontents_send(store2_id, store2_name, table2_num1, table_value)
            sendstate = False        
                    
        elif led2_on1 is False and sendstate is True:
            GPIO.output(table2_led1, False)
            table_value = 'OFF'                
            webcontents_send(store2_id, store2_name, table2_num1, table_value)
            sendstate = False
            
            
        # store2 table2
        if btn22 is 1:   
            if table2_pressed2 == 0:
                led2_on2 = not led2_on2
                print(led2_on2)
                table2_pressed2 = 1
                sendstate = True
                    
        else:            
            table2_pressed2 = 0
            
        if led2_on2 is True and sendstate is True:
            GPIO.output(table2_led2, True)
            table_value = 'ON'                
            webcontents_send(store2_id, store2_name, table2_num2, table_value)
            sendstate = False        
                    
        elif led2_on2 is False and sendstate is True:
            GPIO.output(table2_led2, False)
            table_value = 'OFF'                
            webcontents_send(store2_id, store2_name, table2_num2, table_value)
            sendstate = False  
       
        
except KeyboardInterrupt:
    pass

GPIO.cleanup()

▲스프링, DB 연동