sequence_out_t TeacherBB::outputQuery(const sequence_in_t& inputSequence) {
_outputQueryCounter++;
if (inputSequence.empty()) return sequence_out_t();
sequence_out_t output;
for (const auto& input : inputSequence) {
output.emplace_back(outputQuery(input));
_outputQueryCounter--;
}
return output;
}
sequence_out_t TeacherBB::resetAndOutputQueryOnSuffix(const sequence_in_t& prefix, const sequence_in_t& suffix) {
resetAndOutputQuery(prefix);
_outputQueryCounter--;
return outputQuery(suffix);
}
sequence_out_t TeacherBB::resetAndOutputQuery(const sequence_in_t& inputSequence) {
resetBlackBox();
return outputQuery(inputSequence);
}
output_t TeacherBB::resetAndOutputQuery(input_t input) {
resetBlackBox();
return outputQuery(input);
}
/*
* the order status transaction
*/
int ordstat( int t_num,
int w_id_arg, /* warehouse id */
int d_id_arg, /* district id */
int byname, /* select by c_id or c_last? */
int c_id_arg, /* customer id */
char c_last_arg[] /* customer last name, format? */
)
{
int w_id = w_id_arg;
int d_id = d_id_arg;
int c_id = c_id_arg;
int c_d_id = d_id;
int c_w_id = w_id;
char c_first[17];
char c_middle[3];
char c_last[17];
int c_balance; //goda:float -> int
int o_id;
char o_entry_d[25];
int o_carrier_id;
int ol_i_id;
int ol_supply_w_id;
int ol_quantity;
int ol_amount; //goda:float -> int
char ol_delivery_d[25];
int namecnt;
int n;
int proceed = 0;
MYSQL_STMT* mysql_stmt;
MYSQL_BIND param[6];
MYSQL_BIND column[5];
/* goda [ */
char tempquery[500];
MYSQL_RES *resp = NULL;
MYSQL_ROW row;
int max_o_id;
struct timespec tbuf;
double runtime;
/* ] goda */
/*EXEC SQL WHENEVER NOT FOUND GOTO sqlerr;*/
/*EXEC SQL WHENEVER SQLERROR GOTO sqlerr;*/
if (byname) {
strcpy(c_last, c_last_arg);
proceed = 1;
/*EXEC_SQL SELECT count(c_id)
INTO :namecnt
FROM customer
WHERE c_w_id = :c_w_id
AND c_d_id = :c_d_id
AND c_last = :c_last;*/
/* goda commentout
mysql_stmt = stmt[t_num][20];
memset(param, 0, sizeof(MYSQL_BIND) * 3); /* initialize *
param[0].buffer_type = MYSQL_TYPE_LONG;
param[0].buffer = &c_w_id;
param[1].buffer_type = MYSQL_TYPE_LONG;
param[1].buffer = &c_d_id;
param[2].buffer_type = MYSQL_TYPE_STRING;
param[2].buffer = c_last;
param[2].buffer_length = strlen(c_last);
if( mysql_stmt_bind_param(mysql_stmt, param) ) goto sqlerr;
if( mysql_stmt_execute(mysql_stmt) ) goto sqlerr;
if( mysql_stmt_store_result(mysql_stmt) ) goto sqlerr;
memset(column, 0, sizeof(MYSQL_BIND) * 1); /* initialize *
column[0].buffer_type = MYSQL_TYPE_LONG;
column[0].buffer = &namecnt;
if( mysql_stmt_bind_result(mysql_stmt, column) ) goto sqlerr;
switch( mysql_stmt_fetch(mysql_stmt) ) {
case 0: //SUCCESS
break;
case 1: //ERROR
case MYSQL_NO_DATA: //NO MORE DATA
default:
mysql_stmt_free_result(mysql_stmt);
goto sqlerr;
}
mysql_stmt_free_result(mysql_stmt);
*/
/* goda [ */
sprintf(tempquery,"SELECT count(c_id) FROM customer WHERE c_w_id = %d AND c_d_id = %d AND c_last = '%s'",c_w_id,c_d_id,c_last);
GetStartTime(&tbuf);
if(mysql_query(ctx[t_num],tempquery)) goto sqlerr;
runtime = GetRunTime(&tbuf);
query_log[20].runCount++;
query_log[20].runTime += runtime;
resp = mysql_use_result(ctx[t_num]);
if((row = mysql_fetch_row(resp)) != NULL){
namecnt = atoi(row[0]);
}
else{
//NO RESULT
mysql_free_result(resp);
goto sqlerr;
}
mysql_free_result(resp);
/* ] goda */
proceed = 2;
/*EXEC_SQL DECLARE c_byname_o CURSOR FOR
SELECT c_balance, c_first, c_middle, c_last
FROM customer
WHERE c_w_id = :c_w_id
AND c_d_id = :c_d_id
AND c_last = :c_last
ORDER BY c_first;
proceed = 3;
EXEC_SQL OPEN c_byname_o;*/
/* goda commentout
mysql_stmt = stmt[t_num][21];
memset(param, 0, sizeof(MYSQL_BIND) * 3); /* initialize *
param[0].buffer_type = MYSQL_TYPE_LONG;
param[0].buffer = &c_w_id;
param[1].buffer_type = MYSQL_TYPE_LONG;
param[1].buffer = &c_d_id;
param[2].buffer_type = MYSQL_TYPE_STRING;
param[2].buffer = c_last;
param[2].buffer_length = strlen(c_last);
if( mysql_stmt_bind_param(mysql_stmt, param) ) goto sqlerr;
if( mysql_stmt_execute(mysql_stmt) ) goto sqlerr;
if( mysql_stmt_store_result(mysql_stmt) ) goto sqlerr;
memset(column, 0, sizeof(MYSQL_BIND) * 4); /* initialize *
column[0].buffer_type = MYSQL_TYPE_FLOAT;
column[0].buffer = &c_balance;
column[1].buffer_type = MYSQL_TYPE_STRING;
column[1].buffer = c_first;
column[1].buffer_length = sizeof(c_first);
column[2].buffer_type = MYSQL_TYPE_STRING;
column[2].buffer = c_middle;
column[2].buffer_length = sizeof(c_middle);
column[3].buffer_type = MYSQL_TYPE_STRING;
column[3].buffer = c_last;
column[3].buffer_length = sizeof(c_last);
if( mysql_stmt_bind_result(mysql_stmt, column) ) goto sqlerr;
*/
/* goda [ */
sprintf(tempquery,"SELECT c_balance, c_first, c_middle, c_last FROM customer WHERE c_w_id = %d AND c_d_id = %d AND c_last = '%s' ORDER BY c_first",c_w_id,c_d_id,c_last);
GetStartTime(&tbuf);
if(mysql_query(ctx[t_num],tempquery)) goto sqlerr;
runtime = GetRunTime(&tbuf);
query_log[21].runCount++;
query_log[21].runTime += runtime;
resp = mysql_use_result(ctx[t_num]);
/* ] goda */
if (namecnt % 2)
namecnt++; /* Locate midpoint customer; */
for (n = 0; n < namecnt / 2; n++) {
proceed = 4;
/* goda commentout
/*EXEC_SQL FETCH c_byname_o
INTO :c_balance, :c_first, :c_middle, :c_last;*
switch( mysql_stmt_fetch(mysql_stmt) ) {
case 0: //SUCCESS
case MYSQL_DATA_TRUNCATED:
break;
case 1: //ERROR
case MYSQL_NO_DATA: //NO MORE DATA
default:
mysql_stmt_free_result(mysql_stmt);
goto sqlerr;
}
*/
/* goda [ */
if((row = mysql_fetch_row(resp)) != NULL){
c_balance = atoi(row[0]);
sprintf(c_first,"%s",row[1]);
sprintf(c_middle,"%s",row[2]);
sprintf(c_last,"%s",row[3]);
}
else{
//NO RESULT
mysql_free_result(resp);
goto sqlerr;
}
/* ] goda */
}
proceed = 5;
/*EXEC_SQL CLOSE c_byname_o;*/
//goda commentout mysql_stmt_free_result(mysql_stmt);
mysql_free_result(resp);
} else { /* by number */
proceed = 6;
/*EXEC_SQL SELECT c_balance, c_first, c_middle, c_last
INTO :c_balance, :c_first, :c_middle, :c_last
FROM customer
WHERE c_w_id = :c_w_id
AND c_d_id = :c_d_id
AND c_id = :c_id;*/
/* goda commentout
mysql_stmt = stmt[t_num][22];
memset(param, 0, sizeof(MYSQL_BIND) * 3); /* initialize *
param[0].buffer_type = MYSQL_TYPE_LONG;
param[0].buffer = &c_w_id;
param[1].buffer_type = MYSQL_TYPE_LONG;
param[1].buffer = &c_d_id;
param[2].buffer_type = MYSQL_TYPE_LONG;
param[2].buffer = &c_id;
if( mysql_stmt_bind_param(mysql_stmt, param) ) goto sqlerr;
if( mysql_stmt_execute(mysql_stmt) ) goto sqlerr;
if( mysql_stmt_store_result(mysql_stmt) ) goto sqlerr;
memset(column, 0, sizeof(MYSQL_BIND) * 4); /* initialize *
column[0].buffer_type = MYSQL_TYPE_FLOAT;
column[0].buffer = &c_balance;
column[1].buffer_type = MYSQL_TYPE_STRING;
column[1].buffer = c_first;
column[1].buffer_length = sizeof(c_first);
column[2].buffer_type = MYSQL_TYPE_STRING;
column[2].buffer = c_middle;
column[2].buffer_length = sizeof(c_middle);
column[3].buffer_type = MYSQL_TYPE_STRING;
column[3].buffer = c_last;
column[3].buffer_length = sizeof(c_last);
if( mysql_stmt_bind_result(mysql_stmt, column) ) goto sqlerr;
switch( mysql_stmt_fetch(mysql_stmt) ) {
case 0: //SUCCESS
case MYSQL_DATA_TRUNCATED:
break;
case 1: //ERROR
case MYSQL_NO_DATA: //NO MORE DATA
default:
mysql_stmt_free_result(mysql_stmt);
goto sqlerr;
}
mysql_stmt_free_result(mysql_stmt);
*/
/* goda [ */
sprintf(tempquery,"SELECT c_balance, c_first, c_middle, c_last FROM customer WHERE c_w_id = %d AND c_d_id = %d AND c_id = %d",c_w_id,c_d_id,c_id);
GetStartTime(&tbuf);
if(mysql_query(ctx[t_num],tempquery)) goto sqlerr;
runtime = GetRunTime(&tbuf);
query_log[22].runCount++;
query_log[22].runTime += runtime;
resp = mysql_use_result(ctx[t_num]);
if((row = mysql_fetch_row(resp)) != NULL){
c_balance = atoi(row[0]);
sprintf(c_first,"%s",row[1]);
sprintf(c_middle,"%s",row[2]);
sprintf(c_last,"%s",row[3]);
}
else{
//NO RESULT
mysql_free_result(resp);
goto sqlerr;
}
mysql_free_result(resp);
/* ] goda */
}
/* find the most recent order for this customer */
proceed = 7;
/*EXEC_SQL SELECT o_id, o_entry_d, COALESCE(o_carrier_id,0)
INTO :o_id, :o_entry_d, :o_carrier_id
FROM orders
WHERE o_w_id = :c_w_id
AND o_d_id = :c_d_id
AND o_c_id = :c_id
AND o_id = (SELECT MAX(o_id)
FROM orders
WHERE o_w_id = :c_w_id
AND o_d_id = :c_d_id
AND o_c_id = :c_id);*/
/* goda commentout
mysql_stmt = stmt[t_num][23];
memset(param, 0, sizeof(MYSQL_BIND) * 6); /* initialize *
param[0].buffer_type = MYSQL_TYPE_LONG;
param[0].buffer = &c_w_id;
param[1].buffer_type = MYSQL_TYPE_LONG;
param[1].buffer = &c_d_id;
param[2].buffer_type = MYSQL_TYPE_LONG;
param[2].buffer = &c_id;
param[3].buffer_type = MYSQL_TYPE_LONG;
param[3].buffer = &c_w_id;
param[4].buffer_type = MYSQL_TYPE_LONG;
param[4].buffer = &c_d_id;
param[5].buffer_type = MYSQL_TYPE_LONG;
param[5].buffer = &c_id;
if( mysql_stmt_bind_param(mysql_stmt, param) ) goto sqlerr;
if( mysql_stmt_execute(mysql_stmt) ) goto sqlerr;
if( mysql_stmt_store_result(mysql_stmt) ) goto sqlerr;
memset(column, 0, sizeof(MYSQL_BIND) * 3); /* initialize *
column[0].buffer_type = MYSQL_TYPE_LONG;
column[0].buffer = &o_id;
column[1].buffer_type = MYSQL_TYPE_STRING;
column[1].buffer = o_entry_d;
column[1].buffer_length = sizeof(o_entry_d);
column[2].buffer_type = MYSQL_TYPE_LONG;
column[2].buffer = &o_carrier_id;
if( mysql_stmt_bind_result(mysql_stmt, column) ) goto sqlerr;
switch( mysql_stmt_fetch(mysql_stmt) ) {
case 0: //SUCCESS
break;
case 1: //ERROR
case MYSQL_NO_DATA: //NO MORE DATA
default:
mysql_stmt_free_result(mysql_stmt);
goto sqlerr;
}
mysql_stmt_free_result(mysql_stmt);
*/
/* goda [ */
/* preprocess to get max_o_id */
sprintf(tempquery,"SELECT MAX(o_id) FROM orders WHERE o_w_id = %d AND o_d_id = %d AND o_c_id = %d",c_w_id,c_d_id,c_id);
if(mysql_query(ctx[t_num],tempquery)) goto sqlerr;
resp = mysql_use_result(ctx[t_num]);
if((row = mysql_fetch_row(resp)) != NULL){
max_o_id = atoi(row[0]);
}
else{
//NO RESULT
mysql_free_result(resp);
goto sqlerr;
}
mysql_free_result(resp);
proceed = 70;
//sprintf(tempquery,"SELECT o_id, o_entry_d, COALESCE(o_carrier_id,0) FROM orders WHERE o_w_id = %d AND o_d_id = %d AND o_c_id = %d AND o_id = (SELECT MAX(o_id) FROM orders WHERE o_w_id = %d AND o_d_id = %d AND o_c_id = %d)",c_w_id,c_d_id,c_id,c_w_id,c_d_id,c_id);
sprintf(tempquery,"SELECT o_id, o_entry_d, o_carrier_id FROM orders WHERE o_w_id = %d AND o_d_id = %d AND o_c_id = %d AND o_id = %d",c_w_id,c_d_id,c_id,max_o_id);
GetStartTime(&tbuf);
if(mysql_query(ctx[t_num],tempquery)) goto sqlerr;
runtime = GetRunTime(&tbuf);
query_log[23].runCount++;
query_log[23].runTime += runtime;
resp = mysql_use_result(ctx[t_num]);
if((row = mysql_fetch_row(resp)) != NULL){
sprintf(o_entry_d,"%s",row[1]);
if(row[2] != NULL){
o_carrier_id = atoi(row[2]);
}
else{
o_carrier_id = 0;
}
}
else{
//NO RESULT
mysql_free_result(resp);
goto sqlerr;
}
mysql_free_result(resp);
/* ] goda */
/* find all the items in this order */
proceed = 8;
/*EXEC_SQL DECLARE c_items CURSOR FOR
SELECT ol_i_id, ol_supply_w_id, ol_quantity, ol_amount,
ol_delivery_d
FROM order_line
WHERE ol_w_id = :c_w_id
AND ol_d_id = :c_d_id
AND ol_o_id = :o_id;*/
/* goda commentout
mysql_stmt = stmt[t_num][24];
memset(param, 0, sizeof(MYSQL_BIND) * 3); /* initialize *
param[0].buffer_type = MYSQL_TYPE_LONG;
param[0].buffer = &c_w_id;
param[1].buffer_type = MYSQL_TYPE_LONG;
param[1].buffer = &c_d_id;
param[2].buffer_type = MYSQL_TYPE_LONG;
param[2].buffer = &o_id;
if( mysql_stmt_bind_param(mysql_stmt, param) ) goto sqlerr;
if( mysql_stmt_execute(mysql_stmt) ) goto sqlerr;
if( mysql_stmt_store_result(mysql_stmt) ) goto sqlerr;
memset(column, 0, sizeof(MYSQL_BIND) * 5); /* initialize *
column[0].buffer_type = MYSQL_TYPE_LONG;
column[0].buffer = &ol_i_id;
column[1].buffer_type = MYSQL_TYPE_LONG;
column[1].buffer = &ol_supply_w_id;
column[2].buffer_type = MYSQL_TYPE_LONG;
column[2].buffer = &ol_quantity;
column[3].buffer_type = MYSQL_TYPE_FLOAT;
column[3].buffer = &ol_amount;
column[4].buffer_type = MYSQL_TYPE_STRING;
column[4].buffer = ol_delivery_d;
column[4].buffer_length = sizeof(ol_delivery_d);
if( mysql_stmt_bind_result(mysql_stmt, column) ) goto sqlerr;
*/
/* goda [ */
sprintf(tempquery,"SELECT ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_delivery_d FROM order_line WHERE ol_w_id = %d AND ol_d_id = %d AND ol_o_id = %d",c_w_id,c_d_id,o_id);
GetStartTime(&tbuf);
if(mysql_query(ctx[t_num],tempquery)) goto sqlerr;
runtime = GetRunTime(&tbuf);
query_log[24].runCount++;
query_log[24].runTime += runtime;
resp = mysql_use_result(ctx[t_num]);
/* ] goda */
/*proceed = 9;
EXEC_SQL OPEN c_items;
EXEC SQL WHENEVER NOT FOUND GOTO done;*/
for (;;) {
proceed = 10;
/*EXEC_SQL FETCH c_items
INTO :ol_i_id, :ol_supply_w_id, :ol_quantity,
:ol_amount, :ol_delivery_d;*/
/* goda commentout
switch( mysql_stmt_fetch(mysql_stmt) ) {
case 0: //SUCCESS
case MYSQL_DATA_TRUNCATED:
break;
case MYSQL_NO_DATA: //NO MORE DATA
mysql_stmt_free_result(mysql_stmt);
goto done;
case 1: //ERROR
default:
mysql_stmt_free_result(mysql_stmt);
goto sqlerr;
}
*/
if((row = mysql_fetch_row(resp)) != NULL){
ol_i_id = atoi(row[0]);
ol_supply_w_id = atoi(row[1]);
ol_quantity = atoi(row[2]);
ol_amount = atoi(row[3]);
sprintf(ol_delivery_d,"%s",row[4]);
}
else{
//NO RESULT
mysql_free_result(resp);
goto done;
//goto sqlerr;
}
mysql_free_result(resp);
}
done:
/*EXEC_SQL CLOSE c_items;*/
/*EXEC_SQL COMMIT WORK;*/
if( mysql_commit(ctx[t_num]) ) goto sqlerr;
return (1);
sqlerr:
fprintf(stderr, "ordstat %d:%d\n",t_num,proceed);
outputQuery(tempquery);
error(ctx[t_num],mysql_stmt);
/*EXEC SQL WHENEVER SQLERROR GOTO sqlerrerr;*/
/*EXEC_SQL ROLLBACK WORK;*/
mysql_rollback(ctx[t_num]);
sqlerrerr:
return (0);
}
