MicroArm MINI2440 Manual do Utilizador Página 70

  • Descarregar
  • Adicionar aos meus manuais
  • Imprimir
  • Página
    / 80
  • Índice
  • MARCADORES
  • Avaliado. / 5. Com base em avaliações de clientes
Vista de página 69
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
Vista de página 69
1 2 ... 65 66 67 68 69 70 71 72 73 74 75 ... 79 80

Comentários a estes Manuais

Sem comentários