Shiny‐Fixie App - psrc/shiny-fixie GitHub Wiki

The Shiny-Fixie app collects data edits and executes update query/ stored procedures to update tables in database

Main features

These are the full list of update queries and stored procedures to go through for each action to update tables in database

1. Edit trip

   • Data Validation: validate if data edits are accurate, complete, and have consistent data type before executing update query
     • must be positive value: distance_miles
     • longitude value (origin_lng, dest_lng) must be between -180 and 180 inclusive
     • latitude value (origin_lat, dest_lat) must be between -90 and 90 inclusive
     • arrival time must be later than departure time
     • More validations? (Issue #30)
   • Send update query to database: Identify edited variables and their values to write update queries
   • Trigger stored procedures: after_edits(recalculate_after_edit, generate_error_flags)

2. Add trip (create blank trip, add reverse trip, add return home trip)

   • Identify variables that can be inferred from previous trip record and their values to show in trip editor pane
   • Same data validation process as Edit trip
   • Send update query to database
   • Trigger stored procedures: update_tripnum, recalculate_after_edit, generate_error_flags

3. Dismiss flag

   • Trigger stored procedures: dismiss_flag(update psrc_resolved value, generate_error_flags)

4. Delete trip

   • Trigger stored procedures: remove_trip, update_tripnum, generate_error_flags

5. Link Trip

   • Trigger stored procedure: link_trip_via_id (list of recid required)

6. Unlink Trip

   • unlink trips that were linked in the trip linking process