exports.updateTickets = function() {
var input = request.readInputText();
var responseBody = JSON.parse(input);
var connection = datasource.getConnection();
try {
var sql = "UPDATE TICKETS SET ";
sql += "TICKET_CLASS = ?";
sql += ",";
sql += "TICKET_PRICE = ?";
sql += ",";
sql += "TICKET_QUANTITY = ?";
sql += ",";
sql += "TICKET_AVAILABLE = ?";
sql += ",";
sql += "TRANSPORT_ID = ?";
sql += " WHERE TICKET_ID = ?";
var statement = connection.prepareStatement(sql);
var i = 0;
statement.setString(++i, responseBody.ticket_class);
statement.setDouble(++i, responseBody.ticket_price);
statement.setInt(++i, responseBody.ticket_quantity);
statement.setInt(++i, responseBody.ticket_available);
statement.setInt(++i, responseBody.transport_id);
var id = responseBody.ticket_id;
statement.setInt(++i, id);
statement.executeUpdate();
response.println(id);
} catch(e){
var errorCode = response.BAD_REQUEST;
exports.printError(errorCode, errorCode, e.message, sql);
} finally {
connection.close();
}
};
exports.updateMaster_currency = function() {
var input = request.readInputText();
var responseBody = JSON.parse(input);
var connection = datasource.getConnection();
try {
var sql = "UPDATE MASTER_CURRENCY SET ";
sql += "CURRENCY_CODE = ?";
sql += ",";
sql += "CURRENCY_ENTITY = ?";
sql += ",";
sql += "CURRENCY_NAME = ?";
sql += ",";
sql += "CURRENCY_NUMERIC_CODE = ?";
sql += ",";
sql += "CURRENCY_MINOR_UNIT = ?";
sql += " WHERE CURRENCY_ID = ?";
var statement = connection.prepareStatement(sql);
var i = 0;
statement.setString(++i, responseBody.currency_code);
statement.setString(++i, responseBody.currency_entity);
statement.setString(++i, responseBody.currency_name);
statement.setInt(++i, responseBody.currency_numeric_code);
statement.setInt(++i, responseBody.currency_minor_unit);
var id = responseBody.currency_id;
statement.setInt(++i, id);
statement.executeUpdate();
response.println(id);
} catch(e){
var errorCode = response.BAD_REQUEST;
exports.printError(errorCode, errorCode, e.message, sql);
} finally {
connection.close();
}
};
exports.createTickets = function() {
var input = request.readInputText();
var requestBody = JSON.parse(input);
var connection = datasource.getConnection();
try {
var sql = "INSERT INTO TICKETS (";
sql += "TICKET_ID";
sql += ",";
sql += "TICKET_CLASS";
sql += ",";
sql += "TICKET_PRICE";
sql += ",";
sql += "TICKET_QUANTITY";
sql += ",";
sql += "TICKET_AVAILABLE";
sql += ",";
sql += "TRANSPORT_ID";
sql += ") VALUES (";
sql += "?";
sql += ",";
sql += "?";
sql += ",";
sql += "?";
sql += ",";
sql += "?";
sql += ",";
sql += "?";
sql += ",";
sql += "?";
sql += ")";
var statement = connection.prepareStatement(sql);
var i = 0;
var id = datasource.getSequence('TICKETS_TICKET_ID').next();
statement.setInt(++i, id);
statement.setString(++i, requestBody.ticket_class);
statement.setDouble(++i, requestBody.ticket_price);
statement.setInt(++i, requestBody.ticket_quantity);
statement.setInt(++i, requestBody.ticket_available);
statement.setInt(++i, requestBody.transport_id);
statement.executeUpdate();
response.println(id);
return id;
} catch(e) {
var errorCode = response.BAD_REQUEST;
exports.printError(errorCode, errorCode, e.message, sql);
} finally {
connection.close();
}
return -1;
};
exports.createMaster_currency = function() {
var input = request.readInputText();
var requestBody = JSON.parse(input);
var connection = datasource.getConnection();
try {
var sql = "INSERT INTO MASTER_CURRENCY (";
sql += "CURRENCY_ID";
sql += ",";
sql += "CURRENCY_CODE";
sql += ",";
sql += "CURRENCY_ENTITY";
sql += ",";
sql += "CURRENCY_NAME";
sql += ",";
sql += "CURRENCY_NUMERIC_CODE";
sql += ",";
sql += "CURRENCY_MINOR_UNIT";
sql += ") VALUES (";
sql += "?";
sql += ",";
sql += "?";
sql += ",";
sql += "?";
sql += ",";
sql += "?";
sql += ",";
sql += "?";
sql += ",";
sql += "?";
sql += ")";
var statement = connection.prepareStatement(sql);
var i = 0;
var id = datasource.getSequence('MASTER_CURRENCY_CURRENCY_ID').next();
statement.setInt(++i, id);
statement.setString(++i, requestBody.currency_code);
statement.setString(++i, requestBody.currency_entity);
statement.setString(++i, requestBody.currency_name);
statement.setInt(++i, requestBody.currency_numeric_code);
statement.setInt(++i, requestBody.currency_minor_unit);
statement.executeUpdate();
response.println(id);
return id;
} catch(e) {
var errorCode = response.BAD_REQUEST;
exports.printError(errorCode, errorCode, e.message, sql);
} finally {
connection.close();
}
return -1;
};
exports.updateTransports = function() {
var input = request.readInputText();
var responseBody = JSON.parse(input);
var connection = datasource.getConnection();
try {
var sql = "UPDATE TRANSPORTS SET ";
sql += "TRANSPORT_TYPE = ?";
sql += ",";
sql += "TRANSPORT_DEPARTURE_DATE = ?";
sql += ",";
sql += "TRANSPORT_ARRIVAL_DATE = ?";
sql += ",";
sql += "DEPARTURE_CITY_ID = ?";
sql += ",";
sql += "ARRIVAL_CITY_ID = ?";
sql += " WHERE TRANSPORT_ID = ?";
var statement = connection.prepareStatement(sql);
var i = 0;
statement.setString(++i, responseBody.transport_type);
if (responseBody.transport_departure_date !== null) {
var js_date_transport_departure_date = new Date(Date.parse(responseBody.transport_departure_date));
statement.setTimestamp(++i, js_date_transport_departure_date);
} else {
statement.setTimestamp(++i, null);
}
if (responseBody.transport_arrival_date !== null) {
var js_date_transport_arrival_date = new Date(Date.parse(responseBody.transport_arrival_date));
statement.setTimestamp(++i, js_date_transport_arrival_date);
} else {
statement.setTimestamp(++i, null);
}
statement.setInt(++i, responseBody.departure_city_id);
statement.setInt(++i, responseBody.arrival_city_id);
var id = responseBody.transport_id;
statement.setInt(++i, id);
statement.executeUpdate();
response.println(id);
} catch(e){
var errorCode = response.BAD_REQUEST;
exports.printError(errorCode, errorCode, e.message, sql);
} finally {
connection.close();
}
};