wiki.raudys.com

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
Rasperry Pi turi 1-wire protokolo palaikymą. Pats populiariausias W1 įrenginys yra skaitmeninis termometras  DS18B20 

{{:raspberrypi:pasted:20170225-112158.png}}

{{:raspberrypi:pasted:20200320-182905.png}}

panaudojus sita gida pavyko gauti temperaturas ir jas irasyti i faila:
  * http://www.cl.cam.ac.uk/projects/raspberrypi/tutorials/temperature/
  * https://www.modmypi.com/blog/ds18b20-one-wire-digital-temperature-sensor-and-the-raspberry-pi

Čia iš komandinės eilutės parašius komandas galima pamatyti temperatūrą:
  ls /sys/bus/w1/devices/
{{:raspberrypi:pasted:20170311-170343.png}}

Čia 28-0316881dadff yra termometro/mikroschemos numeris. Jei yra keli tai bus kelios tokios direktorijos.
Ir Temperatūra yra 22,250 laipsnių pagal Celsijų. 

tada parasiau nedidele c programa kuri raso i loga temperaturas ir ją paleidau kas 10 sekundžių
<code c>
#include <stdio.h>
#include <stdlib.h>
#include <time.h>

/*
gcc -Wall -pthread -o w1_temp_rec w1_temp_rec.c && sudo ./w1_temp_rec
sudo ./w1_temp_rec

watch -n10 ./w1_temp_rec
*/

int main()
{
    FILE * temp_log = fopen("temp_log.txt", "a");

    time_t now;
    time(&now);
    char buf[sizeof "2011-10-08T07:07:09Z"];
    strftime(buf, sizeof buf, "%FT%TZ", gmtime(&now));
    //printf("%s\n", buf);

    printf("record temperature readings to file\n");
    FILE * fp;
    char * line = NULL;
    size_t len = 0;
    fp = fopen("/sys/bus/w1/devices/28-031688217aff/w1_slave", "r");
    getline(&line, &len, fp); //printf("%s", line);
    getline(&line, &len, fp); 
    strftime(buf, sizeof buf, "%FT%TZ", gmtime(&now)); 
    printf("%s OUT %s", buf, line);
    fprintf(temp_log, "%s OUT %s", buf, line);
    
    fclose(fp);

    fp = fopen("/sys/bus/w1/devices/28-03168812d2ff/w1_slave", "r");
    getline(&line, &len, fp); //printf("%s", line);
    getline(&line, &len, fp); 
    strftime(buf, sizeof buf, "%FT%TZ", gmtime(&now)); 
    printf("%s IN %s", buf, line);
    fprintf(temp_log, "%s IN %s", buf, line);
    fclose(fp);

    fclose(temp_log);
    

    if (line) free(line);
    return 0;
}
</code>

reikia paleisti kad kas minute rasitu i faila:
  crontab -e
  
ideti tokia eilute:
<code>
* * * * * ./w1_temp_rec
</code>
  
  

Paleidau 2 termometrus, viesnas matuoja temperatūrą namuose kitas lauke. Tada nubraižiau grafikus su matlab ir gavau toki vaizdą:

<code matlab>
%% read temperature log file and plot chart
fileID = fopen('\\aistis\pihome\home\pi\temp_log.txt','r');
C = textscan(fileID,'%s %s %*s %*s %*s %*s %*s %*s %*s %*s %*s %*s %f','Delimiter',' =');
fclose(fileID);
d = struct('date',num2cell(datenum(C{1},'yyyy-mm-ddTHH:MM:SSZ')), ...
    'type', C{2}, 'temp', num2cell(C{end}./1000));

figure(1);clf;
l = strcmp({d.type},'IN');
plot([d(l).date],[d(l).temp]);
dynamicDateTicks;grid on;title('temperature in the house');
xlabel('time');ylabel('temperature in celcius');

figure(2);clf;
l = strcmp({d.type},'OUT');
plot([d(l).date],[d(l).temp],'r');
dynamicDateTicks;grid on;title('temperature outside');
xlabel('time');ylabel('temperature in celcius');
</code>

Ir gavau tokį vaizdą. 

{{:raspberrypi:pasted:20170311-170024.png}}

{{:raspberrypi:pasted:20170311-170059.png}}

Čia kelios nuotraukos

{{:raspberrypi:pasted:20170225-120556.png}}

{{:raspberrypi:pasted:20170225-120700.png}}



Žemiau MYSQL irasymas į duomenų bazę temperatūros:

<code c>
#include <stdio.h>
#include <stdlib.h>
#include <signal.h>
#include <string.h>

#include <mysql/mysql.h>
 
//#include <pigpio.h>

//get temperature from w1 sendor and insert into database

// specify sensor names to insert into database
// temp_mysql 28-0316881dadff 28-0316881dadf1 28-0316881dadf2

// pataisyti skripta kad rasytu i db 
// sudeti senus duomenis i baze
// paliesti rasyti naujus duomenis i baze

