@Autowired
public void setDataSource(DataSource dataSource) {
jdbcInsert = new SimpleJdbcInsert(dataSource);
jdbcInsert.setTableName("tb_user");
jdbcInsert.setGeneratedKeyName("user_id");
jdbcTemplate = new JdbcTemplate(dataSource);
}
@Override
public long save(MisoPrintService printService) throws IOException {
MapSqlParameterSource params = new MapSqlParameterSource();
params
.addValue("serviceName", printService.getName())
.addValue("contextName", printService.getPrintContext().getName())
.addValue("enabled", printService.isEnabled())
.addValue("printServiceFor", printService.getPrintServiceFor().getName());
try {
JSONObject contextFields =
PrintServiceUtils.mapContextFieldsToJSON(printService.getPrintContext());
String contextFieldJSON = contextFields.toString();
params.addValue("contextFields", contextFieldJSON);
} catch (IllegalAccessException e) {
e.printStackTrace();
}
if (printService.getServiceId() == -1) {
SimpleJdbcInsert insert =
new SimpleJdbcInsert(template)
.withTableName(TABLE_NAME)
.usingGeneratedKeyColumns("serviceId");
Number newId = insert.executeAndReturnKey(params);
printService.setServiceId(newId.longValue());
} else {
params.addValue("serviceId", printService.getServiceId());
NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
namedTemplate.update(PRINT_SERVICE_UPDATE, params);
}
return printService.getServiceId();
}
@Override
public Ride addRide(Ride ride) throws Exception {
Map<String, Object> parameters = new HashMap<String, Object>();
parameters.put("status", ride.getStatus());
parameters.put("origin_lat", ride.getOriginLat());
parameters.put("origin_long", ride.getOriginLong());
parameters.put("dest_lat", ride.getDestLat());
parameters.put("dest_long", ride.getDestLong());
parameters.put("start_datetime", ride.getStartDatetime());
parameters.put("end_datetime", ride.getEndDatetime());
parameters.put("fare", ride.getFare());
parameters.put("rider_rate_quality", ride.getRiderRateQuality());
parameters.put("rider_rate_msg", ride.getRiderRateMsg());
parameters.put("driver_rate_quality", ride.getDriverRateQuality());
parameters.put("driver_rate_msg", ride.getDriverRateMsg());
parameters.put("riders_rider_id", ride.getRidersRiderId());
parameters.put("drivers_driver_id", ride.getDriversDriverId());
SimpleJdbcInsert insert =
new SimpleJdbcInsert(ds).withTableName("rides").usingGeneratedKeyColumns("ride_id");
Number newId = insert.executeAndReturnKey(parameters);
ride.setRideId(newId.intValue());
return ride;
}
@Override
public void save(Guest... guests) {
SimpleJdbcInsert insertStmt = new SimpleJdbcInsert(jdbc).withTableName("guest");
for (Guest guest : guests) {
BeanPropertySqlParameterSource params = new BeanPropertySqlParameterSource(guest);
insertStmt.execute(params);
}
}
@Override
public void insert(Transaction transaction) throws SQLException {
logger.debug("Inserting transaction with type [{}]", transaction.getFlockId());
Map<String, Object> valuesToInsert = new HashMap<String, Object>();
valuesToInsert.put("FlockID", transaction.getFlockId());
valuesToInsert.put("Name", transaction.getName());
valuesToInsert.put("Expenses", transaction.getExpenses());
valuesToInsert.put("Revenues", transaction.getRevenues());
jdbcInsert.setGeneratedKeyName("ID");
jdbcInsert.execute(valuesToInsert);
}
private Vehicle insert(Vehicle vehicle) {
SimpleJdbcInsert insert =
new SimpleJdbcInsert(template).withTableName("vehicles").usingGeneratedKeyColumns("id");
SqlParameterSource parameters =
new MapSqlParameterSource()
.addValue("manufacturer", vehicle.getManufacturer())
.addValue("model", vehicle.getModel());
Number id = insert.executeAndReturnKey(parameters);
vehicle.setId(id.intValue());
return vehicle;
}
@AuditTrail
public Invoice create(final Invoice invoice) {
SimpleJdbcInsert insert =
new SimpleJdbcInsert(dataSource).withTableName("invoice").usingGeneratedKeyColumns("id");
Map<String, Object> parameters = new HashMap<String, Object>();
parameters.put("account_id", invoice.getAccountId().intValue());
parameters.put("period_from", invoice.getPeriodFrom());
parameters.put("period_to", invoice.getPeriodTo());
parameters.put("sent_time", invoice.getSentTime());
parameters.put("state", invoice.getState());
LOG.debug(parameters.toString());
Number id = insert.executeAndReturnKey(parameters);
invoice.setId(BigInteger.valueOf(id.longValue()));
return invoice;
}
private String saveTxn(TransactionVO currentTransaction) throws ParseException {
insertTransaction =
new SimpleJdbcInsert(getDataSource())
.withTableName("transaction")
.usingGeneratedKeyColumns("id");
SqlParameterSource parameters =
new MapSqlParameterSource()
.addValue("dateReported", getMySQLSaveDate(currentTransaction.getDateReported()))
.addValue("customerId", currentTransaction.getCustomerId())
.addValue("productCategory", currentTransaction.getProductCategory())
.addValue("makeId", currentTransaction.getMakeId())
.addValue("modelId", currentTransaction.getModelId())
.addValue("serialNo", currentTransaction.getSerialNo())
.addValue("accessories", currentTransaction.getAccessories())
.addValue("complaintReported", currentTransaction.getComplaintReported())
.addValue("complaintDiagnosed", currentTransaction.getComplaintDiagonsed())
.addValue("engineerRemarks", currentTransaction.getEnggRemark())
.addValue("repairAction", currentTransaction.getRepairAction())
.addValue("note", currentTransaction.getNotes())
.addValue("status", currentTransaction.getStatus())
.addValue("createdOn", currentTransaction.getCreatedOn())
.addValue("modifiedOn", currentTransaction.getModifiedOn())
.addValue("createdBy", currentTransaction.getCreatedBy())
.addValue("modifiedBy", currentTransaction.getModifiedBy());
Number newId = insertTransaction.executeAndReturnKey(parameters);
LOG.info(" the queryForInt resulted in " + newId.longValue());
currentTransaction.setId(newId.longValue());
// update the tag No
String tagNo = "WON2N" + newId.longValue();
String query = "update transaction set TagNo = '" + tagNo + "' where id =" + newId.longValue();
getJdbcTemplate().update(query);
return tagNo;
}
public void addTeam(Team team) {
SimpleJdbcInsert insertTeam = new SimpleJdbcInsert(getDataSource()).withTableName("teams");
Map<String, Object> teamParameters = new HashMap<String, Object>(5);
teamParameters.put("teamid", team.getTeamId());
teamParameters.put("location", team.getLocation());
teamParameters.put("abbreviation", team.getAbbreviation());
teamParameters.put("displayname", team.getDisplayName());
teamParameters.put("venueid", team.getVenue().getVenueId());
try {
insertTeam.execute(teamParameters);
} catch (DataIntegrityViolationException divex) {
log.warning("Duplicate entry");
}
}
public void saveRelapse(final Relapse relapse) throws Exception {
Map<String, Object> relapseMap =
new HashMap<String, Object>() {
{
put("relID", relapse.getId());
put("RADAR_NO", relapse.getRadarNumber());
put("DATE_ONSET_RELAP", relapse.getDateOfRelapse());
put(
"RELAP_TX_NAT",
relapse.getTransplantedNative() != null
? relapse.getTransplantedNative().getId()
: null);
put("TRIG_VIRAL", relapse.getViralTrigger());
put("TRIG_IMMUN", relapse.getImmunisationTrigger());
put("TRIG_OTHER", relapse.getOtherTrigger());
put("RELAP_DRUG_1", relapse.getDrug1());
put("RELAP_DRUG_2", relapse.getDrug2());
put("RELAP_DRUG_3", relapse.getDrug3());
put(
"REMISS_ACHIEVE",
relapse.getRemissionAchieved() != null
? relapse.getRemissionAchieved().getId()
: null);
put("DATE_REMISSION", relapse.getDateOfRemission());
put("SEQ_NO", relapse.getSequenceNumber());
}
};
simpleJdbcInsert = new SimpleJdbcInsert(dataSource).withTableName("tbl_Relapse");
simpleJdbcInsert.execute(relapseMap);
}
/**
* Add a new TournamentEnrollment to the database
*
* @param enrollment the enrollment to be added
*/
public void addEnrollment(TournamentEnrollment enrollment) {
SimpleJdbcInsert insertEnrollment =
new SimpleJdbcInsert(getDataSource()).withTableName("tournament_enrollments");
Map<String, Object> parameters = new HashMap<String, Object>(3);
parameters.put("tournamentId", enrollment.getTournamentid());
parameters.put("fantasy_teamId", enrollment.getTeamId());
parameters.put("score", enrollment.getScore());
try {
insertEnrollment.execute(parameters);
} catch (DataIntegrityViolationException divx) {
String msg = "Duplicate entry";
log.warning(msg);
}
}
public void addGame(Game game) throws GameServiceException {
SimpleJdbcInsert insertGame = new SimpleJdbcInsert(getDataSource()).withTableName("games");
Map<String, Object> gameParameters = new HashMap<String, Object>(5);
gameParameters.put("gameid", game.getGameId());
gameParameters.put("startTime", game.getStartTime());
gameParameters.put("teamHomeid", game.getTeamHome().getTeamId());
gameParameters.put("teamAwayid", game.getTeamAway().getTeamId());
gameParameters.put("venueid", game.getVenue().getVenueId());
try {
insertGame.execute(gameParameters);
} catch (DataIntegrityViolationException divex) {
log.warning("Duplicate entry");
throw new GameServiceException(divex.getMessage(), divex);
}
}
public static void insert(
DataSource dataSource,
String tableName,
List<String> usingColumns,
List<Map<String, Object>> fields) {
SimpleJdbcInsert jdbcInsert = new SimpleJdbcInsert(dataSource);
jdbcInsert.withTableName(tableName);
List<String> pp = new ArrayList<>();
pp.addAll(usingColumns);
pp.add(tableName + "_id");
jdbcInsert.usingColumns(pp.toArray(new String[usingColumns.size()]));
for (Map<String, Object> field : fields) {
field.put(tableName + "_id", UUID.randomUUID().toString());
}
Map<String, Object>[] batch = fields.toArray(new Map[fields.size()]);
jdbcInsert.executeBatch(batch);
}
/** {@inheritDoc} */
@Override
public void insert(Relay relay) {
logger.debug("Inserting relay with id [{}]", relay.getId());
Map<String, Object> valuesToInsert = new HashMap<String, Object>();
valuesToInsert.put("id", relay.getId());
valuesToInsert.put("name", relay.getText());
jdbcInsert.execute(valuesToInsert);
}
public synchronized CookingRecipe insertCookingRecipe(CookingRecipe recipe) throws Exception {
System.out.println("Database: insertCookingRecipe(" + recipe + ")");
SimpleJdbcInsert insert = new SimpleJdbcInsert(jdbcTemplate);
insert.withTableName("recipes");
insert.setGeneratedKeyName("id");
Map<String, Object> mapa = new HashMap<String, Object>();
mapa.put("recipe_name", recipe.getName());
mapa.put("author", recipe.getAuthor());
mapa.put("guide", recipe.getGuide());
// mapa.put("incident_ID", incidentID);
Number insertedRecipeId = insert.executeAndReturnKey(mapa);
recipe.setId(insertedRecipeId.longValue());
insertIngredients(recipe.getIngredients(), insertedRecipeId.longValue());
for (CookingIngredient ci : recipe.getIngredients()) {
ci.setRecipe_id(insertedRecipeId.longValue());
}
return recipe;
}
public long saveGroup(Group group) throws IOException {
MapSqlParameterSource params = new MapSqlParameterSource();
params.addValue("name", group.getName()).addValue("description", group.getDescription());
if (group.getGroupId() == Group.UNSAVED_ID) {
SimpleJdbcInsert insert =
new SimpleJdbcInsert(template)
.withTableName("_Group")
.usingGeneratedKeyColumns("groupId");
Number newId = insert.executeAndReturnKey(params);
group.setGroupId(newId.longValue());
} else {
params.addValue("groupId", group.getGroupId());
NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
namedTemplate.update(GROUP_UPDATE, params);
}
return group.getGroupId();
}
public void savePhenotypes(final long id, final String desc) {
Map<String, Object> therapMap =
new HashMap<String, Object>() {
{
put("pID", id);
put("pDesc", desc);
}
};
simpleJdbcInsert = new SimpleJdbcInsert(dataSource).withTableName("tbl_PHENOTYPES");
simpleJdbcInsert.execute(therapMap);
}
public void saveCountry(final Country country) throws Exception {
Map<String, Object> map =
new HashMap<String, Object>() {
{
put("cID", country.getId());
put("cName", country.getName());
}
};
simpleJdbcInsert = new SimpleJdbcInsert(dataSource).withTableName("tbl_Country");
simpleJdbcInsert.execute(map);
}
public void saveTherapy(final Therapy therapy) {
Map<String, Object> therapMap =
new HashMap<String, Object>() {
{
put("RADAR_NO", therapy.getRadarNumber());
put("tID", therapy.getId());
}
};
simpleJdbcInsert = new SimpleJdbcInsert(dataSource).withTableName("tbl_Therapy");
simpleJdbcInsert.execute(therapMap);
}
public void savePrdCode(final String code, final String term) throws Exception {
Map<String, Object> map =
new HashMap<String, Object>() {
{
put("ERA_EDTA_PRD_code", code);
put("ERA_EDTA_primaryRenalDiagnosisTerm", term);
}
};
simpleJdbcInsert = new SimpleJdbcInsert(dataSource).withTableName("rdr_prd_code");
simpleJdbcInsert.execute(map);
}
public void savePlasmaLu(final long id, final String desc) {
Map<String, Object> therapMap =
new HashMap<String, Object>() {
{
put("exID", id);
put("exDesc", desc);
}
};
simpleJdbcInsert = new SimpleJdbcInsert(dataSource).withTableName("tbl_RRT_PLASMA_LU");
simpleJdbcInsert.execute(therapMap);
}
public void saveKarotype(final long id, final String type) {
Map<String, Object> therapMap =
new HashMap<String, Object>() {
{
put("kID", id);
put("KARYOTYPE", type);
}
};
simpleJdbcInsert = new SimpleJdbcInsert(dataSource).withTableName("tbl_Karyotype");
simpleJdbcInsert.execute(therapMap);
}
public void saveRRTTreatment(final long id, final long radarNo) {
Map<String, Object> therapMap =
new HashMap<String, Object>() {
{
put("tID", id);
put("RADAR_NO", radarNo);
}
};
simpleJdbcInsert = new SimpleJdbcInsert(dataSource).withTableName("tbl_RRT_TREATMENT");
simpleJdbcInsert.execute(therapMap);
}
public void saveLabData(final long id, final long radarNo) {
Map<String, Object> therapMap =
new HashMap<String, Object>() {
{
put("labID", id);
put("RADAR_NO", radarNo);
}
};
simpleJdbcInsert = new SimpleJdbcInsert(dataSource).withTableName("tbl_LabData");
simpleJdbcInsert.execute(therapMap);
}
public void createClinPres(final Long id, final String pres) throws Exception {
Map<String, Object> map =
new HashMap<String, Object>() {
{
put("cID", id);
put("CLIN_PRES", pres);
}
};
simpleJdbcInsert = new SimpleJdbcInsert(dataSource).withTableName("tbl_Clin_Pres");
simpleJdbcInsert.execute(map);
}
public void saveTransplantModality(final long id, final String desc) {
Map<String, Object> therapMap =
new HashMap<String, Object>() {
{
put("trID", id);
put("trDesc", desc);
}
};
simpleJdbcInsert = new SimpleJdbcInsert(dataSource).withTableName("tbl_TRANSPLANT_MODALITY");
simpleJdbcInsert.execute(therapMap);
}
public void saveClinicalData(final ClinicalData clinicalData) throws Exception {
Map<String, Object> clinicalDataMap =
new HashMap<String, Object>() {
{
put("cID", clinicalData.getId());
put("RADAR_NO", clinicalData.getRadarNumber());
}
};
simpleJdbcInsert = new SimpleJdbcInsert(dataSource).withTableName("tbl_clinicalData");
simpleJdbcInsert.execute(clinicalDataMap);
}
public void saveSex(final long id, final String type) {
Map<String, Object> therapMap =
new HashMap<String, Object>() {
{
put("sID", id);
put("sType", type);
}
};
simpleJdbcInsert = new SimpleJdbcInsert(dataSource).withTableName("tbl_Sex");
simpleJdbcInsert.execute(therapMap);
}
public void saveTransplantReject(final long id, final long trId) {
Map<String, Object> therapMap =
new HashMap<String, Object>() {
{
put("recID", id);
put("trID", trId);
}
};
simpleJdbcInsert = new SimpleJdbcInsert(dataSource).withTableName("tbl_Transplant_Reject");
simpleJdbcInsert.execute(therapMap);
}
/*
* (non-Javadoc)
*
* @see org.cuny.sensors.dao.IDao#save(java.lang.Object)
*/
@Override
public RawFile save(RawFile obj) throws Exception {
Map<String, Object> parameters = new HashMap<String, Object>(5);
parameters.put(FILE_NAME, obj.getFilename());
parameters.put(FILE_SIZE, obj.getFileSize());
parameters.put(STATUS, obj.getStatus().toString());
parameters.put(BUILDING, obj.getBuilding());
parameters.put(CAMPUS, obj.getCampus());
Number newId = insertActor.executeAndReturnKey(parameters);
obj.setId(newId.longValue());
return obj;
}
