This is Test challenge by filed

##setup the system

1. Setup codebase

   1. clone the code in a directory

       git clone https://github.com/sahasrara62/filed_audio_file_server.git
      

   2. go in the directory cd filed_audio_file_server

   3. install all project requirements, use command python -m pipenv install -r requirements.txt

   4. go in pipenv virtualenv by python -m pipenv shell

   5. set up flask env variable, run commands

      1. export FLASK_APP=main.py
      2. export FLASK_ENV=developement

2. create database

   in postgresql create database "audioserver" and grant permission to user, in postgresql shell run command .

   1. create db audioserver;
   2. GRANT ALL PRIVILEGES ON DATABASE audioserver to "prashant"; # my username
   

3. create the table in audioserver database

   1. in .env file add the data as below

      # example
      # DATABASE_URL="postgresql://prashant:rana@localhost:5432/audioserver"
      DATABASE_URL="postgresql://<username>:<password>@<server host>:<port>/<database name>
      SECRET_KEY="this-is-a-sample-secret-key"
      FLASK_ENV="development"
      SQLALCHEMY_TRACK_MODIFICATIONS=True
      

   2. lets do migrations, run following commands

      1. flask db init
      2. flask db migrate
      3. flask db upgrade

      this will create a migration folder, and create table in the database

4. run app, activate envrionment pipenv shell and run the command to run server flask run

5. check if server is running, in browser go to localhost:5000/, you will get server is running msg.

Write a Flask / FastAPI Web API that simulates the behavior of an audio file server while using a MongoDB / SQL database.

Requirements: You have one of three audio files which structures are defined below Audio file type can be one of the following:

1 – Song
2 – Podcast
3 – Audiobook

##Song file fields:

• ID – (mandatory, integer, unique)
• Name of the song – (mandatory, string, cannot be larger than 100 characters)
• Duration in number of seconds – (mandatory, integer, positive)
• Uploaded time – (mandatory, Datetime, cannot be in the past)

• ID – (mandatory, integer, unique)
• Name of the podcast – (mandatory, string, cannot be larger than 100 characters)
• Duration in number of seconds – (mandatory, integer, positive)
• Uploaded time – (mandatory, Datetime, cannot be in the past)
• Host – (mandatory, string, cannot be larger than 100 characters)
• Participants – (optional, list of strings, each string cannot be larger than 100 characters, maximum of 10 participants possible)

##Audiobook file fields:

• ID – (mandatory, integer, unique)
• Title of the audiobook – (mandatory, string, cannot be larger than 100 characters)
• Author of the title (mandatory, string, cannot be larger than 100 characters)
• Narrator - (mandatory, string, cannot be larger than 100 characters)
• Duration in number of seconds – (mandatory, integer, positive)
• Uploaded time – (mandatory, Datetime, cannot be in the past)

API structuture is define in documentation folder. it is postman structure

Test challenge summary is define in documentation folder

##How to start

1. Clone the repo from github git clone https://github.com/sahasrara62/filed_audio_file_server.git

2. in terminal go to folder , cd filed_audio_file_server

3. setup flask app

    a. export FLASK_APP=main.py
    b. export FLASK_ENV='developement'
   

4. run flask server : flask run

5. check if server is running at browser localhost:5000/ you will get , server is running

Test api structure is given in documentation, it is postman exported one.

url = /api/v1/create 
method = Post
content-type=application/json

• structures:

  • song

    request body

     {
      "audioFileType":"song",
      "audioFileMetadata":{
          "uploaded_time":<upload time>>,
          "duration_time":<time duration in seconds>,
          "name":"<name of song>"
          }
      }
    

  • podcast

    • request body

       {
            "audioFileType":"podcast",
            "audioFileMetadata":{
                    "uploaded_time":"0",
                    "duration_time":102,
                    "name":"in the end.mp4",
                    "host":"linkin park - arizona park",
                    "participents":["linkin park","us","american band"]
            }
         }      
      

  • audiobook

    • request body

        {
            "audioFileType":"audiobook",
            "audioFileMetadata":{
                    "uploaded_time":"0",
                    "duration_time":102,
                    "title":"in the end.mp4",
                    "author":"linkin park",
                    "narrator":"linkin park"
            }
        }
      

####2. Update

url = /api/v1/update/<audioFileType>/<audioFileID> 
method = PUT
content-type=application/json

• song

  • url : /api/v1/update/song/1

  • request body :

      {
          "audioFileType":"song",
          "audioFileMetadata":{
                  "uploaded_time":"0",
                  "duration_time":102,
                  "name":"in the end - metoria by linkin park.mp4"    
          }
      }
    

• podcast

  • url : /api/v1/update/podcast/1

  • request body :

      {
          "audioFileType":"podcast",
          "audioFileMetadata":{
              "uploaded_time":"0",
              "duration_time":102,
              "name":"linkin park in the end.mp4",
              "host":"linkin park - arizona park",
              "participents":["linkin park","us","american band"]    
           }    
    

    }

• audiobook

  • url : /api/v1/update/audiobook/1

  • request body:

      {
      "audioFileType":"audiobook",
      "audioFileMetadata":{
              "uploaded_time":"0",
              "duration_time":102,
              "title":"in the end.mp4",
              "author":"linkin park- mike shindoda",
              "narrator":"linkin park"  
      }
    

    }

##3. delete

url = /api/v1/delete/<audioFileType>/<audioFileID>
method = DELETE
content-type = application/json

• song
  • url: /api/v1/delete/song/1 - delete record present at id 1
• podcast
  • url: /api/v1/delete/podcast/1 - delete record present at id 1
• audiobook
  • url : /api/v1/delete/audiobook/1 - delete record present at id 1

##4. get

1. • url: /api/v1/<audioFileType>
   • description: get all the data present in <audioFileType> database 2.- url: /api/v1/<audioFileType>/<audioFileID>
   • description: get all data present in <audioFileType> database having id audioFileID`

2. urls

   1. song,

      url1 = `/api/v1/get/song` - get all song in database
      url2 = `/api/v1/get/song/1` - get song having id 1       
      

   2. podcast

      url1 = `/api/v1/get/podcast` - get all data in podcast in database
      url2 = `/api/v1/get/podcast/1` - get song having id 1
      

   3. audiobook

   url1 = `/api/v1/get/audiobook` - get all data in audiobook in database
   url2 = `/api/v1/get/audiobook/1` - get data having id 1
   

- Action is successful: 200 OK
- The request is invalid: 400 bad request
- Any error: 500 internal server error