Exemplo n.º 1
0
Arquivo: ints.c Projeto: javigf/smRPi
int updateStatus (int port, bool portStatus){
	
	//6 = HUMO - 21/22
	//5 = PRTA - 23 - NC - LOW
	//2 = TALT - 24
	
	//  DETECTA VALOR -10 => PUERTA ABIERTA	0
	// 	DETECTA VALOR -20 => PUERTA CERRADA 1
	
	
	if (!mysql_connect ()){
		
		if (portStatus){
			db_insert (5,0,puerta_abierta);
			printf ("PA\n");
		}
		else {
			db_insert (5,0,puerta_cerrada);
			printf ("PC\n");
		}
		db_update (5,0,0);
		mysql_disconnect ();
	}

	return 0;
}
Exemplo n.º 2
0
//*****************************************************************************
//*************************   MAIN-FUNCTION   *********************************
//*****************************************************************************
int main () {


	//Connect to the database
	mysql_connect();

	//gets min_rv en RV[]
	get_stuff();

	//disconnect from the database
	mysql_disconnect();


	//check for a too low value and send mail
	for(int i = 0; i < 3600; i++){
		if((RV[i] < min_rv) && (RV[i] > 0)){
			//exec command
			//snprintf(temp, 100, "cat /usr/share/nginx/mail/humidity_low.txt | mail -s \"Test Subject\" [email protected]");
			//echo "<b>HTML Message goes here</b>" | mail -s "$(echo -e "This is the subject\nContent-Type: text/html")" [email protected]
			snprintf(temp, 200, "cat /usr/share/nginx/mail/humidity_low.txt | mail -s \"$(echo \"[TerraPi] Too low humidity detected.\nContent-Type: text/html\")\" [email protected]");
			system(temp);

			printf("Error: Too low humidity - mail has been sent.\n\n");
			break;
		}
	}

}
Exemplo n.º 3
0
int main() 
{
    mysql_connect(); 

    list_drivers();
    list_data_sources();
    list_driver_information();
    list_tables();

    execute_query("select * from junk");
    execute_query("select count(*), sum(a) from junk");
    execute_query("select a, a+3, 3.141592654 from junk");
    execute_query("select j1.a, j2.a from junk j1 natural join junk j2");

    mysql_disconnect();
}
Exemplo n.º 4
0
int main(int argc, char **argv){

 uint8_t data_array[4];
 uint8_t tx_address[5] = { 0xE7, 0xE7, 0xE7, 0xE7, 0xE7 };
 uint8_t rx_address[5] = { 0xD7, 0xD7, 0xD7, 0xD7, 0xD7 };

 if (!bcm2835_init())
  return 1;

 mysql_connect();

 /* init hardware pins */
 nrf24_init();

 /* Channel #2 , payload length: 4 */
 nrf24_config(2, 4);

 /* Set the device addresses */
 nrf24_tx_address(tx_address);
 nrf24_rx_address(rx_address);

 printf("Configured\n");

 while (1){
  if (nrf24_dataReady()) {
   nrf24_getData(data_array);
   printf("> %d %d %d %d \n",
    data_array[0],
    data_array[1],
    data_array[2],
    data_array[3]);
  if (argc>1) {
   if (argv[1][0]=='1') {
    writeCpm(
     data_array[0],
     data_array[1],
     data_array[2],
     data_array[3]);
    }
   }
  }
 }
 mysql_disconnect();
 bcm2835_close();
 return 0;
}
Exemplo n.º 5
0
Arquivo: debug.c Projeto: javigf/smRPi
/////////////////////////////////////////////////////////////////////////////////
//++++++++++++++++++++++ START READ PORTS FUNCTION ++++++++++++++++++++++++++++++
/////////////////////////////////////////////////////////////////////////////////
int readActivePorts (void){
	
	int size = sizeof (activePorts)/ sizeof (int);
	int result; 
	int lcontador = 0;
	
	if (!mysql_connect ()){
								
		if (!digitalRead (24))
			volts = 0;
		
		db_insert (2,0,volts);
		db_update (2,0,0);
		
		if (!digitalRead (21))	
			humo = 70;
		
		db_insert (6,0,humo);
		db_update (6,0,0);
		humo = 20;
		
		if (!digitalRead (22))
			humo = 70;
		
		db_insert (6,1,humo);
		db_update (6,1,0);

		fileRead ();

		for  (int i=0 ; ((i < MAXPORTS) && (i < size)) ; i++){ 
			
			result = displayDHTData (activePorts[i]);
			if(!result){
	
				db_insert (0,i,temperature);
				db_update (0,i,0);
				fprintf(fr, "%2.1f\t", temperature);

				db_insert (1,i,humidity);
				db_update (1,i,0);
				fprintf(fr, "%2.1f\t", humidity);

				db_insert (4,i,dewPoint);
				db_update (4,i,0);
				fprintf(fr, "%2.1f\n", dewPoint);
				//lcontador = 0;
					
			}
			//else {
				//if ((result == 20) && (lcontador < MAX_ERRORS)){
				//	++lcontador;
				//	--i;
				//}
			else if (result == 20){
				
				for (int j = 1; j < i;  j++){					
					fscanf(fr, "%*f %*f %*f");
					//printf ("J:%d\n",j);
					//printf ("I:%d\n",i);
				}
					
				fscanf(fr, "%f %f %f", &temperature, &humidity, &dewPoint);

				fprintf(stderr, "New value T %2.1f\n", temperature);
				fprintf(stderr, "New value H %2.1f\n", humidity);
				fprintf(stderr, "New value D %2.1f\n", dewPoint);
					
				db_insert (0,i,temperature);
				db_update (0,i,0);
					
				db_insert (1,i,humidity);
				db_update (1,i,0);
				
				db_insert (4,i,dewPoint);
				db_update (4,i,0);
				//	lcontador = 0;
			}
			else if (result == 10){
					db_update (0,i,result);
					db_update (1,i,result);
					db_update (4,i,result);
					//lcontador = 0;
			}
		}
		//fflush (fr);
		fclose (fr);
		printf("File Closed\n");
		mysql_disconnect ();
	}

	return 0;
}