// nunesti rpi aistis i kampa 
// pritvirtinti laida prie sienos
// nupirkti balto laido ir baltu laikikliu kikek? irt dezute juoda ant faxverko vandeniui nelaidzia


//TODO: auto create table
//TODO: verify CRC value YES in sensor file
 
/*   instaliuoti
sudo apt-get install libmysqlclient-dev -y
*/

/* 
gcc -Wall -pthread -o temp_mysql temp_mysql.c `mysql_config --libs`
sudo ./temp_mysql 28-031688217aff 28-03168812d2ff 
*/

/*
CREATE TABLE if not exist temperature3 (ts timestamp NOT NULL, value double NOT NULL, sensor_id bigint NOT NULL) ENGINE=MyISAM

*/

// You must free the result if result is non-NULL.
char *str_replace(char *orig, char *rep, char *with) {
    char *result; // the return string
    char *ins;    // the next insert point
    char *tmp;    // varies
    int len_rep;  // length of rep (the string to remove)
    int len_with; // length of with (the string to replace rep with)
    int len_front; // distance between rep and end of last rep
    int count;    // number of replacements

    // sanity checks and initialization
    if (!orig || !rep)
        return NULL;
    len_rep = strlen(rep);
    if (len_rep == 0)
        return NULL; // empty rep causes infinite loop during count
    if (!with)
        with = "";
    len_with = strlen(with);

    // count the number of replacements needed
    ins = orig;
    for (count = 0; (tmp = strstr(ins, rep)); ++count) {
        ins = tmp + len_rep;
    }

    tmp = result = malloc(strlen(orig) + (len_with - len_rep) * count + 1);

    if (!result)
        return NULL;

    // first time through the loop, all the variable are set correctly
    // from here on,
    //    tmp points to the end of the result string
    //    ins points to the next occurrence of rep in orig
    //    orig points to the remainder of orig after "end of rep"
    while (count--) {
        ins = strstr(orig, rep);
        len_front = ins - orig;
        tmp = strncpy(tmp, orig, len_front) + len_front;
        tmp = strcpy(tmp, with) + len_with;
        orig += len_front + len_rep; // move to next "end of rep"
    }
    strcpy(tmp, orig);
    return result;
}

double get_temperature(const char *w1_sensor_name)
{
    FILE * fp;
    char w1_sensor_file_name[1000];
    sprintf(w1_sensor_file_name, "/sys/bus/w1/devices/%s/w1_slave",w1_sensor_name);
    fp = fopen(w1_sensor_file_name, "r");

    char crc_value_buf[100];
    double temperature;
    fscanf(fp,"%*s %*s %*s %*s %*s %*s %*s %*s %*s %*s %*s %s",crc_value_buf);
    fscanf(fp,"%*s %*s %*s %*s %*s %*s %*s %*s %*s %*c %*c %lf",&temperature);
    fclose(fp);
    temperature = temperature / 1000;

    //printf("%s\n", crc_value_buf);
    //printf("%f\n", temperature);

    return temperature;
}

 
int main(int argc, char *argv[])
{
  //if (gpioInitialise() < 0) return -1;

  MYSQL *con = mysql_init(NULL);

  if (con == NULL) 
  {
      fprintf(stderr, "%s\n", mysql_error(con));
      exit(1);
  }

  if (mysql_real_connect(con, "algo.lt", "algo_aistis", "aistis445445", 
          "algo_aistis", 0, NULL, 0) == NULL) 
  {
      fprintf(stderr, "%s\n", mysql_error(con));
      mysql_close(con);
      exit(1);
  }  

  /*if (mysql_query(con, "insert into temperature (ts, value, location) values (LOCALTIMESTAMP(), 10, 'HOME_NORTH');")) 
  {
      fprintf(stderr, "%s\n", mysql_error(con));
      mysql_close(con);
      exit(1);
  }*/


    printf("record temperature readings from w1 sensor and recor to mysql table\n");
    //const char * w1_sensor_nr1 = "28-031688217aff";

    printf("%d\n", argc);
    
    int i;
    for (i=1;i<argc;i++)
    {
        char  *w1_sensor_nr1 = argv[i];

        double t1 = get_temperature(w1_sensor_nr1);
        printf("%f\n",t1);

        char sql_buf[2000];
        char * w1_sensor_nr2 = str_replace(w1_sensor_nr1,"-","");
            printf("%s\n",w1_sensor_nr2);
        
        sprintf(sql_buf, "insert into temperature (ts, value, sensor_id) values (LOCALTIMESTAMP(), %lf, 0x%s);",t1,w1_sensor_nr2);
        printf("%s\n",sql_buf);
        free(w1_sensor_nr2);

        if (mysql_query(con, sql_buf)) 
        {
            fprintf(stderr, "%s\n", mysql_error(con));
            mysql_close(con);
            exit(1);
        }
    }
    
  mysql_close(con);

  return 0;   
}


</code>