void call_to_save_data_var_api()
{
char *str = %inputString;
ns_save_string(str,"NS_DP");
printf("\nNS_SAVE_DATA_VAR API Called");
int return_val = ns_save_data_var(file_name,mode,"NS_DP");
if ( return_val == 0)
{
printf("\nValues saved to %s in mode=%d",file_name,mode);
printf("\nSTATUS=PASS\n");
}
else {
printf("\nSTATUS=FAIL\n");
}
}
void db_select_flow()
{
char buf[2048];
void *stmt = NULL;
char tablename[30], qstr[256];
sprintf(tablename, "products_%d", atoi(ns_eval_string("{uniq_num}")));
// Initialize db environement and variables
if(0>ns_db_odbc_init())
return;
ns_page_think_time(1);
ns_start_transaction("Connect_db_for_select");
// Connect to database with DSN PostgresSQL, username netstorm and password test123
if(0>ns_db_connect("DSN=PostgreSQL; Username=netstorm; Datbase=test"))
return;
ns_end_transaction("Connect_db_for_select", NS_AUTO_STATUS);
ns_page_think_time(2);
// Allocate statement handle.
if(0>ns_db_alloc_stmt_handle(&stmt))
return;
ns_start_transaction("Run_select");
sprintf(qstr, "select * from %s;", tablename);
// Executing select query
if(0>ns_db_execute(stmt, qstr))
return;
ns_end_transaction("Run_select", NS_AUTO_STATUS);
ns_page_think_time(2);
if(0>ns_db_get_value(stmt, buf, 2048))
return;
ns_page_think_time(2);
printf("\n======\nBuffer = %s\n======\n", buf);
ns_save_data_var("/tmp/db_result.txt", 1, buf);
ns_db_free_stmt(stmt);
ns_db_odbc_close();
}
