A Request Refactor

Task: Same Same

React, Java/Spring-Boot, Hibernate, SQLServer

React, Node, SQL, SQLServer

1 Week

All SQL in 1 file

Websocket and Rest

Messaging

On and Off the Bus

[Actor-Model]

Configuration: DB streaming

{
  "PROGRAMS_STREAMING": false
}

A postman-like example file

http://localhost:8090/
###
http://localhost:8090/data/programs?where=where%20program_id%20=%20113
###
http://localhost:8090/data/program/?program_id=370
###
http://localhost:8090/data/outlets/?outletNameStartsWith=NC%20R
###
http://localhost:8090/data/programevents/?program_id=370
###
http://localhost:8090/data/programeventmappings/?program_id=424
###
http://localhost:8090/data/programpricelevels/?program_id=424
###
http://localhost:8090/data/programpricelevelsmappings/?program_id=424
###
http://localhost:8090/data/programoptions/?program_id=370
###
http://localhost:8090/data/programoptionsvalues
###
http://localhost:8090/data/targeteventsafter/?outlet=4259&startDate=2022-04-05
###

// CREATE, UPDATE, DELETE  Note: DEBUG setting
POST http://localhost:8090/data/programeventmappingcreate HTTP/1.1
content-type: application/json

{
  "fields": {
    "request_event_id": 196579,
    "target_event_id": 196580,
    "program_id": 443,
    "sequence": 7
  },
  "DEBUG": true
}

###

POST http://localhost:8090/data/programeventmappingupdate HTTP/1.1
content-type: application/json

{
  "updates": {
    "request_event_id": 196582,
    "target_event_id": 196580,
    "sequence": 22
  },
  "program_event_mapping_id": 1214,
  "DEBUG": true
}

###

http://localhost:8090/data/programeventmappingdelete/?program_event_mapping_id=1228&DEBUG=true
###

POST http://localhost:8090/data/programpricelevelmappingcreate HTTP/1.1
content-type: application/json

{
  "fields": {
    "request_price_level_type_id": 664,
    "target_price_level_type_id": 6,
    "program_id": 424,
    "rank": 7
  },
  "DEBUG": true
}

###

POST http://localhost:8090/data/programpricelevelmappingupdate HTTP/1.1
content-type: application/json

{
  "updates": {
    "request_price_level_type_id": 1,
    "target_price_level_type_id": 6,
    "rank": 3
  },
  "program_seat_preference_mapping_id": 355,
  "DEBUG": true
}

###

http://localhost:8090/data/programpricelevelmappingdelete/?program_seat_preference_mapping_id=480&DEBUG=true
###

A postman-like example file

// CREATE, UPDATE, DELETE  Note: DEBUG setting
POST http://localhost:8090/data/programeventmappingcreate HTTP/1.1
content-type: application/json

{
  "fields": {
    "request_event_id": 196579,
    "target_event_id": 196580,
    "program_id": 443,
    "sequence": 7
  },
  "DEBUG": true
}

###

POST http://localhost:8090/data/programeventmappingupdate HTTP/1.1
content-type: application/json

{
  "updates": {
    "request_event_id": 196582,
    "target_event_id": 196580,
    "sequence": 22
  },
  "program_event_mapping_id": 1214,
  "DEBUG": true
}

###

http://localhost:8090/data/programeventmappingdelete/?program_event_mapping_id=1228&DEBUG=true
###

POST http://localhost:8090/data/programpricelevelmappingcreate HTTP/1.1
content-type: application/json

{
  "fields": {
    "request_price_level_type_id": 664,
    "target_price_level_type_id": 6,
    "program_id": 424,
    "rank": 7
  },
  "DEBUG": true
}

###

POST http://localhost:8090/data/programpricelevelmappingupdate HTTP/1.1
content-type: application/json

{
  "updates": {
    "request_price_level_type_id": 1,
    "target_price_level_type_id": 6,
    "rank": 3
  },
  "program_seat_preference_mapping_id": 355,
  "DEBUG": true
}

###

http://localhost:8090/data/programpricelevelmappingdelete/?program_seat_preference_mapping_id=480&DEBUG=true
###

Time to see code...

Transparent

Simple

Timeless

Efficient

Taking the magic out of code is cool too.

or is this another case of...

Jon Tiemann

Experience in many languages
Database experience since Codd and Date
Team Building through passion and curiosity
Sharing and Pairing
Mentoring and being Mentored
Writing maintainable, long lasting code
Actor Model advocate
Ask about Mel B JS Messaging Micro-Framework