sudo apt-get install python-mysqldb

CREATE TABLE IF NOT EXISTS `gpio` (
  `id_gpio` int(2) NOT NULL,
  `state` int(2) NOT NULL,
  `mode` int(2) NOT NULL,
  PRIMARY KEY (`id_gpio`)
)

#!/usr/bin/env python
# -*- coding: utf-8 -*-

# Import des modules
import RPi.GPIO as GPIO
import time
import MySQLdb

# Initialisation de la numerotation et des E/S
GPIO.setmode(GPIO.BCM)
GPIO.setwarnings(False)

db   = MySQLdb.connect("localhost", "root", "raspberry", "GPIO_CONTROLE")
curs = db.cursor()

def Update_State_GPIO(iGPIO, iState):
   curs.execute("""UPDATE gpio SET state=%s WHERE id_gpio=%s""",(iState,iGPIO))

while True:
   time.sleep(0.15)
   # Pour toutes les GPIO de la base
   curs.execute("SELECT * FROM gpio")
   rows = curs.fetchall()
   for row in rows:
      if (row[3]==1):
         GPIO.setup(int(row[0]), GPIO.OUT)
         if (GPIO.input(row[0])!=int(row[2])):
            GPIO.output(int(row[0]), int(row[2]))

      else:
         GPIO.setup(int(row[0]), GPIO.IN)
         Update_State_GPIO(int(row[0]), GPIO.input(int(row[0])))
   db.commit()

import picamera
import time
import RPi.GPIO as GPIO

# Definition de l'objet camera
camera = picamera.PiCamera()

# Lecture de l'incrementation fichier
ficR = open('/home/pi/Programme/Python/Video_Drone/Videos/INCR.txt','r+')
sINCR = ficR.read(3)
print sINCR
iINCR = int(sINCR)
ficR.close()

iINCR +=1

# Ecriture du fichier d'incrementation
ficW = open('/home/pi/Programme/Python/Video_Drone/Videos/INCR.txt','wb')
ficW.write(str(iINCR))
ficW.close()

camera.rotation = 180
camera.start_recording('/home/pi/Programme/Python/Video_Drone/Videos/Flight' + str(iINCR) + '.h264')

while (1):
        time.sleep(1)

@reboot sudo python /home/pi/Programme/Python/Video_Drone/Video_Reboot.py

sudo apt-get install gpac

MP4Box -add ./Flight9.h264  ./Flight9.mp4

#include "../Lib/libGPIO.h"
#include <stdio.h>
#include <stdlib.h>

int main()
{
    GPIO led("A23"); // "A23" ou kernel id = 23

    led.pinMode(OUTPUT);
    while(1)
    {
       Delay(250);
       led.digitalWrite(HIGH);
       Delay(250);
       led.digitalWrite(LOW);
    }

}

#include "../Lib/libGPIO.h"
#include <stdio.h>
#include <stdlib.h>

int main()
{
    GPIO led("A23"); // "A23" ou kernel id = 23

    led.pinMode(OUTPUT);
    while(1)
    { 
       led.digitalWrite(readButton());
    }

}

git clone https://github.com/kkiwill/Arietta_G25_GPIO_Library.git

cd ./Arietta_G25_GPIO_Library/Example

