if(ola==1){
/*Proetoimasia query ola*/
sprintf(sqlq,"select time, heat, humidity from envstore
order by time desc limit %d,20",sel*20);
error = sqlite3_prepare_v2(conn,sqlq,1000, &res, &tail);
sprintf(scount,"select count(*) from envstore");
sprintf(sqliq,"select AVG(\"heat\") from envstore");
average_heat = Qtoi(sqliq,conn);
sprintf(sqliq,"select max(\"heat\") from envstore");
max_heat = Qtoi(sqliq,conn);
sprintf(sqliq,"select min(\"heat\") from envstore");
min_heat = Qtoi(sqliq,conn);
sprintf(sqliq,"select AVG(\"humidity\") from envstore");
average_hym = Qtoi(sqliq,conn);
sprintf(sqliq,"select max(\"humidity\") from envstore");
max_hym = Qtoi(sqliq,conn);
sprintf(sqliq,"select min(\"humidity\") from envstore");
min_hym = Qtoi(sqliq,conn);
}
else if(krit == 1){
/*Proetoimasia query kritiriwn*/
sprintf(sqlq,"select * from envstore where %s order by
time desc limit %d,20",sqlqtmp,sel*20);
error = sqlite3_prepare_v2(conn,sqlq,1000, &res, &tail);
sprintf(scount,"select count(*) from envstore where
%s",sqlqtmp);
sprintf(sqliq,"select AVG(\"heat\") from envstore where
%s",sqlqtmp);
average_heat = Qtoi(sqliq,conn);
sprintf(sqliq,"select max(\"heat\") from envstore where
%s",sqlqtmp);
max_heat = Qtoi(sqliq,conn);
sprintf(sqliq,"select min(\"heat\") from envstore where
%s",sqlqtmp);
min_heat = Qtoi(sqliq,conn);
sprintf(sqliq,"select AVG(\"humidity\") from envstore
where %s",sqlqtmp);
average_hym = Qtoi(sqliq,conn);
sprintf(sqliq,"select max(\"humidity\") from envstore
where %s",sqlqtmp);
max_hym = Qtoi(sqliq,conn);
sprintf(sqliq,"select min(\"humidity\") from envstore
where %s",sqlqtmp);
min_hym = Qtoi(sqliq,conn);
/*Proetoimasia query 10 teleutaia*/
}
else{
/*an kati den paei kala me ta argument*/
system("date >> /my/sel_log.txt");
system("Argument related problem >> /my/sel_log.txt");
}
Σελίδα 63
Comentários a estes Manuais