Simple app in Sinatra to receive and send files to university project's subsystems.

First you should have MySQL server running, with database colon. Inside you should create two tables:

tasks
  id:integer
  in_file_path:string
  out_file_path:string

solutions
  id:integer
  file_path:string

This app does not create records, so to attach any file you first need to create sample rows yourself. Then:

1. git clone https://github.com/sjchmiela/colon-files.git
2. cd colon-files
3. bundle install
4. Edit database connection settings in config.yml.
5. ruby app.rb
6. Open browser, head over to http://localhost:4567/.

POST /solutions/:solution_id — attach file solution_file to solution with id solution_id. Expects solution_file parameter with file attached. Solution with specified solution_id should already be persisted in database. Returns JSON: {success:boolean, message:text}.

GET /solutions/:solution_id — retrieve file solution_id.

POST /tasks/:task_id — attach files task_in_file and task_out_file to task with id task_id. Expects parameters task_in_file and task_out_file as files. Task with specified task_id should already be persisted in database. Returns JSON: {success:boolean, message:text}.

GET /tasks/:task_id/in — retrieve infile of task with id task_id.

GET /tasks/:task_id/out — retrieve outfile of task with id task_id.

Testing web interface is at http://localhost:4567/ of the app.