g++ ./Blink.cpp ../Lib/libGPIO.cpp -o Blink -lrt

 #include "stdio.h"  
 #include "stdlib.h"  
 #include "unistd.h"  
 int gpioexport(int gpioid)   
 {  
      FILE *filestream;  
      if ((filestream=fopen("/sys/class/gpio/export","w"))==NULL) {  
           printf("Error on export GPIO\n");  
           return -1;  
      }       
      fprintf(filestream,"%d",gpioid);  
      fclose(filestream);  
      return 0;  
 }  
 int gpiosetdir(int gpioid,char *mode)   
 {  
      FILE *filestream;  
      char filename[50];  
      sprintf(filename,"/sys/class/gpio/gpio%d/direction",gpioid);  
      if ((filestream=fopen(filename,"w"))==NULL) {  
           printf("Error on direction setup\n");  
           return -1;  
      }       
      fprintf(filestream,mode);  
      fclose(filestream);  
      return 0;  
 }  
 int gpiogetbits(int gpioid)   
 {  
      FILE *filestream;  
      char filename[50];  
      char retchar;  
      sprintf(filename,"/sys/class/gpio/gpio%d/value",gpioid);  
      if ((filestream=fopen(filename,"r"))==NULL) {  
           printf("Error on gpiogetbits %d\n",gpioid);  
           return -1;  
      }       
      retchar=fgetc(filestream);  
      fclose(filestream);  
      if (retchar=='0') return 0;  
      else return 1;  
 }  
 int gpiosetbits(int gpioid)   
 {  
      FILE *filestream;  
      char filename[50];  
      sprintf(filename,"/sys/class/gpio/gpio%d/value",gpioid);  
      if ((filestream=fopen(filename,"w"))==NULL) {  
           printf("Error on setbits %d\n",gpioid);  
           return -1;  
      }       
      fprintf(filestream,"1");  
      fclose(filestream);  
      return 0;  
 }  
 int gpioclearbits(int gpioid)   
 {  
      FILE *filestream;  
      char filename[50];  
      sprintf(filename,"/sys/class/gpio/gpio%d/value",gpioid);  
      if ((filestream=fopen(filename,"w"))==NULL) {  
           printf("Error on clearbits %d\n",gpioid);  
           return -1;  
      }       
      fprintf(filestream,"0");  
      fclose(filestream);  
      return 0;  
 }  
 int main(void)   
 {  
      int led = 23;  # GPIO PA23 donc son nom est 23
      gpioexport(led);  
      gpiosetdir(led,"out");  
      for (;;) {  
           gpiosetbits(led);  
           sleep(1);  
           gpioclearbits(led);  
           sleep(1);  
      }  
 }  

mkdir ./LCD_IPcd ./LCD_IP

git clone https://github.com/quick2wire/quick2wire-python-api.git 

lcd = i2c_lcd.i2c_lcd(0x27, 0, 2, 1, 0, 4, 5, 6, 7, 3)

 import sys, os  
 # On définie l'emplacement de la librairie  
 sys.path.append(r'/home/pi/LCD_IP/quick2wire-python-api')  
 from i2clibraries import i2c_lcd

 from time  import * 

 import socket  
 #Init de 'afficheur  
 lcd = i2c_lcd.i2c_lcd(0x27,1, 2, 1, 0, 4, 5, 6, 7, 3)  
 #Récupère l'adresse ip   
 locals = socket.socket(socket.AF_INET, socket.SOCK_DGRAM)  
 locals.connect(('google.com', 0))  
 #On affiche tout sa sur l'afficheur   
 LCDlcd.backLightOn()  
 lcd.clear()  
 lcd.setPosition(1, 2)  
 lcd.writeString(str(locals.getsockname()[0]))  
 lcd.setPosition(2, 0)  
 lcd.writeString("hello")  

sudo python3 ./LCD.py

 #!/bin/bash  
 # /etc/init.d/LCD_IP.sh  
 case "$1" in  
  start)  
   echo "lancement du programme de l'afficheur LCD"  
   #la on lance le programme 
   sudo python3 /home/pi/LCD_IP/LCD_IP.py &
   ;;  
  stop)  
   echo "arret du programme de l'afficheur LCD"  
   sudo killall LCD_IP.py  
   ;;  
  *)  
   echo "Usage: /etc/init.d/LCD_IP {start|stop}"  
   exit 1  
   ;;  
 esac  
 exit 0  

sudo raspi-config

sudo mkdir ./minecraft

cd ./minecraft

wget CraftBukkit.jar

sudo chmod +x Craftbukkit.jar

sudo java -Xms300M -jar craftbukkit.jar

sudo nano mkdir ./CraftBukkit.sh

#!/bin/sh BINDIR=$(dirname "$(readlink -fn "$0")") cd "$BINDIR" java -Xms300M -jar craftbukkit.jar -o false

sudo chmod 555 ./CraftBukkit.sh

sudo apt-get install screen

screen -s minecraft java -Xms300M -jar craftbukkit.jar -o false

screen -raAd minecraft

sudo gpp ++ -o NFC NFC.cpp -lwiringPi

sudo ./NFC