1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
|
PGresult* result1;
PGresult* result2;
PGresult* result3;
PGresult* result4;
//sprintf(commande_sql1,"select verify_replicat('192.168.1.1', 'ADC16448521539632AB165', current_timestamp);");
const char *commande_sql1="select * from ips;";
result1 = PQexec(connect_database, commande_sql1);
char *val1 = PQgetvalue(result1,0,0);
printf("%s \n", val1);
if ((PQresultStatus(result1) != PGRES_TUPLES_OK ))
{
fprintf(stderr, "couldnt execute query 1\n");
PQclear(result1);
}
else {
printf ("commande 1 exécutée\n");
}
//sprintf(commande_sql2,"select verify_replicat('192.168.1.1', 'ADC16448521539632AB165', current_timestamp);");
const char *commande_sql2="select mape_add_ip('192.168.1.4');";
result2 = PQexec(connect_database, commande_sql2);
char *val2 = PQgetvalue(result2,0,0);
printf("%s \n", val2);
if ((PQresultStatus(result2) != PGRES_TUPLES_OK ))
{
fprintf(stderr, "couldnt execute query 2\n");
PQclear(result2);
}
else {
printf ("commande 2 exécutée\n");
}
//sprintf(commande_sql3,"select verify_replicat('192.168.1.2', 'BCC16448521539632AB165', current_timestamp);");
const char *commande_sql3="select verify_replicat('192.168.1.2', 'BCC16448521539632AB165', current_timestamp);";
result3 = PQexec(connect_database, commande_sql3);
char *val3 = PQgetvalue(result3,0,0);
printf ("%s\n", val3);
if ((PQresultStatus(result3) != PGRES_TUPLES_OK ))
{
fprintf(stderr, "couldnt execute query 3\n");
PQclear(result3);
}
else {
printf ("commande 3 exécutée\n");
}
//sprintf(commande_sql4,"select verify_replicat('192.168.1.3', 'ADC16448521539632AB165', current_timestamp);");
const char *commande_sql4="select verify_replicat('192.168.1.3', 'ADC16448521539632AB165', current_timestamp);";
result4 = PQexec(connect_database, commande_sql4);
char *val4 = PQgetvalue(result4,0,0);
printf ("%s\n", val4);
if ((PQresultStatus(result4) != PGRES_TUPLES_OK ))
{
fprintf(stderr, "couldnt execute query 4\n");
PQclear(result4);
}
else {
printf ("commande 4 exécutée\n");
} |
Partager